Microsoft Excel 365 Intermediate Training: 4+ Hour Excel Tutorial Class

In this tutorial, we'll walk you through various essential topics to enhance your spreadsheet skills. Learn how to design better spreadsheets, improve readability with cell styles, and control data input with data validation. Discover how to add navigation to a workbook and create a summary sheet for efficient organization. Speed up your workflow with forms to input data quickly. Dive into logical functions with a basic recap, AND, OR, nested IF statements, and more. Master conditional IF statements, error handling, and logical functions with conditional formatting. Explore VLOOKUP, HLOOKUP, INDEX and MATCH, XLOOKUP, XMATCH, and other modern lookup techniques. Handle duplicates with ease and perform statistical analysis using functions like MEAN, MEDIAN, MODE, and more. Plus, learn sorting techniques, find duplicates, round values, and unlock the power of custom formatting and advanced conditional formatting. Whether you're a beginner or looking to refine your skills, this tutorial has something for everyone.

📝 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 - Course Introduction
00:02:00 - Exercise 01
00:03:00 - Design Better Spreadsheet
00:14:55 - Improve Readability with Cell Styles
00:22:29 - Control Data Input: Data Validation
00:29:02 - Add Navigation to a Workbook
00:35:02 - Create a Summary Sheet
00:37:57 - Use Forms to Input Data Quickly
00:42:16 - Exercise 02
00:43:34 - Logical Functions: Basic Recap
00:49:44 - Logical Functions: AND and OR
00:56:43 - Nested IF Statements
01:02:17 - The IFS Function
01:05:11 - Conditional IF: COUNTIFS and SUMIFS
01:12:39 - Error Handling with IFERROR and IFNA
01:17:00 - Use Logical Functions with Conditional Formatting
01:22:03 - Exercise 03
01:23:37 - VLOOKUP: Exact vs Approx Match
01:32:13 - HLOOKUP
01:38:41 - Flexible Lookups: INDEX and MATCH
01:46:26 - Modern Lookups: XLOOKUP and XMATCH
01:54:10 - Lookups with Duplicates
02:01:09 - Lookups with the CHOOSE Function
02:05:29 - The SWITCH Function
02:10:02 - Exercise 04
02:11:17 - Sort on Multiple Columns
02:16:56 - Sort with a Custom List
02:21:38 - The SORT and SORTBY Functions
02:29:26 - The FILTER Function
02:39:31 - Extract and Sort Unique Values
02:44:13 - Exercise 05
02:45:27 - Find Duplicates with Conditional Formatting
02:50:08 - Find Duplicates with Formulas
02:52:38 - Exercise 06
02:53:37 - Use Mean, Median and Mode
03:00:00 - The LARGE and SMALL Functions
03:09:49 - RANK and RANK Average
03:17:54 - The SUBTOTAL and AGGREGATE Functions
03:29:31 - Exercise 07
03:30:31 - ROUND Values
03:37:33 - Special Rounding
03:43:04 - Exercise 08
03:44:07 - Custom Formatting Explained
03:53:36 - Practical Uses of Custom Formatting
04:00:52 - Advanced Conditional Formatting
04:11:45 - Exercise 09
04:13:12 - Conclusion

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

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

💬Stay in touch!

🔔 Subscribe to our channel:

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

[HalpPlsxx]

This video is a game changer. This is like 65% - 70% of what you need to know in excel 365 to become a data analyst. Insane value for free. Much gratitude.

[latifaanggrek]

Thanks for making this tutorial. May god always bless you for being kind ❤

[damithbodhikotuwa]

really supportive, thank you very much Deb for your excellent teaching methods.

[anniesuem]

Deb thank you so much for making all your tutorials so enjoyable. I feel like they are my happy place.

[akulanarayana]

This Is The Tutorial needed in this present scenario beside many other videos 🎉

[timesavertricks]

Deby as always you are simply best with examples as well as explanation.
Regarding Filter can you provide tutorial where we have multiple columns in Main data.
But we need only specific columns data extracted using Filter formula.
e.g - we have 10 column of data, but we need random, non-consecutive 5 or 7 column data only.

[JayaV-lonq]

Thank you ...one -- Microsoft Excel 365

[SuperLittlewillies]

Thank you for a great course, i'm learning a great deal. I have one problem in that when you say use the ALT + 30 or any ALT key mine doesnt work is it my laptop or excel 365

[sanketv]

@1:59, , can d5 formula formula be made without helper (extra column), means just referring b8:d27 in lookup?

[sanketv]

03-03-nested ifs @1:02:04, please make an explanatory video as how to use XLOOKUP

[sanketv]

@41:00, can we make validations in form that comes from excel application

[benosborne]

Hi thumbnail say expert training but it is Intermediate.

[camilleadams]

I realize this is a free lesson but I would appreciate your recording to not go in and out of focus at any time.

[goraji]

ADD CELLS IN INCREMENTAL ORDER
A1+A2
A1+a2 +A3
A1+A2+A3+....An