1 Course Outline (31.74 MB)
2 Join Our Online Classroom! (75.31 MB)
4 ZTM Resources (44.48 MB)
6 1 The Excel Bootcamp - Zero To Mastery - Starter Files (24.37 MB)
1 Intro to Modeling (9.36 MB)
2 The PMT Function (36.04 MB)
3 Data Validation Lists (40.71 MB)
4 Scroll Bars (83.44 MB)
5 Named Ranges (60.41 MB)
6 Model Design (37.85 MB)
8 Budget Project Modeling (67.71 MB)
1 Custom Formats (43.53 MB)
2 Conditional Formatting I (43.59 MB)
3 Conditional Formatting II (70.61 MB)
4 Introducing Charts (73.94 MB)
5 Column Charts (48.73 MB)
6 Line Charts (101.79 MB)
8 Budget Project Data Visualization (68.76 MB)
1 Text to Columns (44.63 MB)
2 External Data (73.97 MB)
3 Table Features (86.87 MB)
4 Tables as Named Ranges (148.35 MB)
5 1 External Data Files (35.33 KB)
6 Budget Project Structured Data (78.02 MB)
1 Intro to Pivot Tables (109.92 MB)
2 Adding Layers to Pivot Tables (134.76 MB)
3 Pivot Table Formatting and Layout (84.74 MB)
4 Filtering Pivot Tables (75.13 MB)
5 Slicers (92.09 MB)
6 Pivot Table Math (82.38 MB)
8 Budget Project Pivot Tables (61.3 MB)
1 Intro to Macros (38.8 MB)
2 Running Macros With Buttons (19.4 MB)
3 Editing Macros (63.03 MB)
4 Macros - A Case Study (151.43 MB)
4 1 CSV Data csv (1.09 MB)
6 Budget Project Macros and VBA (59.81 MB)
1 Thank You! (16.87 MB)
1 Hello Excel Part 1 (58.44 MB)
10 Working With Multiple Worksheets (63.09 MB)
11 Find and Replace (96.84 MB)
12 Working With Multiple Workbooks (84.07 MB)
13 Intro to Formatting (20.05 MB)
14 Formatting Numbers (68.64 MB)
15 Formatting Dates and Times (61.32 MB)
16 Font Styles (105.02 MB)
17 Text Wrapping and Alignment (80.66 MB)
18 Cell Borders and Merging (47.58 MB)
2 Hello Excel Part 2 (62.74 MB)
3 Data Entry Part 1 (52.23 MB)
4 Data Entry Part 2 (54.12 MB)
5 Autofill (52.31 MB)
6 Working With Ranges (68.52 MB)
7 Working With Rows and Columns (76.74 MB)
8 Resizing Rows and Columns (73.99 MB)
9 Freezing Rows and Columns (81.17 MB)
1 Intro to Filtering (58.1 MB)
2 Advanced Filtering (136.09 MB)
3 Sorting in Excel (151.08 MB)
1 Intro to Formulas (31.01 MB)
10 Budget Project Formulas 101 (30.21 MB)
2 Arithmetic Formulas (35.47 MB)
3 Applying Formulas to Text (31.74 MB)
4 Applying Formulas to Dates (40.73 MB)
5 Copying and Cutting Formulas (89.06 MB)
6 Cell References (105.83 MB)
7 Hiding Rows and Columns (19.75 MB)
9 Budget Project Introduction (12.69 MB)
1 Intro to Excel Functions (34.59 MB)
2 Arithmetic Functions (102.98 MB)
3 Counting Functions (41.18 MB)
4 The Status Bar (9.05 MB)
5 Rounding and Truncation (35.18 MB)
6 Median (34.19 MB)
7 Standard Deviation (33.75 MB)
9 Budget Project Crunching Numbers With Excel Functions (26.12 MB)
1 Conditional Calculations I (75.62 MB)
2 Conditional Calculations II (79.58 MB)
3 Conditional Calculations III (110.01 MB)
5 Budget Project Conditional Calculations (35.22 MB)
6 Exercise Imposter Syndrome (39.22 MB)
1 Introducing Date and Time Functions (10.55 MB)
2 Parsing Date and Time Components (30.36 MB)
3 The DATE Function (28.98 MB)
4 Applying the DATE and TIME Functions (39.93 MB)
5 DATEDIF and NETWORKDAYS (39.67 MB)
6 Transforming Date Values (52.29 MB)
8 Budget Project Date and Time Functions (44.85 MB)
1 LEFT, RIGHT, and MID (35.45 MB)
2 FIND and LEN (126.08 MB)
3 Text Cleaning Functions (106.49 MB)
5 Budget Project Text Functions (45.55 MB)
1 The IF Function (89.3 MB)
2 AND and OR (72.44 MB)
3 VLOOKUP (64.45 MB)
4 VLOOKUP with IFERROR (81.77 MB)
6 Budget Project IF Statements (23.03 MB)