Excel - PivotTables and Large Spreadsheets

Category: Microsoft Office, Microsoft Excel

Pivot Tables

  • Introduction to PivotTables
  • Organising your Data before creating a PivotTable
  • Lists
  • Trim Data
  • Concatenate
  • Creating a PivotTable
  • Understanding Rows, Columns and Report Areas
  • Adding, Moving & Removing Fields
  • Customising Formats
  • Customising Calculations
  • Sorting & Filtering Pivot Data
  • Filtering Data with Interactive Slicers
  • Grouping & Ungrouping Data
  • Drill Down & Extract Data
  • Summary Functions & Custom Calculations
  • Defining Pivot Field & Field Settings
  • PivotTable Formats and Layouts
  • Creating & Modifying PivotChart Reports
  • About SquareOne

    SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

    Course Objectives

    Learn how to organise, summarise and present your data using Excel PivotTables and PivotCharts. These powerful tools will help you to simplify and analyse the complex data stored in your spreadsheets. This course is suitable for people of an intermediate level of Excel. The course will be delivered in the PC version of Excel 2010

    Course Duration

    Half day.

    Training Format

    This course can either be delivered as a short course in half a day or as a seminar.

    Classroom Training – Small groups of people using their own PCs or Laptops – or these can be provided by SquareOne at an additional cost. Sessions to be 3 hours in length.

    Seminar Format – Maximum of 100 delegates. This seminar will be delivered by a trainer as a demonstration. Session can last between 60 minutes to 90 minutes. If this is to be delivered to small groups then this can be repeated up to 3 sessions per day.

    Training Locations

    Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at you office in any location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead and Aberdeen as well as in European countries such as France, Switzerland, Germany, Sweden, Norway and Ireland.


    To discuss course contents and booking arrangements, please call SquareOne on:

    T: +44 (0)151 650 6907

    E: enquiries@squareonetraining.com

    Download Course Outline Request More Information

    For more information about any of our courses please call +44 (0)151 650 6907,
    email enquiries@squareonetraining.com or complete an enquiry form.

    Back to top