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

The eLearning course is designed to enhance your skills in using Microsoft Excel for advanced functions, consolidating data from multiple workbooks, auditing formulas, and managing workbook sharing and protection. The course has an estimated seat time of 3 hours, meaning it is designed to be completed within this duration.

The primary objective of this course is to prepare you for the Microsoft Office Specialist (MOS) Expert exam 77-728, which focuses on advanced Excel features. By taking this course, you will gain proficiency in using logical, informational, time, mathematical, and lookup functions, consolidating data from different workbooks, sharing and protecting workbooks, and utilizing auditing tools.

Learning Objectives

  • Logical and Informational Functions
  • Time and Mathematical Functions
  • Lookup Functions
  • Consolidating Workbooks
  • Auditing Tools
  • Protecting Workbooks
  • Sharing Workbooks

Microsoft Excel Courses

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to open workbooks, navigate directly to cells and between worksheets.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn cell selection techniques, how to move and copy data, add and remove cells.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use Excel views, and import and export files.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will use AutoFill and Paste options, modify and group worksheets, insert rows and columns apply styles, and format worksheets.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will create charts, move charts and add illustrations using Pictures, WordArt, SmartArt, and ClipArt.

eLearning course

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to add comments and share workbooks.

eLearning course

This course covers topics included in the MOS Expert exam 77-728. This includes using Advanced Chart features, PivotTables and PivotCharts.

eLearning course

This course covers topics included in the MOS Expert exam 77-728. This includes custom templates, data formats and Internationalizing workbooks.

eLearning course

This course covers topics included in the MOS Expert exam 77-728. This includes using Logical, Informational, Time, Mathematical and Lookup Functions.

eLearning course