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
Watch Online The Excel Bootcamp: Zero to Mastery
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
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
Cursor AI - Ultimate Course
Sources: Kevin Kern
The course "Cursor AI: A Complete Guide for Developers" is designed for developers aiming to accelerate the process of creating websites, applications...
6 hours 52 minutes 57 seconds
Introduction to Excel Automation: Excel Macros and VBA
Sources: zerotomastery.io
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