Use promo code EB15 at checkout to enjoy a 15% discount.
Summarizing and analyzing your Excel data can seem overwhelming. PivotTables in Excel will do the hard work for you, and you don’t even need to know formulas and functions. We will show you how you can quickly create dynamic custom reports in half the time you may be spending on those now. In this webinar we will learn how to use Excel’s recommended PivotTables and how to create PivotTable reports from scratch. We will customize our report layout by adding fields and selecting table filters. Then we will cover how to automatically update those reports with a simple refresh of your PivotTables. We will change the summary function, use the expand and collapse buttons and easily filter fields. We will then learn how to format the PivotTable and how to create PivotCharts for instant data visualization.
- Recommended PivotTables
- Create PivotTables
- Add Fields
- Selecting Table Filter
- Refreshing PivotTables
- Change Summary Function
- Expand/Collapse data
- Filter Items
- Format PivotTables
- Create PivotCharts
See full list of topics on our website.