Pivot Tables in Excel

Or log in to access your purchased courses

In this course we teach you how to use Pivot Tables in Excel. Whether you are simply performing recons, or are responsible for data analytics and business intelligence in your company, Pivot Tables are the most important tool in Excel.

Pivot Tables are an intermediate skill and much easier to learn then all the complex VLOOKUP, SUMIFS type functions. BUT they are much more powerful!

If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

Modules

More Pivot Table Exercises

A variety of exercises involving Pivot Tables, with solutions and video solutions which will highlight other useful aspects of Pivot Tables and address some of the common problems,

Lessons

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons