CF

The Excel Bootcamp: Zero to Mastery

22h 32m 54s
English
Paid

The Excel Bootcamp: Zero to Mastery is a 164-lesson 22 hours 32 minutes self-paced course by Zero To Mastery. The only bootcamp you need to become an Excel wizard.

Course facts

Lessons
164
Duration
22 hours 32 minutes
Level
All levels
Language
English
Updated
Instructor
Zero To Mastery
Price
Premium

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.

Additional

https://coursehunters.online/t/the-excel-bootcamp-zero-to-mastery-materials/5265

Who teaches The Excel Bootcamp: Zero to Mastery? Zero To Mastery

Zero To Mastery thumbnail

Zero To Mastery (ZTM) is a Toronto-based online coding academy founded by Andrei Neagoie, originally a senior developer at large Canadian tech firms before turning to teaching full-time. The academy's signature is the cohort-based bootcamp track combined with a deep self-paced course library, all aimed at career-changers and self-taught developers preparing to land software-engineering roles at top companies.

The instructor roster has grown well beyond Andrei to include other senior practitioners: Daniel Bourke (machine learning), Aleksa Tešić (DevOps), Jacinto Wong, and others. Courses cover the full software-engineering career path: web development with React and Next.js, Python, machine learning and deep learning, DevOps and cloud, system design, mobile, and the algorithm / data-structure interview prep that gates engineering jobs.

The CourseFlix listing under this source carries over 120 ZTM courses spanning that full range. Material is paid; ZTM itself runs on a monthly / annual membership model. The teaching style favours long-form, project-based courses where students build complete portfolio-quality applications rather than disconnected feature tutorials.

What lessons are included in The Excel Bootcamp: Zero to Mastery?

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 164 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 (164)
#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
TEXTJOIN
11:36
56
Budget Project: Text Functions
08:19
57
Exercise: Imposter Syndrome
02:56
58
The IF Function
15:37
59
AND and OR
10:45
60
IFS
11:58
61
VLOOKUP
10:27
62
VLOOKUP with IFERROR
09:26
63
XLOOKUP
12:01
64
Handling Errors with XLOOKUP
08:50
65
Matching Lists
10:47
66
Budget Project: IF Statements
04:11
67
Intro to Modeling
02:59
68
The PMT Function
07:08
69
Data Validation Lists
08:17
70
Scroll Bars
16:12
71
Named Ranges
11:16
72
Model Design
07:26
73
Budget Project: Modeling
11:54
74
Custom Formats
09:10
75
Conditional Formatting I
07:10
76
Conditional Formatting II
10:19
77
Introducing Charts
13:11
78
Column Charts
07:10
79
Line Charts
12:08
80
Budget Project: Data Visualization
09:56
81
Text to Columns
05:56
82
External Data
10:05
83
Table Features
09:59
84
Tables as Named Ranges
14:10
85
Budget Project: Structured Data
09:33
86
Intro to Pivot Tables
13:04
87
Adding Layers to Pivot Tables
14:09
88
Pivot Table Formatting and Layout
10:58
89
Filtering Pivot Tables
10:04
90
Slicers
11:13
91
Pivot Table Math
09:45
92
Budget Project: Pivot Tables
06:29
93
SEQUENCE
13:30
94
SORT
11:03
95
UNIQUE
07:33
96
CHOOSECOLS
08:56
97
FILTER I
13:52
98
Combining FILTER, CHOOSECOLS and SORT
13:00
99
FILTER II
13:25
100
FILTER III
11:03
101
Refactoring with Tables
12:45
102
Refactoring with LET
12:58
103
Project 1 - Introduction
03:49
104
Project 1 - Solution
08:56
105
Combining FILTER, UNIQUE and SORT
08:03
106
Referencing Dynamic Arrays I
10:03
107
Referencing Dynamic Arrays II
11:41
108
Creating Dynamic Drop - Down Lists
08:29
109
Project 2 - Introduction
03:48
110
Project 2 - Solution
11:35
111
GROUPBY - Part 1
12:37
112
GROUPBY - Part 2
14:04
113
GROUPBY - Part 3
06:36
114
PIVOTBY
14:51
115
Project 3 - Introduction
09:22
116
Project 3 - Solution
12:08
117
Intro to Macros
09:25
118
Running Macros With Buttons
04:54
119
Editing Macros
09:45
120
Macros - A Case Study
19:28
121
Budget Project: Macros and VBA
06:53
122
Capstone Project Demo
05:25
123
Introducing the Project Template
02:48
124
Applying Number Formats
02:54
125
Solution: Applying Number Formats
02:06
126
Creating Drop Down Lists
01:41
127
Solution: Creating Drop Down Lists
03:38
128
Creating the Retirement Age Slider
02:37
129
Solution: Creating the Retirement Age Slider
04:25
130
Applying Cell Styles
04:12
131
Solution: Applying Cell Styles
03:09
132
Defining Names
03:25
133
Solution: Defining Names
03:43
134
Fetching the Investment Return
03:44
135
Solution: Fetching the Investment Return
05:23
136
Plan Year and Age
03:35
137
Solution: Plan Year and Age
02:11
138
Working Income
03:30
139
Solution: Working Income
03:39
140
Income Tax and Yearly Expenditures
02:01
141
Solution: Income Tax and Yearly Expenditures
02:51
142
Yearly Savings
01:21
143
Solution: Yearly Savings
02:33
144
Earned Interest and Retirement Savings Balance
02:26
145
Solution: Earned Interest and Retirement Savings Balance
02:25
146
Earned Interest and Retirement Savings Balance II
04:22
147
Solution: Earned Interest and Retirement Savings Balance II
05:07
148
Wrapping Up the Calculations Worksheet
04:45
149
Solution: Wrapping Up the Calculations Worksheet
05:41
150
Retirement Age and Years Calcs
03:43
151
Solution: Retirement Age and Years Calcs
02:50
152
The Banner Message
05:32
153
Solution: The Banner Message
04:24
154
The Retirement Balance Chart
01:52
155
Solution: The Retirement Balance Chart
04:57
156
Dynamic Charts with OFFSET I
08:36
157
Dynamic Charts with OFFSET II
14:29
158
Solution: Dynamic Charts with OFFSET
08:44
159
Formatting the Retirement Balance Chart
03:21
160
Solution: Formatting the Retirement Balance Chart
03:32
161
The Detail Worksheet
04:47
162
Solution: The Detail Worksheet
08:08
163
The End (a.k.a. Retirement)
01:01
164
Thank You!
01:18
Unlock unlimited learning

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

