Showing 11–20 of 20 resultsSorted by latest
-
Course
Power Query and Get & Transform: Getting Started
If you are a novice Get & Transform Data user, this course will help you to navigate your way comfortably around the user interface. Learn the basics of using Power Query to connect, combine and transform your data, so that it meets your analysis needs. -
Course
Power Pivot: Getting Started
This course has been designed to take the novice Power Pivot user to a level where they are comfortable working with Power Pivot models and using Pivot tables and charts. You’ll also be able to carry out calculations and time intelligence functions by learning the basics of DAX.
-
Course
Intermediate Excel Formulas for Accountants
ake your Excel skills to the next level with this course on intermediate level formulas. Learn about a variety of rounding and text functions, as well as how to make the most out of date and time formulas and increase your workbooks resistance to errors. -
Course
Advanced Excel Formulas for Accountants
This course explores advanced Excel accounting functions and how you can apply them in your finance work. Learn how to calculate future value, carry out one and two variable analysis, use reference functions, create dynamic ranges and more, in this course.
-
Course
General Excel Formulas for Accountants
Designed specifically for accountants, this course enables you to create basic and complex IF statements and use various LOOKUP functions. It also explains how to use conditional functions, relative and absolute cell references to write formulas efficiently.
-
Course
Creating Dashboards in Excel
Dashboards are useful for presenting complex information in a more user-friendly way. This course will guide you through the fundamentals of creating dashboards in Excel, enabling you to produce professional charts and interactive visualisations that will inform users.
-
Course
Financial Modelling: Business Simulation
Updated for 2024. Did you know Excel can be used to model potential business situations? In this course, you can learn the basics of business simulation in Excel, along with how to create financial models to aid decision making.
-
Course
Charts and Visualisations in Excel
Excel provides a host of charts and visualisations to tell stories data. Explore the basics of creating charts in Excel and what makes a good chart. And discover how to use a range of less common Excel charts for maximising the effectiveness of your data visualisations.
-
Pathway
Finance Data Analysis
Explore how data analysis can empower you to deliver valuable insights to your business and clients. This pathway provides the tools, technologies, and methodologies you need to ensure you play a pivotal role in decision making. -
Course
Excel Productivity Booster
It’s easy to find yourself using Excel the same way for years at a time. This course concentrates on a range of practical and simple techniques that can make spreadsheets quicker to set up, easier for the user to use, more automated, and guard against career-threatening errors.