Excel Super User 1-Day Workshop | Chicago, IL | November 24, 2026

About this event

Excel Super User 1-Day Workshop | Chicago, IL Duration: 1 Day, Course Delivery: In-person classroom training. Virtual and in-house options are available upon request., Language: English, Credits: 8 PDUs, Certificate: Strive Wisdom Certificate of Completion Course Overview Take your Excel skills beyond standard advanced training with the Excel Super User course. Designed for confident Excel users who want to explore powerful features and expert techniques, this workshop covers advanced formulas, data extraction, analysis, automation, and visualization. Learn techniques for building more robust spreadsheets, extracting data from external sources, reducing data-entry errors, and creating interactive workbooks. The course also introduces VBA programming to help automate tasks and extend Excel’s capabilities. Learning Objectives By the end of this course, participants will be able to:

Apply advanced Excel formulas to improve spreadsheet functionality and structure. Use Microsoft Query and SQL to extract data from databases, accounting systems, and other sources. Explore advanced Excel capabilities and techniques. Use functions and tools that reduce data-entry errors and improve consistency. Recognize the risks of VLOOKUP and explore safer alternatives. Use ActiveX and Form controls to create interactive, controlled spreadsheets. Apply advanced data analysis and visualization techniques to identify trends and anomalies. Understand the fundamentals of VBA and create custom functions or automate tasks beyond formula capabilities.

Key Topics Covered Advanced Formulas

Array formulas for complex tasks INDEX/MATCH, OFFSET, and SUMPRODUCT INDIRECT, ADDRESS, and HYPERLINK for dynamic functionality

Advanced Functionality

Dynamic ranges and input-dependent drop-down lists Scenario Manager Dynamic charts that adjust to available data Formula-driven conditional formatting

Advanced Data Extraction and Manipulation

Microsoft Query and SQL for extracting and manipulating external data Pivot Table techniques and features referenced for Excel 2010/2013 Introduction to Power BI, Power Pivot, Power Query, and Power Map

Custom VBA Functions

Writing VBA code and recording or editing macros Automating tasks such as Pivot Table refreshes and worksheet visibility Creating change-tracking code to build an audit trail

Prerequisites No formal prerequisites. The course is intended for participants who are already confident using Excel and want to develop more advanced skills. Course Materials Participants will receive a comprehensive course manual containing presentation slides and reference materials. Examination There is no exam for this course. Agenda

Advanced Formula Techniques: Array formulas, INDEX/MATCH, OFFSET, SUMPRODUCT, INDIRECT, and related functions. Advanced Functionality: Input-dependent drop-down lists, Combo Boxes, Scenario Manager, and dynamic charts. Advanced Data Extraction: Microsoft Query, SQL, Pivot Table techniques, and an introduction to Power BI tools, including Power Pivot, Power Query, and Power Map. VBA and Macros: Introduction to VBA, writing code, and best practices for creating macros.

Related Course

Maximizing Your Excel Productivity (1 day)

Target Audience This workshop is designed for Excel users who want to advance their skills and explore Excel’s capabilities in data extraction, analysis, visualization, and VBA programming. Technical Requirements For eBooks, participants need:

Internet access to download the eBook A laptop, tablet, or smartphone (Kindle is not supported) Adobe DRM-supported software, such as Adobe Digital Editions or Bluefire Reader

Certification Upon successful completion, participants will receive a Strive Wisdom Certificate of Completion.

From Strive Wisdom