Course Description

New for 2012!

This seminar is about how to create accurate, easy-to-prepare reports in Excel when the source data resides in an accounting or other database. In this seminar, learn how to use tools such as ODBC and OLAP to connect Excel to external data sources for reporting and analysis. You will also learn best practices for spreadsheet design and for report formatting and presentation.

Course Information

CPE Credit: Recommended for 4 hours of Accounting

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

Prerequisites: Strong working knowledge of Excel 2007 or Excel 2010

Program level: Advanced

Advanced preparation: None

Designed for: Those who regularly prepare financial statements or other financial reports and use Excel in the process

Who should attend: Accountants and other business professionals who want to use Excel to reduce the risk of errors, simplify reporting processes, and improve the quality of reports

Course Highlights

• Link and import data from external databases – including multi-table databases – into Excel
• Use Tables and PivotTables to create accurate financial reports and analyses
• Describe Excel shortcuts for formatting financial reports
• Implement Excel templates to improve reporting productivity
• Identify opportunities to work with third-party tools to streamline reporting in Excel

Dates & Locations