The aim of this course is to produce a rolling forecast in Excel (18 months). This entails heavy automation to facilitate the re-use of the model to create updated forecasts on an ongoing basis. This automation involves rolling out into the future and recognising opening historical position and financial years.

This course explains the main content of IFRS for accountants in Ireland. It contains practical guidance on understanding the rules and on preparing relevant financial statements.

This virtual morning masterclass will showcase a lineup of industry experts, as they conduct a deep dive into current Fraud and Forensic Investigation trends, problem areas and emerging issues.

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. This course provides a solid introduction to using Power BI Desktop to connect to data, create visualisations, query the data and publish reports.

This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and Effective Macro creation and editing are explored.