✅ Download the free course files to follow along and complete the exercises here ➡️https://www.simonsezit.com/microsoft-excel-365-intermediate-training-course-files/
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
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ 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 👍🏽 ;-)