MS Excel (Advanced)

Course Code: DCU165

Target Audience: To ensure success, participants should have an advanced level of  Excel Functions including Pivot Tables and Lookups or have the equivalent knowledge and experience.

Overview: This course is designed for staff 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 Fee: €105 (charged to school / unit / centre)