View all the services available for students of the Institute
Study with us
View member services
Services to support your business
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and Effective Macro creation and editing are explored.
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.
Accountants handle vast amounts of data from multiple sources, often spending hours on manual cleaning, reconciliation, and integration. This course explores AI-powered automation to eliminate errors, streamline reporting, and enhance accuracy. Learn to extract, clean, and merge data seamlessly. Free up time for analysis, gain predictive insights, and improve decision-making. Gain skills in smarter, AI-driven efficiency and automation.
Power Automate is an online workflow service used to automate time-consuming business tasks and processes across apps and services. This example-driven course will give the confidence to select the right actions and logic for business workflows. Participants will learn how to navigate the Power Automate interface confidently, use templates, create workflows and triggers and how to use Artificial Intelligence to increase productivity.