AFP Guide Explores Making Excel Work in FP&A’s Data-Centric World
Association for Financial Professionals’ Latest FP&A Guide Covers Excel Best Practices and New Applications for Finance Professionals
June 5, 2018 -- Bethesda, Md. -- While Excel is a tool that every financial planning and analysis (FP&A) professional knows well, practitioners may not be aware of recent advances that expand its connectivity and capabilities to keep pace with a data-centric world, according to AFP’s new FP&A guide, Making Excel Work for FP&A, underwritten by Vena Solutions.
The new guide explores the ways in which Excel has evolved, including recent advances, add-ins and third-party solutions/offerings. It features insights from multiple practitioners—some who are true Excel evangelists and others who only use it sparingly—to give you a broad view on how you can get the most out of this ubiquitous application.
“As this FP&A guide illustrates, finance professionals need to jettison their old perceptions about Excel,” said Jim Kaitz, president and CEO of AFP. “This guide features real-world practitioners explaining how to leverage Excel for maximum effect.”
“Excel provides finance teams the power and flexibility they need in a platform they know and love, but the Excel of today is a lot different from the Excel you learned in school,” said Rishi Grover, chief solutions architect of Vena Solutions. “Most users have just scratched the surface of Excel's potential, and solutions like Vena make it even better - integrating with different data sources to support powerful BI, data analytics and reporting for FP&A and company-wide decision making."
To Excel or Not to Excel
Today’s FP&A professionals apply Excel to a multitude of tasks, including financial models, visualization, data analysis, data storage, textual and quantitative data, and regression and statistical analysis. Still, many teams miss the mark in terms of leveraging everything Excel has to offer. Designed to help FP&A professionals fill the gap, the guide covers:
- Excel’s evolution over time, including new features that accelerate end-to-end workflow and that help uncover hidden data insights.
- "Hidden secrets” or functionalities that only the most Excel-savvy FP&A practitioners know about, and how to address program limitations.
- Use-cases from peers on the spectrum of ways they apply Excel in their own organizations. Learn from Excel evangelists and others who use it sparingly in various contexts:
- Stand-alone Excel adapted for enterprise use.
- “Add-in Tools” such as Power BI to maximize FP&A reporting and output tasks.
- Hybrid approaches that enable advanced data analytics and system management using third-party vendor tools, all while maintaining Excel - the tool FP&A already knows and loves.
Headquartered outside Washington, D.C., the Association for Financial Professionals (AFP) is the professional society that represents finance executives globally. AFP established and administers the Certified Treasury Professional and Certified Corporate FP&A Professional credentials, which set standards of excellence in finance. The quarterly AFP Corporate Cash Indicators serve as a bellwether of economic growth. The AFP Annual Conference is the largest networking event for corporate finance professionals in the world.
Copyright © 2018 Association for Financial Professionals, Inc.
All rights reserved.