| Name | Description |
| Make your Data AI-Ready |
A lack of usable data is to blame for the limited use of AI in many organisations, research suggests. Siloed systems and poor data quality remain the top barriers to the promises of AI-driven efficiencies. This one-day course shows how to use AI to fix messy data and simplify recurring reports. Participants learn how to use modern tools powered by artificial intelligence (AI) to bring together, clean, prepare and use data from many sources — without doing everything manually. It helps automate tasks such as preparing and producing regular period reports, so you can spend more time analysing results and less time organising the data.
Through hands-on exercises and real-world case studies, you’ll master AI-assisted data workflows—making your data preparation faster, smarter, and more efficient. |
| AI-Assisted Data Automation |
In an increasingly data-driven world, automation is key to improving efficiency, reducing errors and accelerating decision-making. AI-Assisted Data Automation is designed to help professionals automate data collection, processing and reporting using a combination of PowerQuery, VBA, command-line tools, task scheduling and AI-powered scripting.
This course will take you step by step through automating repetitive data tasks, such as retrieving data from multiple sources, cleaning and transforming datasets and generating reports on a schedule. You’ll explore VBA for Excel automation, PowerQuery refresh automation, file handling via command-line scripting and AI-driven enhancements to make your workflows smarter and more efficient.
By the end of this course, you’ll be able to build fully automated workflows that streamline data integration, minimize manual effort and leverage AI to optimize your automation processes. Whether you're a business analyst, data professional, or automation enthusiast, this course will equip you with the tools and techniques to take your data automation skills to the next level.
|
| AI in Excel using ChatGPT and Copilot |
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. |
| Microsoft Excel 365 Intermediate |
This Excel Intermediate course is designed to extend participants’ knowledge and proficiency in MS Excel by focusing on a wide range of key functions, tools and analytical techniques. The course aims to enhance learners’ ability to utilise Excel effectively for data management, analysis and presentation and introduces using AI tools like ChatGPT and Copilot to get into deeper data analysis. |
| AI+ Programme for ENTIRE EDIH - AI-Powered Productivity with Excel, Data & Presentations - Day 1 |
Artificial Intelligence is transforming the way professionals analyse data, build reports and deliver presentations. This practical course shows you how to harness AI to work smarter in Excel and PowerPoint.
You’ll start with a clear, non-technical introduction to AI and learn powerful prompting techniques to generate, refine and summarise content with confidence. The course then moves into AI-enhanced Excel — helping you create and troubleshoot formulas, modernise spreadsheets with advanced features and build interactive dashboards using slicers and controls.
You’ll also discover how AI can accelerate slide preparation, generate visuals and infographics, refine messaging and support automation using VBA, Power Query and Power Automate.
This course is ideal for professionals who want to boost productivity, modernise their Excel skills and apply AI confidently in real business environments.
|
| AI+ Programme for ENTIRE EDIH - Smart Data Integration with AI |
AI-powered data integration and preparation is essential for saving time, reducing manual effort, and improving data accuracy. It streamlines workflows by automating data cleaning, extraction, and integration, enabling smarter decision-making. AI helps detect errors, handle large datasets, and optimise compliance and reporting. It reduces costs, enhances scalability, and preps data for AI and BI tools, ensuring better insights. Ultimately, it future-proofs data management in today’s increasingly data-driven world.
Through hands-on exercises and real-world case studies, you’ll master AI-assisted data workflows—making your data preparation faster, smarter and more efficient.
|
| AI+ Programme for ENTIRE EDIH - AI-Driven Data Automation |
In an increasingly data-driven world, automation is key to improving efficiency, reducing errors, and accelerating decision-making. AI-Assisted Data Automation is designed to help professionals automate data collection, processing, and reporting using a combination of PowerQuery, VBA, command-line tools, task scheduling, and AI-powered scripting.
This course will take you step by step through automating repetitive data tasks, such as retrieving data from multiple sources, cleaning and transforming datasets, and generating reports on a schedule. You’ll explore VBA for Excel automation, PowerQuery refresh automation, file handling via command-line scripting, and AI-driven enhancements to make your workflows smarter and more efficient.
By the end of this course, you’ll be able to build fully automated workflows that streamline data integration, minimize manual effort, and leverage AI to optimize your automation processes. Whether you're a business analyst, data professional, or automation enthusiast, this course will equip you with the tools and techniques to take your data automation skills to the next level.
|