EN
0
Basket

Your basket is empty

background section

Excel : advanced 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. This course takes your Excel knowledge and abilities to a higher level.
 
Do you want to take your Excel skills even further? Follow up this course with another one from the range of Excel courses at Cevora.
 
  • Training type

    Classical

  • Duration of training

    2 days

  • Available languages
    EN 
  • Training code

    1664EB2

What do you learn?

 
  • You have no questions or doubts when it comes to using What-If analyses, even in conjunction with the Goal Seek, Solver and Scenarios tools;
  • You know the why, where, when and how of using array formulas, user-defined formulas, as well as cube functions and even formulas based on conditional formatting;
  • You record and use macros to speed up your work processes.

Target group

You have a reasonably advanced knowledge of Excel, but would like to unlock a few more of its secrets.

Required prior knowledge

Your knowledge of Excel is advanced enough for you to use formulas and PivotTables without a second thought. The Cevora course  – Excel: Advanced I is the perfect foundation going into this course.

Overview of the programme

  • What-If analysis;
  • Array formulas;
  • Conditional formatting based on formulas;
  • Creating and using templates;
  • User-defined functions;
  • Cube functions;
  • Introduction to dashboards;
  • Protection;
  • Finding cells with formulas;
  • The Inquire add-in;
  • Macros.