Kubicle Path

Microsoft Excel Associate

This learning path helps you develop the practical skills needed to organize, analyze, and present data effectively using Microsoft Excel, aligning with the Microsoft Office Specialist: Excel Associate (Office 2019/365) certification objectives. Specifically, you’ll learn how to manage workbooks and worksheets efficiently; enter, format, and manipulate data; create and troubleshoot formulas and functions; organize and analyze information using tables, lookups, and PivotTables; and visualize results clearly with professional charts. Through hands-on courses and practical business projects, you’ll build confidence in applying Excel’s core features to real-world problems. By completing this path, you’ll gain the knowledge required to prepare for the MOS Excel Associate exam and demonstrate proficiency in transforming raw data into meaningful insights and well-structured reports.

Green Clock
20.5 HOURS
Green Certificate
17.5 CPE / CPD Credits
1
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
Green Clock
150 MINS
Green Certificate
2.0 CPE / CPD Credits
2
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
Green Clock
210 MINS
Green Certificate
3.0 CPE / CPD Credits
3
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
Green Clock
60 MINS
Green Certificate
1.0 CPE / CPD Credits
4
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
Green Clock
150 MINS
Green Certificate
2.0 CPE / CPD Credits
5
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
Green Clock
150 MINS
Green Certificate
2.0 CPE / CPD Credits
6
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
Green Clock
150 MINS
Green Certificate
2.0 CPE / CPD Credits
7
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
Green Clock
90 MINS
Green Certificate
1.0 CPE / CPD Credits
8
Excel

Identify high-yield locations for retail outlets

In this project, you'll help a retailer looking to expand their operations but who isn't sure where to go. You'll use Excel to identify the optimal locations for new stores, helping the company grow stronger and faster.
Project
Green Clock
90 MINS
Green Certificate
1.5 CPE / CPD Credits
9
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
Green Clock
90 MINS
Green Certificate
1.5 CPE / CPD Credits
10
Excel

Use data effectively with organized spreadsheets

In this project, you'll help a clothing retailer that has not developed good practices in storing and structuring their data. You'll develop Excel sheets that store the company's data in an organized manner, helping the company derive insights on revenues and profits that are currently being missed.
Project
Green Clock
90 MINS
Green Certificate
1.5 CPE / CPD Credits
Kubicle Certified Diploma:

Microsoft Excel Associate

Green Clock
20.5 HOURS
Green Certificate
17.5 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