Skip Main Navigation
Page Content

Save This Event

Event Saved

Microsoft Excel 2016 – Level 2 (Advanced)

International Leadership Academy (ILA), The British School in the Netherlands

Wednesday, January 16, 2019 from 9:00 AM to 4:00 PM (CET)

Microsoft Excel 2016 – Level 2 (Advanced)

Ticket Information

Ticket Type Sales End Price Fee Quantity
Microsoft Word Level 1 (Basic) Participant Fee Jan 15, 2019 €195.00 €0.00

Share Microsoft Excel 2016 – Level 2 (Advanced)

Event Details

Microsoft Excel 2016 – Level 2 (Advanced)


Learn in 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 Dates

Wednesday 16th January 2018

Programme Cost

€195 Euros

Programme Facilitator

Westhaghe Training & Advies


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 (ILA), The British School in the Netherlands

Save This Event

Event Saved

When & Where

The British School in The Netherlands
International Leadership Academy
Lange Houtstraat 26
2511 CW Den Haag

Wednesday, January 16, 2019 from 9:00 AM to 4:00 PM (CET)

  Add to my calendar


International Leadership Academy (ILA), The British School in the Netherlands

The International Leadership Academy (ILA) is a dynamic and innovative centre of professional learning and development. Working in partnership with world-renowned organisations, we provide impactful programmes specifically designed for international school staff.


Based in The Hague, in the heart of Europe, we offer a comprehensive range of programmes covering four key strands. Together we are rethinking education for 21st century schools.


  Contact the Organizer

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.