Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 365 Intermediate
Section 1: Introduction
Course Introduction (2:46)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Exercise 01 (1:01)
Section 2: Spreadsheet Fundamentals for Good Design
Design Better Spreadsheets (11:54)
Improve Readability with Cell Styles (7:34)
Control Data Input: Data Validation (6:32)
Add Navigation Buttons (6:00)
Create a Summary Sheet (2:53)
Use Forms to Input Data Quickly (4:00)
Exercise 02 (1:17)
Section 3: Make Better Decisions with Logical Functions
Logical Functions: Basic Recap (6:09)
Logical Functions: AND and OR (7:00)
Nested IF Statements (5:33)
The IFS Function: Simplified Nested Ifs (2:53)
Conditional IF: COUNTIFS and SUMIFS (7:29)
Error Handling with IFERROR and IFNA (4:20)
Use Logical Functions with Conditional Formatting (5:03)
Exercise 03 (1:32)
Section 4: Work with Lookup Formulas
VLOOKUP: Exact and Approx Match (8:37)
Horizontal Lookups: HLOOKUP (6:29)
Flexible Lookups: INDEX and MATCH (7:44)
Modern Lookups: XLOOKUP and XMATCH (7:44)
Lookups with Duplicates (6:59)
Lookups with the CHOOSE Function (4:19)
The SWITCH Function (4:32)
Exercise 04 (1:15)
Section 5: Sort and Filter Like a Pro!
Sort on Multiple Columns (5:39)
Sort with a Custom List (4:41)
The SORT and SORTBY Functions
The FILTER Function
Extract and Sort Unique Values (4:42)
Exercise 05 (1:12)
Section 6: Compare Data
Find Duplicates with Conditional Formatting (4:41)
Find Duplicates with Formulas (2:31)
Exercise 06 (0:59)
Section 7: Statistical Functions
Use Mean, Median and Mode (6:51)
The LARGE and SMALL Functions (9:19)
Rank and Rank Average (8:05)
The SUBTOTAL and AGGREGATE Functions (11:37)
Exercise 07 (0:59)
Section 8: Math Functions
Special Rounding (5:31)
ROUND Values (7:02)
Exercise 08 (1:03)
Section 9: Formatting
Custom Formatting Explained (9:28)
Practical Uses of Custom Formatting (7:16)
Advanced Conditional Formatting (10:52)
Exercise 09 (1:28)
Section 10: Work with Date and Time
Understand Dates and Times (5:05)
Apply Custom Formats (5:49)
Common Time and Date Functions (8:42)
WORKDAY and NETWORKDAYS (7:31)
Calculate Dates with EDATE and EOMONTH (6:36)
Exercise 10 (1:30)
Section 11: Text and Array Manipulation
Import Data from a Text File (4:44)
Clean a Dataset (8:16)
Clean a Dataset with Power Query (7:57)
Split Data: Text to Columns (6:53)
Split Data: The TEXTSPLIT Function (9:30)
Split Data: TEXTBEFORE and TEXTAFTER (7:02)
Join Data: CONCAT and TEXTJOIN (7:29)
TOCOL and TOROW (3:36)
WRAPROWS and WRAPCOLS (5:04)
TAKE and DROP (4:49)
CHOOSECOLS and CHOOSEROWS (3:05)
Exercise 11 (1:32)
Section 12: Analyze Data with PivotTables
PivotTables Explained (3:47)
Create a PivotTable from Scratch (7:01)
Pivot the Fields (3:14)
Apply Number Formatting and Totals (4:22)
Show Values As and Summarize By (5:53)
Group PivotTable Fields (5:33)
Format Error Values and Empty Cells (3:46)
Choose a Report Layout (5:19)
Apply and Modify PivotTable Styles (7:22)
Exercise 12 (1:41)
Section 13: Pivot Charts
Create a Pivot Chart (7:31)
Formatting a Pivot Chart - Part 1 (9:12)
Formatting a Pivot Chart - Part 2 (10:28)
Using Map Charts (5:18)
Exercise 13 (2:13)
Section 14: Add Interaction to PivotTables and Charts
Insert Slicers (6:12)
Format Slicers (9:03)
Insert Timeline Slicers (7:37)
Connect Slicers to Pivot Charts (5:37)
Update PivotTable Data (3:00)
Exercise 14 (1:52)
Section 15: Formula Auditing
Troubleshoot Common Errors (9:56)
Trace and Evaluate Formulas (7:19)
Exercise 15 (1:29)
Section 16: Data Validation
Dynamic Drop-down Lists (5:40)
Input Messages and Error Alerts (3:39)
Exercise 16 (1:42)
Section 17: What-If Analysis Tools
Calculate Repayments on a Loan: PMT Function (9:58)
Goal Seek (5:53)
Data Tables: One and Two Variable (5:49)
Scenario Manager (6:44)
Exercise 17 (1:03)
Section 18: Course Close and Quiz
Course Close (2:35)
Course Quiz and Certificate of Completion
Control Data Input: Data Validation
Complete and Continue