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:


 


Formats



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


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
Verjaardag
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