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.

This course reviews the main components of the annual report and provides an understanding of the basis of the company’s past performance so as to form a reasoned assessment of its prospective future performance.It examines challenges encountered in analysing annual reports and provides exposure to ratios and techniques used in assessing financial statements.Learners are acquainted with the decision models of equity, credit & other analysts

One of the most significant updates to Ireland’s pensions landscape is just weeks away, with auto-enrolment (AE) set to impact every employer and over 800,000 employees. This live webinar will explain how AE will work, compare it with existing employer-sponsored schemes, and showcase the strong benefits available to employees with access to an employer scheme.

We would like to have a festive catch up with our regional members and we are starting in Tralee this year.

Many accountants are thrust into a Project Management role or are doing their current job but also completing the PM function for their business. Others may find themselves unable to control, influence or interface with their teams and projects due to a lack of basic PM knowledge. This course will provide the learner with an understanding of Project Management and supply tools and techniques to plan the scope and timeline required for their projects.