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