Excel Smarter, Not Harder: Harnessing AI in Excel

Course Information
-
Overview
-
Learning Outcomes
-
Who Should Attend
-
Testimonials
-
Trainer's Profile
-
Course Outline
Unlock next-level productivity in this hands-on workshop! Learn how to dominate your workflows by integrating AI tools like Microsoft Excel and ChatGPT. Walk away with game-changing skills to make smarter decisions, save time, and supercharge efficiency across your business. This isn’t just about learning. It’s about transformation.
By the end of the workshop, you will be able to:
· Increase your Productivity with AI
· Integrate AI Tools in Tandem With Excel
· Clean and Transform Data Efficiently
· Craft, Debug, and Improve Formulas With AI
· Learn to Perform Complex Data Analysis
- People eager to discover how AI can transform their Excel experience.
- Professionals striving to automate workflows and improve data analysis efficiency.
- Individuals aiming to deepen their knowledge and skills in Excel.
“This course completely changed the way I work with Excel. I never thought of using AI with Excel.”
“The workshop introduced me to innovative ways of using AI in Excel that I didn’t even know were possible.”
“As someone new to Excel, I was able to pick up many useful tips and tricks, and I’m more confident in using it now. The hands-on exercises really helped as well.”
“I feel like I have a lot more tools to be more productive now. I highly recommend this course for anyone wanting to upskill.”

Step into the future of corporate training with Aloysius Soong, where AI meets EQ. With over 8 years of experience, Aloysius empowers individuals and organisations to unlock their potential. Specialising in Gen AI, sales negotiation, and transformational leadership, he has worked extensively with both multinational corporations (MNCs) and small-to-medium enterprises (SMEs), delivering tailored training solutions that drive tangible results.
His expertise spans emerging technologies, consultative selling, and leadership development, equipping clients to navigate today’s fast-evolving business landscape. Known for his engaging and innovative approach, Aloysius weaves magic tricks into his presentations, combining cutting-edge insights with practical strategies to inspire meaningful change. His ability to connect with diverse audiences ensures every session resonates deeply, fostering growth and transformation at both individual and organisational levels.
Beyond his professional achievements, Aloysius is committed to continuous learning and staying ahead of industry trends. His forward-thinking mindset has led him to explore the intersection of AI, data analytics, and human behavior, leveraging these insights to enhance training methodologies. Whether working with global corporations or grassroots organisations, Aloysius’s dedication to excellence and passion for empowering others make him a trusted catalyst for growth. With a reputation for delivering impactful results, he is an invaluable partner in driving success.
Leveraging AI Tools in Excel
- Utilizing Flash Fill, TextJoin, and Concatenante for quick data manipulation
- Harnessing Power Query
How to Start Integrating ChatGPT with Excel
- What is ChatGPT
- How to get ChatGPT
- Differences between ChatGPT 3.5 and ChatGPT 4.0
- Basic commands and functionalities.
Using ChatGPT to create Formulas in Excel
- Introduction to Prompt Engineering
- Crafting formulas
- Creating Datasets
- Creating tables with ChatGPT
Unlocking Complex Formulas with ChatGPT
- Writing advanced formulas with Chatgpt
- Using ChatGPT to explain formulas
- Improving existing formulas
- Formular debugging and fixing
Cleaning Up Data
- Transforming data from PDFs
- Transforming data from images
- Transforming data from existing sheets
Advanced Data Analysis Techniques with ChatGPT
- Leveraging AI for complex data analysis.
- Using AI to generate insights from datasets.
Task Automation with AI Tools
- Using AI to create macros
- Creating Dashboards using AI
Course Review and Q&A
- Recap of key concepts covered in the workshop.
- Open floor for questions and further clarification.
