
Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
Excel Pivot Tables: Get a Handle on your Data
Excel’s Pivot Tables enable you to quickly create concise reports from large data sets, spot trends by consolidating information and display results for multiple variable questions ‐ plus you can easily create Pivot Charts to visually represent your data. Stop writing complicated formulas, creating multiple worksheets, and using Sort and Filter commands ‐ and make Pivot Tables do the work for you!
Course Topics
• analysing data using pivot tables
• creating pivot tables from worksheet data
• recommended pivot tables
• using the pivot table wizard
• using the pivot table toolbar
• managing pivot tables
• modifying a pivot table
• filtering & sorting pivot table
• using slicers to filter pivot table data
• adding sparklines to a pivot table
• adding calculated fields to a pivot table
• creating a chart from a pivot table
• showing/hiding pivot table data
Follow on Courses

Course Dates
Classroom: 20th May 2020 – To be confirmed
Online: Dates coming soon!
Course Duration
Classroom: 90-minutes
Online: 1 Session
Scheduled Course Fee
£50 + VAT
Class size
Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates
Location
Classroom: Ipswich or onsite at clients premises
Prerequisites
Delegates should be regular users of Excel and have a good understanding of formulas, navigation techniques, and formatting.
Training Formats
Scheduled course · private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)
Manuals
A comprehensive course manual provides support throughout the course. Available in PDF format for Online sessions.
Not found the course you are looking for?