Excel for Business Analysts

Master Excel’s specific functions and formulae to conduct business analysis with this free online spreadsheet course.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Explain how to make better business decisions with ‘if’ functions
Outline the difference between concatenating and standardizing data
Describe how to split data using text functions like ‘search’, ‘left’, ‘right’ and ‘mid’
Apply ‘vlookup’ and ‘hlookup’ functions in your own spreadsheets
Select ‘index match’ and ‘xlookup’ in Excel
Analyze business data with the ‘if’, ‘ifs’, ‘iferror’, ‘sumif’ and ‘countif’ functions
Indicate the difference between the ‘countif’, ‘sumif’ and ‘countif’ functions in Excel
Review and ‘clean’ data for analysis

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.