Clara Excel Academy · HRDC-Accredited · Malaysia

Clara Tan Chai Fang

Hands-on Microsoft Excel, AI & Agentic AI training that turns spreadsheets and workflows into a competitive advantage.

  • Microsoft Excel
  • Google Sheets
  • Generative AI
  • Agentic AI
3,000+ Participants Trained
100+ Malaysian Companies
10+ Years Experience
Clara Tan Chai Fang, HRDC-accredited Excel and AI trainer
HRDC Accredited

Specialisation 01

Microsoft Excel

All levels — Beginner · Intermediate · Advanced

From formulas and PivotTables to VLOOKUP, Power Query, VBA and Excel + AI. The deepest part of Clara's catalogue — hands-on with real Malaysian business data.

  • Beginner · Intermediate · Advanced
  • VLOOKUP, XLOOKUP, INDEX/MATCH
  • PivotTables & dashboards
  • Power Query & VBA macros
  • Excel + AI with Copilot
See Excel courses →

Specialisation 02

Google Sheets

All levels — from foundations to power user

Cloud-based, collaborative spreadsheets that go beyond Excel: QUERY, IMPORTRANGE, ARRAYFORMULA and Apps Script automation built right into your team's daily workflow.

  • Sheets foundations to advanced
  • QUERY, IMPORTRANGE, ARRAYFORMULA
  • Live collaboration & version control
  • Apps Script automation
  • Forms & data collection
See Google Sheets courses →

Specialisation 03

Generative AI Training

All levels — office, finance & HR use-cases

Practical training across ChatGPT, Claude, Gemini, NotebookLM, Perplexity and Google AI Studio — for office workflows, finance extraction, HR shortlisting and more.

  • ChatGPT · Claude · Gemini
  • Google AI Studio & NotebookLM
  • Perplexity for research
  • Finance: invoice & receipt AI
  • HR: resume extraction
See AI courses →
New for 2026

Specialisation 04

Agentic AI with n8n

Intermediate — build real business agents

The next leap: AI agents that plan and execute multi-step work. Build agents on n8n that read inboxes, update spreadsheets, draft reports and trigger workflows — all under your team's control.

  • What is agentic AI?
  • Single-agent vs multi-agent
  • Tool use & function calling
  • Building agents with n8n
  • Safety, oversight & cost
See Agentic AI course →

Tools You'll Master

The apps Clara teaches in her training.

Every course is grounded in the real software your team uses every day — not toy demos. Clara delivers hands-on training across spreadsheets, AI assistants, and workflow automation tools.

About

A trainer who actually trains.

  • Microsoft Excel Expert Trainer
  • AI-Certified Trainer (Workplace & Data Productivity)
  • Gemini-Certified Trainer
  • HRDC-Accredited Trainer (TTT-certified)
  • Course Speaker — UUM K-12 Youth Program
  • Trained 3,000+ participants across 100+ training programs
  • Specialised in Excel, Automation, Dashboards & AI
  • Fluent in English, Bahasa Malaysia & Chinese — trains in all three

Certifications & Accreditation

Services

How Clara can help your team.

📊

Corporate In-House Training

Customised 1–3 day workshops delivered at your office or online. Course material is rebuilt around your actual data and use cases.

🏛️

Public HRDC Courses

HRDC-claimable open enrolment courses in KL and Selangor. Send 1–10 participants without committing to a full in-house cohort.

🤖

AI & Copilot Training

Practical AI workshops for non-technical teams — ChatGPT, Microsoft Copilot, Gemini — focused on real office workflows, not toy demos.

🛠️

Agentic AI Workshops

Hands-on building of AI agents that read, write, and act across email, Excel and your line-of-business tools — with safety guardrails baked in.

Courses

Most-requested Excel & AI topics.

Every course is HRDC-claimable, customisable to your team's level, and delivered with Malaysian business context. Click any module to see the full syllabus, who it's for and what you'll walk away able to do.

Excel · Beginner

Microsoft Excel — Beginner

2 days · New to Excel

For office staff who use Excel daily for data entry and want to gain real speed and confidence.

What you'll learn

  • Excel interface, ribbon and navigation
  • “Tekan-Tarik-Tarik” range-selection mnemonic
  • Core formulas: SUM, AVERAGE, COUNT, IF, ROUND
  • Cell formatting, borders, conditional formatting
  • Sorting, filtering, freeze panes, AutoFill
  • Charts: column, line, pie — when to use which
  • Printing layouts, headers/footers, page setup

You'll leave able to: confidently navigate Excel and build clean, formatted spreadsheets without asking for help.

Excel · Intermediate

Microsoft Excel — Intermediate

2 days · Comfortable with basics

For users ready to manage real datasets, build summary reports and stop doing repetitive work.

What you'll learn

  • Advanced logic: IF, AND, OR, IFS, nested formulas
  • SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS
  • VLOOKUP, XLOOKUP and INDEX/MATCH cross-sheet lookups
  • Named ranges and structured references
  • PivotTables and PivotCharts from scratch
  • Data validation, dropdown lists, dependent lists
  • Conditional formatting with formulas, sparklines, data bars
  • Importing CSV/text and cleaning data

You'll leave able to: build reusable templates and analyse datasets like a power user.

Excel · Advanced

Microsoft Excel — Advanced

2 days · Power user level

For analysts and managers handling large datasets, automation and complex modelling.

What you'll learn

  • Power Query: get, transform, merge, refresh
  • Power Pivot and the Excel Data Model
  • DAX fundamentals for measures and KPIs
  • VBA macros: recording, modifying, buttons, triggers
  • What-If: Scenario Manager, Goal Seek, Data Tables
  • Dynamic arrays: FILTER, SORT, UNIQUE, SEQUENCE, LAMBDA
  • Financial functions: NPV, IRR, PMT, FV
  • Interactive dashboards with slicers and form controls

