CF

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.

Additional

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

About the Author: 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.

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

Related courses

Frequently asked questions

What is The Excel Bootcamp: Zero to Mastery about?
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…
Who teaches this course?
It is taught by Zero To Mastery. You can find more courses by this instructor on the corresponding source page.
How long is the course?
It contains 91 lessons with a total runtime of 14 hours 19 minutes. Every lesson is available to watch online at your own pace.
Is it free to watch?
It is part of CourseFlix's premium catalog. A subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch it online?
The course is available to watch online on CourseFlix at https://courseflix.net/course/the-excel-bootcamp-zero-to-mastery. The page hosts every lesson with the integrated video player; no download is required.