Download and complete your free course exercise file here
️https://www.simonsezit.com/excel-2021-beginners-courseexercise-files/
In this Excel 2021 Beginner Course, you will build a solid foundation in Excel that you can use in a job or school. We'll go over the difference between Excel 2021 and Excel 365 and then start exploring the Excel interface. We will also discuss Excel 2021 new features, basic formulas and functions, formatting options, applying themes, and more! Once finished, you will have a solid foundation for using Excel 2021/365, as part of the Office 2021 suite of applications.
We've even included downloadable exercise and instructor files from our paid-for course which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught.
We've even included a free downloadable exercise file so you can follow along in this QuickBooks 2022 Tutorial
https://www.simonsezit.com/excel-2021-beginners-courseexercise-files/
Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction
0:00:22 - Course Intro
0:02:42 - Excel 2021 vs Excel 365
0:08:21 - Launching Excel
0:12:00 - The Start Screen
0:22:12 - Exploring the Interface
0:33:51 - Ribbons, Tabs and Menus
0:42:20 - Backstage Area
0:47:00 - Quick Access Toolbar
0:56:45 - Useful Keyboard Shortcuts
1:06:27 - Getting Help
1:13:04 - Exercise 01
1:15:27 - Working with Templates
1:24:30 - Workbooks and Worksheets
1:32:04 - Saving Workbooks
1:40:50 - Entering and Editing Data
1:50:43 - Navigating and Selecting Cells, Rows, and Columns
1:58:02 - Exercise 02
2:03:22 - Formulas and Functions Explained
2:15:06 - SUM Function
2:22:44 - COUNT Function
2:30:10 - AVERAGE Function
2:34:27 - MIN and MAX Function
2:36:52 - Handling Errors in Calculations
2:45:34 - Absolute vs Relative Referencing
2:52:29 - Autosum and Autofill Options
3:02:12 - Flash Fill
3:07:15 - Exercise 03
3:12:26 - What are Named Ranges
3:21:33 - Managing Named Ranges
3:25:22 - Using Named Ranges
3:30:42 - Exercise 04
3:35:00 - Applying Number Formats
3:45:03 - Applying Date and Time Formats
3:50:41 - Formatting Cells, Rows and Columns
3:59:20 - Format Painter
4:04:00 - Exercise 05
4:08:11 - Working with Rows and Columns
4:16:36 - Deleting and Clearing Cells
4:23:02 - Aligning Text and Numbers
4:34:15 - Applying Themes and Styles
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)