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.
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.
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 firstname.lastname@example.org or call 086 083 6626 for more information