Course ID: CFOBIER

CFO Reporting Re-Imagined — Building Interactive Excel Reporting with Gen AI Assistance (Module 2)

About & Customize

Popular Options

  • On-Demand
  • In-Person
  • Live Webcast
  • Webcast Replay

After completing this course, participants will be able to:

  1. Apply PivotTables, functions and formulas to create core trend, comparative, and LTM calculations.
  2. Use data-validation dropdowns, dependent lists, slicers, and timelines to build self-service report interfaces that guide scenario analysis and minimize input errors.
  3. Identify lightweight automation— one-click VBA/Office Scripts, formatting, and dynamic arrays—to distribute ready-to-use workbooks.
  4. Apply Gen AI (“My Excel Buddy” custom GPT) responsibly to generate formulas, refactor macros, and assist you with all Excel related tasks.

  • 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.
Designed For

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.

Field of Study
Information Technology
Prerequisites

Familiarity with basic financial statements, Excel formulas and functions, and pivot tables.

CPE Credits
1
Level
Intermediate
Available Formats
On-Demand, In-Person, Live Webcast, Webcast Replay

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org