Pivot Tables

Summary

This intermediate course will teach you how to create & manipulate Pivot Tables in Microsoft Excel. When exploring datasets, Pivot Tables are the fastest way to filter, sort, & explore the data, with a simple drag & drop functionality. Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for intermediate learners who have a basic level of familiarity with writing Microsoft Excel formulas, but no prior knowledge of Pivot Tables. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 12 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Preparing your data for pivot Tables
  • Formatting pivot tables
  • Changing pivot table output values
  • Grouping date columns
  • Updating pivot tables with new data
  • Pivot table subtotals
  • Sorting pivot table data
  • Apply filters to pivot tables
  • Build charts from a pivot table
  • Updating formulas with new data
  • Pivot table data in formulas

Key Outcomes

Once you have completed this course you will know how to create Pivot Tables for any dataset. You will know how to format your Pivot Table results, refresh Pivot Tables with new data, sort and filter these results and even create charts from your Pivot Table results.