Speaker – Jon Acampora – The Active Cell

SPEAKER

Jon Acampora

Jon Acampora is a Microsoft MVP and the founder of Excel Campus, where he helps professionals save time and advance their careers with Excel and automation. Through his online courses, YouTube channel, and Elevate Excel Training Program, Jon has taught millions of people how to work more efficiently with formulas, PivotTables, Power Query, VBA, and AI. He is passionate about simplifying complex topics and providing practical techniques that attendees can immediately apply to their everyday work.

Nov 30 | 11:30 AM - 12:30 PM

Build Once, Refresh Forever: Automating Everyday Excel Reports

Many Excel users repeat the same reporting tasks every week or month. Tasks like cleaning exported data, updating formulas, rebuilding summaries, applying formatting, and preparing reports for others can be very time consuming.

In this hands-on session, you’ll explore practical strategies for turning those repetitive tasks into faster, more reliable Excel processes.

Along the way, you’ll see how tools such as formulas, Power Query, PivotTables, VBA, and AI can automate different parts of the reporting process. The examples will demonstrate reusable automation patterns that can be applied to many types of Excel tasks, rather than one specific workflow.

Learning Objectives

By the end of this session, you will learn how to:

Identify repetitive steps in an Excel reporting process that are good candidates for automation.
Build refreshable, reusable reports with Power Query and PivotTables.
Find answers faster with XLOOKUP and FILTER.
Format and prepare workbooks in seconds with macros and VBA.
Choose the right Excel or AI tool for each task.

You’ll leave with a practical framework for choosing the right Excel tool, building more reusable solutions, and spending less time repeating the same work.