Master Excel’s specific functions and formulae with this online spreadsheet course.

This online spreadsheet course covers many of the most popular and useful functions in Excel for analyzing business and finance. It is an excellent choice for anyone looking to develop practical Microsoft Excel skills.

On Course Completion

• A certificate from Alison.com and

• You will be eligible for the CMC Excel certificate on the payment of a fee.

Course Syllabus

The course consists of two Modules:

Module 1

• Introduction to Excel for Business Analysts

Learning Outcomes

Introduction to Business Analysis

Print and View Options in Excel

Merging and Looking up Data

Making better decisions with IF

Preparing Data for Analysis

Lesson Summary

Module 2

• Course Assessment

Final Assessment

In this course, you will learn how to:

Use ‘vlookup’ and ‘hlookup’ business analysis

Logically analyze business data with the ‘if’, ‘ifs’, ‘iferror’, ‘sumif’ and ‘countif’ functions

Outline the difference between concatenating and standardizing data

Describe how to split data using text functions like ‘search’, ‘left’, ‘right’ and ‘mid’

Implement ‘index match’ and ‘xlookup’ in Excel

Explain how to make better business decisions with ‘if’ functions

Demonstrate the difference between the ‘countif’, ‘sumif’ and ‘countif’ functions in Excel

Standardize and ‘clean’ data for analysis