Excel

Make better, faster decisions with comprehensive Excel training covering everything from core skills and advanced techniques.

Categories

  • Excel Essentials
  • Data Analysis
  • Charts and Dashboards
  • Modeling for Business
  • Investment Valuation
  • Macros and VBA
  • Power Pivot and Power Query Essentials
  • DAX in Power Pivot
  • Simulation in Excel

Courses

Excel Essentials

Learn the core functionality needed to become proficient in Excel, from cell navigation and selection to writing formulas and sorting data.

Data Manipulation and Formatting

Course

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.

Created with Sketch. Beginner
15 Lessons
150 minutes
CPD Credits
Formulas and Functions

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.

Created with Sketch. Beginner
14 Lessons
210 minutes
CPD Credits
Finance Functions

Course

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.

Created with Sketch. Intermediate
5 Lessons
60 minutes
CPD Credits
Text, Time, and Dates

Course

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.

Created with Sketch. Intermediate
15 Lessons
150 minutes
CPD Credits
Optimize company revenue with cost analysis

Project

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.

Project
6 Steps
90 minutes
CPD Credits

Work smarter with full access to our full library of courses

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.

Monte Carlo Simulation

Course

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.

Created with Sketch. Intermediate
12 Lessons
150 minutes
CPD Credits

Work smarter with full access to our full library of courses