Microsoft Excel Intermediate

Week 1

Data Entry form (5:30)
Data Validation Basics (5:42)
Data validation for text data (4:58)
Using formulas in validation criteria (3:06)
Autofill introduction (3:38)
Flash fill (2:49)
Absolute referencing (5:41)
Named cells (3:24)
Named ranges (1:58)

Week 2: Tables and conditional formatting

Creating tables (2:30)
Modifying tables (3:40)
Sorting data in tables (1:35)
Filtering data in tables (5:58)
Structured referencing (4:39)
Introduction to conditional formatting (1:34)
Using built-in conditional formatting (5:41)
Custom conditional formatting (6:17)
Conditional formatting using formulas (6:15)

Week 3: Conditional calculations

SUMIF (6:52)
AVERAGEIF (5:04)
Numeric criteria (3:42)
Date criteria (5:14)
COUNTIF (2:15)
SUMIFS (5:13)
AVERAGEIFS (2:36)
COUNTIFS (2:54)
MAXIFS and MINIFS (4:54)

Week 4: Logical, date and time functions

IF (7:24)
IF, AND (5:56)
IF, OR (4:57)
Nested IF (9:29)
IFS (4:11)
Basics of dealing with dates in Excel (4:20)
NOW and TODAY (1:51)
EDATE and EOMONTH (3:49)
DAYS (1:29)
DATEDIF (2:29)
NETWORKDAYS (2:48)

Week 5: Text and lookup functions

CONCATENATE (9:17)
TRIM (3:14)
LEFT (5:59)
MID (1:18)
RIGHT (3:41)
VLOOKUP (9:07)
HLOOKUP (3:33)
INDEX and MATCH (14:51)
XLOOKUP (6:32)

Week 6: Charts, pivot tables and pivot charts

Criteria for choosing a type of chart (9:07)
Creating bar and column charts (11:28)
Introduction to chart customization (6:57)
Customizing bar and column charts (5:20)
Creating and customizing line charts (6:45)
Creating and customizing pie charts (5:36)
Creating and customizing combo charts (4:04)
Creating and customizing sparklines (5:21)
Introduction to pivot tables (2:13)
Using automatic pivot tables (5:19)
Creating a pivot table from scratch (6:33)
Creating calculated fields in the pivot table (1:54)
Sorting and filtering pivot tables (6:14)
Customizing pivot tables (5:19)

Named cells

Download