Dates:

Wednesday 1st February 2023

 

Duration:

9.30am to 5pm – 1 day, by webinar

 

Overview:

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

 

Prerequisites:

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.

 

Trainer:

Sharon O’Neill, New Horizons

 

Fee:

Members €80 pp
Non Members €100 pp

 

Booking:

Book online below.

For more information, email Dervla O’Neill at oneilld@ihf.ie  or call 086 083 6626 for more information