Excel Training Full Course - Formulas, VLOOKUP, PivotTables & Dashboards (July 2026)
Full 2-day Excel training, both days in one video. Day 1 covers navigation and formatting fundamentals, dates and NETWORKDAYS, absolute references, text functions, COUNTIF, data validation and IF statements. Day 2 covers conditional formatting, VLOOKUP and INDEX/MATCH, PivotTables and charts, and building the interactive dashboard with slicers.
Recorded 27-28 July 2026.
Chapters:
00:00 Introduction
00:10 [Day 1 Morning] Setup - downloading the day 1 and day 2 workbooks
09:06 Freeze panes and moving around large sheets
15:58 Filters
20:15 Resizing columns, autofit and Format as Table
28:44 Where macros, Power Query and AI tools fit in
50:32 Working with dates
58:53 Custom number and date formats
1:08:32 NETWORKDAYS - response time in working days
1:18:47 Absolute vs relative references ($)
1:35:21 Tracing precedents and auditing formulas
1:48:44 TRIM and PROPER - cleaning text
1:52:52 Text to Columns
2:16:18 LEN - measuring text length
2:17:24 LEFT, RIGHT and MID
2:29:43 CONCAT - joining text back together
2:37:48 [Day 1 Afternoon] Session start
2:44:20 Filters
2:48:34 COUNTIF
3:01:03 Data validation - building a basic dropdown
3:08:37 Advanced Filter - extracting unique records
3:25:28 Building a dropdown from a unique list
3:29:43 Comparison operators - not equals to
3:30:40 IF statements - structuring the logical test
3:46:31 SUMIFS
3:57:55 Practice - conditional totals by division
4:20:29 TRUE and FALSE results explained
4:45:22 Nested IF - multiple conditions
5:14:29 [Day 2 Morning] Day 1 recap - shortcuts, dates and COUNTIF
5:22:08 IF statements - building the logical test
5:48:34 Practice - bonus calculation with multiple conditions
6:15:53 Conditional formatting - introduction
6:19:35 Data bars, colour scales and icon sets
6:25:10 Managing, editing and deleting rules
6:33:17 Text rules and formula-driven formatting
7:21:00 Highlighting duplicates and unique values
7:26:37 Lookups - Day 2 material begins
7:30:15 VLOOKUP
7:49:28 INDEX and MATCH
7:56:48 Practice and wrap before the break
8:03:35 [Day 2 Afternoon] Session start
8:11:11 Dropdown practice
8:16:31 What we're building - the interactive dashboard
8:27:34 PivotTables - the first build
8:30:18 Format as Table (Ctrl+T) before pivoting
8:39:51 Building the dashboard from the data set
8:51:29 Inserting slicers
9:00:02 Donut and bar charts
9:05:36 Chart anatomy - legend, title, gridlines
9:06:31 Data labels and formatting
9:35:35 Connecting slicers across charts
9:38:24 Naming pivot tables
9:51:38 Turning off gridlines for the dashboard look
10:20:29 Conditional formatting on the dashboard