Excel 2021/365 Beginners & Intermediate Training: 10-Hour Excel Tutorial Class

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.

📝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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

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

[ifemanimmazuubs]

You are the best teacher in the world Deborah! If I had teachers like you growing up, I would have done better in academics. God bless you.

[thomassamuelrobinson]

This is an awesome class. It is very long, but that is because the teacher tells you every single step, she makes it very easy. I looked on youtube the last few months and I could never find an Excel training that was not very small and not taught in a professional manner as much as this one.

[philippelambrechts]

Bonjour,
Un grand merci pour ce cours.
Vous avez une élocution parfaite ce qui me permets de suivre ce cours.

[HappyCampingMom]

I recently completed a college computing course where excel was 1/4 of the semester. I have learned more of what I really NEED to learn in the first 4 hours of this course. Very well presented for business use!

[arwahsdiary]

Thanks. It is really detailed teaching covering all the aspects.

[UskaVII]

Thank you so much for making this. And for having it free! You're amazing. Great class

[bernardotabil]

I sat through the whole 10hrs video and i must confess this is one of the best tutorial videos i have watched on YouTube thus far...thank you Deb for gems and nuggets you released in this video.

[CLARAIVETTE]

Thank you so much for this Valuable Tutorial along with an excellent trainer who covers every single detail and question one might have, Thank you Deborah & Simon Sez IT... Thank you, Thank you, Thank you! After this 10 hr training, one is trained to master excel like a pro.

[Sofiii]

Absolutely fantastic. Thank you. I love discovering all the hidden options that make my work easier and more effective.

[kalamay]

Okay, I finally got to download the files and I'm half-way through this. So far, AWESOME

[summerliu]

Your way of teaching is most effective. Your voice is most beautiful. The class you presented here is just awesome. YOU ARE THE BEST TEACHER!!!

[VAL_ON_WHEELS]

You have invested in time and patience to summarise everything systematically...awesome, i can now take 3 days off from work and focus on the fundamentals to gain more experience...pretty much sums up thank you.

[HollowPointBlank]

Best of the wishes for the lovely teacher

[SimonSezIT]

🔥Check out our FREE 300+ hour training course playlist here ➡️

🚀 Boost your Excel skills with these free Excel playlists 👉🏼

[FlouradenceEnterprise]

Awesome. Learnt So Much.
Thanks So Much Ma. Love Your Voice Too.

[vencislavvankov]

Hello! Thanks for the wonderful tutorial!
How do I remove tabs at the beginning of cells? How do I enter a tab character in REPLACE?

[shibainsouthcarolina]

Her voice is very pleasant and relaxing! it's almost like I am studying to hear her voice...lol I appreciate not only her amazing teaching skills, but also her voice and how she talks! Makes my study a lot bearable ;) Thanks for turning my study into something fun!!!

[vishnusuraj]

Great teaching video I learned a lot thank you will recommend this channel to my friends ❤❤❤❤❤👍👍👍👍⭐⭐⭐⭐⭐

[LaceyWinter-jpur]

Deb, You are a great teacher. Love this video. Quick question though. On the 'naming ranges' exercise on the Customer Data. I named them in the same way you did but when I did the CountA for customers it picked up the title 'Customer Name' and added it so my number of customers changed from 50 to 51. I had to go into the defined names tab and delete it and then rename it using the click and drag method so as not to include it in my range. How come that didn't happen when you did it.?Thanks for this great tutorial.

[SteelerYNation]

I used to love Excel 15 years ago when I last had it, so I'm relearning it from this video. I bought MS 365 last April