Excel Expert: the hidden treasures of Excel

Classical courses

Version: Microsoft 365
Duration: 1/2 day (09:00-12:30 or 13:30-17:00)
Price training (excl. VAT) starting at: €995
Number of people: 1-12p

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

Request for quotation

Let's start a conversation!

Team Xylos is ready to meet you