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