Are you intimidated by PivotTables? Don't be - PivotTables are one of the most powerful reporting features in Excel! This seminar will show you the ins and outs of using PivotTables to maximize your Excel reporting capabilities. CPE Credit: MicroAssist can provide 1.5 hours of Continuing Professional Education credit for attendance at this seminar Topics Include: Why create a Pivot Table? Prepping your data for a Pivot Table - data lists in Excel Create a Pivot Table using the wizard Changing the layout of the Pivot Table • Add/Remove fields. • Change field order. • Grouping data. Other Pivot Table options • Table options • Field settings • Creating summary reports. Printing Refreshing the data on your Pivot Table AutoFormat a Pivot Table Advanced options • Working with multiple data fields. • Using named ranges.