EN
0
Basket

Your basket is empty

background section

Excel : functions and formulas II

There’s a reason why Excel is the most widely used spreadsheet in the world: it’s designed to help you work more quickly, efficiently and effectively. Of course, to truly tap into the awesome power of Excel, you  need to know more than the basics. With this course, you develop your own creativity as you learn to use lesser known techniques and formulas.
 
Do you want to take your Excel skills even further? Check out the full range of Excel courses at Cevora.
 

  • Training type

    $name

  • Duration of training

    1 day

  • Available languages
    EN 
  • Training code

    1667EB

What do you learn?


  • You know even the finest points of array formulas;
  • You integrate user-defined functions into your files;
  • Your toolbox includes the techniques used to create dashboards.

Target group

You have better than average knowledge of Excel … But you’re hungry for more! You would particularly like to improve your knowledge of functions and formulas.

Required prior knowledge

You have a relatively strong basic knowledge of Excel, with a strong grasp of prominent formulas like IF, VLOOKUP, SUMIF, SUMIFS, MATCH, INDEX and date, time and logical functions. The Cevora course  – Excel: Functions and formulas I is the perfect foundation for this course.

Overview of the programme

  • What-If analysis (Goal Seek, Scenarios, Solver);
  • Array formulas;
  • Conditional formatting based on formulas;
  • Creating a template;
  • User-defined functions;
  • Cube functions;
  • Introduction to dashboards;
  • Protection;
  • Finding cells with formulas;
  • The Inquire add-in.