Data Analysis Tools in Microsoft Excel

Do you need to get useful information from your data using Microsoft Excel? Would what-if analysis you make comparisons and projections?

Using Microsoft Excels data analysis tools targets can be set, figures can be maximised or minimised and data can be quickly hidden from view then shown again.

The ‘data analysis’ module of Lara Mellor Training and Consultancy’s Microsoft Excel training courses is designed to help you to analyse data effectively using the tools provided

You will learn:

  • How to use scenarios to compare possible outcomes
  • How to use goal seek to hit a target value
  • How solver can be used to maximise, minimise or hit a target value
  • To use data tables to efficiently perform similar calculations
  • How group and outline can quickly hide and unhide data

Ready to get started? Get in touch today to book your Microsoft Excel training. Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and learn valuable skills that they will be able to use within your business straight away.