Seminar In-Depth

Course Description

Microsoft Excel is a powerful tool for analyzing financial data and preparing financial reports, but like most powerful tools, it contains hidden features and functionality useful for these purposes that are not obvious to users, both novice and expert alike. The purpose of this course is to uncover these hidden features so that users may prepare computationally accurate and aesthetically pleasing reports in a more effective and efficient manner. It provides 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. Participants will have access to sample data files.

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

“This was an outstanding session I would highly recommend.” T.K., CPA NJ

“The course was right on target. Great examples for functional application immediately upon return to the office.” W.L., CPA TX

Course Information

CPE Credit: Recommended for 8 hours Accounting

Instructional delivery method: Group-live demo and discussion using color computer projection – NOT a hands-on course

Prerequisites: Fundamental knowledge of Excel operations

Program level: Advanced

Advanced preparation: None

Designed for: Accountants desiring more knowledge in the use of Excel for financial statement preparation and analysis

Who should attend: Those who utilize Excel for preparing and analyzing financial reports

Course Highlights

• 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

Dates & Locations