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 businesses 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 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 analyze 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 modeling 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 analyze 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.
Learn how to use Alteryx in a wide variety of practical contexts, including AB testing, designing user-friendly applications and macros, working with spatial data, scraping data from the web and using Alteryx in combination with and Tableau.
Learn how to deploy Alteryx's predictive tools such as regression, time series, classification models, market basket analysis and clustering.
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.
Learn the basics of creating a business document in Word by manipulating text, creating tables and adding visual design elements.
Learn how to add finishing touches to your document by adjusting the layout, citing your sources and sharing and reviewing with collaborators.
Some useful Word tools are not often used. This track covers less common but still occasionally useful tools that can be found in Word or through 3rd party add-ins.
Advanced Tools in Word
Shapes, images, charts and text are the building blocks of PowerPoint. Learn about these objects and much more.