CF

The Excel Bootcamp: Zero to Mastery

14h 19m 32s
English
Paid

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

Course facts

Lessons
91
Duration
14 hours 19 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 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

What courses are similar to The Excel Bootcamp: 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.