What will I be able to do upon completing the Specialization?

Learners who take this specialization will learn how to manipulate large quantities of data in excel using some of Excel's most advanced features. By the end you'll be able to set-up automatic workflows and sleek visualization dashboards using these tools.

Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.

Can I just enroll in a single course?

Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Can I take the course for free?

No, you cannot take this course for free. When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. If you cannot afford the fee, you can apply for financial aid.

Will I earn university credit for completing the Specialization?

This Specialization doesn't carry university credit, but some universities may choose to accept Specialization Certificates for credit. Check with your institution to learn more.

Data Skills for Excel Professionals Specialization

Data Skills for Excel Professionals. Learn to apply Excel's power tools such as Power Query and Power Pivot to manipulate data, save time and energy, and create stunning visualizations.

Instructor: CFI (Corporate Finance Institute)

Included with Coursera Plus

Learn more

3 course series

Get in-depth knowledge of a subject

4.8

(109 reviews)

Beginner level

Recommended experience

2 months at 4 hours a week

Flexible schedule

Earn a career credential

Share your expertise with employers

3 course series

Get in-depth knowledge of a subject

4.8

(109 reviews)

Beginner level

Recommended experience

2 months at 4 hours a week

Flexible schedule

Earn a career credential

Share your expertise with employers

What you'll learn

The Specialization "Data Skills for Excel Professionals" offered by the Corporate Finance Institute equips participants with essential data analysis capabilities within Excel. The courses cover fundamental aspects, including Data Analysis in Excel, Power Query Fundamentals, and Power Pivot Fundamentals. The recommended pre-work for participants is to have a basic familiarity with Excel. The Specialization aims to enhance professionals' proficiency in leveraging Excel for data-driven decision-making and is a valuable resource for individuals seeking to sharpen their data skills in a corporate finance context.

What’s included

Shareable certificate

Add to your LinkedIn profile

Taught in English

8 practice exercises

Advance your subject-matter expertise

Learn in-demand skills from university and industry experts
Master a subject or tool with hands-on projects
Develop a deep understanding of key concepts
Earn a career certificate from Corporate Finance Institute

Specialization - 3 course series

Participants in the "Data Skills for Excel Professionals" Specialization at the Corporate Finance Institute engage in hands-on projects where they apply acquired skills to solve real-world problems. These projects involve tasks such as data analysis, cleaning, and visualization, allowing learners to gain practical experience in leveraging Excel's data capabilities for authentic business challenges in corporate finance.

Fundamentals of Data Analysis in Excel

Course 15 hours4.8 (69 ratings)View course

What you'll learn

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

Skills you'll gain

Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Data Transformation, Data Cleansing, Data Visualization Software, Spreadsheet Software, Dashboard, Data Analysis, Data Presentation, Data Manipulation, and Business Intelligence

Power Query Fundamentals

Course 25 hours4.8 (64 ratings)View course

What you'll learn

In this online Power Query Fundamentals course, we’ll explore the world of data transformation and automation. You’ll learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, we’ll end by looking at how to deal with common errors.

Power Query is absolutely essential for any Excel focused analyst, and is a powerful asset to any Business Intelligence analyst. These skills will help you spend less time on data manipulation, and more time on your analysis projects. By the end of this course, you will be able to: ● Identify the characteristics of good and bad data using the principles of data normalization ● Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot ● Extract information from fields that combine two or more values ● Transform datasets by grouping or combining data from different tables, or even multiple files from the same folder ● Avoid, interpret, and fix errors and exceptions that you experience in Power Query ● Load transformed data into Excel for use as automated data feeds

Skills you'll gain

Data Transformation, Data Import/Export, Data Cleansing, Pivot Tables And Charts, Automation, Extract, Transform, Load, Data Integration, Data Manipulation, Data Validation, and Microsoft Excel

Power Pivot Fundamentals

Course 34 hours4.8 (31 ratings)View course

What you'll learn

This course provides step-by-step instructions for how to set-up a business intelligence dashboard in Excel using the Power Pivot add-on. You’ll learn the key functions and best practices for setting-up a dashboard. As you progress through the course, you’ll apply everything you’ve learned to a hands-on example using data we provide. By the end of this course, you’ll walk away with 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.

Upon completing this course, you will be able to: ● Create a Power Pivot table by drawing data from several different tables ● Develop simple calculated metrics with consistent formatting to be re-used across our dashboard ● Assemble multiple pivot tables, charts, and dimensions into a dashboard ● Apply DAX formatting language to create measures and columns that draw data from other tables ● Manipulate context to calculate more advanced metrics ● Utilize DAX Advanced Time Intelligence to create powerful period comparisons and KPIs

Skills you'll gain

Data Analysis Expressions (DAX), Data Modeling, Business Intelligence, Dashboard, Pivot Tables And Charts, Star Schema, Interactive Data Visualization, Business Metrics, Key Performance Indicators (KPIs), Data Storytelling, Data Presentation, Data Manipulation, Microsoft Excel, and Competitive Analysis