View all the services available for students of the Institute
Study with us
View member services
Services to support your business
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.
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.
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.