This two-day MIM workshop empowers professionals to supercharge their Microsoft Excel skills using ChatGPT and AI tools. Learn how to simplify data tasks, automate reports, and improve analysis with practical, real-world applications.
.png)
.png)
The ChatGPT and AI for Microsoft Excel programme by the Malaysian Institute of Management (MIM) is a two-day practical workshop designed to revolutionise how professionals use Excel. By combining Excel’s built-in AI tools with ChatGPT’s natural language capabilities, participants will learn how to streamline data analysis, simplify complex formulas, and automate routine tasks. Through hands-on exercises, real-world case studies, and interactive demonstrations, this course equips professionals with the skills to boost productivity, improve reporting, and make smarter, faster decisions using AI-powered Excel solutions.
• Welcome & Icebreaker.
• Course Objectives & Resources.
• Downloadable: ChatGPT for Excel eBook + Practice Files.
• Flash Fill for fast data manipulation.
• Let Excel auto-generate formulas.
• Power Query: Column from Examples.
• Analyse Data for AI-powered insights.
• Practice Exercise & Quiz.
• Accessing ChatGPT (Free vs Paid).
• ChatGPT 3.5 vs 4.0.
• ChatGPT for Excel use cases.
• Practice Scenarios & Quiz.
• Asking ChatGPT for basic to complex formulas.
• Using ChatGPT with Tables.
• Advanced formula generation.
• Practice Exercises.
• Complex formula structures with ChatGPT.
• Troubleshooting with ChatGPT.
• Commenting and explaining formulas.
• Comprehensive practice set.
• IF, AND, OR.
• Nested IF-AND & IF-OR Combinations.
• Creating PivotTables.
• Layout modifications.
• Filters, grouping, and slicers.
• PivotTable formulas.
• Creating validation rules.
• Input messages and error alerts.
• Using INDIRECT in data validation.
• Goal Seek for back-calculation.
• Data Tables for scenario comparison.
• Solver for optimisation tasks.
• Consolidating data across sheets.
• Using formulas for consolidation.
• Linking workbooks and repairing broken links.
• REPLACE, SUBSTITUTE, LEN, TRIM.
• Practical exercises for cleaning text data.
Morgan is a seasoned IT trainer with over 23 years of experience in technology education and corporate training. He holds a Degree in IT & Tech Management from Universiti Teknologi Malaysia (UTM) and is a certified ITIL professional and PSMB-accredited trainer (TTT). A specialist in Microsoft Excel, Power Query, Power Pivot, Power BI, and other Microsoft Office tools, Morgan is known for translating complex functions into practical, real-world solutions. He has trained professionals across sectors including government, education, banking, and energy, with clients such as Bank Negara Malaysia, Tenaga Nasional, the Prime Minister’s Office, and Sime Tyres. Morgan’s sessions are hands-on, results-oriented, and designed to equip participants with time-saving strategies for managing, analysing, and automating data tasks with ease.
Unit T1-L16-1, Level 16, Tower 1, PJ 33 No. 3, Jalan Professor Khoo Kay Kim,Seksyen 13, 46200 Petaling Jaya, Selangor, Malaysia.
© Copyright Malaysian Institute of Management 2025. All Rights Reserved
