PivotTable Course

Analyse and present data quickly and easily using PivotTables. PivotTables are one of Microsoft Excel's most useful, powerful and misunderstood features. Learn to master them!

PivotTables can work with very large data sets, but are equally useful for small businesses trying to understand where their sales opportunities lie, or for individuals working on their household finances or even their fantasy football leagues.

Recent versions of Excel have seen major improvements in the way PivotTables deliver real insights from raw data - whether this is a few dozen rows in a spreadsheet or a massive corporate database.

Using screenshots, video examples and exercises, this PivotTable course from ExcelWithBusiness teaches you how to draw key conclusions easily and present and manage your findings effectively.

Highlights

By the end of this course you will know how to:

Preview

Course Content

Course Content

Course Content

User Dashboard

Syllabus Explorer

Course Certificate

Syllabus

Section 1: PivotTables

directright

Unit 1.1 - Introduction - Finding the Best or the Worst

How Pivot Tables are useful, when to use them, and some basic Pivot Table techniques

directright

Unit 1.2 - Filter and Group to Compare and Contrast

How to filter, sort and group Pivot Table data

directright

Unit 1.3 - Presentation - Clarity and Impact

Formatting and presenting Pivot Table data using PivotCharts and Conditional Formatting

directright

Unit 1.4 - Calculations - Adding Value to Values

How to use Value Fields and Calculated Fields and Items

directright

Unit 1.5 - Your Data Your Way - Flexible Reporting

How to use Pivot Tables as a management-report engine, and how to work with cube values

directright

Unit 1.6 - Power to the User - Interactivity

How to use Slicers and build an interactive dashboard

Section 2: PivotTables for Data Analysis

directright

Unit 2.1 - Dominate Your Data

Identify how to use data structures in spreadsheets, in addition to using Power Query to shape your data

directright

Unit 2.2 - PowerPivot and Big Data

Apply PowerPivot to replicate Excel's big data abilities

directright

Unit 2.3 - Make Your Data Work Harder

Encounter Data Analysis Expressions and master them, pulling data and functions in a number of accurate ways

directright

Unit 2.4 - From Data to Decisions

How to use Power Pivot to turn your data into business intelligence reports

directright

Unit 2.5 - Present Data Analysis with Impact

Use charts, waterfall charts, and sparklines, to revolutionise the way you present data

Section 1: PivotTable 2013 PC

directright

Unit 1.1 - Introduction and Basics

How Pivot Tables are useful, when to use them, and some basic Pivot Table techniques

directright

Unit 1.2 - Filter and Group to Compare and Contrast

How to filter, sort and group Pivot Table data

directright

Unit 1.3 - Presentation - Clarity and Impact

Formatting and presenting Pivot Table data using PivotCharts and Conditional Formatting

directright

Unit 1.4 - Calculations - Adding Value to Values

How to use Value Fields and Calculated Fields and Items

directright

Unit 1.5 - Your Data Your Way - Flexible Reporting

How to use Pivot Tables as a management-report engine, and how to work with cube values

directright

Unit 1.6 - Power to the User - Interactivity

How to use Slicers and build an interactive dashboard

Section 2: PivotTables for Data Analysis

directright

Unit 2.1 - Dominate Your Data

Identify how to use data structures in spreadsheets, in addition to using Power Query to shape your data

directright

Unit 2.2 - PowerPivot and Big Data

Apply Power Pivot to replicate Excel's big data abilities

directright

Unit 2.3 - Make Your Data Work Harder

Encounter Data Analysis Expressions and master them, pulling data and functions in a number of accurate ways

directright

Unit 2.4 - From Data to Decisions

How to use Power Pivot to turn your data into business intelligence reports

directright

Unit 2.5 - Present Data Analysis with Impact

Use charts, waterfall charts, and sparklines, to revolutionise the way you present data

directright

Unit 2.6 - Give me more Power

Determine how Power View and Power Map visualise data in new ways

Pricing

Pricing is for 12 months access.

*The AUD price shown above is an estimate. Actual charges are based on the current exchange rate from GBP

Requirements

Software:

  • Required: Microsoft Excel

Completion Time: 10 hours (average)