CMF19203. What’s new for Financial Controllers in Excel

Controller Conference
FPA Conference
Manufacturing Conference
Field of Study: 
Computer Software & Applications
CPE Credit: 
Knowledge Level: 
Advanced Preparation: 

Tuesday, November 19, 2019

For our Finance users, we discuss a breadth of new Excel features that capitalize on Artificial Intelligence, Business Intelligence and modern spreadsheeting: Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources. Intelligent cloud-backed Office365 features such as Stocks and Geography data types open up Excel to recognize more than text and numbers and Ideas in Excel helps you identify interesting trends and patterns in your data, providing charts with formatting and titles as well as accelerating data analysis and understanding. Dynamic arrays revolutionize the modern spreadsheeting experience. With a set of new charts and our one-click forecasting feature, we’ve added more capabilities to reduce the work to get the desired visualizations or analysis.
Learning Objectives:

  • Learn more about new functionality you can leverage for your analysis in Microsoft Excel.
  • Continue to master your knowledge and expertise in Excel.


Program Manager | Microsoft