Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for users who need to analyse, summarise and present large volumes of data using Pivot Tables and Pivot Charts.

Objectives:

By the end of the course users will be able to create Pivot Table and Pivot Chart reports of varying complexities that include a variety of formulae and functions.

Prerequisites:

A thorough grounding in building spreadsheets which include functions, such as Min, Max, and Average.

Download Outline (PDF)

Data List Revision
  • Data List Essential Skills
  • Sorting List Data
  • Filtering Data & Custom Filters
  • Naming Cells & Ranges
Introducing Pivot Tables
  • Creating a Pivot Table
  • Creating Pivot Tables from Multiple Tables
  • Adding, Moving & Removing Fields
  • Sorting & Filtering Pivot Data
  • Refreshing Data & Changing the Data Source
  • Filtering Data with Interactive Slicers & Timelines
  • Grouping & Ungrouping Data
  • Drill Down & Extract Data
  • Summary Functions & Custom Calculations
  • Using the GETPIVOTDATA Function
  • Defining Pivot Field & Field Settings
  • Formatting Pivot Tables
  • Creating & Modifying PivotChart Reports

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.