Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class

✅ Download to follow along and complete the exercises

In this Excel 2021 Intermediate training course, you will build on your beginner-level Excel knowledge and expand your skills. We'll go over Excel logical functions such as IF, COUNTIF, and SUMIF and Excel lookup functions like VLOOKUP, HLOOKUP, INDEX, and MATCH. We will also discuss various other Excel formulas such as UNIQUE, CONCAT, and so much more!

You will also learn how to use advanced filters, sort columns and lists, use custom date formats, remove duplicate entries, split and combine data, and many other Excel tips and tricks. After this training video, you will have a solid foundation for using Excel 2021/Excel 365, as part of the Office 2021 suite of applications.

We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Microsoft Excel 2021/365 Tutorial.

📝 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:06:38 - Improve Readability with Cell Styles
0:11:37 - Controlling Data Input
0:19:57 - Adding Navigation Buttons
0:28:43 - Logical Functions
0:42:02 - The IF Function
0:47:28 - Nested IFs
0:55:30 - The IFs Function
1:01:35 - Conditional IFs
1:08:20 - Multiple Criteria
1:15:33 - Error Handling
1:21:34 - Exercise 01
1:29:04 - VLOOKUP (Exact Match)
1:39:44 - VLOOKUP (Approximate Match)
1:44:10 - HLOOKUP Function
1:49:49 - INDEX and MATCH
2:00:16 - XLookup and XMatch
2:10:26 - OFFSET Function
2:21:17 - INDIRECT Function
2:30:24 - Exercise 02
2:35:26 - Sorting on Multiple Columns
2:42:31 - Sorting Using a Custom List
2:46:07 - SORT and SORTBY Functions
2:56:07 - Advanced Filter
3:02:59 - UNIQUE Function
3:08:16 - FILTER Function
3:17:48 - Exercise 03
3:23:29 - How Dates and Times are Stored
3:27:39 - Custom Date and Time Formats
3:34:49 - Time and Date Functions
3:43:33 - WORKDAY and WORKDAY.INT Functions
3:47:22 - NETWORKDAYS and NETWORKDAYS.INT Functions
3:50:20 - DATEDIF Function
3:56:33 - EDATE and EOMONTH Functions
4:03:55 - Exercise 04
4:08:51 - Importing Data into Excel
4:18:46 - Removing Blank Rows, Cells, and Duplicate Entries
4:24:07 - Changing Case and Removing Spaces
4:33:12 - Splitting Up Data Using Text to Columns
4:40:15 - Splitting Up Data Using Text Functions
4:48:22 - Using Flash Fill
4:53:21 - CONCAT Function
5:00:50 - Formatting Data as Table

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

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

🔥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 👍🏽 ;-)

[philipaniche]

Her voice is so reassuring, navigating even the most complex concepts with grace and dexterity

[cannonzhou]

This is by far the most comprehensive and easiest to follow tutorials I have had. I picked up many useful tips. thanks Deb!

[edwardholyk]

How lucky I’m to find a genuine Tutor spending her precious time to offer tuition free course that everyone who need to excel in their career would take.
Special thanks, I can’t wait to subscribe, like and share.

[peterkovacevic]

Your exercises are transparent, clear, and extremely interesting. In every lesson I found something new. Thank you for your efforts.

[justhere]

1:21:42 exercise 1
2:30:37 exercise 2
3:17:56 exercise 3
4:04:06 exercise 4
Wooo i finished in 9 days 🎉🎉

[maytesmart]

OMG, she is such a brilliant instructor that I could gladly learn physics if she taught it. Simply extraordinary!

[Metal_seer]

Thanks for a great course. I am using it as a refresher, since I haven't used Excel in 25 years.

[changchuntang]

I have watched all way through xlookup and index/match... so far so good....hope Simon Sez could provide more practice sheets to work with.

[TheMsimpson]

Absolutely by far the best presentation on Excel I’ve seen.

[darrenlewisjones]

Undoubtedly the best Microsoft Excel course I've ever done; and I've completed Amazing work!

[arnmt]

This class is well done and is helping me with some sorting issues I had.

[changchuntang]

Great resources. helpful...I have been watching this series for two weeks....

[Marcelo-officepro]

Thanke you for you excel clases....congratulations your channel is very good for learn

[yasir]

Ma'am your video tutorials are really amazing and very effective in learning Excel 👍Keep up the good work 👍

[Reallifejourney]

Thank you for your time care and videos. Muchly appreciated! Truly is. Thank you again.

[junniorbundor]

Hey Deb! Thanks very much for the course. Can't tell that much, but your courses are awsome and comprehensive.

[tastein]

Just a quick comment, love the courses. On the offset section, couldn't really see the change when you changed your range to a table, because you still had the range of the cells in the formula to the extended range.

[FayeFryer]

Just over 3 hours into the video. What an absolute belter of a tutorial! I did a couple ECDL courses back a while ago (2014/2015) but work-wise I haven't been using the more advanced features as they haven't been relevant to my role (although I do have an interview coming up where I need to show competence). I wanted to brush up and learn more of the new additions there have been to Excel that have passed me by and this course has been a revelation so far. Definitely one to re-visit time and time again to keep it fresh in my mind. I'm truly grateful as I've no spare funds for a paid course right now and most of my old coursework is a bit outdated / the publisher whose practice files were online appears to be no longer trading, so I've been in a bit of a panic trying to find something intuitive and practical (and safe security wise) to help me out! THANK YOU!

[hazemmelliti]

you are doing a really good job ! thank you for sharing the knowledge <3

[benosborne]

Excellent training. Where can I find all Excel 365 functions/formulas with a short explanation of each?