Advanced Excel Reporting: Best Practices, Tools, and Techniques

Learn how to use Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP) to connect Excel to external data sources, such as your accounting software database, to extract data for reporting and analysis. Learn how to incorporate PivotTables into your reporting routines, including how to add calculations to your PivotTables, how to group PivotTable data into fiscal reporting periods, and how to filter your PivotTables using Slicers.
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*List and apply 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*