Purchase your training online

Visit our online shop to browse classroom courses, webinar training, distance learning and eLearning


Classroom training

A portfolio of over 200 courses delivered at your own setting by our team of 100+ trainers strategically positioned across the country.


Webinar training

Webinar training is an online training method which is live and led by an experienced trainer to offer remote access to learning.

Distance learning

Distance learning

Our distance learning books are all accredited and mapped to our Level 2 courses. All the credibility of our face-to-face courses, but with unbeatable flexibility. Plus, we mark and certificate it for you.



Accredited e-Learning designed by curriculum experts and mapped to national standards, all on our sleek, user-friendly LMS. Best of all, it's great value for money.

previous arrow
next arrow

Excel Advanced Formulas, Macros and External Data


Seat time: 3.5 hours

About the course: This course covers topics included in the MOS Expert exam 77-728. This includes custom templates, data formats and Internationalizing workbooks. You will also get external data, use macros and form controls, evaluate formulas and use the MATCH and INDEX functions.

Learning Objectives

Languages and Accessibility

AutoSave and Templates

Custom Formatting

External Data and Queries

Macros and Form Controls

Evaluating Formulas and Watch Window

MATCH and INDEX Function

Related Courses