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 Quantity
Microsoft Excel Level 2 (Advanced) Participant Fee Jun 9, 2020 €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:

 

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 11th June 2020

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

Save This Event

Event Saved

When & Where


International Leadership Academy
Lange Houtstraat 26
2511 CW Den Haag
Netherlands

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.