Skip to main content
Learning Path

Applied Excel Tools

Learn about a variety of tools and applications that will enhance your Excel capabilities to expert proficiency. You’ll learn how to use Power Pivot and Power Query to develop complex data models from various data sources using Excel. You’ll learn how macros can be used to automate tasks and save time when using Excel – and much more.

Excel      17 hours      13 CPD/CPE Credits
TRY FOR FREEEXPLORE OUR LIBRARY
1

Excel

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!

Course     90 Minutes     1 CPD/CPE Credits
2

Excel

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.

Course     120 Minutes     1.5 CPD/CPE Credits
3

Excel

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.

Course     120 Minutes     1.5 CPD/CPE Credits
4

Excel

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.

Course     120 Minutes     1.5 CPD/CPE Credits
5

Excel

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.

Course     120 Minutes     1.5 CPD/CPE Credits
6

Excel

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.

Course     150 Minutes     2.0 CPD/CPE Credits
7

Excel

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.

Course     150 Minutes     2.0 CPD/CPE Credits
8

Excel

Monte Carlo Simulation

Monte Carlo simulation allows us to identify possible and probable outcomes from a process by simulating it repeatedly. Learn how to create these simulations in this course.

Course     150 Minutes     2.0 CPD/CPE Credits
9

Kubicle
Certified Diploma

Applied Excel Tools

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

TRY FOR FREE

$39 per month after 7 days trial

Why Learn With Kubicle?

Real-world data skills to really set you apart

Recognized Certificates and Diplomas

You can demonstrate your proficiency to current and potential employers, by earning internationally recognized certificates and diplomas upon competition of your course exams and learning profiles.

Build Your Expertise and Confidence

When you decrease gaps in your decrease, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability too.

Get Real World Experience

While our training is undertaken by diverse leaners around the world, each share a common ambition – to get the tools, knowledge and confidence to master the real world of work.

Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Got A Question?

We’re here to help in any way we can.