If you've never made use of Excel Pivot Tables, prepare to be blown away! This hands-on class will lead you to sharpen your reporting skills with the most powerful and under-utilized tools in the Excel arsenal-Pivot Tables and Pivot Charts! You will learn how to use Excel to retrieve database records and other external information as a basis for your reports. Learn to achieve speed with effective handling of large volumes of data and provide flexible reports that can be changed at-will, and format your reports for clarity and professionalism. This class takes a ground-up approach - no prior knowledge of Pivot Tables is required. Bring your own laptop to participate!
- Retrieving data from external sources
- Data layout best practices
- Anatomy of a Pivot Table
- Using the gallery for style
- PivotTable calculations
- Drill-down capabilities
- Using PivotTables as reporting packages
Email Address: | |
Password: |