< CLICK HERE > To View Class Outline and Topics

Explore how to use the Microsoft Excel Pivot Table tool to help make the most out of your data by applying its powerful summarization, charting, and reporting tools. Identify what constitutes for suitable data to base your Pivot Tables on. Learn why converting your data to table format is beneficial to successful reporting. Learn how to add new and missing data either by adding fields to the worksheet or directly to the pivot table realm using calculated fields and items. Understand the utility tools used in creating Pivot Tables and Pivot Charts. Create Microsoft Excel Pivot Table designs from scratch or through the use of preferred templates. Learn how to group and bundle your pivot table data including dates, values, and text. Apply a variety of sorting techniques and filtering tools including advanced slicer and timeline filters. Insert powerful summary calculations and custom row/column calculations and custom comparative calculations. Format pivot tables and pivot charts using traditional tools as well as advanced conditional formatting rules. Create a variety of microsoft Excel pivot table charts including column, bar, line, area, pie and more. Learn how to perfectly print pivot tables and pivot charts, with options.