Kubicle 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.
17.0 HOURS
13.5 CPE / CPD Credits
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 MINS
1 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
1.5 CPE / CPD 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 MINS
1.5 CPE / CPD 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 MINS
1.5 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
2 CPE / CPD 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 MINS
2 CPE / CPD Credits
Kubicle Certified Diploma:
Applied Excel Tools
17.0 HOURS
13.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
