Monday 13th November 2023



9.30am to 5pm – 1 day, by webinar



This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.


Course Objectives:

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.


Course Content:

Once you complete Excel 2016 – Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality.
This course empowers you to:

  • Refer to internal and external worksheets
  • Perform LOOKUPs and audit formulas
  • Share and protect workbooks
  • Automate workbook functionality using validation rules and macros
  • Create sparklines and map data
  • Forecast data



To ensure success, students should have completed Excel Essentials (Part 1) and Excel Functions Including Pivot Tables and Lookups (Part 2) or have the equivalent knowledge and experience.



Sharon O’Neill, New Horizons



Members €80 pp
Non Members €100 pp



Book online below.

For more information, email Dervla O’Neill at  or call 086 083 6626 for more information