Excel Mastery: Advanced Data & Automation

Overview

Advanced Excel skills boost business efficiency by enabling better data management, analysis, and automation. They allow for quick handling of large datasets, creation of insightful reports, and automation of repetitive tasks. These capabilities lead to more informed decision-making, streamlined processes, and improved financial planning, giving businesses a competitive edge.

This practical course is designed to enable you to create advanced spreadsheets for data analysis and forecasting. You will learn how to implement advanced functions and features such as macros and will be familiar with the basics of Visual Basic for Applications (VBA). The course is designed as a practical course enabling you to receive hands-on experience of all topics covered. By the end of the course, you will have an understanding of:

Course Content

• Advanced Functions
• IF, Nested IF
• Lookups
• Match, Index

Who Should Attend

This course is designed for those who are proficient in basic MS Excel features and wish to use MS Excel for more complex and sophisticated tasks. Participants should have a good working knowledge of MS Excel.

Location

The Mount Business & Conference Centre

Cancellation Policy

NON-ACCREDITED TRAINING

• More than 3 weeks prior to the course start date - No cancellation fee payable.
• Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.

ACCREDITED TRAINING

• More than 6 weeks prior to the course start date - No cancellation fee payable.
• Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.

Substitute delegates will be accepted at any time at no cost.

Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.

We are scheduling future dates for this course. Register your interest in attending by email at contact@aku.training or call us on 028 9016 0587. If you have four or more participants, inhouse delivery may be more cost effective. Contact us today for a quote.

Registration

Location: The Mount Business & Conference Centre

Fill in the form below and we will contact you as soon as possible.