Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Intermediate Excel 2021
Section 1: Introduction
Course Introduction (6:16)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Section 2: Designing Better Spreadsheets
The Golden Rules of Spreadsheet Design (11:54)
Improving Readability with Cell Styles (4:58)
Controlling Data Input (8:19)
Adding Navigation Buttons (8:42)
Section 3: Making Decisions with Logical Functions
Logical Functions (AND, OR, IF) (13:18)
The IF Function (5:26)
Nested IFs (8:01)
The IFS Function (6:04)
Conditional IFs (SUMIF, COUNTIF, AVERAGEIF) (6:45)
Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS) (7:12)
Error Handling with IFERROR and IFNA (6:01)
Exercise 01 (7:29)
Section 4: Looking Up Information
Looking Up Information using VLOOKUP (Exact Match) (10:41)
Looking Up Information using VLOOKUP (Approx Match) (4:25)
Looking Up Information Horizontally using HLOOKUP (5:38)
Performing Flexible Lookups with INDEX and MATCH (10:28)
Using XLOOKUP and XMATCH (10:09)
The OFFSET Function (10:50)
The INDIRECT Function (9:07)
Exercise 02 (5:03)
Section 5: Advanced Sorting and Filtering
Performing Sorts on Multiple Columns (7:03)
Sorting Using a Custom List (3:35)
The SORT and SORTBY Functions (10:00)
Using the Advanced Filter (6:52)
Extracting Unique Values - The UNIQUE Function (5:16)
The FILTER Function (9:29)
Exercise 03 (5:41)
Section 6: Working with Date and Time
Understanding How Dates are Stored in Excel (4:11)
Applying Custom Date Formats (7:09)
Using Date and Time Functions (8:44)
Using the WORKDAY and WORKDAY.INT Functions (3:49)
Using the NETWORKDAYS and NETWORKDAYS.INT Function (2:56)
Tabulate Date Differences with the DATEDIF Function (6:14)
Calculate Dates with EDATE and EOMONTH (7:22)
Exercise 04 (4:51)
The Golden Rules of Spreadsheet Design
Complete and Continue