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

Read more about the course
  • 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

Developer Productivity, v2

Developer Productivity, v2frontendmasters

Category: Other (Tools)
Duration 3 hours 28 minutes 46 seconds
MobX In Depth With React(Hooks+TypeScript)

MobX In Depth With React(Hooks+TypeScript)udemy

Category: React.js, Other (Tools)
Duration 2 hours 25 minutes 54 seconds
Cursor: Learn to Code with AI

Cursor: Learn to Code with AIMckay Wrigley (takeoff)

Category: Other (Tools)
Duration 4 hours 50 minutes 14 seconds
Cursor: Coding with AI

Cursor: Coding with AIDAIR.AI

Category: Other (Tools)
Duration 2 hours 45 minutes 57 seconds
Istio Hands-On for Kubernetes

Istio Hands-On for Kubernetesudemy

Category: Kubernetes, Other (Tools)
Duration 12 hours 15 minutes 1 second
Complete FastAPI REST course + AWS + Emails + Payments

Complete FastAPI REST course + AWS + Emails + Paymentsudemy

Category: Other (Tools)
Duration 9 hours 38 minutes 51 seconds
Effective PyCharm (2021 edition)

Effective PyCharm (2021 edition)Talkpython

Category: Python, Other (Tools)
Duration 7 hours 30 minutes 43 seconds
Scale React Development with Nx

Scale React Development with Nxegghead

Category: React.js, Other (Tools)
Duration 1 hour 34 minutes 10 seconds
The Complete Strapi Course - with plugins and deployment

The Complete Strapi Course - with plugins and deploymentudemy

Category: Other (Tools)
Duration 15 hours 4 minutes 4 seconds