EN
0
Basket

Your basket is empty

background section

Excel - module 10 : Using functions for simulations

Microsoft Excel offers an incredibly varied number of functions and features that range from basic to highly specialised. Our different courses are aimed at helping you discover each of its secrets. This specific module shows you how to discover the secrets in your data: you learn to use different Excel functions to run analyses and simulations.
 
  • Training type

    Classical

  • Duration of training

    0.5 day

  • Available languages
    EN 
  • Training code

    1663E10

What do you learn?


  • You run simulations using several different sets of values thanks to the What-If tools;
  • Your simulations give results in ranges thanks to your knowledge of array formulas;
  • You create and use templates without batting an eyelid.

You can find full details of the programme consisting of 14 Excel modules on our website.

Target group

You want to improve your knowledge or ability in Excel.

Required prior knowledge

Depending on the module.

Overview of the programme

  • The What-If analysis;
  • Array formulas;
  • Conditional formatting based on formulas;
  • Creating a template;
  • Using a template;
  • Exercises.