Excel for Business Analysts

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

This online spreadsheet course covers some of the most popular and useful functions used in Excel to analyze business and finance. This is an excellent course for those who want to gain practical skills in Microsoft Excel.

On Course Completion

Once you have succesfully completed this certificate course you will receive:

• a certificate from Alison.com and
• you will be eligible for the CABA Associate certification on the payment of a fee.

Course Syllabus

The course consists of two Modules:

Module One

• 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 Two

• 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