Learning Outcomes

Introduction to Business Analysis

Merging and Looking Up Data

Making Better Decisions with IF

Preparing Data for Analysis

Lesson Summary

Microsoft Excel remains one of the best tools for data analysis. This course will focus on the specific functions, and formulas such as VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP that will help to conduct business or data analysis.

Final Assessment

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

Excel for Business Analysts

This free online spreadsheet course covers some of the most popular and useful functions used in Excel to analyze business and finance. We teach you how to use Excel functions such as ‘vlookup’, ‘hlookup’, ‘xlookup’, ‘index’ and ‘if’ to help you make better business decisions. This course is ideal for those who want to gain practical skills in Microsoft Excel to make business reports more compelling  and meaningful.

10 Best Programming Courses for 2025

2025’s Online Education Shakeup Claims Another: Skillshare’s CEO Departs

EdX’s 2021: Year in Review

Open edX Conference 2026: Program, Workshops & Registration

Harvard CS50 in 2025: How to Get a Free Certificate

Udemy Q4 2025: First Profitable Year Ends in a Loss

2U Market Cap Falls Below edX Acquisition Price. Google to Blame?

Inside the Coursera-Udemy Deal: Three Bids, Two Years and a Rival Suitor

Unlock 800+ Free Certificates: Master Tech & Soft Skills with CodeSignal Learn

Coursera Growth Stalls, Leadership Changes as Stock Hits All-Time Low

Coursera 10-K Highlights: Lower Partner Revenue Share, 1k+ Employees

Coursera, Udemy, and the $10M+ Video Privacy Battle: Class Action Update

Writing as Enchantment: Inside Alan Moore’s BBC Maestro Course

freeCodeCamp’s Responsive Web Design (Free) Certification Is Out of Beta

Coursera’s $100 Million Thesis: Andrew Ng Will Think of Something

Harvard CS50 Guide: How to Pick the Right Course (with Free Certificate)