About the Mastery Series
Format: 6 sessions, 2 hours each, over 3 weeks
Session Days: Monday and Wednesdays
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:
- Fundamentals: Solidify your Excel foundation and boost your confidence
- Formulas: Explore new dynamic functions and custom-built formulas
- Formatting: Create professional, clear, and insightful visuals
- Analyzing: Use tools like PivotTables and charts to make data actionable
- Assembling: Gather, transform, and manage diverse data sources
- Automating: Streamline repetitive tasks with Power Query and macros
What You’ll Get:
- 6 x 2-hour live sessions
- Recordings of all sessions
- Presentation slides and workbook materials
- Reference guides and example files for ongoing use
Session Breakdown
Session 1: Mastering the Fundamentals
- Navigation: Ribbon, files, sheets, and ranges
- Formulas: Basics, reference types, functions
- Formatting: Entry-level tools that pack a punch
- Pro Habits: Build muscle memory for speed and accuracy
Session 2: Mastering Formulas
- Understand key formula syntax and references
- Work with named ranges and dynamic arrays
- Top 60 Excel functions to know
- Custom functions for efficiency and reliability
Session 3: Mastering Formats
- Apply standard and number formatting
- Use conditional formatting (pre-set and custom)
- Explore table styles, themes, and formatting tools
Session 4: Mastering Analysis
- Sort and filter data (functions and visual tools)
- Use Tables, PivotTables, and Slicers
- Build charts, PivotCharts, and Sparklines
Session 5: Working with Power Query
- Connect to various data sources
- Apply basic and advanced transformations
- Learn refresh workflows and best practices
Session 6: Working with Macros
- Display the Developer tab
- Use the macro recorder and learn basic VBA
- Explore macro examples and coding logic
- Session recap and workshop wrap-up
Why You Should Register
- Master the most powerful Excel tools in under a month
- Boost your value, efficiency, and confidence in Excel
- Save hours each week with smarter workflows
- Reduce errors and build consistency in your processes
Program FAQs
Instructional Delivery Method: Group Internet Based or Group Live
Recommended Field of Study: Computer Software & Applications
Program Level: Basic
Prerequisites: None
Advance Preparation: None
About The Speaker
-
Derek Henry, CPA, CFE
Derek is an accomplished speaker, trainer, consultant, and developer with over 20 years of experience in public accounting, corporate accounting/finance, and software pre-sales. Over that time, he has taught, managed, and mentored hundreds of people on how to work with more efficiency, accountabilit [...]