|
3 Evening sessions: 5.30pm – 8.00pm Our trainer is an experienced MS EXCEL professional Course Notes included. Valid towards CPE hours
|
What is it about?
The Advanced course is a continuation of the basic and intermediate course. It will enable you to confidently manage worksheets and workbooks, enter data and be able to perform calculations by creating advanced formulas. You will also be able to use Apply Functions in formulas including the IF function in conjunction with other functions, utilizing the AND/OR functions. You will learn to create and manage Pivot Tables and create advanced chart elements. You will also get the feel of basic Macros. At the end of each lesson, there will be a practical exercise to ensure that the course objectives have been reached.
Who is it for?
This course is aimed at individuals seeking to gain extensive understanding of MS Excel 2016 functions that will enable them to fully utilise the program's potential.
What will I gain?
This course will provide you with extensive knowledge on how to use lookup utilise what if analysis and apply advanced date and time functions among others. You will learn how to create and manage pivot tables as well as basic macros. This course enables you to take full advantage of the versatility MS Excel 2016 offers.
Course Overview
Advanced Excel 2016 - Class Outline
Fee
Advanced - 3 sessions - 190 Euros
Funding Options for Employees and Self Employed:
Similar Courses
MS Excel 2016 Fundamentals - Advanced
Course Schedules |
|||
|---|---|---|---|
| 10 Jun 2024 - 17 Jun 2024 €180.00 | |||
| DATE | FROM | TILL | |
| 10 Jun 24 | 17:30 | 20:00 | |
| 12 Jun 24 | 17:30 | 20:00 | |
| 17 Jun 24 | 17:30 | 20:00 | |
| 21 Oct 2024 - 28 Oct 2024 €180.00 | |||
| DATE | FROM | TILL | |
| 21 Oct 24 | 17:30 | 20:00 | |
| 23 Oct 24 | 17:30 | 20:00 | |
| 28 Oct 24 | 17:30 | 20:00 | |
| 27 Nov 2024 - 04 Dec 2024 €180.00 | |||
| DATE | FROM | TILL | |
| 27 Nov 24 | 17:30 | 20:00 | |
| 02 Dec 24 | 17:30 | 20:00 | |
| 04 Dec 24 | 17:30 | 20:00 | |
