The Ultimate MS Excel Crash Course: 6-Hour Microsoft Excel 2016 Tutorial for Beginners

In this mega, 6-hour long Excel 2016 tutorial for beginners, you'll finally learn how to use Microsoft Excel including Excel formulas and functions such as VLOOKUP. By the end of this Excel tutorial, you'll be well on your way to mastering spreadsheets.

This Excel course is packed full of Excel tips, tricks, and hacks on how to get the most from your spreadsheets! Over 6-hours, we cover many different areas of Excel, including Excel formulas, formatting in Excel, VLOOKUP in Excel and so much more.

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

- Introduction to the Excel Course and Exercise Files - 0:00
- Basics of Using the Ribbon - 2:47
- Quick Access Toolbar - 18:07
- Mini Toolbars and Contextual Menus - 24:06
- Status Bar - 27:41
- Basics of Entering and Editing Data in a Workbook - 32:43
- Exercise 01 - 46:13
- Formatting Dates - 48:03
- Formatting Numbers - 1:00:40
- Exercise 02 - 1:14:28
- Working with Fill and Series - 1:16:11
- Flash Fill - 1:25:20
- Workbook Views, Zoom, and Freeze - 1:29:25
- Printing - 1:38:06
- Exercise 03 - 1:53:05
- Methods of Cutting, Copying, and Pasting - 1:56:01
- Delete and Clear - 2:09:33
- Insert, Hide, Column Width and Row Height, and Merge - 2:23:18
- Alignment - 2:36:06
- Themes and Styles - 2:48:10
- Exercise 04 - 2:59:29
- Basics of Formulas and Functions - 3:01:14
- Complex Examples of Formulas - 3:12:29
- Exercise 05 - 3:26:35
- Managing Worksheets - 3:30:02
- Working with Multiple Workbooks -3:38:42
- Saving in Different File Types - 3:54:31
- The Spell Checker - 4:07:34
- Inserting Comments - 4:20:42
- Exercise 06 - 4:26:06
- The VLOOKUP Function - 4:29:07
- Text Functions - 4:43:14
- Date and Time Functions - 4:51:31
- Logical Functions - 4:58:19
- Creating Graphs and Charts - 5:14:10
- Customizing a Cluster Column Chart - 5:26:20
- Customizing a Pie Chart - 5:42:02
- New Chart Types in Excel 2016 - 5:55:38
- Exercise 7 - 5:58:08


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

[maxpachec]

My whole semester in six hours,
But better explained and actually enjoyable

[Why-yqwj]

The fact that Toby provides such an in depth course, right frorm the basics, puts so much effort into making sure that everyone would understand and follow, for free, is an amazing thing. Thank you so much.

[guner]

Thank you so much, I took this course last night for an assessment on hiring process and I was just offered the job!

[Abkrknn]

Finally I found a tutor with British accent:-)) Thanks Simon.

[stephengreenway]

Great Crash Course. I just needed a refresher, but ended up learning quite a bit more than I thought I would. Thank you very much Simon.

[charlotte_nvdt]

I'm a college student and I'm following an advanced excel course, but I've never really worked with excel before. This video has helped me so much! Thank you for taking the time and making it!

BTW for people wondering, I'm using Excel 2019, and you can easily follow this video with that!

[Julie-homz]

This is a great course!! I had no excel experience and I am learning so much!! Thank you for providing this information!

[celanadimitrijevik]

Thank you for providing this course, Mr. Simon!! Excellent tutorial.

[saleemmahar]

Simon Sez you've done a great job by offering this video to people like me!!!! Excellent style and presentation techniques. Thank you, Mr. Simon!!!

[momarsagang]

Thank you so much for this course. Your effort is highly appreciated.

[samanthianoal]

I have to say, you make something that seems so difficult become easy! Thank you

[luckyapple]

What an excellent & eloquent the real english language is..

[goshehroz]

Simon: "I'm a Microsoft certified professional"
Me: Oh it's the guy who fixed my computer for £2000 last week!

[ikhtiarapon]

This is a great course.
Thanks for doing that for us.
I really appreciate your work.

[aliceanderson]

I am a detail person and that is how I learn. This had amazing details and I learned a lot. I am looking forward to pratiing and using what I have learned so far and am going to do the next level after I have the 1st level down pat. WOW!! Great Stuff!!

[josephamoforitse]

Thank you so much for doing justice to this course in six hours. You are a great teacher!

[vincent]

Great 6-hour course to get the basics straight even for intermediate Excel users! Thanks a lot!

[ahmadmahadi]

This is a type of YouTuber who deserves million of subscriber... not some morons out there who does stupid pranks...

[amyrajpat]

I never got the chance to do the Excel co-curricular course offered at my university and since I barely know anything about Excel and most jobs in my field of study require you to use Excel, I thought I would find a crash course on it. I just came from watching the one on Word and I learned things I hadn't known before. Definitely looking forward to this one.

[dillighimire]

This is the Brilliant course for beginners !