Excel Expert: The hidden treasures of Excel

  • Duration: 1 day


Our ‘Excel Expert: Excel’s Hidden Treasures’ training teaches you how to format reliable, useful Excel documents and tackles the most advanced software features. If you already know all the ins and outs of Excel and are looking for a challenge to hone your skills, this course is perfect for you.


After this training, you’ll be able to:

  • Write more efficient and better-performing formulas
  • Apply (conditional) formatting more efficiently
  • Create analyses and best case/worst case scenarios
  • Create functional standard workbooks
  • Boost your workbooks.

Target Group

Advanced Excel users who are already working effortlessly with Excel and want to optimise their knowledge and workbooks.


Advanced knowledge of formulas and Excel in general.


Part 1 Formatting

  • Custom data formatting (show 15K instead of 15,000)
  • Points to note when using functions in conditional formatting

Part 2 Functions

  • Alternatives for Vlookup: Index, Match, Offset, Indirect

Part 3 Cell names

  • Cell names with a limited scope
  • Dynamic cell names
  • Automatic creation of cell names

Part 4 Simulations and What If analysis

  • Scenarios
  • Goal Seek
  • Solver
  • Data tables

Part 5 Arrays

  • What is an array function?
  • How do you use array functions?

Part 6 Data validation

  • Custom data validation rules
  • List box based on the output of another list box

Part 7 Miscellaneous

  • Restrict the end user’s access
  • Compare values in different rows/columns with each other
  • Use slicer and table styles in multiple workbooks
  • Faster way of extracting unique values from a specific column

Part 8 Performance

  • General performance tips when preparing workbooks
  • Optimise search functions
  • Optimise conditional formatting

Request an offer

Share this course on Facebook, Twitter, LinkedIn or e-mail

This training as in-company training?

Would you like to organize this training course for your employees? At your offices and/or with adapted content? We transform your requirements into the perfect solution.