Pivot Tables - Beyond the Basics

OBJECTIVES

Overview of and introduction to pivot tables – including the importance of clean data

Customising your pivot table through the use of Slicers/Timeline

Use the ‘Show Values As’ options to get more out of your data

KEY TOPICS

• Review of what a pivot table is and why you would use it
• The importance of clean data
• Learn how to add and customise slicers and timelines to your pivot table/charts for ease of analysis
• Learn how to get more out of your data with the ‘Show Values As’ options e.g. Year-To-Date totals, month-to-month changes

WHO SHOULD ATTEND

This is aimed at accountants who want to deepen their understanding of pivot tables to help their clients get more out of their data.