The Excel Bootcamp: Zero to Mastery
14h 19m 32s
English
Paid
Course description
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
0:00
/ #1: The Excel Bootcamp: Zero to Mastery
All Course Lessons (91)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
ChatGPT for Excel
Sources: zerotomastery.io
Imagine that 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
OpenSeadragon Deep Dive
Sources: newline (ex fullstack.io)
In this course, you will learn how to prepare and publish giant images on the web using OpenSeadragon scaling technology. The course is designed for web...
51 minutes 8 seconds
Stripe Payments Cloud Functions
Sources: fireship.io
This course has been deprecated! While the code here will still work, the it is recommended that you use the latest Stripe APIs shown in the new.
1 hour 10 minutes 33 seconds
Istio Hands-On for Kubernetes
Sources: udemy
Istio is one of the most talked-about frameworks in recent years! If you've worked with Kubernetes before, then you'll want to learn Istio! With this hands-on, practical course,...
12 hours 15 minutes 1 second
Supercharge Excel with Dynamic Array Functions & Formulas
Sources: zerotomastery.io
Dynamic arrays in Excel are a real breakthrough! With their help, you can simplify the execution of complex data tasks, make Excel faster, smarter, and...
3 hours 8 minutes 53 seconds