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
Understanding Your Video Player (notes, video speed, subtitles + more)
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)
Exercise: Text Functions
Exercise: Imposter Syndrome (2:55)
Budget Project: Text Functions (8:18)
Module 8: Logical and Lookup Functions
The IF Function (15:36)
AND and OR (10:44)
VLOOKUP (10:26)
VLOOKUP with IFERROR (9:25)
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
External Data (10:04)
Text to Columns (5:55)
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!
Where To Go From Here?
Thank You! (1:17)
Review This Course!
Become An Alumni
Your Next Step
LinkedIn Endorsements
Exercise: Crunching Numbers With Excel Functions
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