PivotTables in Excel (Advanced)

The MBA Part-Time Program office is hosting an Excel: PivotTables in Excel (Advanced) workshop to be hosted by Marcie Anszberger from the Center for Teaching, Advancement, and Assessment Research (CTAAR)

Topics to be covered include:

• What is a PivotTable and how can it be used
• Optimizing your data for pivoting
• PivotTable tools and menus
• Ways to analyze data with the PivotTable
• PivotCharts
• Understanding the “refresh data” option
• Special formatting tools and advanced formatting
• Calculating percentages & ad hoc calculations
• The new “dashboard” tools: Slicers & Timelines