Skip Main Navigation
Page Content

Save This Event

Event Saved

Microsoft Excel 2016 – Level 2 (Advanced)

International Leadership Academy, BSN

Thursday, June 11, 2020 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 21h 4m €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 11th June 2020

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, BSN

Save This Event

Event Saved

When & Where

International Leadership Academy
Lange Houtstraat 26
2511 CW Den Haag

Thursday, June 11, 2020 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.