CFO Reporting Re-Imagined — Building Interactive Excel Reporting with Gen AI Assistance (Module 2)
In Module 2 of CFO Reporting Re-imagined — Building Interactive Excel Reporting with Gen AI Assistance, you’ll learn how to transform static spreadsheets into dynamic, decision-enabling reporting.
Format
Online
NASBA Field of Study
Information Technology
Level
Intermediate
CPE Credits
1.5
Author(s)
Don Tomoff
Availability
1 year
Product Number
BLICFOBIER25SSO
In Module 2 of CFO Reporting Re-imagined — Building Interactive Excel Reporting with Gen AI Assistance, you’ll learn how to transform static spreadsheets into dynamic, decision-enabling reporting. This session shows how to bring reports to life using Excel’s interactive features—including dropdowns, slicers, conditional formatting, and tips for implementing functions and formulas—while using ChatGPT to help generate formulas and brainstorm layout ideas.
Who Will Benefit
This course is designed for accounting and finance professionals who build Excel reports for decision-makers and want to increase interactivity, automation, and insight quality.
Key Topics
- Advanced data-validation & dependent lists – structured drop-downs keep user inputs clean and drive self-service parameter changes.
- Scenario-driven slicers – one-click region or date pivots let users explore “what-ifs” without rewriting formulas.
- PivotTables as data sources – how to set up pivottables as reporting data sources
- Micro-automation tips – one-click VBA or Office Scripts refresh data, tidy formatting, and export polished PDFs in seconds.
- Gen AI prompt patterns – Use responsible prompting, data privacy, and ethical considerations in their Gen AI use and consider where “My Excel Buddy” custom GPT can streamline workflows.
Learning Outcomes
After completing this course, participants will be able to:
- Apply PivotTables, functions and formulas to create core trend, comparative, and LTM calculations.
- Use data-validation dropdowns, dependent lists, slicers, and timelines to build self-service report interfaces that guide scenario analysis and minimize input errors.
- Select lightweight automation—Worksheet_Change events, one-click VBA/Office Scripts, and refresh-all Power Query routines—to distribute ready-to-use workbooks rapidly.
- Apply Gen AI (“My Excel Buddy” custom GPT) responsibly to generate formulas, refactor macros, and assist you with all Excel related tasks.
Group ordering for your team
2 to 5 registrants
Save time with our group order form. We’ll send a consolidated invoice to keep your learning expenses organized.
Start order6+ registrants
We can help with group discounts. Email client.support@aicpa-cima.com
US customers call 1-800-634-6780 (option 1)
The Association is dedicated to removing barriers to the accountancy profession and ensuring that all accountancy professionals and other members of the public with an interest in the profession or joining the profession, including those with disabilities, have access to the profession and the Association's website, educational materials, products, and services.The Association is committed to making professional learning accessible to all product users. This commitment is maintained in accordance with applicable law. For additional information, please refer to the Association's Website Accessibility Policy. As part of this commitment, this product is closed-captioned. For additional accommodation requests please contact adaaccessibility@aicpa-cima.com and indicate the product that you are interested in (title, etc.) and the requested accommodation(s): Audio/Visual/Other. A member of our team will be in contact with you promptly to make sure we meet your needs appropriately.