Description
Managing any type of enterprise means mastering your data. Frequently, however, turning that data into useful information and then sharing that with the managers who need it can take much more time than it should.
In this faster-paced intensive course, you will discover how to use Excel’s powerful Pivot Table and Pivot Chart tools to summarise and display useful and relevant information to help your decision makers use all of this data.
Using your knowledge of Excel’s Pivot Table and Pivot Chart tools, you will be able to turn large data sets into meaningful dashboards and reports confidently and efficiently.
What you will learn
What You Will Learn
By the end of this intensive advanced course, you will learn how to condense, summarise, group and display large amounts of data. Using Pivot Tables and Pivot Charts to create dashboards that more effectively communicate the “story” behind your data.
In particular, you will be able to:
Manipulate your Pivot Table, such as rearranging the layout, adding and removing fields, grouping data
Change the look of your Pivot Table, display subtotals, add or remove Pivot Table elements
Use a range name to make updating your data easier
Change the way data is summarised and displayed, calculate new data within the Pivot Table
Use the GETPIVOTDATA function to create summary data from large Pivot Tables
Create Pivot Charts
Arrange your Pivot Tables and Pivot Charts into a user-friendly dashboard
Add interactive tools such as slicers and timelines
Timetable
Session 1
Creating Pivot Tables: Create and change Pivot Tables; add and remove Pivot Table elements; change field and table properties; format text and numbers
Session 2
Updating and calculations: Make Pivot Table data easy to update; Change the way data is calculated in a pivot table; create calculations within a Pivot Table; pivot a pivot.
Session 3
Using the GETPIVOTDATA function
Session 4
Pivot Charts
Session 5
Dashboard: Arranging tables and charts; formatting the dashboard sheet; adding interactive tools.
Intensive Courses From Happy
Intensive courses have been created specifically for those who need to learn a great deal of content at a faster pace. Each one is focused on increasing your productivity, and building a substantial expertise. These courses will be longer, faster and more intensive than a standard classroom course. If you can keep up, the rewards will definitely be worth the effort.
020 7375 7300
Email