Back to courses

The Excel Bootcamp

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 in 2023.

instructor

Taught by: Travis Cuzick

Last updated: March 2023

Course overview

We guarantee you that this is the best and most up-to-date Excel Bootcamp that you can find. You will learn Excel from scratch including advanced topics like data analysis & modeling, pivot tables, and VBA. You'll build your own professional spreadsheets and charts, and have the skills to get hired as a Data Analyst in 2023!

What you'll learn

  • 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

Why learn Excel?

Because it's one of the most powerful applications ever built, with a massive and widely underappreciated feature set. It has the horsepower and flexibility to play a crucial role in any Data Analyst and Developer’s toolbox.

If you squint just a little bit, Microsoft Excel absolutely has all the essential components of a full-stack application development platform. And for rapid development of data-driven applications, you’d be hard-pressed to find a better solution.

Bottom line: whether you're a programming novice or an experienced developer, or you need to use data for any reason, there's a good chance Excel has something for you.

The next time you're tempted to scoff at a colleague using Excel, consider that it just might be the fastest, best tool for the job they're doing... and it might just be for the job you're doing too.

Why this Excel course?

This Excel Bootcamp is focused on efficiency.

So you never have to waste your time on confusing, out-of-date, incomplete tutorials anymore.

Instead, you'll learn everything from the basics to using the most advanced features and functions Excel has to offer. All in one course.

And you'll be learning Excel in a fun and supportive envrionment.

By enrolling today, you’ll also get to join our exclusive live online community classroom to learn alongside thousands of students, alumni, mentors, TAs and Instructors.

Most importantly, you will be learning from an industry expert that has actual real-world experience working as a Data Solutions Engineer on massive datasets for some of the largest companies.

Here is what the course will cover to take you from Zero to Excel Mastery:

The curriculum is presented in basic building blocks so that you can build your knowledge step-by-step.

We start from the very beginning by teaching you Excel basics and fundamentals. We then dive into advanced topics so you can make good decisions on data manipulation, analysis, and visualization, and tools for use in any of your future Excel projects.

Along the way, we give you many exercises so you can practice yourself but you will also build a massive personal budgeting spreadsheet using Excel macros and data visualization. This will not only help solidify your understanding but also help you master your finances.

By the end of this course, we guarantee you're going to love Excel. It will make you more effective and efficient at your job, no matter your role or industry.

Here's a section by section breakdown:

1. EXCEL 101 - You'll learn about the fundamentals of Excel, such as formulas, working with multiple worksheets & workbooks, and utilizing Excel for data entry. With just the fundamentals, we'll be able to manipulate, format, and prepare data for analysis. You'll also start your first exercise to practice and solidify your knowledge.

2. FILTERING & SORTING DATA - You'll learn to filter and sort data sets, further preparing data sets for analysis and visualization.

3. EXCEL FORMULAS 101 - You'll dive into the magic of Excel formulas for text, dates, and arithmetic purposes. We'll also start the Budget Project where you will start applying your knowledge to creating a personal budgeting spreadsheet that will allow you to masterfully track and analyze your personal finances.

4. CRUNCHING NUMBERS WITH EXCEL FUNCTIONS - You'll start learning how to analyze data with arithmetic functions including calculating median and standard deviation. Throughout your career, you'll need to know the importance of these fundamental arithmetic functions and what they say about your data.

5. CONDITIONAL CALCULATIONS - You'll go down the rabbit hole into more advanced subjects with calculations that are conditional upon variables. The goal of Excel is to make the relationships and patterns in data pop and allow you to tell the story of complex data sets, and conditional calculations are your first step towards doing that.

6. DATE & TIME FUNCTIONS - You'll learn how to add some pizzaz to your spreadsheets using the DATE and TIME Excel functions and analyze data across one of the most important variables that you'll want to consider when analyzing your data: changes across time.

7. TEXT FUNCTIONS - Ever receive a data dump and need to somehow sort through it all? Here you're going to learn how to pull out pieces of text data from a data set so that you can sort, organize, and ultimately analyze it using Text Excel functions. Large, messsy data sets are present in almost every industry, so this is going to come in handy.

