Showing 1–10 of 12 resultsSorted by latest
- Course
Excel for Accountants: Getting Started
Excel is a powerful calculation tool, record keeper and a tool for reporting and analysing. This course takes you through the features and functions available. Enhance your knowledge of navigating an Excel workbook, formatting data, and more. - Course
Data Analysis for Accountants: Statistics
This course explores the various ways you can use statistics and probability to enhance your role as an accounting and finance professional. Gain an understanding of basic probability functions and testing your hypotheses using Excel.
- Course
Data Analysis for Accountants: Power BI
This course introduces you to Power BI, Microsoft’s powerful data analysis tool, and how it can benefit you in your finance role. Transform the way you handle and analyse data, creating a range of interactive data visualisations.
- Course
Power Query and Get & Transform: Intermediate
Take your knowledge and application of Power Query and Get & Transform Data to the next level. This course looks at adding custom, index and conditional columns, covers the basics of JSON and M (Mashup), and explores the uses of parameters and custom functions. - Course
Excel Skills Booster for Accountants
This course examines what Excel can offer accountants. Become confident in using fundamental and advanced Excel functions and features including conditional calculations and IF statements, lookups, tables, PivotTables and dynamic arrays. - 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
Take 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.