Webcast: 07 May, 2019 | 5:00 am - 8:00 am UTC
This webcast is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel spreadsheets.
£139.00
VAT calculated on checkout
Webcast: 22 May, 2019 | 5:00 am - 7:00 am UTC
This webcast introduces you to the relevant Excel data analysis tools and focuses on what you can do with your data once it is in Microsoft Excel. You will learn how to use Power BI various techniques to cleanse your data by removing errors, validating and standardizing data.
£99.00
VAT calculated on checkout
This online course will make you excel in Excel. It’s designed for accountants, by an accountant, so you’ll learn how to unlock all the magic in your spreadsheets.
£139.00
VAT calculated on checkout
In this session, attendees will learn about some new and existing analytics features provided by Microsoft Excel.
£45.00
VAT calculated on checkout
This video introduces the PivotTable feature and covers the basics
£99.00
VAT calculated on checkout
Take your reporting skills to the next level. These four 2-hour videos with interactive exercises will show you how.
£299.00
VAT calculated on checkout
This video covers one of the most significant enhancements rolled out with Excel 2007, the table feature. It also covers named references and the five most important shortcuts so that you can improve your personal productivity.
£99.00
VAT calculated on checkout
Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization
£79.00This video covers the five workbook design principles that help you build reliable recurring-use workbooks, as well as workbook and worksheet organisation ideas.
£99.00
VAT calculated on checkout
This video finishes the PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.
£99.00
VAT calculated on checkout
This video opens with conditional summing, which will absolutely improve efficiency in your reporting workbooks. It also explores lookup basics and why lookups are preferable to direct cell references and the details of VLOOKUP.
£99.00
VAT calculated on checkout