Earn Your Data Analysis in Excel Specialization

Develop best-in-class Excel analytics skills including creating and visualizing insights from raw data, manipulating and connecting related data to supercharge your work, and using the latest Excel tools and add-ins to improve your efficiency.
  • Discover the world of data analysis using the full suite of Excel functionality
  • Automate and streamline data collection, transformation, and analysis to save hours of time
  • Learn how to manipulate data to create models and visuals that generate actionable business insights

Specialization Overview

100%

Online learning

Learn at Your Own Pace

With videos, exercises, and quizzes

 Unlimited Access

To our library of content

4

Total courses

2-4 Weeks

Average completion time

Receive a Certificate

To verify your Excel analysis skills

Your path to becoming an Excel data analysis expert

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

3 Required Courses

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

Fundamentals of Data Analysis in Excel
Level 2
8 hours
Preview Course
Power Query Fundamentals
Level 3
6 hours
Preview Course
Power Pivot Fundamentals
Level 3
7 hours
Preview Course
Hide All Courses

1 Elective Course

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

Excel VBA for Finance
Level 3
7.5 hours
Preview Course
Hide Elective

Get Specialized

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

See 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 saving 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

Taught by Industry 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. He has a degree in Economics and Finance with a focus on Econometrics.
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. A data enthusiast with a background in retail banking, he is an advocate for making advanced analytics more accessible to a wider audience by integrating them in business intelligence solutions.
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. With experience drawn from supply chain management and fintech, John uses his experience to help us create world class business analytics courses.

Our Alumni Work At:

salesforce

Explore Your Career Options

Data Analysis in Excel is a transferable skill that will help advance your efficiency, proficiency, and career in almost any industry. Here are a few examples of roles that Excel will transform:

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.

Data Analyst

Data Analysts collect data and transform it into more usable formats. They combine related data and create models and metrics to analyze trends and performance. Excel is the workhorse of a Data Analyst.

Business Intelligence Specialist

Business Intelligence Specialists have a broader range of skills including SQL and data visualization. However, Excel often remains the tool of choice for quick calculations, basic models, 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.

Trust Our CFI Certified Alumni on LinkedIn

"Excellent resource for Excel. I really love this course. it covered all the topics needed for a data analyst."
Read more
"This course provides all the necessary information to become confident with [analysis] in Excel. It is very informative, clear, visually ideal and really memorable. This learning [journey] was a blast! Thanks!"
Read more
"Well explained and walkthrough scenarios to understand Excel functions to improve analysis work. Great job!"
Read more
"Mastered Powerpivot easily After failing on youtube videos would not expect to master powerpivot and powerBI so easily."
Read more
"The course is very informative and challenging at the same time but worth it all together."
Read more
"This course was exactly what I've been searching for! I've looked at various other training videos (YouTube, vlogs, LinkedIn, even group training at my work) but always felt like I was still missing important pieces when I was finished..."
Read more

Get specialized in Data Analysis in Excel

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?
As this is a recurring payment, we accept all major credit and debit cards including Visa, MasterCard, and American Express.
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.

Looking for team solutions? Train and improve with CFI.

0 search results for ‘