CourseFlix

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

Course content

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

Related courses

  • Supercharge Excel with Dynamic Array Functions & Formulas thumbnail

    Supercharge Excel with Dynamic Array Functions & Formulas

    By: Zero To Mastery
    Discover how dynamic arrays revolutionize Excel tasks by simplifying complex data analysis and streamlining data management. Boost your productivity
    3 hours 8 minutes 53 seconds
  • Introduction to Excel Automation: Excel Macros and VBA thumbnail

    Introduction to Excel Automation: Excel Macros and VBA

    By: Zero To Mastery
    Studying macros and VBA (Visual Basic for Applications) for Excel is an indispensable skill for anyone who regularly works with data, performs repetitive tasks.
    2 hours 44 minutes 10 seconds
  • ChatGPT for Excel thumbnail

    ChatGPT for Excel

    By: Zero To Mastery
    Imagine you have an AI assistant ready to solve any task in Excel. This course will show you how to unlock the full potential of ChatGPT even with basic.
    3 hours 23 minutes 27 seconds

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 The Excel Bootcamp: Zero to Mastery?
The Excel Bootcamp: Zero to Mastery is taught by Zero To Mastery. You can find more courses by this instructor on the corresponding source page.
How long is The Excel Bootcamp: Zero to Mastery?
The Excel Bootcamp: Zero to Mastery contains 91 lessons with a total runtime of 14 hours 19 minutes. All lessons are available to watch online at your own pace.
Is The Excel Bootcamp: Zero to Mastery free to watch?
The Excel Bootcamp: Zero to Mastery is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch The Excel Bootcamp: Zero to Mastery online?
The Excel Bootcamp: Zero to Mastery 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.