Excel for Business Analysts 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 successfully completed this certificate course you will receive:
  • a certificate from Alison.com and
  • you will be eligible for the ISMF 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
  Course details at a Glance
  • Course Duration :3-4 Hours of Learning
  • CPD Accreditation
  • Course Link:
BOOK THIS COURSE
Online Provider
Approved Teaching Schools