For Individuals
For Teams
  • DAE program: 6 total, 5 required to earn DAE certificate
  • Self-paced & 100% online
  • Get this full program, community, & more with a CFI membership
  • Get this program and CFI's full training catalog for your organization
  • Manage learning, create custom paths, & measure progress
  • For teams of 2 or more learners

The Data Analysis in Excel Certificate Program at a Glance

CFI’s Data Analysis in Excel (DAE) Certificate Program positions you to master the world of data analysis using Microsoft Excel. Save hours by automating and streamlining data collection, transformation, and analysis. The DAE Certificate program is designed to ropel your career forward as an Excel wizard, equipping you with the skills to generate actionable business insights by creating compelling data models and visuals.

Program Overview

6 courses

5 Required Courses

26-30 Hours

Average completion time

Receive a Certificate

To verify your skills

500,000+ 5-star ratings

Best-in-class training, as rated by you

Our Learners Work At:

Your path to becoming a Microsoft Excel expert

This comprehensive specialization consists of four courses delivering practical, job-ready Excel analytics skills

5 Required Courses

Complete 5 required courses at your own pace, and get certified in Data Analysis in Excel.

Fundamentals of Data Analysis in Excel
4.8 (222 Ratings)
Level 2
8 hours
Fundamentals of Data Analysis in Excel - Case Study
4.9 (9 Ratings)
Level 3
3 hours
Power Query Fundamentals
5 (269 Ratings)
Level 3
6 hours
Power Query Fundamentals Case Study
4.9 (27 Ratings)
Level 3
1.5 hours
Power Pivot Fundamentals
5 (121 Ratings)
Level 3
4 hours
Hide All Courses

1 Elective Course

Electives are optional, supplementary courses designed to expand your Excel analytics skills.

Excel VBA for Finance
4.8 (42 Ratings)
Level 3
7.5 hours
See All Courses

What is a Specialization Program?

Specializations allow narrow and deep focus on a targeted subject area, with particular attention to specific analysis techniques and actionable skills.

They are designed to deepen your industry acumen and to prepare you for faster professional growth within the sector.

Skill Categories and Learning Objectives

Data Modelling & Analysis

Hide Details
  • Learn how to supercharge your analysis using a data model in Excel
  • Understand how to structure your data for efficient analysis
  • Create measures and metrics that help quantify the most important trends

Data Transformation

See Details
  • Learn how to transform data from multiple sources, reducing manual errors and save valuable time
  • Automate transformations to enable report refreshes at the click of a button
  • Use Power Query to perform efficient data transformations

Data Visualization

See Details
  • Create clear visuals that communicate key messages
  • Learn how to choose the right visual for the right type of data
  • Combine visuals to tell a story, allowing users to drill down into issues or trends using interactive dashboards.

Courses Taught by BI & Data Experts

Sebastian Taylor

Sebastian leads our BIDA® program, and has worked with a variety of BI tools across a number of industries. From quant energy risk management to financial and retail analysis, Seb loves the challenge of automating and communicating complex analysis with simplicity and clarity.

Joseph Yeates

Joseph is passionate about driving better decision making by creating, curating, and communicating insights from data. He has a degree in Business Administration and Finance, with further certifications in Business Analytics & Decision Making and Applied Database Administration & Design.

John Lee

John is an advocate of using analytics to drive decision making. He has a degree in Business Administration - Management Information Systems as well as a diploma in Data Science.

Explore Your Career Options

  • Data Analyst

    Data Analysts collect and transform data, creating models and metrics for analysis. Excel is their primary tool for this work.
  • Business Intelligence Specialist

    Business Intelligence Specialists have diverse skills, including SQL and data visualization. Excel remains the preferred choice for quick calculations and testing ideas.
  • Data Scientist

    Data Scientists use a variety of tools to create predictive models and analysis. Again, Excel is a useful tool to manipulate data and interrogate smaller datasets.
  • Finance Analyst

    Finance analysts perform many of the same tasks as data analysts, but using finance specific data. Microsoft Excel is by a significant margin the most widely used analysis tool in finance.

What Our Students Say

I can’t describe how amazing this course is! I’ll recommend it to anyone who wants to learn Excel so they can analyze data efficiently.

Abdulrahman Alhemidda

This has been one of the best courses! I had no idea how to use Power Pivot or even what it was. I’ve got several datasets that I can use this on right now while increasing efficiency, reducing file sizes, and getting rid of dozens of formulas that are scattered throughout the files.

Anthony Santillanes

This program will greatly aid in the automation process in my daily tasks and also improves on efficiencies!

Given Morakwi

Everything was explained clearly and carefully by the instructor which made things easy to understand.

Joss Atkinson

See more

Frequently Asked Questions

Will these courses help me advance my career?

Reviews from learners who have taken CFI courses and programs include numerous stories about how people have been able to advance their careers. There is a proven track record of CFI graduates marking successful transitions into the careers of their dreams and this is based largely on the resources that we make available to our learners upon enrolment. Our training is designed to be fully practical and simulates the experience of being trained on the job with real-world application of skills and knowledge learned. Additionally, we offer a wealth of information through our resources library. The unique blend of all these elements is what sets us apart from other eLearning platforms when it comes to giving you all the tools you need to drive your career forward in business analytics and data-driven finance.

Admission Requirements

This specialization bundle is recommended for learners and finance professionals who are looking to develop best-in-class data analysis skills in Excel and gain hands-on experience using the latest tools and add-ins. No pre-requisites or prior experience are necessary. However, to take the courses and complete the required exercises, learners will need access to a PC and/or Mac, Microsoft Suite (2016 or newer), and a stable internet connection.

What is the duration of the program?

It takes an average of 2-4 weeks to complete the entire specialization. However, you are given the freedom to complete all of the training at your own pace! Please see the “What You’ll Learn” section for recommended study hours for each course to give you a better idea for your time management.

How much time do I have to complete the courses?

Take as much time as you need. You will have access to all courses and all future upgrades in your subscription. You can review the video lessons as many times as you like and complete the courses at a pace that is most convenient for you. All of the required courses, resources, and assessments to obtain the certifications will be provided for as long as your subscription is active.

Can I download and edit the course material and templates?

Yes! You can download the resources included in your courses. All of the files needed in a course are available for download. Please note that while our study materials can be downloaded, the lecture videos are only available online due to copyright infringement issues.

How do I earn my certificates?

You need to complete all the video lessons, quizzes, and final assessments in each course to earn your course certificates. The certificate will then be available on your learner dashboard and also emailed to you as soon as you have completed all of the requirements.

What currency are your courses priced in?

All of our individual memberships are priced in USD. To learn more about pricing for corporate training solutions, visit CFI for Teams.

What payment methods do you accept?

Edit Page “Data Analysis in Excel Specialization (DAE)” ‹ Corporate Finance Institute — WordPress

Are there any additional fees or costs?

None! Your all-access membership includes everything and there are no additional fees required to earn your digital certification.

0 search results for ‘