Skip to main content

Remote training Excel Expert: The hidden treasures of Excel

Version: Office 365
Duration: Half a day
Price incompany training: € 475 VAT excl. / Terms for incompany training.

Description

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.

Objectives

After this training, you’ll know how 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.

Prerequisites

Advanced knowledge of formulas and Excel in general.

Content

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 a quote

"*" indicates required fields

Address*
Name*
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?