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 31, 2018 from 8:45 AM to 4:00 PM (CET)

Microsoft Excel 2016 – Level 2 (Advanced)

Ticket Information

Ticket Type Sales End Price Fee Quantity
Microsoft Excel 2016 – Level 2 (Advanced) Participant Fee Jan 30, 2018 €185.00 €0.00

Who's Going

Loading your connections...

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:

 

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 Dates

Wednesday 31st January 2018

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 info@bsnila.com . 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 Hague

The Hague
Netherlands

Wednesday, January 31, 2018 from 8:45 AM to 4:00 PM (CET)


  Add to my calendar

Organizer

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
Microsoft Excel 2016 – Level 2 (Advanced)
Things to do in The Hague Class Family & Education

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.