Excel intermediate - using pivot tables

Richmond and Hillcroft Adult Community College

Vocational qualification

In Richmond upon Thames

£ 20 VAT inc.

Description

  • Type

    Vocational qualification

  • Location

    Richmond upon thames

  • Start date

    Different dates available

Course Overview:
This is a skills training course in how to use Pivot tables in Excel 2013.
When you have a lot of data, it can sometimes be difficult to analyse all of the information in your worksheet. PivotTables can help make your worksheets more manageable by summarizing data and allowing you to manipulate it in different ways.

Facilities

Location

Start date

Richmond upon Thames (London)
See map
Parkshot, TW9 2RE

Start date

Different dates availableEnrolment now open
Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • MS Excel
  • IT
  • Statistics
  • Maths
  • Mathematics
  • Excel Advanced
  • Excel Formula
  • Excel Sheet
  • Excel for Accounting

Course programme

Course Content:
1 x 3 hour session
Creating and using a Pivot table
Filtering and sorting data within a Pivot table
Automatically grouping data in a Pivot table and renaming groups
Manually grouping data in a Pivot table and renaming groups

The session will teach the skills above and then there will be time to practice these skills.
Assessment Methods:
The price of the course includes a set of printed instructions and a certificate of attendance.

Excel intermediate - using pivot tables

£ 20 VAT inc.