Module 4: Exploring Subtotals

In this course, you will learn how to use Excel Subtotals to consolidate large chunks of numbers in a few rows on your worksheet.

Take this course to learn more.

Happy Learning!

Module 3: Conditional Formatting

In this course, you will learn to format cells, use Lists and Tables to handle extensive data, and use Comparative Conditional Formatting to compare multiple data sets.

Take this course to learn more.

Happy Learning!

Module 2: LOOKUP and Reference Functions

In this course, you will learn Excel’s Vlookup function and how to use it with various other Excel functions such as IFERROR, ISERROR, Column, Index and Match functions.

Take this course to learn more.

Happy Learning!

Module 1: Efficient Ways of Using Excel

With the wide range of formulae and functions that MS Excel provides, it is one of the most important programs to work on for data organizing and analysis.

In this course, you will learn the basics of Excel – including General Options, Formulae, Proofing options, Language settings, Ribbon customisation, Quick Access toolbar editing, Add-ins, working with Templates, Shortcuts, Range names, and multiple logical functions.

Take this course to learn more.

Happy Learning!

.