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.
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 shows participants how to automate data collection, processing, and reporting using AI, PowerQuery, VBA, and scripting tools. Learn to streamline workflows, reduce manual effort, and improve data accuracy. Automate report generation, reconciliation, and compliance tasks while leveraging AI for smarter decision-making. Gain hands-on experience building efficient, end-to-end data automation solutions.
LOADING...