Skip to main content
Learning Path

Data Analysis with Excel

Transform your understanding of Excel and learn how you can perform faster analysis, reduce errors and make better business decisions. You’ll develop a deep understanding of Excel’s most important capabilities, from basic manipulation and formatting to lookups and pivot tables. Learners who complete this Learning Path will be ready for examination under Microsoft’s official Excel certifications (MO-201 Associate & MO-202 Expert).

Excel      25 hours      20.0 CPD/CPE Credits
Start Today
1

Data Literacy

Thinking and Communicating with Data

Often the ability to think about data and the ability to effectively communicate are considered separate skillsets. This course focuses on harmonizing the two skills into one essential skillset.

Course     120 Minutes     1.5 CPD/CPE Credits
2

Data Literacy

Introduction to Data and Databases

Data doesn’t have to be just for technically minded analysts. These courses teach you all the non-technical principles of understanding and working with data in your company.

Course     90 Minutes     1.0 CPD/CPE Credits
3

Excel

Data Manipulation and Formatting

Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.

Course     150 Minutes     2.0 CPD/CPE Credits
4

Excel

Formulas and Functions

This course introduces the most useful of Excel’s built-in arithmetic and logical functions. You also learn how to write, manipulate and audit your own formulas.

Course     210 Minutes     3.0 CPD/CPE Credits
5

Excel

Finance Functions

Excel is commonly used by finance professionals to evaluate investment returns. This course introduces important finance functions you can use for this purpose, including Internal Rate of Return and Net Present Value.

Course     60 Minutes     1.0 CPD/CPE Credits
6

Excel

Text, Time, and Dates

Excel has a host of functions that help manipulate these 3 data types. In this course, we’ll learn how to clean, chop and manipulate text entries and how to perform time-series analysis on a dataset for an online start-up.

Course     150 Minutes     2.0 CPD/CPE Credits
7

Excel

Optimize company revenue with cost analysis

Help a startup catering company that has grown quickly in its first year, but can’t pinpoint why. You’ll use Excel to analyze their cost trends and determine what spending items actually boost revenue – helping the company mature and grow steadily in the future.

Project    90 Minutes     1.5 CPD/CPE Credits
8

Excel

Lookups and Database Functions

Lookup functions help you quickly find records in large datasets. Learn how to use these functions, create dropdown lists, build search panels and much more in this course.

Course     150 Minutes     2.0 CPD/CPE Credits
9

Excel

Pivot Tables

Pivot Tables allow you to search, filter and sort data very quickly, making them an essential data analysis tool in Excel.

Course     150 Minutes     2.0 CPD/CPE Credits
10

Excel

Boost productivity by optimizing compensation

In this project, you’ll help a solar panel manufacturer that’s unable to motivate their salespeople to perform effectively. You’ll use Excel to analyze their existing sales data and identify a compensation structure that delivers optimal performance for the sales department.

Project      90 Minutes     1.5 CPD/CPE Credits
11

Excel

Charts in Depth

Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.

Course     90 Minutes     1.0 CPD/CPE Credits
12

Excel

Build Your First Dashboard

Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we’ll build a simple sales dashboard from scratch in Excel.

Course     120 Minutes     1.5 CPD/CPE Credits
13

Kubicle
Certified Diploma

Data Analysis with Excel

Get Started Today

Learning paths offer a guided experience, with relevant content selected by our content experts.

Kubicle Certified Diploma
Comprehensive Courses
Hands-on Projects

TRY FOR FREE

$39 per month after 7 days trial

Why Learn With Kubicle?

Real-world data skills to really set you apart

Recognized Certificates and Diplomas

You can demonstrate your proficiency to current and potential employers, by earning internationally recognized certificates and diplomas upon competition of your course exams and learning profiles.

Build Your Expertise and Confidence

When you decrease gaps in your decrease, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability too.

Get Real World Experience

While our training is undertaken by diverse leaners around the world, each share a common ambition – to get the tools, knowledge and confidence to master the real world of work.

Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Got A Question?

We’re here to help in any way we can.