Slide 1
Microsoft Office Courses

eLearning courses to help any Microsoft novice get to grips with the software they need.

Slide 1
Outlook Courses

Become the master of your mailbox.

Slide 1
Word Courses

From the basics to more advanced formatting, learn to use Microsoft Word.

Slide 1
PowerPoint Courses

Create and present impressive slideshows.

Slide 1
Excel Courses

Learn all the tips and tricks to create excellent spreadsheets.

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.

Course Content

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