In-depth analysis with Pivot Tables in Excel
In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort your data more efficiently, create multiple customized reports in a few easy steps ,and gain a powerful new tool to help you make better business decisions. Led by an Excel expert, this training event concentrates solely on PivotTables, what they are and how they can make your life much easier!
In this 60 Minute fast-paced learning session, you’ll learn:
- Why PivotTables are the “hidden gems” inside Excel
- How to create multiple PivotTables so you can analyse large data sets from different business perspective
- How to easily group and view data in a spreadsheet
- The secrets to converting PivotTables into easy-to-read charts instantly
- Steps for creating a macro that keeps your PivotTable data automatically updated
- How to group date-related data into months, quarters and years and perform ad hoc grouping in 2 quick steps
- Creating calculations in a pivot table
Like this? Wanna see more webinars?
We have lots of different webinars on offer. To read more about them, click the button below.