Skip to main content

Excel Expert: The hidden treasures of Excel

Version: Microsoft 365
Duration: Half a day (09:00-12:30 or 13:30-17:00)
Price incompany training: € 970 VAT excl. / Terms for incompany training.


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 Format

  • Modified data format (15K instead of 15,000 tons)

Part 2 Simulations and what-if analysis

  • Scenarios
  • Goal seek
  • Solver
  • Data tables

Part 3 Functions

  • Cell names (limited scope, automatic creation of cell names)
  • Array Functions (What is an Array Function? How do you work with array functions?)

Part 4 Miscellaneous

  • Limiting end-user range
  • Comparing values in different rows/columns
  • Using slicer and table styles in multiple workbooks
  • Quick way to extract the unique values from a particular column
View all our trainings

Request for quotation

"*" indicates required fields

In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?