Kubicle 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).

24.5 HOURS
20 CPE / CPD Credits
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 MINS
1.5 CPE / CPD 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 MINS
1 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
3 CPE / CPD 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 MINS
1 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
1.5 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
1.5 CPE / CPD 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 MINS
1 CPE / CPD 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 MINS
1.5 CPE / CPD Credits
Kubicle Certified Diploma:

Data Analysis with Excel

24.5 HOURS
20 CPE / CPD Credits

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