CMA PD Series:

Excel Financial Reporting and Analysis

This workshop will provide solutions for accountants in the following six major topic areas: 

• Advanced techniques for formatting reports and financial statements,
• Assembly and printing of reports and schedules,
• Using templates to automate reporting processes,
• Advanced financial analysis with PivotTables connected to the General Ledger using ODBC, 
• Data consolidation, and
• Using charts and digital dashboards for presenting financial information.

This course includes coverage of features found in Excel 2003, 2007, and 2010.

Learning Objectives

• Identify and understand how to format financial statements and other Excel‐based reports more effectively with tools such as Custom Formats, Conditional Formatting, the Accounting Format, and Multicolumn line headings
  
  
• Recognize opportunities to streamline report assembly and printing with tools such as Camera, Custom Views, Report Manager, Linked and Embedded Objects, and saving Excel‐based reports as PDF documents
  
  
• Differentiate between Excel’s default templates and templates for financial reporting and analysis and describe how to create templates and apply them to financial reporting and analysis situations
  
  
• Describe how Excel features such as Sorting, Data Tables, Subtotal, Filters, and PivotTables aid in financial reporting and analysis and apply each of these tools in context 
  
  
• List four techniques for consolidating data, describe advantages of each technique, and apply each technique when consolidating data
  
  
• Create Excel‐based charts and dashboards to aid in communicating financial data to information consumers, including differentiating between different types of charts and describing the circumstances under which certain types of charts are preferable