Learn more about subscription

What courses are similar to The Excel Bootcamp: Zero to Mastery?

More courses by Zero To Mastery

Frequently asked questions

What prerequisites do I need before starting this course?
The course is designed for beginners, meaning no prior experience with Excel is necessary. However, basic computer skills and familiarity with navigating software applications will be helpful. The course starts with foundational topics like data entry and formatting, making it accessible for learners at all levels.
What projects will I build during the course?
One of the key practical projects in the course is the Budget Project. This involves creating a personal budgeting spreadsheet, which helps improve your Excel skills while providing insights into personal finance management. The project covers formulas, functions, and various Excel features, ensuring that you gain hands-on experience in applying the concepts learned.
Who is the target audience for this Excel course?
The course is ideal for anyone looking to enhance their data analysis and modeling skills, whether you're a student, a business professional, or someone interested in improving personal productivity. It caters to beginners as well as those who wish to deepen their understanding of Excel's advanced capabilities like VBA Macros and Pivot Tables.
How does the depth of this course compare to other Excel courses?
This course covers a wide range of topics from basic data entry and formatting to advanced analysis with Pivot Tables and automation using VBA Macros. It aims to transform learners into top 10% Excel power users, which suggests a comprehensive approach compared to introductory courses. The inclusion of practical projects further enhances the learning experience.
Does the course focus on any specific Excel tools or platforms?
Yes, the course provides in-depth coverage of essential Excel tools such as formulas, functions, data visualization, and Pivot Tables. Additionally, it emphasizes automation through VBA Macros, enabling efficient task management within Excel. These tools are crucial for conducting advanced data analysis and developing data-driven applications.
What topics are not covered in this course?
While the course offers a broad scope of Excel functionalities, it does not delve into specialized data analysis tools outside of Excel, such as R or Python. The focus remains strictly within the Excel environment, emphasizing mastering its native capabilities for data manipulation, visualization, and automation.
How much time should I expect to commit to this course?
The course comprises 91 lessons, covering a comprehensive range of Excel topics. Although the total runtime is not specified, learners should plan to dedicate significant time to engage with the material, complete practical projects, and practice the skills taught. The time commitment will vary based on individual pace and prior familiarity with Excel.