Excel Pivot Table Training 1/2 day Workshop

31/10/2019 Updates

Date/Time
Date(s) - 31/10/2019
9:30 am - 12:30 pm

Location
Glasgow Training Centre

Categories


Microsoft Excel Pivot Table

This Microsoft Excel training course workshop focuses on pivot tables to analyse and report on data sets.

Target Audience: Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills.

Microsoft Excel Pivot Table Training – Objectives

  • Create pivot tables and charts.
  • Manipulate pivot tables
  • Re-format pivot tables to enhance the look
  • Apply filters, slicers and timelines.

Class Outline

  • Using Pivot Tables
    • Creating Pivot Tables
      • Preparing Your Data
      • Inserting a Pivot Table
    • Inserting Slicers
    • Using Timeline Filters
    • Working with Pivot Tables
      • Grouping Data
      • Using Pivot Filters/Slicers
      • Multiple Pivot Row & Column Settings
    • Inserting Pivot Charts
    • Formatting Pivot Tables and Pivot Charts
    • More Pivot Table Functionality
    • Copying & Pasting Pivot data

Bookings

£150.00