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.

8 Best Crochet Courses for 2025: Practical, Enriching, Creative

Duolingo’s Reddit Community Revolts: ‘No Más’ to Unpaid Support

Open edX Conference 2024: Program & Speakers

40+ Free Certificates from Wolfram U: Expand Your Computational Universe

University of Sheffield Ends 11-Year Partnership with FutureLearn

12 Best Data Analysis Courses for 2025: From Data to Insights

2000+ Free Developer and IT Certifications

262K Courses, 833M Enrollments: Breaking Down Udemy’s Massive Catalog

10 Best Programming Courses for 2025

Harvard’s Intro to Python: Earn a Free Certificate

10 Best Guitar Courses for Beginners in 2025

7 Best Climate Change Courses for 2025: Exploring the Science

Can an AI Teach AI? Learning From an Avatar

Udemy’s Fourth Leadership Exit of 2025: CMO Genefa Murphy Resigns

7 Best Kubernetes Courses for 2025

25 Resources to Learn Generative Engine Optimization in 2025