7. Excel Pivot Tables

Excel Pivot Tables
Duration: 1 Day (9 am - 1 pm)
Location: Welwyn Garden City or Borehamwood
Includes: Lunch and Documentation
Price: £180 per delegate
 

Who is this course for?
The Excel Pivot Tables course is suitable for those with an advanced knowledge of Excel. Although Pivot Tables are covered in our Excel Advanced Level 1 course, this course looks as Pivot Tables in much greater depth.

What will they learn?
At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.
You will be able to troubleshoot common problems as well as automate procedures for maximum efficiency.
You will be able to create charts and dashboards from your data.

• Using functions to prepare data for analysis
• Creating a basic Pivot Table
• Refreshing data
• Changing the data source
• Importing data
• Troubleshooting imported data
• Consolidating multiple sheets or ranges of data
• Changing the report layout
• Filtering and sorting
• Formatting
• Using Slicers
• Adding a Timeline
• Creating calculated fields
• Pivot Charts
• Creating a dashboard
• Automating Pivot Tables with Macros