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 Functions, Consolidating and Auditing


Seat time: 3 hours

About the course: This course covers topics included in the MOS Expert exam 77-728. This includes using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools.

Course Content

Logical and Informational Functions

Time and Mathematical Functions

Lookup Functions

Consolidating Workbooks

Auditing Tools

Protecting Workbooks

Sharing Workbooks