Data Skills for Excel Professionals. Learn to apply the power of Excel tools like Power Query and Power Pivot to manipulate data, save time and effort, and create stunning visualizations.
Suggested by: Coursera (What is Coursera?)
No prior knowledge required
No unnecessary risks
The Institute of Corporate Finance’s specialization equips participants with essential data analysis skills in Excel. The courses cover fundamental aspects, including:
Participants are recommended to have a basic familiarity with Excel. The specialization aims to improve professionals’ proficiency in utilizing Excel to make data-driven decisions.
Internship participants engage in practical projects where they apply the skills they have acquired to solve real-world problems. The projects include tasks such as:
This allows learners to gain hands-on experience in leveraging Excel’s data capabilities to address real business challenges in corporate finance.
Course 1
5 hours
4.8 (21 ratings)
Excel is the world’s most widely used data analysis tool and a great starting point for data analysis. In this course, you’ll use Excel’s built-in tools to organize your data into sheets and rows. Then, you’ll analyze and derive insights from that data using pivot tables. Finally, you’ll present those insights by building an Excel dashboard.
Apply these skills using modern capabilities like dynamic array formulas, linked data types, and Excel concepts. Work with real-world scenarios, using data sets from financial reports and retail sales.
Course 2
5 hours
4.6 (16 ratings)
In the Power Query Fundamentals online course, we’ll explore the world of data transformation and automation. You’ll learn how to extract data from a variety of sources, and transform it into formats that are more suitable for analysis. We’ll show you how to automate data joins and transformations, as well as how to extract and aggregate data from multiple files. Finally, we’ll finish by handling common errors.
Power Query is absolutely essential for any Excel-focused analyst, and is a powerful asset for business intelligence analysts. These skills will help you spend less time manipulating data and more time on analysis projects.
Course 3
4 hours
4.8 (12 ratings)
This course provides original guidance on how to build a business intelligence dashboard in Excel using the Power Pivot add-in. You will learn the key functions and best practices for creating a dashboard. Throughout the course, you will apply everything you have learned to a practical example using data we will provide you.
By the end of the course, you’ll have everything you need to create your own dashboards in Excel—so you can analyze and present data, track KPIs, and make your data easily accessible.
