Skip Main Navigation
Page Content

Save This Event

Event Saved

Microsoft Excel 2016 – Level 2 (Advanced)

International Leadership Academy, BSN

Tuesday, June 15, 2021 from 9:00 AM to 4:00 PM (CEST)

Microsoft Excel 2016 – Level 2 (Advanced)

Ticket Information

Ticket Type Sales End Price Fee
Microsoft Excel Level 2 (Advanced) Participant Fee Ended €195.00 €0.00

Share Microsoft Excel 2016 – Level 2 (Advanced)

Event Details

Learn on this course in a fast and efficient way to calculate with Excel. You will learn to make calculations through advanced features, databases and PivotTables. In addition, it will be explained how this data can be presented in an optimal way.

Who is this course for?

This course is designed for those who want to enhance their working knowledge of Excel. This course is suitable for those who have an understanding of Excel to the extent of the Level 1 course.

 What’s Involved?

With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:



  • Modify Number format
  • Create and modify Cell styles
  • Create Table styles
  • Conditional formatting
  • Copy formatting


Working with databases

  • Creating and formatting Tables
  • Sort lists (or tables)
  • Filter lists (or tables)
  • Group and outlines of data
  • Using subtotals


Calculating with advanced functions

  • Working with cell names
  • Creating calculations over more worksheets and files
  • Calculate with Date and Time functions
  • Calculate with Financial functions
  • Calculate with Statistical functions
  • Calculate with Lookup functions
  • Calculate with Logical functions
  • Calculate with Database functions


Presenting data with Charts

  • Creating a chart
  • Modify a chart
  • Formatting a chart
  • Moving a chart
  • Sparklines


Introduction to Pivot Tables

  • Creating a PivotTable
  • Creating a PivotChart


Graphical objects

  • Insert a picture
  • Creating shapes
  • Formatting graphical elements
  • Changing the following order of objects
  • Grouping objects
  • Moving, duplicating and changing the size of objects
  • Using SmartArt


Modify the Excel environment

  • Creating a new workbook using a template
  • Using themes
  • Insert, create, modify and delete Custom lists
  • Inserting, modifying en removing hyperlinks


Programme Date

Thursday 15th June 2021

Programme Cost

€195 Euros

Programme Facilitator

Westhaghe Training & Advies - Bert Roos


Cancellation can be made up to six weeks before the first day of delivery by contacting us directly at .  Any participant cancellation after this time is non-refundable.


BSN ILA General Skills

Have questions about Microsoft Excel 2016 – Level 2 (Advanced) ? Contact International Leadership Academy, BSN

Save This Event

Event Saved

When & Where

International Leadership Academy
Vrouw Avenweg 422
2493 WX The Hague

Tuesday, June 15, 2021 from 9:00 AM to 4:00 PM (CEST)

  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.