************************************************* Please Note: The March 22 Lunch and Learn is now also full. If you would like to attend this event or a future session, please call MicroAssist at (512) 794-8440 to be added to the event waiting list. We hope to schedule another Excel PivotTable Lunch and Learn in the near future. ************************************************* 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.