Microsoft Excel 365 Tutorial: 3+ Hours of Advanced Excel Training

Опубликовано: 28 Сентябрь 2024
на канале: Simon Sez IT

5,168

280

✅Download the free course files and follow along here:
➡️https://www.simonsezit.com/excel-365-...

Welcome to the Microsoft Excel 365 Advanced Tutorial, designed to boost your data analysis and productivity skills with advanced Excel 365 features. Delve into dynamic array formulas like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn complex lookups and reference functions, even with multiple criteria. Discover how to create custom functions with LET and LAMBDA, tailoring formulas to your needs. Master Power Pivot and Power Query for effortless data management and analysis.

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

00:00:09 - Course Introduction
00:03:59 - Exercise 01
00:05:01 - What are Dynamic Array Functions?
00:07:26 - Introduction to Spills and Arrays
00:13:35 - Extract and Count Unique Entries
00:17:16 - Unique vs Distinct
00:21:26 - Extract Multiple Unique Columns
00:23:47 - Extract Unique Values by Column
00:27:23 - The SORT Function
00:33:12 - The SORT Function - Horizontal Sort
00:39:18 - The SORTBY Function
00:43:39 - The SORTBY Function - Horizontal SORTBY
00:47:38 - The SEQUENCE Function
00:52:29 - The FILTER Function
00:58:34 - FILTER with Logic: + Operator (OR)
01:03:48 - FILTER with Logic: * Operator (AND)
01:07:47 - FILTER with Logic: = Operator (Both or Neither Criteria)
01:10:56 - FILTER with Logic: - Operator (One or the Other but Not Both)
01:14:21 - RANDARRAY and RANDBETWEEN
01:23:43 - Use XLOOKUP to Perform Complex Lookups
01:31:11 - The XMATCH Function
01:35:20 - Exercise 02
01:36:47 - Lookups with Multiple Criteria
01:43:05 - Lookups with Duplicate Values
01:48:44 - Exercise 03
01:50:32 - The LET Function
02:00:06 - Create Your Own Formulas with LAMBDA
02:11:33 - Exercise 04
02:13:33 - Create a Data Model in Power Pivot
02:20:10 - Create Relationships Between Tables
02:24:34 - Add Calculated Columns
02:30:32 - Build a PivotTable from Multiple Sources
02:34:24 - Exercise 05
02:35:38 - Import Data Using Power Query
02:41:03 - Clean Data with Power Query
02:50:21 - Combine Files from a Folder
02:56:49 - Add More Files to the Data Model and Refresh
03:03:29 - Exercise 06

🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/

🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ https://www.simonsezit.com/ssit-first...

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

🔥Check out our FREE 400+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses

✅ Check out our free video playlist for Excel beginners 👉   • Microsoft Excel Beginner's Training T...

✅ Excel 2021 Tutorials for Intermediate Users here 👉   • Excel 2021 Tutorials for Intermediate...

✅ Microsoft Excel Tips and Tricks 👉   • Microsoft Excel Tips and Tricks

✅ Microsoft Office 2021 and Office 365 Training here 👉   • Microsoft Office 2021 and Office 365 ...

💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simon-sez-it
FaceBook:   / simonsezit

🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittra...

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