1 -Introduction (20.92 MB)
2 -Download Excel files (1.46 MB)
1 -Developer Tab (35.78 MB)
2 -Macro Basics (39.38 MB)
3 -Relative Reference Macros (25.78 MB)
4 -VBA Basics (50.59 MB)
5 -Cleaning Up Macros (63.29 MB)
1 -IF Function Basics (50.08 MB)
2 -IF Functions with Calculations (36.91 MB)
3 -Nesting AND with IF (52.97 MB)
1 -Naming Ranges and COUNTIF (59.89 MB)
2 -SUMIF and AVERAGEIF (48.78 MB)
3 -SUMIFS (39.29 MB)
1 -XLOOKUP (86.14 MB)
2 -Populating Forms with XLOOKUP (107.99 MB)
1 -Displaying Pivot Table Fields with COUNT Function (35.94 MB)
2 -Calculated Fields (59.07 MB)
3 -Slicers (55.77 MB)
4 -Using the Timeline (48.07 MB)
5 -Inserting Report Filter Pages (41.13 MB)
1 -Flash Fill for Text Functions (82.04 MB)
1 -Array Formula Basics (50.74 MB)
2 -Looking Up Multiple Values with XLOOKUP (43.12 MB)
3 -Array Functions (53.44 MB)
1 -Advanced Conditional Formatting (84.24 MB)
1 -Combo Charts (61.02 MB)