Kubicle Path
Data Analysis with Excel: Analysis
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, such as formatting lookups and building 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).
10.0 HOURS
8.0 CPE / CPD Credits
1
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.0 CPE / CPD Credits
2
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.0 CPE / CPD Credits
3
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
4
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.0 CPE / CPD Credits
5
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: Analysis
10.0 HOURS
8.0 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
