A 2-hour self-paced course that lifts you from basic Excel user to confident intermediate. Focus on data analysis, formula automation, interactive reports with slicers and timelines, and bringing AI productivity into Excel.
18 lessons3 minutes total
Watch a free preview
Get a feel for the teaching style before you enrol.
Syllabus
Everything you'll get at a glance — outcomes, prerequisites, audience, and modules.
✓
What you'll learn
By the end of this course, you'll be able to:
✓Apply intermediate formulas (logical, conditional, date and text functions) to real workplace problems
✓Manage and clean data with Tables, Remove Duplicates, Text to Columns and Consolidate
✓Combine datasets using VLOOKUP, XLOOKUP and INDEX/MATCH
✓Build dynamic PivotTables and PivotCharts, with slicers and timelines for interactive dashboards
✓Apply advanced data validation and conditional formatting to build a smart task tracker
✓Run What-If Analysis (Goal Seek, Scenario Manager, Data Table) to support forecasting and decisions
✓Use AI tools (Copilot / ChatGPT / Claude) to speed up your Excel work
📋
Prerequisites
◆Completed the Beginner course or have equivalent hands-on experience
◆Comfortable with basic formulas (SUM, AVERAGE) and cell references
◆Able to navigate Excel and apply basic formatting independently
•
Who this is for
•Executives, supervisors, finance and administrative staff
•Human resources professionals
•Everyday Excel users wanting stronger data analysis, reporting and AI skills
•
Topics covered
Module 1 — Smart Data Management & Cleansing
•1.1 Excel Tables (Ctrl + T) — the foundation of data analysis
•1.2 Structured references — tbl[Salary] beats D2 every time
•1.3 Remove Duplicates — build a clean dataset
•1.4 Text to Columns — split names, addresses & IDs
•1.5 Consolidate — combine multiple sheets into one
•1.6 Hands-on: Clean messy sales data — a 7-step workflow
•6.5 Scenario Manager in action — 3 sales-target scenarios
•Part C: Data Tables
•6.6 One-variable Data Table — interest-rate sensitivity
•6.7 Two-variable Data Table — rate × tenure matrix
•6.8 Hands-on: Integrated financial analysis — all 3 tools combined
•6.9 Recap + quiz
Module 7 — AI for Excel Productivity
•Part A: Bringing AI and Excel together
•7.1 AI + Excel concept — the 3 AI assistants (Copilot / ChatGPT / Claude)
•7.2 AI vs traditional Excel — when to use which
•7.3 The 3-part prompt formula — the gold standard for AI prompts
•Part B: AI in practice
•7.4 AI writes formulas — plain English to Excel formula
•7.5 AI explains formulas — taking over someone else's file
•7.6 AI generates sample data + cleans messy data
•7.7 AI writes management commentary + translation
•7.8 Hands-on: Malaysian working-day formula (AI prompt walkthrough)
•7.9 Recap + quiz
Terms & Conditions
Version: 2026-05-31
By enrolling in any course on Clara Excel Academy, you agree to the following terms. Please read them carefully before purchasing.
1. Payment & Refund Policy
All course purchases are non-refundable once payment has been completed. This includes single courses and bundles.
By proceeding with payment, you acknowledge that you have reviewed the course outline and preview videos and are satisfied with what you are buying.
If you experience a genuine technical issue that prevents access (e.g. video won't load, locked account), please WhatsApp Clara at +60 11-6189 8230 — we'll always help, but this is support, not a refund window.
HitPay handles all payment processing securely. Clara Excel Academy does not store your credit card or bank details.
2. Course Access
You receive lifetime access to the course content you have purchased.
Access is granted to one individual account — sharing your login with another person is a violation of these terms.
Clara Excel Academy reserves the right to revoke access if account sharing, reselling, or abuse is detected.
3. Intellectual Property & Copyright
All course videos, PDF notes, Excel exercise files, slide decks, and certificates remain the exclusive property of Clara Excel Academy.
You may download materials for your own personal learning and reference only.
You may NOT redistribute, resell, sublicense, upload to other websites, or share course materials with any third party.
Recording, screenshotting, or transcribing course content for distribution is strictly prohibited.
Unauthorized use is a copyright violation and may result in legal action.
4. Certificates
Certificates are issued automatically after passing the course exam at 80% or above.
Certificates are personal to the student named on them and are not transferable.
Please download your certificate within 30 days of issue — due to storage limits, certificates may be removed from our servers after this period. WhatsApp Clara if you miss the window and need a reissue.
Misrepresenting a certificate (e.g. listing one on LinkedIn for a course you did not actually pass) is grounds for revocation.
5. Community Conduct
Be respectful to Clara and your classmates in lesson comments, WhatsApp groups, and any other community space.
Spam, advertising, harassment, or off-topic content may be removed at the moderators' discretion. Repeat violations may result in account suspension.
6. Changes to These Terms
Clara Excel Academy may update these terms from time to time. The current version is shown at the top of this page.
Material changes will be communicated by email and on the website. Continued use after a change implies acceptance of the new terms.