Building smarter, interactive Excel dashboards with AI
RM1900.00
Program Overview
If you have ever spent hours copying data into a report only to redo it the next week, this program is for you. Over two days, participants will go from basic spreadsheet users to confident data storytellers — building interactive dashboards, automating repetitive tasks, and using free AI tools like ChatGPT or Gemini as a personal Excel assistant. No coding background required. Just bring your data challenges and a willingness to work smarter.
Learning Outcome
Use VLOOKUP, date functions, and AI-generated prompts to retrieve information, flag deadlines, and write formulas you never thought you could build on your own.
Turn raw, messy data into clean, professional business dashboards using PivotTables, Pivot Charts, and interactive slicers — reports that update with a click.
Put free AI tools (ChatGPT, Gemini) to work as your formula co-pilot: troubleshoot errors, brainstorm KPIs, and uncover insights you might have otherwise missed.
Walk away with a working dashboard and the confidence to keep improving it — no waiting for the IT team.
Duration
2-Full Day | 16 hours (include 1 hour lunch break each day)
Delivery | Methodology
Face to Face | Hands-on practical
Target Industry | Audience
All Industries | Executives, Engineers, Analysts, Team Leads, and any professional involved in knowledge work, reporting, communication, or technical tasks
Course Level
Beginner to Intermediate
Pre-requisites
Basic computer literacy and familiarity with data entry in Excel (no advanced skills required)