Virtual Microsoft Excel Bootcamp
- Event Type: 🌐 Virtual Event
- Start: May 26, 2026 9:00 AM EDT
- End: May 29, 2026 5:00 PM EDT
- Cost: $1,995.00
- Instructor: Emily Taylor
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
🌐 Virtual Event
Event description
The Introduction to Excel Bootcamp is an intensive course that is designed to get you to use Excel comfortably. You will first learn about the structure of Excel, then you will dive right into learning different types of formulas and functions. Next, you will discover how to create models, tables, and charts to analyze your data better. You will also learn all about PivotTables, PivotCharts, and Power Pivot. This class will take you from Excel novice to PRO in four days! Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.
Prerequisites
This course was created with the current version of Excel 365, but all features will also work in Excel 2010, 2013, and 2016 as well as Excel 365. Students should have a general knowledge of Excel prior to starting the class.
System Requirements
- Windows 11, Windows 10, Windows 8, or Windows 7
- Microsoft Excel
Course Outline:
- Module 01
- Excel Basics
- Intro to Excel
- Cell References
- Notation Styles
- Keyboard shortcuts
- Naming ranges and cells
- Conditional Formatting
- Module 02 – Working with Excel Tables
- Overview
- Sorting
- Filtering
- Aggregations
- Module 03 – Working with Functions and Formulas
- Formula Editing Tips
- Text Formulas (TRIM, LEFT)
- Date Formulas (DATE, DAY, HOUR)
- Logical Formulas (AND, IF)
- Math and Statistical Functions (AVERAGE, SUM)
- Date and Time Functions (TODAY, MONTH)
- IF Formulas
- Lookup and Reference Functions (INDEX and MATCH, VLOOKUP)
- Conditional Formatting
- Module 04 – Leveraging Excel Charts
- Creating and Designing Charts
- Module 05 – Data Visualization Principles
- Spatial Position
- Gestalt Principles
- The Problem with Pie Charts
- Module 06 – PivotTables
- PivotTables
- PivotCharts
- Module 07 – Power Query
- Data Cleansing with Power Query in Excel
- Module 8 – Building Data Models with Power Pivot
- Hierarchies
- Relationships
- DAX
- Module 9 – Designing Excel Reports (Connecting to Power BI Datasets)
- Excel and Power BI, better together
- Module 10 – Advanced Excel Elements
- Python in Excel
- Protecting and hiding information and formulas
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Microsoft Excel Bootcamp (May 26, 2026 – 5/29/26) | $1,995.00 | |
Add an event to your calendar
Instructor – Emily Taylor
Emily graduated from Indiana University with a bachelor's degree in elementary education and the University of North Florida with a master's degree in educational leadership. After 11 years of teaching varying grades (K-5) in Indiana and Florida, she joined the Pragmatic Works team as a Power BI Trainer. Emily's primary goal is to provide engaging trainings that help customers gain confidence using Power BI. When not in the office, Emily enjoys camping, the beach, cheerleading, and visiting family in Indiana.