An In-depth Look at the Power of Pivot Tables
Get under the hood and unleash the power of Pivot Tables!
Of all the great features that make Excel so great and so much fun to use none are as powerful and compelling as Pivot Tables.
In this great 2 Day dedicated workshop we will get into the details of this great tool and explore it uses and versatility which will make any user an instant expert.
What we will cover:
- Creating a Pivot Table
- Rearranging Fields in a Pivot Table
- Explaining the Report Layout Options
- Using the Report Filters Feature
- Using Top 10 & Date Filters
- Handling Blank Cells
- Drilling Down in the Pivot Table
- Sorting a Pivot Table
- Formatting a Pivot Table
- Creating Custom Formats
- Explaining the Grouping Options
- Adding Formulas to a Pivot Table
- Changing a Calculation in a Pivot Table
- Replicating a Pivot Table
- Counting with a Pivot Table
- Using Pivot Charts
- … and much more!!
Join us and lets get under the hood of this great Excel Power Tool!