Mastering Excel Pivot Tables

Pivot Table is a powerful data summarization and analysis tool in Microsoft Excel. A pivot table quickly summarizes long lists of data without the need to write a single formula or build a separate report. It is a most useful tool for business professionals as it allows you to examine, summarize and analyze your data from multiple angles. Many Excel users avoid pivot tables because the tool seems too complicated at first glance, and end up wasting a lot of time without getting their work properly done.

This 6-hour course is developed specifically to enable all who attend to use Pivot Tables proficiently and apply the tool effectively to data summarization and analysis tasks.

Prerequisites: The prerequisite of the course is a basic knowledge of Microsoft Excel.

Course Price: $960

You will Learn

  • Preparing data for creating PivotTables
  • Creating PivotTables with different layouts that suit your presentation
  • Understanding different ways to summarize data, e.g. Sum, Average or Count for each data category
  • Calculating subtotals by grouping dates (e.g. yearly, quarterly, monthly, and weekly), numbers and text
  • Making your report more readable by converting data into different types of percentage calculations
  • Creating PivotCharts for better data presentation
  • Formatting PivotTable reports for better look-and-feel
  • Keeping PivotTable data up-to-date
  • Setting up calculated fields and calculated items in PivotTables
  • Advanced techniques for consolidating multiple data tables into a PivotTable
  • Setting up PivotTables to pull data directly from an Access database

Course Schedule/Enrol

Course Title Duration Fee Outline/Schedules/Enrol
Mastering Excel 2016 Pivot Tables 6 hours $960 Outline Schedules/Enrol
Mastering Excel 2013 Pivot Tables 6 hours $960 Outline Schedules/Enrol
Mastering Excel 2010/2007 Pivot Tables 6 hours $960 Outline Schedules/Enrol

© Welkin Systems Limited. All rights reserved.