Pivot Tables and Formatting:

In this 120-minute session, you’ll learn the essentials of tables for data input and PivotTable reports for effective data output and how to write a formula and how to use built-in functions to streamline complicated formulas. The training focuses on the following categories:

• Recognizing the difference between reports, crosstabs, and tables
• Building and working with tables  
• Basics of pivot table reports
• Relative vs absolute formatting
• Formatting styles
• Formatting with formulas and conditional formatting