Make better, faster decisions with comprehensive Excel training covering everything from core skills and advanced techniques.
Learn the core functionality needed to become proficient in Excel, from cell navigation and selection to writing formulas and sorting data.
1. Data Manipulation and Formatting
Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.
2. 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.
3. 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.
4. 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.
5. 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.
Learn how to do lookups on large datasets, build pivot tables and perform complex statistical analysis.
1. 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.
2. Pivot Tables
Pivot Tables allow you to search, filter and sort data very quickly, making them an essential data analysis tool in Excel
3. 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.
4. 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!
Charts and Dashboards
Charts and dashboards quickly summarise and generate insights from your data. Learn how to create these tools effectively in Excel.
1. 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.
2. 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.
Modeling for Business
Learn how to build models that help businesses solve complex problems. This course assumes you have intermediate-level Excel skills.
1. 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, maximize profitability.
2. 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.
Investment valuation is a hugely beneficial skill in business. Learn both valuation theory and how to build valuation models.
1. 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.
2. 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.
Macros and VBA
Macros extend the functionality of Excel, enabling you to automate certain tasks and create much more complex formulas.
1. 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!
Power Pivot and Power Query Essentials
Learn the core functionality of Power Pivot and Power Query, including how to connect to, transform, and manipulate datasets.
1. 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.
2. 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.
3. 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.
DAX in Power Pivot
Data Analysis Expressions, or DAX is the formula language used in Power Pivot. Learn about the main functions of the language and how to use them in these courses.
1. 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.
2. 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.
3. 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.
Simulation in Excel
Uncertainty is always present in business. Learn how to use simulation to identify the most likely future outcomes in an uncertain climate.
1. 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.