€195

Microsoft Excel 2019 – Level 2 (Advanced)

Actions and Detail Panel

€195

Event Information

Share this event

Date and Time

Location

Location

International Leadership Academy

Vrouw Avenweg 422

Leidschenveen

2493 WX The Hague

Netherlands

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description
You will learn to use the advanced functionality of Excel: make calculations through advanced features, databases and PivotTables.

About this Event

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

Updated Cancellation Policy

Due to the changing travel restrictions and health precautions caused by COVID-19, we understand that delegates may need to cancel a programme booking. This is possible up to one week before the start of the programme. Please email info@bsnila.com and we will work with you to find a fair solution.

*Please note that the International Leadership Academy will not be liable for travel, flight or hotel costs in the event of a cancellation.

 


		Microsoft Excel 2019 – Level 2 (Advanced) image

Website tags: #general

Staff url: https://app.blueskyeducation.co.uk/training/73364

Share with friends

Date and Time

Location

International Leadership Academy

Vrouw Avenweg 422

Leidschenveen

2493 WX The Hague

Netherlands

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved