Advanced PivotTables

advanced

In short

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.

£49.00

You can also subscribe to Toppa for unlimited access to all of our courses for just £9.99 per month.
Category

Further info

In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.

In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive.

This course is perfect for intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel.

 

In this course, you will learn:

How to do a PivotTable (a quick refresher)

How to combine data from multiple worksheets for a PivotTable

Grouping, ungrouping and dealing with errors

How to format a PivotTable, including adjusting styles

How to use the Value Field Settings

Advanced Sorting and Filtering in PivotTables

How to use Slicers, Timelines on multiple tables

How to create a Calculated Field

All about GETPIVOTDATA

How to create a Pivot Chart and add sparklines and slicers

How to use 3D Maps from a PivotTable

How to update your data in a PivotTable and Pivot Chart

All about Conditional Formatting in a PivotTable

 

Toppa courses: Set your business up for success

Wide range of content

Wide range of content

A huge range of the best video, audio and animated courses specifically created to develop your skills and help you succeed in business.

Expert instructors

Expert instructors

A vibrant community of proven expert instructors, meaning you can learn from the very best in the business.

Unlimited access

Unlimited access

Once you are a Toppa member there are no limits to how many courses you can start, or how often you learn.

Mapped to global MBA Syllabuses

Mapped to global MBA Syllabuses

Toppa and our instructors use the best MBA syllabuses from around the globe to help structure our courses

Toppa perks

Toppa perks

With Toppa, you get more than just unlimited learning. We've partnered with some amazing brands to give you access to optional learner perk add ons.

Just £9.99 per month

Just £9.99 per month

It is just £9.99 a month for a Toppa membership. Full access to all courses. No hidden costs.