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
Creating the Retirement Age Slider
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