Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Excel Bootcamp: Zero to Mastery
Introduction
The Excel Bootcamp: Zero to Mastery (2:53)
Course Outline (5:12)
Exercise: Meet Your Classmates and Instructor
ZTM Plugin + Understanding Your Video Player
Course Resources (Starter Files & Cheatsheet)
Set Your Learning Streak Goal
Module 1: Excel 101
Hello Excel Part 1 (10:02)
Hello Excel Part 2 (12:10)
Data Entry Part 1 (11:54)
Data Entry Part 2 (10:38)
Autofill (10:54)
Working With Ranges (11:28)
Working With Rows and Columns (9:40)
Resizing Rows and Columns (9:35)
Freezing Rows and Columns (9:47)
Working With Multiple Worksheets (10:33)
Find and Replace (14:01)
Working With Multiple Workbooks (10:23)
Intro to Formatting (4:35)
Formatting Numbers (11:06)
Formatting Dates and Times (11:27)
Font Styles (11:30)
Text Wrapping and Alignment (10:38)
Cell Borders and Merging (9:19)
Exercise: Excel 101
Let's Have Some Fun (+ Free Resources)
Module 2: Filtering and Sorting Data
Intro to Filtering (8:10)
Advanced Filtering (16:00)
Sorting in Excel (14:25)
Exercise: Filtering and Sorting Data
Unlimited Updates
Module 3: Excel Formulas 101
Intro to Formulas (8:28)
Arithmetic Formulas (9:50)
Applying Formulas to Text (7:48)
Applying Formulas to Dates (9:03)
Copying and Cutting Formulas (12:20)
Cell References (13:36)
Hiding Rows and Columns (2:49)
Exercise: Formulas 101
Budget Project: Introduction (1:52)
Budget Project: Formulas 101 (6:21)
Course Check-In
Module 4: Crunching Numbers With Excel Functions
Intro to Excel Functions (10:45)
Arithmetic Functions (14:36)
Counting Functions (6:03)
The Status Bar (2:23)
Rounding and Truncation (9:10)
Median (8:22)
Standard Deviation (7:53)
Exercise: Crunching Numbers With Excel Functions
Budget Project: Crunching Numbers With Excel Functions (5:34)
Implement a New Life System
Module 5: Conditional Calculations
Conditional Calculations I (12:19)
Conditional Calculations II (12:09)
Conditional Calculations III (14:12)
Exercise: Conditional Calculations
Budget Project: Conditional Calculations (4:52)
Module 6: Date and Time Functions
Introducing Date and Time Functions (4:15)
Parsing Date and Time Components (7:34)
The DATE Function (5:49)
Applying the DATE and TIME Functions (7:30)
DATEDIF and NETWORKDAYS (9:09)
Transforming Date Values (6:37)
Exercise: Date and Time Functions
Budget Project: Date and Time Functions (8:35)
Module 7: Text Functions
LEFT, RIGHT, and MID (6:13)
FIND and LEN (15:20)
Text Cleaning Functions (10:16)
TEXTJOIN (11:35)
Exercise: Text Functions
Budget Project: Text Functions (8:18)
Exercise: Imposter Syndrome (2:55)
Module 8: Logical and Lookup Functions
The IF Function (15:36)
AND and OR (10:44)
IFS (11:57)
VLOOKUP (10:26)
VLOOKUP with IFERROR (9:25)
XLOOKUP (12:00)
Handling Errors with XLOOKUP (8:49)
Exercise: Logical and Lookup Functions
Budget Project: IF Statements (4:10)
Module 9: Modeling in Excel
Intro to Modeling (2:58)
The PMT Function (7:07)
Data Validation Lists (8:16)
Scroll Bars (16:11)
Named Ranges (11:15)
Model Design (7:25)
Exercise: Modeling
Budget Project: Modeling (11:53)
Module 10: Data Visualization in Excel
Custom Formats (9:09)
Conditional Formatting I (7:09)
Conditional Formatting II (10:18)
Introducing Charts (13:10)
Column Charts (7:09)
Line Charts (12:07)
Exercise: Data Visualization
Budget Project: Data Visualization (9:55)
Module 11: Working With Structured Data in Excel
Text to Columns (5:55)
External Data (10:04)
Table Features (9:58)
Tables as Named Ranges (14:09)
Exercise: Working With Structured Data in Excel
Budget Project: Structured Data (9:32)
Module 12: Pivot Tables
Intro to Pivot Tables (13:03)
Adding Layers to Pivot Tables (14:08)
Pivot Table Formatting and Layout (10:57)
Filtering Pivot Tables (10:03)
Slicers (11:12)
Pivot Table Math (9:44)
Exercise: Pivot Tables
Budget Project: Pivot Tables (6:28)
Module 13: Macros and VBA
Intro to Macros (9:24)
Running Macros With Buttons (4:53)
Editing Macros (9:44)
Macros - A Case Study (19:27)
Exercise: Macros and VBA
Budget Project: Macros and VBA (6:52)
More VBA!
Capstone Project: Build a Retirement Planner with Excel
Capstone Project Demo (5:24)
Capstone Project Resources + An Important Note!
Introducing the Project Template (2:47)
Applying Number Formats (2:53)
Solution: Applying Number Formats (2:05)
Creating Drop Down Lists (1:40)
Solution: Creating Drop Down Lists (3:37)
Creating the Retirement Age Slider (2:36)
Solution: Creating the Retirement Age Slider (4:24)
Applying Cell Styles (4:11)
Solution: Applying Cell Styles (3:08)
Defining Names (3:24)
Solution: Defining Names (3:42)
Fetching the Investment Return (3:43)
Solution: Fetching the Investment Return (5:22)
Plan Year and Age (3:34)
Solution: Plan Year and Age (2:10)
Working Income (3:29)
Solution: Working Income (3:38)
Income Tax and Yearly Expenditures (2:00)
Solution: Income Tax and Yearly Expenditures (2:50)
Yearly Savings (1:20)
Solution: Yearly Savings (2:32)
Earned Interest and Retirement Savings Balance (2:25)
Solution: Earned Interest and Retirement Savings Balance (2:24)
Earned Interest and Retirement Savings Balance II (4:21)
Solution: Earned Interest and Retirement Savings Balance II (5:06)
Wrapping Up the Calculations Worksheet (4:44)
Solution: Wrapping Up the Calculations Worksheet (5:40)
Retirement Age and Years Calcs (3:42)
Solution: Retirement Age and Years Calcs (2:49)
The Banner Message (5:31)
Solution: The Banner Message (4:23)
The Retirement Balance Chart (1:51)
Solution: The Retirement Balance Chart (4:56)
Dynamic Charts with OFFSET I (8:35)
Dynamic Charts with OFFSET II (14:28)
Solution: Dynamic Charts with OFFSET (8:43)
Formatting the Retirement Balance Chart (3:20)
Solution: Formatting the Retirement Balance Chart (3:31)
The Detail Worksheet (4:46)
Solution: The Detail Worksheet (8:07)
The End (a.k.a. Retirement) (1:00)
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Learning Guideline
ZTM Events Every Month
LinkedIn Endorsements
Budget Project: Modeling
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures