This is a hands-on introduction to querying cloud-based databases using Excel and explores the simplest way to get data from the cloud with SQL. Effective use of SQL and examples of its use in modern Data Analysis will be covered and visualisation of the data to ascertain key business insights will be demonstrated, allowing participants to impelement new skills in their roles.

This Microsoft Excel advanced course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by using the data analysis and business intelligence features. Participants will use updated newer functions and features including PivotTables and Power Pivots for analysis of large data sets, using Get and Transform functions and a first look at creating Macros using the powerful point and click features.

More and more people in Ireland live in, invest in, or provide services to multi-owned and multi-unit developments. Apartments, and associated corporate structures, play an increasingly important role in the country's housing stock. This morning session is designed to inform and educate the audience about the latest developments in legislation, regulation, and taxation, and wider issues for the multi-owned residential property sector.

The potential opportunities offered by AI are enormous, but how do you apply them to reap their benefits in Microsoft Excel? This course will help to unveil the power of artificial intelligence, exploring key concepts, applications, and cutting-edge tools like ChatGPT and Copilot. Participants will gain practical skills in using AI and learn Prompt Engineering techniques to carry out intermediate and advanced tasks in Excel.

This course will aim to provide practical tips and guidance on recent updates and changes to FRS 102. Speakers will go through detailed workings and examples, showing participants how to implement the detailed provisions of FRS 102.