November 2-4, 2026  |  JW Marriott Austin  |  Austin, TX

Agenda Session

Microsoft Excel: Building the FP&A Toolkit

Nov 02 2026

9:30 AM - 12:30 PM PDT

The situations FP&A professionals face every day require a refined skill set in Microsoft Excel. You need to model various scenarios and build dashboards that look good and work effectively. In this session, we’ll build working files with repeatable techniques.

Topics include:

  • Designing dynamic, auditable financial models with structured references and functions
  • Creating scenarios with what-if analysis to provide useful answers
  • Using logical functions, color coding, and data validation to control your report as data changes
  • Designing polished dashboards with Pivot Tables, charts, and professional data visualization techniques

Speakers

Knack Training

- President