Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Zero To Mastery

The Excel Bootcamp: Zero to Mastery

via Zero To Mastery

Go to class Write review

Overview

The only course you need to become an Excel and Data Analysis master. Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or supplement your career with data analysis and modeling skills so you can get hired.
  • Become a top 10% Excel power user to enhance your skillset and career opportunities
  • Build a Budget Project where you create a personal budgeting spreadsheet that teaches you Excel while analyzing your own finances
  • Automate your day-to-day tasks through Macros and VBA
  • Transform and clean text data with Excel functions like LEFT/RIGHT, MID, FIND, SUBSTITUTE, and TRIM
  • Analyze large datasets with Excel Pivot Tables
  • Use Excel for rapid development of data-driven applications
  • Use Excel's extensive collection of visualizations to “tell the story” of even the most complex data in an intuitive and visually appealing way
  • Use Excel's powerful charting engine to tell the story of your data with attractive data visualizations
  • Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
  • Manipulate date and time data with functions like DATEDIF and NETWORKDAYS
  • Learn how to work with external datasets
  • Data entry tips and tricks
  • Learn why Excel is one of the most popular pieces of software across all industries
  • Start or supplement your programming journey by recording VBA macros in Excel

Syllabus

  •   Introduction
    • The Excel Bootcamp: Zero to Mastery
    • Course Outline
    • Exercise: Meet Your Classmates and Instructor
    • Understanding Your Video Player
    • Course Resources (Starter Files & Cheatsheet)
    • Set Your Learning Streak Goal
  •   Module 1: Excel 101
    • Hello Excel Part 1
    • Hello Excel Part 2
    • Data Entry Part 1
    • Data Entry Part 2
    • Autofill
    • Working With Ranges
    • Working With Rows and Columns
    • Resizing Rows and Columns
    • Freezing Rows and Columns
    • Working With Multiple Worksheets
    • Find and Replace
    • Working With Multiple Workbooks
    • Intro to Formatting
    • Formatting Numbers
    • Formatting Dates and Times
    • Font Styles
    • Text Wrapping and Alignment
    • Cell Borders and Merging
    • Exercise: Excel 101
    • Let's Have Some Fun (+ Free Resources)
  •   Module 2: Filtering and Sorting Data
    • Intro to Filtering
    • Advanced Filtering
    • Sorting in Excel
    • Exercise: Filtering and Sorting Data
    • Unlimited Updates
  •   Module 3: Excel Formulas 101
    • Intro to Formulas
    • Arithmetic Formulas
    • Applying Formulas to Text
    • Applying Formulas to Dates
    • Copying and Cutting Formulas
    • Cell References
    • Hiding Rows and Columns
    • Exercise: Formulas 101
    • Budget Project: Introduction
    • Budget Project: Formulas 101
    • Course Check-In
  •   Module 4: Crunching Numbers With Excel Functions
    • Intro to Excel Functions
    • Arithmetic Functions
    • Counting Functions
    • The Status Bar
    • Rounding and Truncation
    • Median
    • Standard Deviation
    • Exercise: Crunching Numbers With Excel Functions
    • Budget Project: Crunching Numbers With Excel Functions
    • Implement a New Life System
  •   Module 5: Conditional Calculations
    • Conditional Calculations I
    • Conditional Calculations II
    • Conditional Calculations III
    • Exercise: Conditional Calculations
    • Budget Project: Conditional Calculations
  •   Module 6: Date and Time Functions
    • Introducing Date and Time Functions
    • Parsing Date and Time Components
    • The DATE Function
    • Applying the DATE and TIME Functions
    • DATEDIF and NETWORKDAYS
    • Transforming Date Values
    • Exercise: Date and Time Functions
    • Budget Project: Date and Time Functions
  •   Module 7: Text Functions
    • LEFT, RIGHT, and MID
    • FIND and LEN
    • Text Cleaning Functions
    • TEXTJOIN
    • Exercise: Text Functions
    • Budget Project: Text Functions
    • Exercise: Imposter Syndrome
  •   Module 8: Logical and Lookup Functions
    • The IF Function
    • AND and OR
    • IFS
    • VLOOKUP
    • VLOOKUP with IFERROR
    • XLOOKUP
    • Handling Errors with XLOOKUP
    • Matching Lists
    • Exercise: Logical and Lookup Functions
    • Budget Project: IF Statements
  •   Module 9: Modeling in Excel
    • Intro to Modeling
    • The PMT Function
    • Data Validation Lists
    • Scroll Bars
    • Named Ranges
    • Model Design
    • Exercise: Modeling
    • Budget Project: Modeling
  •   Module 10: Data Visualization in Excel
    • Custom Formats
    • Conditional Formatting I
    • Conditional Formatting II
    • Introducing Charts
    • Column Charts
    • Line Charts
    • Exercise: Data Visualization
    • Budget Project: Data Visualization
  •   Module 11: Working With Structured Data in Excel
    • Text to Columns
    • External Data
    • Table Features
    • Tables as Named Ranges
    • Exercise: Working With Structured Data in Excel
    • Budget Project: Structured Data
  •   Module 12: Pivot Tables
    • Intro to Pivot Tables
    • Adding Layers to Pivot Tables
    • Pivot Table Formatting and Layout
    • Filtering Pivot Tables
    • Slicers
    • Pivot Table Math
    • Exercise: Pivot Tables
    • Budget Project: Pivot Tables
  •   Module 13: Dynamic Array Functions in Excel
    • Section Resources
    • SEQUENCE
    • SORT
    • UNIQUE
    • CHOOSECOLS
    • FILTER I
    • Combining FILTER, CHOOSECOLS and SORT
    • FILTER II
    • FILTER III
    • Refactoring with Tables
    • Refactoring with LET
    • Project 1 - Introduction
    • Project 1 - Solution
    • Combining FILTER, UNIQUE and SORT
    • Referencing Dynamic Arrays I
    • Referencing Dynamic Arrays II
    • Creating Dynamic Drop - Down Lists
    • Project 2 - Introduction
    • Project 2 - Solution
    • GROUPBY - Part 1
    • GROUPBY - Part 2
    • GROUPBY - Part 3
    • PIVOTBY
    • Project 3 - Introduction
    • Project 3 - Solution
  •   Module 14: Macros and VBA
    • Intro to Macros
    • Running Macros With Buttons
    • Editing Macros
    • Macros - A Case Study
    • Exercise: Macros and VBA
    • Budget Project: Macros and VBA
    • More VBA!
  •   Capstone Project: Build a Retirement Planner with Excel
    • Capstone Project Demo
    • Capstone Project Resources + An Important Note!
    • Introducing the Project Template
    • Applying Number Formats
    • Solution: Applying Number Formats
    • Creating Drop Down Lists
    • Solution: Creating Drop Down Lists
    • Creating the Retirement Age Slider
    • Solution: Creating the Retirement Age Slider
    • Applying Cell Styles
    • Solution: Applying Cell Styles
    • Defining Names
    • Solution: Defining Names
    • Fetching the Investment Return
    • Solution: Fetching the Investment Return
    • Plan Year and Age
    • Solution: Plan Year and Age
    • Working Income
    • Solution: Working Income
    • Income Tax and Yearly Expenditures
    • Solution: Income Tax and Yearly Expenditures
    • Yearly Savings
    • Solution: Yearly Savings
    • Earned Interest and Retirement Savings Balance
    • Solution: Earned Interest and Retirement Savings Balance
    • Earned Interest and Retirement Savings Balance II
    • Solution: Earned Interest and Retirement Savings Balance II
    • Wrapping Up the Calculations Worksheet
    • Solution: Wrapping Up the Calculations Worksheet
    • Retirement Age and Years Calcs
    • Solution: Retirement Age and Years Calcs
    • The Banner Message
    • Solution: The Banner Message
    • The Retirement Balance Chart
    • Solution: The Retirement Balance Chart
    • Dynamic Charts with OFFSET I
    • Dynamic Charts with OFFSET II
    • Solution: Dynamic Charts with OFFSET
    • Formatting the Retirement Balance Chart
    • Solution: Formatting the Retirement Balance Chart
    • The Detail Worksheet
    • Solution: The Detail Worksheet
    • The End (a.k.a. Retirement)
  •   Where To Go From Here?
    • Thank You!
    • Review This Course!
    • Become An Alumni
    • Learning Guideline
    • ZTM Events Every Month
    • LinkedIn Endorsements

Taught by

Travis Cuzick

Reviews

Start your review of The Excel Bootcamp: Zero to Mastery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.