Back to Fundamentals of Data Analysis in Excel
Corporate Finance Institute

Fundamentals of Data Analysis in Excel

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales. By the end of the course, you'll be able to: ● analyze a dataset using native Excel tools ● apply Excel tools and formulas to transform and structure your data ● create pivot tables to slice and dice your data ● visualize data with pivot charts and Excel Charts ● describe the landscape of data analysis and visualization

Status: Dashboard Creation
Status: Data Analysis
BeginnerCourse5 hours

Featured reviews

ZW

Reviewed Dec 10, 2024

There are too many short videos, it's better to put the similar topics together.

IA

Reviewed Jul 14, 2026

It was a great course. It was easily and clearly explained, and the examples made it easier for me to follow along.

SS

Reviewed Jan 6, 2026

Informative yet simple and practical course, highly recommend!

AA

Reviewed Aug 2, 2025

An excellent and perfect for finance students and finance relevant employees.

All reviews

Showing: 20 of 25

KATI
3.0
Reviewed Mar 17, 2025
Bernardo
5.0
Reviewed Apr 22, 2025
Kai
5.0
Reviewed May 4, 2024
arif
5.0
Reviewed Aug 3, 2025
SG
5.0
Reviewed Jan 7, 2026
Rudy
5.0
Reviewed Jul 28, 2025
Angelow
5.0
Reviewed Nov 6, 2025
Olga
5.0
Reviewed Apr 16, 2025
Wail
5.0
Reviewed Nov 1, 2025
Anshul
5.0
Reviewed Sep 4, 2024
Elnora
5.0
Reviewed Jun 29, 2026
MICHAEL
5.0
Reviewed Oct 15, 2024
Rana
5.0
Reviewed Feb 12, 2025
Mikhael
5.0
Reviewed Dec 18, 2024
Mikael
5.0
Reviewed Oct 17, 2025
โชติพงศ์
5.0
Reviewed Aug 19, 2025
dougybiexcel
5.0
Reviewed Feb 19, 2025
CHUA
5.0
Reviewed Jun 30, 2025
Rahma
5.0
Reviewed Dec 14, 2025
Oksana
5.0
Reviewed May 28, 2025