✅ Download and complete your free course exercise file here
➡https://www.simonsezit.com/excel2021...

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 paidfor 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/excel2021...

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 30day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssitfirst...

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ➡
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for Excel beginners    • Microsoft Excel Beginner's Training T...  

✅ Excel 2021 Tutorials for Intermediate Users here    • Excel 2021 Tutorials for Intermediate...  

✅ Microsoft Excel Tips and Tricks    • Microsoft Excel Tips and Tricks  

✅ Microsoft Office 2021 and Office 365 Training here    • Microsoft Office 2021 and Office 365 ...  

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simonsezit  
FaceBook:   / simonsezit  

Subscribe to our channel:
https://www.youtube.com/simonsezittra...

If you enjoyed the video, please give a thumbs up ;)