Microsoft Excel 2016 – Level 2 (Advanced)

Microsoft Excel 2016 – Level 2 (Advanced)

41   0   2   0   0   0
Kommentare (0)
Veranstalter bewerten
Microsoft Excel 2016 – Level 2 (Advanced)

Unterkategorie - Rund um Dein Tier



The British School in The Netherlands - Campus TBC, 640 Vrouw Avenweg, 2493 WZ, Den Haag, Netherland


16 Januar, 2019

Microsoft Excel 2016 – Level 2 (Advanced)

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


Start/Ziel tauschen


Es gibt noch keine Benutzer-Kommentare.
  • Haben Sie schon ein Konto?
Bitte registrieren Sie sich oder Sie sich ein, um einen Kommentar abzugeben.