Learn the core functionality needed to become proficient in Excel, from cell navigation and selection to writing formulas and sorting data.
Learn how to do lookups on large datasets, build pivot tables and perform complex statistical analysis.
Charts and dashboards quickly summarise and generate insights from your data. Learn how to create these tools effectively in Excel.
Learn how to build models that help business solve complex problems. This course assumes you have intermediate-level Excel skills.
Investment valuation is a hugely beneficial skill in business. Learn both valuation theory and how to build valuation models.
Macros and VBA extend the functionality of Excel, enabling you to automate certain tasks and create much more complex formulas.
Macros and VBA
Learn the core functionality of Power Pivot and Power Query, including how to connect to, transform, and manipulate datasets.
Learn how to analyse financial statements, build financial projections and perform complex company valuation - all in Excel!
Learn how to build a variety of financial models that cover a variety of different business use-cases, from a fast-growing startup raising venture capital to a large company merging with a smaller rival.
Learn the core skills necessary to become an expert in Tableau, from data manipulation and modelling to building compelling, interactive dashboards.
These courses take an in-depth review of formulas and calculations in Tableau. The software has it's own language for writing formulas which you will master in these courses.
Learn more advanced topics in Tableau such as optimising your dashboards for performance, create interactive geo-spatial visualisations and learn to connect to many different data sources through Tableau.
At the core of Power BI is the ability to create compelling visuals and assemble them into dashboards. These courses will show you how.
Learn the more technical side of Power BI. The Query Editor lets you transform and load data, while DAX lets you add functions and formulas to your data models.
The Query Editor and DAX
Alteryx is a powerful data transformation and analysis tool that empowers users to import, manipulate and analyse complex datasets. These courses will have you quickly up and running as an Alteryx user.
These courses take an in-depth look at how to use formulas and manipulate data in Alteryx.
Through these courses, users will learn how to apply statistical and geospatial analysis techniques through Alteryx.
Learn how to apply time series forecasting and predictive modeling tools in Alteryx. These courses build off of concepts covered in the Statistical Analysis course.
Applications and macros allow you to repackage workflows to automate tasks and create powerful new tools. Learn how they can enhance the Alteryx experience.
Applications and Macros
These courses will take a deeper look at some real-world applications of Alteryx.
Practical Applications of Alteryx
Shapes, images, charts and text are the building blocks of PowerPoint. Learn about these objects and much more.
New courses coming this year
Click the menu icon to view a list of new courses coming later this year. Please let us know what courses you'd like us to cover in the future.
- Financial Statements 1 & 2
- Macros & VBA Part 2
- Advanced Excel Formatting
Power BI - The Query Editor and DAX
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we’ll import files from a folder, combine them into one query, and transform the data using the Query Editor.