At your Convenience
We come to you or
you come to us
Wherever you are!

Build your own tailored course
Lots of options available

Good Value
Your company saves money
and your staff save time

What's New?
Remote Classroom Training...
...coming shortly!

It's Your Training!
When and Where
You want it

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Excel - PivotTables & What-If Analysis

< Back to 1 to 3 hour Microsoft short courses from Insight IT Training

Course Details

Microsoft Excel

Course Duration - 2 hours

Course Objectives

Many people have heard the word PivotTable. It gets mentioned all the time in meetings. Ask someone what they do and they will normally look away and mumble something before beating a hasty retreat. 

This mini session reveals the secrets of the PivotTable - if you have a list of data that you would like to summarise in an easy and flexible way, these are for you. 

We also look at a little used area of Excel - the What-If Analysis tools. 

Course Content

PivotTables and PivotCharts

  • Create a PivotTable
  • Change the type of calculation used in the table
  • Get the table to do your percentage calculations for you!
  • Refresh the table with changes made to the data
  • Turn your table into a chart

What-If Analysis

  • Scenario Manager - Create your formulas and then store multiple versions of the values in your spreadsheet. You can then substitute in any set of figures at any time instead of retyping them
  • Goal Seek - Ever sat there trying the get the answer you want by changing a figure over and over again? Don’t, attend this session instead.
  • Data Tables - An alternative to Scenarios. Use a data table to try out different values in your formulas


This course does assume that you are familar with Excel and, preferably, have used Excel to store lists of data.

What's Next

You may find that you already know the functions you can use with your worksheets to make life easier. If not, check out our Excel - Advanced Functions short course.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 07889 216849. Alternatively contact us online here.