Excel Pivot Tables - Data Analysis

Course Overview

A PivotTable is a powerful tool to calculate, summarise and analyse data that lets you see comparisons, patterns and trends in your data.

This course equips the user with a proficient knowledge of data analysis in Excel focusing on using Pivot Tables and Pivot Charts. Pivot tables enable you explore and analyse raw data, revealing powerful insights and trends. Pivot charts show this data in an attractive, easy to understand graphical format.

This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.

• Course Content

  Getting Started

  Entering the raw data for analysis, hints and tips on best practice.

  Creating Pivot Tables

  Selecting the data, defining the structure of the pivot table.
  
  

  Formatting

  Table layouts and styles, design and formatting options.

  Analyzing data

  Sorting, filtering and grouping tools.
  
  

  Calculations

  Working with calculated fields, items and values. Percentages of rows, columns, totals and other fields.
  
  

  Pivot Charts

  What is a pivot chart? Creating a pivot chart, pivot chart rules. Managing the underlying data. Formatting a pivot chart.
  
  

  Slicers

  Inserting a slicer, inserting multiple slicers, formatting a slicer, editing a slicer.
  

• Prerequisites

  Attendees will gain the maximum benefit if they have attended our Level 1 course, or are familiar with creating basic spreadsheets and using simple functions.

• Qualification

  Computeraid certificate of achievement.

• What Next?

  Excel Level 3
  Gain an in depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.
  
  Excel Formulas and Functions
  Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.