The Excel Bootcamp: Zero to Mastery

14h 19m 32s
English
Paid
November 18, 2024

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 supplement your career with data analysis and modeling skills & get hired in 2022.

More
  • Become a top 10% Excel power user to enhance your skillset and career opportunities
  • Build a Budget Project where you create a personal budgeting spreadsheet that teaches you Excel while analyzing your own finances
  • Automate your day-to-day tasks through Macros and VBA
  • Transform and clean text data with Excel functions like LEFT/RIGHT, MID, FIND, SUBSTITUTE, and TRIM
  • Analyze large datasets with Excel Pivot Tables
  • Use Excel for rapid development of data-driven applications
  • Use Excel's extensive collection of visualizations to “tell the story” of even the most complex data in an intuitive and visually appealing way
  • Use Excel's powerful charting engine to tell the story of your data with attractive data visualizations
  • Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
  • Manipulate date and time data with functions like DATEDIF and NETWORKDAYS
  • Learn how to work with external datasets
  • Data entry tips and tricks
  • Learn why Excel is one of the most popular pieces of software across all industries
  • Start or supplement your programming journey by recording VBA macros in Excel

Watch Online The Excel Bootcamp: Zero to Mastery

Join premium to watch
Go to premium
# Title Duration
1 The Excel Bootcamp: Zero to Mastery 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

Similar courses to The Excel Bootcamp: Zero to Mastery

Stripe Payments Cloud Functions

Stripe Payments Cloud Functionsfireship.io

Duration 1 hour 10 minutes 33 seconds
The Complete Strapi Course - with plugins and deployment
Istio Hands-On for Kubernetes

Istio Hands-On for Kubernetesudemy

Duration 12 hours 15 minutes 1 second
Cursor AI - Ultimate Course

Cursor AI - Ultimate CourseKevin Kern

Duration 2 hours 14 seconds
Effective PyCharm (2021 edition)

Effective PyCharm (2021 edition)Talkpython

Duration 7 hours 30 minutes 43 seconds
IIQ Complete Course

IIQ Complete Courseudemy

Duration 33 hours 31 minutes 30 seconds
Complete FastAPI REST course + AWS + Emails + Payments
Scale React Development with Nx

Scale React Development with Nxegghead

Duration 1 hour 34 minutes 10 seconds
Supercharge Excel with Dynamic Array Functions & Formulas