Home > Microsoft Excel

Excel Pivot Tables

Date

Our Price: £180.00
Excel Pivot Tables
Description

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

 

Our public scheduled courses are currently suspended due to the COVID-19 outbreak, we are still able to offer closed courses in very small groups and 1:1 tuition.  Please contact us for details.

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