Webcast: Excel Financial Reporting and Analysis

Microsoft Excel is a powerful tool for analyzing financial data and preparing financial reports, and like most powerful tools, this program contains useful, hidden features and functionalities that are frequently not obvious to novice or even expert users. In this class we will uncover these hidden features so you can more effectively and efficiently prepare computationally accurate and aesthetically pleasing reports. You'll gain solutions in six major topic areas: advanced techniques for formatting reports and financial statements; assembling and printing reports and schedules; using templates to automate reporting processes; using ODBC to conduct advanced financial analysis with PivotTables connected to the general ledger; consolidating data and using charts and digital dashboards for presenting financial information. Participants will have access to sample data files.