Download to follow along and complete the exercises ️https://www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/

In this Excel 2021 Beginner to Intermediate training course, go from zero to hero as we cover the basics and expand to intermediate Excel skills. We'll go over Excel logical IF functions, Excel lookup functions such as VLOOKUP and XLOOKUP, importing data into Excel, formatting, and so much more!

We've even included downloadable exercise 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.

https://www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 - Introduction
00:00:22 - Course Intro
00:02:42 - Excel 2021 vs Excel 365
00:08:21 - Launching Excel
00:12:00 - The Start Screen
00:22:12 - Exploring the Interface
00:33:51 - Ribbons, Tabs and Menus
00:42:20 - Backstage Area
00:47:00 - Quick Access Toolbar
00:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:11 - Working with Rows and Columns
04:16:36 - Deleting and Clearing Cells
04:23:02 - Aligning Text and Numbers
04:34:15 - Applying Themes and Styles
04:42:13 - Course Introduction
04:48:31 - Improve Readability with Cell Styles
04:53:30 - Controlling Data Input
05:01:49 - Adding Navigation Buttons
05:10:36 - Logical Functions
05:23:56 - The IF Function
05:29:25 - Nested IFs
05:37:24 - The IFs Function
05:43:27 - Conditional IFs
05:50:13 - Multiple Criteria
05:57:25 - Error Handling
06:03:27 - Exercise 01
06:10:56 - VLookup (Exact Match)
06:21:36 - VLookup (Approximate Match)
06:26:02 - HLookup
06:31:40 - INDEX and MATCH
06:42:09 - XLookup and XMatch
06:52:18 - OFFSET Function
07:03:10 - INDIRECT Function
07:12:17 - Exercise 02
07:17:19 - Sorting on Multiple Columns
07:24:25 - Soring Using a Custom List
07:28:00 - SORT and SORTBY Functions
07:37:49 - Advanced Filter
07:44:52 - UNIQUE Function
07:50:10 - FILTER Function
07:49:40 - Exercise 03
08:05:20 - How Date and Times are Stored
08:09:32 - Custom Data and Time Formats
08:16:42 - Time and Date Functions
08:25:26 - WORKDAY and WORKDAY.INTL Functions
08:29:16 - NETWORKDAYS and NETWORKDAYS.INTL Functions
08:32:13 - DATEDIF
08:38:28 - EDATE and EOMONTH
08:45:52 - Exercise 04
08:50:45 - Importing Data into Excel
09:00:40 - Removing Blank Rows, Cells and Duplicate Entries
09:06:02 - Changing Case and Removing Spaces
09:15:07 - Splitting Up Data Using Text to Columns
09:22:08 - Splitting Up Data Using Text Functions
09:30:13 - Flash Fill
09:35:13 - CONCAT
09:42:44 - Formatting Data as Table

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 ;-)