Welcome to Insight

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

We deliver our training
Onsite & Offsite

We Provide
A Wide Range
of Business Skills courses

We Can Help You
Build Your Own
Tailored Courses

The Training You Want
When & Where
You Want It

Keep an Eye on
Our Special Offers
Updated Regularly

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

Prerequisites

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: 08452 306 099 or contact us online here.