Course details

One the most powerful aspects of Microsoft Excel is its ability to analyse and present data quickly and easily using PivotTables.

In this course you will learn:

  • The primary uses of PivotTables
  • How to identify the best and worst data sets
  • To filter, sort and group PivotTable data to maximise it's usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting
  • To create great looking management reports using a PivotTable

Your data analysis will never be the same after unlocking the full power of PivotTables.

The PivotTable is one of the most useful, powerful and misunderstood features in Excel. PivotTables are not just about big data and large companies. Although PivotTables can work with large data sets, they are just as useful for micro businesses trying to understand where their sales opportunities lie, or for individuals working on their household finances.

Updated on 24 September, 2018

About Skillsology

Skillsology was founded in 2013 as a brand of the Excel with Business Ltd. group of brands. Based in Shoreditch and part of London’s expanding tech scene, the team is driven by producing quality, curated online courses that help people fulfil their career or personal goals.

See all Skillsology courses
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or