The Ultimate Excel Boot Camp

The Ultimate Excel Boot Camp

Speaker:
Derek Henry
Air Date:
August 26, 2025
Price:
$595.00
Purchase
Good News! You can join late!
Aurora Training Advantage
+
Derek Henry

About the Mastery Series

Format: 6 sessions, 2 hours each, over 3 weeks
Session Days: Tuesday and Thursdays
Time: 2pm - 4pm ET
Platform: Zoom
Style: Interactive, cohort-based with peer learning and shared insights

Workshop Overview

Most professionals use Excel every day—but often in the same way they did 10 years ago. Excel has evolved, and it’s more powerful than ever. This boot camp is your opportunity to level up your skills in an engaging, supportive learning environment that delivers serious value in a short time frame.

Designed for busy professionals, this workshop equips you with the critical Excel skills needed to analyze, automate, and deliver insights faster and more accurately. Through hands-on sessions and guided materials, you’ll sharpen your abilities across six essential Excel domains, all while building habits that help you work smarter.

You'll Learn:

What You’ll Get:


Session Breakdown

Session 1: Mastering the Fundamentals

Session 2: Mastering Formulas

Session 3: Mastering Formats

Session 4: Mastering Analysis

Session 5: Working with Power Query

Session 6: Working with Macros


Why You Should Register


Program FAQs

The workshop contains 6 sessions of 2 hours each – twice a week for three weeks.
All sessions are recorded. You’ll receive the full recording and materials afterward.
Yes! Contact us at (407) 930-7961 for customized group pricing.
Absolutely. We offer private cohorts customized for your organization’s needs.
This course focuses on high-impact Excel features that deliver immediate ROI. Plus, you’ll get a suite of lasting tools and references.
Yes, upon completion of all sessions, you will receive 12 CPE credits.
Instructional Delivery Method: Group Internet Based or Group Live
Recommended Field of Study: Computer Software & Applications
Program Level: Basic
Prerequisites: None
Advance Preparation: None
Many participants seek employer approval for continuing education. We’ve made it easy — download a pre-written justification letter here to submit for internal approval.

Purchase
Good News! You can join late!
All sessions are recorded.

Session Breakdown

1st Session
Mastering the Fundamentals
Get comfortable with Excel’s core tools as you learn to navigate ribbons, files, sheets, and ranges. Explore essential formulas, entry-level formatting, and pro habits that build speed, accuracy, and confidence.
    2nd Session
    Mastering Formulas
    Take your formulas to the next level by mastering syntax, references, and named ranges. Discover dynamic arrays, the top 60 must-know functions, and create custom formulas that boost efficiency and reliability.
      3rd Session
      Mastering Formats
      Transform raw data into polished, professional spreadsheets. Learn number and standard formatting, apply powerful conditional formats, and use themes, tables, and style tools for clear and consistent presentations.
        4th Session
        Mastering Analysis
        Unlock Excel’s analytical power with tools to sort, filter, and summarize data. Gain hands-on practice with Tables, PivotTables, and Slicers, and bring insights to life using charts, PivotCharts, and Sparklines.
          5th Session
          Working with Power Query
          Streamline your workflow by connecting to diverse data sources and applying both basic and advanced transformations. Learn refresh strategies and best practices that keep your data clean and up to date.
          • 2:00 pm to 4:00 pm EST
          6th Session
          Working with Macros
          Automate repetitive tasks by unlocking Excel’s macro capabilities. From recording simple actions to exploring basic VBA and coding logic, this session equips you with practical skills to save time and simplify complex processes.
          • 2:00 pm to 4:00 pm EST

          About The Speaker