You'll leave able to: automate repetitive work and build executive-ready dashboards from raw exports.

Excel + AI

Excel with AI

1 day · Intermediate

Use AI assistants to cut Excel work in half — write formulas faster, analyse data smarter and build reports with less effort.

What you'll learn

  • Microsoft Copilot inside Excel — what it does and doesn't do
  • ChatGPT for formula generation, debugging and explanations
  • Claude for spreadsheet analysis and data summaries
  • AI-powered data cleaning and reformatting prompts
  • Generating charts and pivot summaries through AI
  • Privacy & data-handling best practice (what NOT to paste)

You'll leave able to: hand off the tedious Excel work to AI and focus on the analysis.

AI · All Levels

AI in Workplace Productivity

1 day · All levels

For anyone who wants AI to handle the routine office work — emails, minutes, research, dashboards, finance extraction, HR shortlisting, and even building small apps.

What you'll learn

  • ChatGPT for emails, replies and meeting minutes
  • Claude for long-document summaries and research
  • Google Gemini inside Docs, Sheets and Gmail
  • Google AI Studio for prototyping with Gemini
  • NotebookLM for deep research on your own documents
  • Perplexity for AI-powered web search & citations
  • Prompt design for office workflows (the “CRAFT” method)
  • Turning data into narrative reports
  • Image AI for slides, posters and social
  • AI-generated dashboards & visual summaries
  • Workflow automation across apps (Zapier / Make / n8n style)
  • Finance: receipt & invoice data extraction with AI
  • HR: resume extraction & candidate shortlisting
  • App generation with AI (no-code / low-code builders)
  • Picking the right AI for the right job

You'll leave able to: save 5–10 hours a week on routine office work and unlock real AI use-cases for finance, HR and operations.

Google Sheets

Google Sheets — Beginner to Advanced

2 days · All levels

For teams on Google Workspace and consultants who need cloud-based, collaborative spreadsheets.

What you'll learn

  • Google Sheets interface, shortcuts and tabs
  • Formulas familiar from Excel + unique ones (QUERY, IMPORTRANGE, ARRAYFORMULA, FILTER)
  • Real-time collaboration: share, comment, suggest, version history
  • Data validation, dropdown lists, protected ranges
  • Charts, dashboards and interactive filter views
  • Connecting Google Forms to Sheets
  • Importing from CSV, websites and other Sheets
  • Pivot tables and conditional formatting in Sheets

You'll leave able to: use Google Sheets from foundations to power-user techniques in a cloud-first team.

Apps Script

Google Apps Script Automation

2 days · Intermediate

For Google Sheets users who want to automate workflows with simple JavaScript — no full developer background required.

What you'll learn

  • What Apps Script is and how it powers Google Workspace
  • Recording macros in Sheets and inspecting the code
  • JavaScript basics for spreadsheets
  • Triggers: time-based, on-edit, on-form-submit
  • Sending emails from Sheets automatically
  • Connecting Sheets to Gmail, Drive, Calendar
  • Building custom menus, buttons and sidebars
  • Using AI to generate and explain Apps Script code

You'll leave able to: build automated Google Workspace workflows that run themselves on a schedule.

Canva AI · All Levels

Canva AI — All Levels

1 day · All levels

For marketers, trainers, HR teams and content creators who need professional design without hiring a designer.

What you'll learn

  • Canva interface, templates and brand kit setup
  • Magic Write — AI text generation for headlines & copy
  • Magic Design — AI-generated layouts in seconds
  • Magic Edit & Magic Eraser — AI image cleanup
  • Presentations, social posts, posters, videos
  • Bulk Create with spreadsheet data
  • Animations and transitions for engaging content
  • Exporting, sharing and brand consistency

You'll leave able to: produce branded marketing content 10× faster, with or without design experience.

Agentic AI · NEW

Agentic AI for Business

2 days · Intermediate

The next leap: AI agents that plan and execute multi-step office work under your team's control.

What you'll learn

  • What agentic AI is — and how it differs from regular AI
  • Single-agent vs multi-agent systems
  • Tool use, function calling and MCP basics
  • Building an Excel-aware agent with n8n (no-code)
  • Agents that read inboxes, draft replies, update spreadsheets
  • Safety, oversight and cost controls
  • Human-in-the-loop design patterns
  • Deploying your first business agent

You'll leave able to: deploy a real AI agent for a real workflow in your business.

Companies Trained

100+ organisations across Malaysia.

From GLCs and multinationals to family-owned SMEs and universities — Clara has delivered training across sectors including banking, energy, education, logistics, construction, manufacturing and F&B.

Want to see the full list or check if Clara has trained your industry? WhatsApp her directly.

Participant feedback

Real feedback from past participants.

Unedited screenshots from WhatsApp, email and post-training surveys. Tap any image to see the full message.

Training feedback from a Genting participant
Feedback — Genting
Training feedback from Claude (participant)
Feedback — Claude
More feedback from past Clara Excel Academy participants
More past participants
Additional feedback from past Clara Excel Academy participants
More past participants

What participants wrote on their training forms

Short notes from the "Comments / Suggestions for course improvement" section.

Get in touch

Ready to train your team?

Send Clara a quick WhatsApp with your team size, preferred dates and topic — she'll come back with a tailored proposal within one business day.

Based in
Kuala Lumpur, Malaysia
WhatsApp
+60 11-1300 3886
Email
clara@claraexcel.com
Delivery
In-house · Public · Online
Languages
English · Bahasa Malaysia · Chinese
HRDC
Fully accredited & claimable