The Excel Bootcamp: Zero to Mastery

14h 19m 32s
English
Paid

The only bootcamp you need to become an Excel wizard.Learn Excel Formulas and Functions, Data Visualization, Pivot Tables, VBA Macros, and much more. Start or enhance your career with essential data analysis and modeling skills & prepare to excel in the industry.

Course Highlights

  • Excel Mastery: Become a top 10% Excel power user to boost your skillset and expand career opportunities.
  • Practical Projects: Build a Budget Project by creating a personal budgeting spreadsheet, which not only improves your Excel skills but also provides insights into your own finances.
  • Automation: Learn to automate your daily tasks with Macros and VBA, increasing efficiency in your workflow.
  • Data Transformation: Transform and clean text data using Excel functions such as LEFT, RIGHT, MID, FIND, SUBSTITUTE, and TRIM.
  • Advanced Analysis: Analyze large datasets effectively using Excel Pivot Tables to gain deeper insights.
  • Application Development: Utilize Excel for the rapid development of data-driven applications.
  • Data Visualization: Employ Excel's extensive collection of visualizations to narrate complex data stories in a visually appealing manner.
  • Charting Skills: Harness Excel's powerful charting engine to create attractive data visualizations that communicate your data's story clearly.
  • Formula Proficiency: Develop proficiency in building Excel formulas for a variety of purposes including data analysis, data science, and everyday office use.
  • Date & Time Manipulation: Manage date and time data efficiently with functions like DATEDIF and NETWORKDAYS.
  • External Data Integration: Learn strategies to effectively work with external datasets to enhance data comprehensiveness.
  • Data Entry Optimization: Discover tips and tricks for streamlined data entry tasks.
  • Industry Relevance: Understand why Excel is a crucial tool across numerous industries, gaining insights into its widespread popularity.
  • Programming Journey: Begin your programming adventure by recording and utilizing VBA macros in Excel.

About the Author: zerotomastery.io

zerotomastery.io thumbnail
Whether you are just starting to learn to code or want to advance your skills, Zero To Mastery Academy will teach you React, Javascript, Python, CSS and more to help you advance your career, get hired and succeed at some of the top companies in the world.

Watch Online 91 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 91 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: The Excel Bootcamp: Zero to Mastery
All Course Lessons (91)
#Lesson TitleDurationAccess
1
The Excel Bootcamp: Zero to Mastery Demo
02:54
2
Course Outline
05:13
3
Hello Excel Part 1
10:03
4
Hello Excel Part 2
12:11
5
Data Entry Part 1
11:55
6
Data Entry Part 2
10:39
7
Autofill
10:55
8
Working With Ranges
11:29
9
Working With Rows and Columns
09:41
10
Resizing Rows and Columns
09:36
11
Freezing Rows and Columns
09:48
12
Working With Multiple Worksheets
10:34
13
Find and Replace
14:02
14
Working With Multiple Workbooks
10:24
15
Intro to Formatting
04:36
16
Formatting Numbers
11:07
17
Formatting Dates and Times
11:28
18
Font Styles
11:31
19
Text Wrapping and Alignment
10:39
20
Cell Borders and Merging
09:20
21
Intro to Filtering
08:11
22
Advanced Filtering
16:01
23
Sorting in Excel
14:26
24
Intro to Formulas
08:29
25
Arithmetic Formulas
09:51
26
Applying Formulas to Text
07:49
27
Applying Formulas to Dates
09:04
28
Copying and Cutting Formulas
12:21
29
Cell References
13:37
30
Hiding Rows and Columns
02:50
31
Budget Project: Introduction
01:53
32
Budget Project: Formulas 101
06:22
33
Intro to Excel Functions
10:46
34
Arithmetic Functions
14:37
35
Counting Functions
06:04
36
The Status Bar
02:24
37
Rounding and Truncation
09:11
38
Median
08:23
39
Standard Deviation
07:54
40
Budget Project: Crunching Numbers With Excel Functions
05:35
41
Conditional Calculations I
12:20
42
Conditional Calculations II
12:10
43
Conditional Calculations III
14:13
44
Budget Project: Conditional Calculations
04:53
45
Introducing Date and Time Functions
04:16
46
Parsing Date and Time Components
07:35
47
The DATE Function
05:50
48
Applying the DATE and TIME Functions
07:31
49
DATEDIF and NETWORKDAYS
09:10
50
Transforming Date Values
06:38
51
Budget Project: Date and Time Functions
08:36
52
LEFT, RIGHT, and MID
06:14
53
FIND and LEN
15:21
54
Text Cleaning Functions
10:17
55
Exercise: Imposter Syndrome
02:56
56
The IF Function
15:37
57
AND and OR
10:45
58
VLOOKUP
10:27
59
VLOOKUP with IFERROR
09:26
60
Intro to Modeling
02:59
61
The PMT Function
07:08
62
Data Validation Lists
08:17
63
Scroll Bars
16:12
64
Named Ranges
11:16
65
Model Design
07:26
66
Budget Project: Modeling
11:54
67
Custom Formats
09:10
68
Conditional Formatting I
07:10
69
Conditional Formatting II
10:19
70
Introducing Charts
13:11
71
Column Charts
07:10
72
Line Charts
12:08
73
Budget Project: Data Visualization
09:56
74
External Data
10:05
75
Text to Columns
05:56
76
Table Features
09:59
77
Tables as Named Ranges
14:10
78
Budget Project: Structured Data
09:33
79
Intro to Pivot Tables
13:04
80
Adding Layers to Pivot Tables
14:09
81
Pivot Table Formatting and Layout
10:58
82
Filtering Pivot Tables
10:04
83
Slicers
11:13
84
Pivot Table Math
09:45
85
Budget Project: Pivot Tables
06:29
86
Intro to Macros
09:25
87
Running Macros With Buttons
04:54
88
Editing Macros
09:45
89
Macros - A Case Study
19:28
90
Budget Project: Macros and VBA
06:53
91
Thank You!
01:18
Unlock unlimited learning

Get instant access to all 90 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription