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.

Download and complete the exercises ►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

Take a look at the latest Excel training courses from Simon Sez IT
►https://bit.ly/3fNO5mw

Watch more popular MS Office tutorials from Simon Sez IT:

Microsoft Excel 2019 Tutorial (3-Hour Course for Beginners)
►https://youtu.be/ZNGqeCcTu0Q
Microsoft Office Ultimate Course (12-Hour Course)
►https://youtu.be/IUAq9r5B9Go
Learn PivotTables in 1 Hour (Excel Crash Course)
►https://youtu.be/2RKw-HGCLB0
Introduction to QuickBooks Desktop 2021 (4-Hour Tutorial)
►https://youtu.be/-K357CmF0Xk
Windows 11 Tutorial for Beginners (40-Minute Live Webinar Course)
►https://youtu.be/HDpZKtE06J4

Other, free Microsoft Excel playlists from Simon Sez IT:

Microsoft Excel 2019 Beginners playlist
►https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg
Microsoft Excel 2019 Advanced playlist
►https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a “thumbs up” and subscribe to the channel 😉

source