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 commentsSimilar courses
Apache Airflow Workflow Orchestration
Sources: Andreas Kretz
Apache Airflow is a platform-independent tool for workflow orchestration that provides extensive capabilities for creating and...
1 hour 18 minutes 41 seconds
Cursor: Learn to Code with AI
Sources: Mckay Wrigley (takeoff)
The course teaches how to use Cursor to accelerate software code development. The course covers working with various features of Cursor, demonstrates best...
4 hours 50 minutes 14 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
Cursor: Coding with AI
Sources: DAIR.AI
The course "Cursor: Программирование с AI" teaches the creation of web applications using the capabilities of artificial intelligence in the Cursor tool.
2 hours 45 minutes 57 seconds
Introduction to AI Agents
Sources: DAIR.AI
This course is dedicated to creating effective and complex AI agents. Students will study the main components for developing AI agents and best practices for...
1 hour 39 minutes 43 seconds
Want to join the conversation?
Sign in to comment