Learning Plan Overview

  1. Excel Essentials
  2. Data Analysis
  3. Charts and Dashboards
  4. Modeling for Business
  5. Investment Valuation
  6. Macros and VBA
  7. Power Pivot and Power Query Essentials
  8. DAX in Power Pivot
Data Manipulation and Formatting

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

15 lessons
1 hour 1 minute
Created with Sketch. Beginner
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.

14 lessons
1 hour 1 minute
Created with Sketch. Intermediate
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.

5 lessons
24 minutes
Created with Sketch. Beginner
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.

15 lessons
58 minutes
Created with Sketch. Intermediate
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.

11 lessons
49 minutes
Created with Sketch. Intermediate
Pivot Tables

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

12 lessons
40 minutes
Created with Sketch. Intermediate
Introducing Statistics

Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!

7 lessons
30 minutes
Created with Sketch. Intermediate
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.

12 lessons
41 minutes
Created with Sketch. Beginner
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.

11 lessons
50 minutes
Created with Sketch. Intermediate
Build Your First Model

This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximise profitability.

18 lessons
1 hour 13 minutes
Created with Sketch. Advanced
Forward-Looking Models

SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.

18 lessons
1 hour 17 minutes
Created with Sketch. Advanced
Introduction to Valuation

Valuing investments can be daunting at first. This course will teach you the basic theory of valuation and show you how to build simple Excel valuation models.

18 lessons
1 hour 13 minutes
Created with Sketch. Advanced
Valuing a Real Estate Investment

In this course, learn how to build your first, full valuation model from scratch. The investment opportunity is a downtown 3-bed apartment, recently put up for sale.

13 lessons
49 minutes
Created with Sketch. Intermediate
Introduction to Excel Macros

Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!

9 lessons
33 minutes
Created with Sketch. Advanced
Introducing Power Pivot

Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.

15 lessons
55 minutes
Created with Sketch. Intermediate
Developing and Visualizing Your Data Model

In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also look at options for displaying your data that go beyond Pivot Tables, such as Power Maps and Power View.

11 lessons
50 minutes
Created with Sketch. Intermediate
Power Query

Power Query (or Get and Transform in Excel 2016) lets you import data from a variety of sources into Excel. You can also transform awkwardly formatted data into an appropriate layout for data analysis, as we’ll see in this course.

17 lessons
1 hour 1 minute
Created with Sketch. Intermediate
Essential DAX Functions and Concepts

Data Analysis Expressions, or DAX, is the formula language of Power Pivot, but there are many similarities with Excel formulas. Learn the basic functions of DAX in this course.

12 lessons
54 minutes
Created with Sketch. Advanced
Practical Applications of DAX

Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power Pivot. You will see that an understanding of Power Pivot and DAX lets you create more complex and insightful charts and tables, without leaving Excel.

10 lessons
58 minutes
Created with Sketch. Intermediate
Advanced DAX Functions and Concepts

In our second course on Data Analysis Expressions, we’ll look at areas of DAX that can be a little bit more difficult to implement, like time intelligence. We’ll also demonstrate some of the important concepts that underpin DAX, such as contexts and filtering. Once you can understand this course, you’ll be well placed to understand DAX comprehensively.

11 lessons
59 minutes
Created with Sketch. Intermediate

What can Kubicle do for you?

  • Managers

  • Learners

Manager Dashboard Tools

Transform your team with data-driven Excel training. We’ll help you implement, manage and measure a training program that matches your organization’s needs.

  • Assign focused training content to your team
  • Measure learner progress and performance
  • Assess and apply knowledge with real datasets
  • Drive success with dedicated onboarding
Learn More
Individual Learner Tools

Take your Excel skills to the next level with data-driven training for business. Our adaptive learning plan will personalize your training to meet your needs.

  • Identify skill gaps and focus on relevant courses
  • Track your own progress and performance
  • Assess and apply your skills with real datasets
  • Earn certificates at the end of every course
Learn More

Trusted by leading organizations worldwide

Client company logo, Deloitte Client company logo, KLM Client company logo, Nestle Client company logo, KPMG Client company logo, Qantas

"Kubicle is highly appreciated by our staff members at all levels due to its concise format and real impact in driving efficiency gains."

Agata, a Deloitte senior consultant

Agata Bak-Geerinck

Senior Consultant

Deloitte Financial Advisory

Sample Lessons

Keyboard Shortcuts

Watch

Net Present Value

Watch

Ranking Metrics

Watch

Get started with a free trial

Request a FREE 14 day team trial

Excel Excel for Business Analytics Learning Plan
Financial Modeling Financial Modeling for Data Analysis Learning Plan
> Tableau Tableau for data visualization
Power BI Power BI for Business Analytics Learning Plan
Alteryx Alteryx for Data Analysis Learning Plan
Data Literacy Data Literacy a b c
Please select a learning plan.

Volume discounts available

Over 50% off for large teams

Please enter your first name
Please enter your last name
Please enter a valid company email address
Please enter a valid phone number

For more information, see our terms of use & Privacy Policy

Start your 7 day FREE trial

Excel Excel for Business Analytics Learning Plan
Financial Modeling Financial Modeling for Data Analysis Learning Plan
> Tableau Tableau for data visualization
Power BI Power BI for Business Analytics Learning Plan
Alteryx Alteryx for Data Analysis Learning Plan
Data Literacy Data Literacy a b c
Please select a learning plan.

$0.00 / month for 12 months

FREE lifetime access after 1 year

Please enter your first name
Please enter your last name
Please enter a valid company email address

Buy Now

Billing Cycle:

Every month for 12 months (November 12, 2019 - October 12, 2020). Access is free thereafter.

Your Payment Details:

Excel learning plan benefits