8. LOGICAL & LOOKUP FUNCTIONS - You'll start working with the magical VLOOKUP function! VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone's name, in order to find out what you don't know, like their phone number. Nifty, huh?

9. MODELING IN EXCEL - Now the tables will turn (so to speak!) and you'll begin to learn from our data! This'll be done by learning how to model our data. Modeling allows you to take messy data, learn from it, and make decisions from it. We'll also help you model your own finances in the Budget Project.

10. DATA VISUALIZATION - You'll learn to tell a story with our data using graphs. As humans we're often visual learners - we can't just look at a spreadsheet of numbers, we need to visualize it in order to separate the signal from the noise. Here you will learn how to do just that, so you can tell a persuastive story with your data that will influence how you (and your clients or boss!) make decisions.

11. WORKING WITH STRUCTURED DATA - You're going to learn to present & structure data using tables. We'll look at how we can use tables to present complex data, including external data and utlizing ranges, in a cohesive and structured manner.

12. PIVOT TABLES - You'll be introduced to one of our favourite parts of Excel: Pivot Tables. A Pivot Table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories. This summary might include sums, averages, or other statistics, which the pivot table groups together using a chosen aggregation function applied to the grouped values.

Sound complex? It doesn't have to be. We break it down step-by-step so you learn exactly how powerful Pivot Tables are and how you can create and use them yourself.

13. MACROS & VBA - You'll learn about VBA Macros ("Visual Basic Application"). They're used to create custom user-generated functions and to speed up manual tasks by creating automated processes. Basically like writing your own code in Excel. Once you learn to do this, the possibilities are endless...

What's the bottom line?

This course is not about making you just watch along without understanding the principles so that when you are done with the course you don’t know what to do other than watch another tutorial... No!

This course will push you and challenge you to go from an absolute beginner in Excel and turn you into an Excel master 💪.

How do we know?

Because thousands of Zero To Mastery graduates have gotten hired and are now working at companies like Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top tech companies.

They come from all different backgrounds, ages, and experiences. Many even started as complete beginners.

So there's no reason it can't be you too.

And you have nothing to lose. Because you can start learning right now and if this course isn't everything you expected, we'll refund you 100% within 30 days. No hassles and no questions asked.

When's the best time to get started? Today!

There's never a bad time to learn in-demand skills. But the sooner, the better. So start learning Excel today by joining the ZTM Academy. You'll have a clear roadmap to developing the skills to build your own projects, get hired, and advance your career.

Start learning now
Expand Overview

What you'll build

The best way you learn is by doing. Not just watching endless tutorials. That's why a key part of this course is the exercises you'll complete and the massive real-world project that you'll get to build. Plus it'll look great on your portfolio.

Personal Budgeting Tool

Personal Budgeting Tool

You'll build an interactive, user-driven tool that lets you compare your income and expenses, plan your spending with precision, determine what percentage of your income you'd like to save, analyze your spending habits, and more.

start learning now

Don't just take our word for it

Our courses and community have helped 1,000s of Zero To Mastery students go from zero to getting hired to levelling up their skills and advancing their careers to new heights.

Great course content delivered by a superb instructor. Loads of information delivered in a simple yet effective way. Exercises to complete after each section to make sure everything sunk in! Highly recommend.

Craig M.

Best course on Excel so far. The instructor is amazing and so is his content. If you want to get a job as a data analyst, business analyst or financial analyst... I recommend the course for you. Stop thinking, Enroll Now.

Patrick S.

Impeccable course! Very detailed and comprehensive.

Jael B.

Very useful information, I'm already using the course to work in Data Analytics.

Yohan C.

Course curriculum

To make sure this course is a good fit for you, you can start learning Excel for free right now by clicking any of the PREVIEW links below.

Introduction

5 lectures

The Excel Bootcamp: Zero to Mastery2:53

PREVIEW

Course Outline5:12

PREVIEW

Exercise: Meet Your Classmates and Instructor

START

How-to's: Speed up videos, Downloading videos, Subtitles

START

Cheatsheet

START

Module 1: Excel 101

20 lectures

Hello Excel Part 110:02

PREVIEW

Hello Excel Part 212:10

