View all the services available for students of the Institute
Study with us
View member services
Services to support your business
This course is designed for those who want to appraise and improve the way they utilise the features of MS Excel and MS PowerPoint to communicate effectively. It will challenge how we present information and explore how we can engage our audience and transfer technical and financial information clearly and simply.
This one-day course equips finance professionals with practical SQL skills for data analysis and reporting. Participants will learn SQL fundamentals, connect Excel to cloud databases, write tailored financial queries, and use Excel's data modelling and visualisation tools. With hands-on exercises, this course enhances financial data retrieval, aggregation, and visualisation, making data-driven decision-making more efficient.
The aim of the course is to provide a general introduction to spreadsheet modelling and related analysis. During the course, participants will create a model 'from scratch' and the use of this model for various outputs, as outlined below (ROI, dashboard outputs etc.). This is augmented by a feed of given data into the model from 'history' to allow comparisons etc. with the model outputs.
Advances in AI coupled with modern features in PowerPoint greatly simplify creating eye-catching and informative presentations. Effective usage of Copilot or ChatGPT cuts the time and manual input required for presenting and reporting on data for regular meetings, ad-hoc assignments or regulatory requirements. This hands-on course will guide you through using AI Tools with Microsoft 365 to efficiently and professionally present information.