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
The Complete Strapi Course - with plugins and deploymentudemy
Category: Other (Tools)
Duration 15 hours 4 minutes 4 seconds
Course
Cursor: Coding with AIDAIR.AI
Category: Other (Tools)
Duration 2 hours 45 minutes 57 seconds
Course
Supercharge Excel with Dynamic Array Functions & Formulaszerotomastery.io
Category: Other (Tools)
Duration 3 hours 8 minutes 53 seconds
Course
Introduction to Excel Automation: Excel Macros and VBAzerotomastery.io
Category: Other (Tools)
Duration 2 hours 44 minutes 10 seconds
Course
Developer Productivity, v2frontendmasters
Category: Other (Tools)
Duration 3 hours 28 minutes 46 seconds
Course
Cursor AI - Ultimate CourseKevin Kern
Category: Other (Tools)
Duration 4 hours 14 minutes 29 seconds
Course
Stripe Payments Cloud Functionsfireship.io
Category: Other (Tools)
Duration 1 hour 10 minutes 33 seconds
Course
Istio Hands-On for Kubernetesudemy
Category: Kubernetes, Other (Tools)
Duration 12 hours 15 minutes 1 second
Course