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.
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.
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.
Learn how to clean messy and unorganized data with Tableau Prep. This will open up Tableau Desktop to a much wider variety of data sources.
At the core of Power BI is the ability to create compelling visuals and assemble them into dashboards. These courses will show you how.
These courses will teach you about the capabilities of the online service and the data connection capabilities of Power BI.
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.
See how the visualization and DAX capabilities of Power BI can be applied to a practical example.
Power BI Case Study
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 advanced 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.
Data doesn’t have to be just for technically minded analysts. These courses teach you all the non-technical principles of understanding and working with data in your company.
People often apply analytical methods without really understanding them. These courses will teach you the relevant principles behind important methods in statistics and predictive modeling.
Shapes, images, charts and text are the building blocks of PowerPoint. Learn about these objects and much more.
Track: DAX in Power Pivot
Track: DAX in Power Pivot
Recommend a Future Course
Do you have any recommendations for new or existing courses? We'd love to hear your thoughts.Make Recommendation