Home Courses Excel Pivot Tables

Courses


Excel Pivot Tables

Length: 0.5 Days    Cost: $310 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreMarAprMayJun
Auckland
08
--
20
--
Hamilton
31
22
20
--
Christchurch
24
--
18
--
Wellington
08
28
21
--
Virtual Class -- -- -- --

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

Learn how to group your data in a meaningful way. Excel Pivot Tables enable us to quickly group large sets of data with very little effort, almost as if by magic.In this specialized half-day course,you will transform a database with thousands of rows into an easy to read report. Quickly capture the average sales price per month or compare performance by region. For those of us who find numbers hard to visualize, we will see how to put that data into Pivot Charts so we can spot trends and changes in the data.



Audience


This course is designed for analysts, managers, or anyone who uses Excel to get insights from business data. If you work with big data sets on a regular basis and spend lots of time sorting through your data, doing complex calculations or SUMIF functions then this is the course for you.

Prerequisites

We recommend that students have knowledge equivalent to the topics covered in our Excel Essential Skills course, OR that students are:

  • Comfortable creating Excel formulae
  • Familiar with basic Excel functions (SUM, COUNT, AVERAGE)
  • Familiar with absolute references ($A$1)

If you are new to Excel, we suggest starting with Excel Essentials Skills before tackling this course. If you just need to brush up on a few of the skills above, check out our half day Excel Beyond the Basics course.

At Course Completion

Take the mystery out of Pivot Tables and let Excel do all the hard work of tricky calculations for you. You’ll leave this course ready to tackle your data and pivot it into insights.

Course Outline


  • The Excel Window
  • PivotTables Summarising Data
  • PivotTables Sorting and Filtering
  • PivotTables Formatting
  • PivotTables Extras
  • Creating Pivot Charts

 Print this page