15. juni 2021 - 7:00 tot 14:00
International Leadership Academy
NetherlandsVoorburgBordewijklaan 38

Microsoft Excel 2016 – Level 2 (Advanced) , International Leadership Academy, dinsdag, 15. juni 2021

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



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 email .  Any participant cancellation after this time is non-refundable.


dinsdag, 15. juni 2021, International Leadership Academy, Microsoft Excel 2016 – Level 2 (Advanced)

Time travellers event!

Time travellers event!

woensdag 22. oktober 2064
Time travellers meeting

Time travellers meeting

maandag 31. december 2057
NK rolstoel rijden
zondag 07. februari 2106
Gijs naar Mars
vrijdag 19. mei 2023
lampen bijeenkomst
zaterdag 01. januari 2050
woensdag 04. augustus 2066
Vincent Willem Van Gogh
zondag 30. maart 2053
100e NPK 2030
donderdag 06. juni 2030
Intocht Sinterklaas in Loosdrecht
dinsdag 31. december 2069
Vind meer interessante evenementen
Krijg event aanbevelingen op basis van uw Facebook-smaak. Snap het nu!Toon me de geschikte evenementen voor mijNiet nu