Description

Our "Excel Expert: The hidden treasures of Excel" course gives you a solid foundation for creating reliable and high-performing Excel documents. The course dives deeper into Excel's most advanced features. If you have a very good knowledge of Excel and want to be challenged to raise your level, this is the perfect course for you.

Objectives

After this Excel training, you will:

• Build more efficient and higher-performing formulas

• Apply (conditional) formatting more efficiently

• Set up analyses and best-case/worst-case scenarios

• Create functional standard workbooks

• Give your workbooks a boost

Target audience

Avid Excel users who can already work fluently with Excel but want to optimize their knowledge and their workbooks.

Prerequisites

You have a very good general knowledge of Excel and, more specifically, of formulas.

Contents

Format

• Custom data formatting (e.g. 15K instead of 15,000 tons)

Simulations and what-if analyses

• Scenarios

• Goal seek

• Solver

• Data tables

Functions

• Cell names (limited scope, automatic creation of cell names)

• Array functions

Other features

• Restricting the end user's range

• Comparing values across different rows/columns

• Using slicer and table styles across multiple workbooks

• Quick way to extract the unique values from a specific column