Microsoft PivotTable

Microsoft PivotTable - Excel with Business
Microsoft PivotTable - Excel with Business
Microsoft PivotTable - Excel with Business
  • Tests
  • Anytime Learning
  • Certificates
  • CPD Accredited Training
  • Video Tutorials
  • 30-Day Refund Guarantee

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

Excel can feel daunting – in particular the infamous PivotTable™ function, which is widely spoken about and little understood.

In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.

But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.


In this course you will learn:

  • The primary uses of pivot tables
  • How to identify the best and worst datasets
  • To filter, sort and group PivotTable™ data to maximise its usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting

+ Syllabus


About the author

Deb Ashby

Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.

Simon Hurst

Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Sale price
£49.00
Regular price
Sale price
£49.00
Regular price
Sold out
Unit price
per 
Tax included.

Learners:

9k+

Level:

Intermediate - Advanced

Duration:

6 hours

Accreditation:

CPD UK

Length of Access:

Lifetime

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

Excel can feel daunting – in particular the infamous PivotTable™ function, which is widely spoken about and little understood.

In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.

But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.


In this course you will learn:

  • The primary uses of pivot tables
  • How to identify the best and worst datasets
  • To filter, sort and group PivotTable™ data to maximise its usefulness
  • How to present your data clearly using PivotCharts and Conditional Formatting

+ Syllabus


About the author

Deb Ashby

Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.

Simon Hurst

Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.