Overview:
Pivot Tables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs. In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you’ll be saving time and making your job easier.

Charts and graphs are visual representations of your data. Viewing the data graphically makes the data less confusing and increases comprehension. It is easier to spot trends and patterns in your data sets. Excel charts update automatically when the data is modified, so charts are always current. Become more productive and efficient at communicating data to others.

Why Should You Attend:
As an intermediate-level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful, and insightful reports in the shortest time possible. These features of the application will help you to do just that.

Areas Covered in the Session:
•  Create a simple Pivot Table
•  Change the Way Data Is Calculated In A PivotTable
•  Group Date Data by Month, Year or Quarter
•  Learn About Slicers – The New Visual Way to Filter PivotTables
•  Format A PivotTable Report for Greater Appeal