PREVIEW

Data Entry Part 111:54

PREVIEW

Data Entry Part 210:38

PREVIEW

Autofill10:54

PREVIEW

Working With Ranges11:28

PREVIEW

Working With Rows and Columns9:40

PREVIEW

Resizing Rows and Columns9:35

PREVIEW

Freezing Rows and Columns9:47

PREVIEW

Working With Multiple Worksheets10:33

PREVIEW

Find and Replace14:01

PREVIEW

Working With Multiple Workbooks10:23

PREVIEW

Intro to Formatting4:35

PREVIEW

Formatting Numbers11:06

PREVIEW

Formatting Dates and Times11:27

PREVIEW

Font Styles11:30

PREVIEW

Text Wrapping and Alignment10:38

PREVIEW

Cell Borders and Merging9:19

PREVIEW

Exercise: Excel 101

PREVIEW

Unlimited Updates

START

Module 2: Filtering and Sorting Data

4 lectures

Intro to Filtering8:10

PREVIEW

Advanced Filtering16:00

PREVIEW

Sorting in Excel14:25

PREVIEW

Exercise: Filtering and Sorting Data

PREVIEW

Module 3: Excel Formulas 101

10 lectures

Intro to Formulas8:28

PREVIEW

Arithmetic Formulas9:50

PREVIEW

Applying Formulas to Text7:48

START

Applying Formulas to Dates9:03

START

Copying and Cutting Formulas12:20

START

Cell References13:36

START

Hiding Rows and Columns2:49

START

Exercise: Formulas 101

START

Budget Project: Introduction1:52

START

Budget Project: Formulas 1016:21

START

Module 4: Crunching Numbers With Excel Functions

9 lectures

Intro to Excel Functions10:45

PREVIEW

Arithmetic Functions14:36

START

Counting Functions6:03

PREVIEW

The Status Bar2:23

START

Rounding and Truncation9:10

START

Median8:22

START

Standard Deviation7:53

PREVIEW

Exercise: Crunching Numbers With Excel Functions

START

Budget Project: Crunching Numbers With Excel Functions5:34

PREVIEW

Module 5: Conditional Calculations

5 lectures

Conditional Calculations I12:19

PREVIEW

Conditional Calculations II12:09

START

Conditional Calculations III14:12

START

Exercise: Conditional Calculations

START

Budget Project: Conditional Calculations4:52

START

Module 6: Date and Time Functions

8 lectures

Introducing Date and Time Functions4:15

START

Parsing Date and Time Components7:34

START

The DATE Function5:49

START

Applying the DATE and TIME Functions7:30

START

DATEDIF and NETWORKDAYS9:09

START

Transforming Date Values6:37

START

Exercise: Date and Time Functions

START

Budget Project: Date and Time Functions8:35

START

Module 7: Text Functions

6 lectures

LEFT, RIGHT, and MID6:13

START

FIND and LEN15:20

START

Text Cleaning Functions10:16

START

Exercise: Text Functions

START

Exercise: Imposter Syndrome2:55

START

Budget Project: Text Functions8:18

START

Module 8: Logical and Lookup Functions

6 lectures

The IF Function15:36

START

AND and OR10:44

START

VLOOKUP10:26

PREVIEW

VLOOKUP with IFERROR9:25

START

Exercise: Logical and Lookup Functions

START

Budget Project: IF Statements4:10

START

Module 9: Modeling in Excel

8 lectures

Intro to Modeling2:58

START

The PMT Function7:07

START

Data Validation Lists8:16

PREVIEW

Scroll Bars16:11

START

Named Ranges11:15

START

Model Design7:25

START

Exercise: Modeling

START

Budget Project: Modeling11:53

PREVIEW

Module 10: Data Visualization in Excel

8 lectures

Custom Formats9:09

START

Conditional Formatting I7:09

PREVIEW

Conditional Formatting II10:18

START

Introducing Charts13:10

START

Column Charts7:09

START

Line Charts12:07

START

Exercise: Data Visualization

START

Budget Project: Data Visualization9:55

START

Module 11: Working With Structured Data in Excel

6 lectures

External Data10:04

START

Text to Columns5:55

START

