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