Excel Expert: The hidden treasures of Excel

  • Course types: Calendar course / In company
  • Version: Office 2010/2013/2016
  • Takes place in: Brussels
  • Duration: 1 day
  • Price: € 395 VAT excl. / Cheaper course?

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.

Choose a date and location

Objectives

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.

Prerequisites

Advanced knowledge of formulas and Excel in general.

Content

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

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



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

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 395 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com