Table Features9:58

START

Tables as Named Ranges14:09

START

Exercise: Working With Structured Data in Excel

START

Budget Project: Structured Data9:32

START

Module 12: Pivot Tables

8 lectures

Intro to Pivot Tables13:03

PREVIEW

Adding Layers to Pivot Tables14:08

START

Pivot Table Formatting and Layout10:57

START

Filtering Pivot Tables10:03

START

Slicers11:12

START

Pivot Table Math9:44

START

Exercise: Pivot Tables

START

Budget Project: Pivot Tables6:28

START

Module 13: Macros and VBA

7 lectures

Intro to Macros9:24

PREVIEW

Running Macros With Buttons4:53

START

Editing Macros9:44

START

Macros - A Case Study19:27

START

Exercise: Macros and VBA

START

Budget Project: Macros and VBA6:52

START

More VBA!

START

Where To Go From Here?

5 lectures

Thank You!1:17

START

Review This Course!

START

Learning Guideline

START

LinkedIn Endorsements

START

Become An Alumni

START

Meet your instructor

Your Excel instructor (Travis) isn't just an expert with years of real-world professional experience. He has been in your shoes. He makes learning fun. He makes complex topics feel simple. He will motivate you. He will push you. And he will go above and beyond to help you succeed.

Travis Cuzick

Hi, I'm Travis Cuzick!

Travis has been architecting and coding data solutions for well over a decade and for some of the biggest companies on the Fortune 500. Travis aims to make the learning process as efficient, intuitive, and fun (yes, fun!) for his students as possible.

SEE MY BIO & COURSES

Travis Cuzick

Data Solutions Engineer

Frequently asked questions

Are there any prerequisites for this course?

  • No previous Excel experience needed. We go from beginner to advanced in this full Excel Bootcamp
  • You do need to install Microsoft Excel (Excel 365 is used for demonstrations, but all course material is also compatible with earlier versions)

Who is this course for?

  • Both beginner and advanced professionals looking to learn and master Excel
  • Students who are interested in going beyond a normal "beginner" Excel bootcamp
  • Anyone who is interested in learning a tech skill that has been around since 1987, is used by ~750 million people and will be around for many years to come
  • Developers, Data Scientists, Machine Learning Engineers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions
  • Anyone who wants to work in the fields of data analysis and/or data science
  • Programmers who want to accelerate their career by adding data science & data analysis skills to their toolkit
  • Programmers who want to learn a tool for the rapid development of data-driven applications

Do you provide a certificate of completion?

We definitely do and they are quite nice. You will also be able to add Zero To Mastery Academy to the education section of your LinkedIn profile as well.

Can I use the course projects in my portfolio?

Yes, you’d be crazy not to in our slightly biased opinion! All projects are downloadable and ready to use the minute you join.

Many of our students tell us the projects they built while following along with our courses were what got them interviews and because they built the projects themselves, they could confidently explain and walk through their work during the interview.

You know what that means? Job offer!

Can I download the videos?

Definitely. You can download any and all lessons for personal use. We do everything we can to make learning easy, fun and accessible. Whether that’s on your commute, on a flight or just when you have limited access to good WiFi.

Still have more questions about the Academy?

Still have more questions specific to the Academy membership? No problem, we answer some more here.

Take the next step and invest in a better you

Choose your currency:
$ USD US Dollar
Monthly
100% OFF$39 / month
$39 / month
You're ready to upskill and advance your career
Start Learning Now
Save 40% vs. monthly (that's $189 a year)
Annual
100% OFF$279 / year
$279 / year
$23 / month
You're committed to getting hired and starting a career in tech
Start Learning Now
Lifetime
100% OFF$999
$999
Only pay once, ever
You're serious about advancing your career and never getting left behind
Start Learning Now

Every ZTM membership includes:

Unlimited access to all courses, workshops, and career paths
Invite to private Discord with 400,000+ members
Access to private Linkedin networking group
Custom ZTM course completion certificates
Download all lessons for offline learning
Unlimited, priority access to all future courses, content, and features
100% RISK FREE

We know you'll love ZTM. That's why we provide a no hassle, 30-day money back guarantee.