Camp Fire Academy
Learning path
UI/UX Design Foundations UI/UX Design Intermediate Advanced UX Strategy
Specialisations
Fintech & Banking UI/UX AI-Powered UI/UX UX for Leaders Design Thinking
Most requested
AI for Workplace Productivity Excel for Business Power BI & Business Intelligence Cybersecurity Awareness PDPA Compliance Data Protection Officer Browse the full catalogue →
For teams
Corporate & In-House Training LMS & Self-Paced Learning Events Verify a Certificate
Company
About Contact WhatsApp

Data Analysis and Dashboard Reporting with Excel

This programme focuses on using Excel for serious business analysis and reporting. Participants learn to clean data, apply advanced formulas, and build dashboards that management can use without needing dedicated BI tools.

Modules

Working with Business Data
Importing, organising, and validating data from different sources. Identifying and fixing data quality issues before analysis.

Advanced Formulas for Analysis
XLOOKUP, INDEX/MATCH, dynamic array functions (FILTER, SORT, UNIQUE), and nested IF logic for complex business calculations.

Data Cleaning Techniques
Removing duplicates, handling blanks, fixing text formatting, and standardising inconsistent entries across large datasets.

PivotTable Analysis
Group, summarise, and slice data using PivotTables. Use calculated fields and groupings to produce custom business metrics.

Building Interactive Dashboards
Combine charts, slicers, and PivotTables into a clean one-page dashboard that stakeholders can filter themselves.

Conditional Formatting for Insight
Highlight trends, exceptions, and KPI status automatically using rules, data bars, and colour scales.

Presenting Data Clearly
Design principles for business charts, including what to show, what to remove, and how to guide a reader's attention without distortion.

Final Activity

Management Dashboard Build. Participants build a complete management dashboard from a raw dataset, covering data cleaning, analysis, and a formatted one-page summary report.

Key Outcomes:
Clean and structure raw data for accurate analysis
Use advanced Excel formulas to produce meaningful metrics
Build dashboards that management can filter and use independently
Present data clearly without overcomplicating visuals
Work through analysis problems with a structured approach
Reduce time spent on manual reporting each cycle

Fee: RM 2,000 per day
Minimum enrolment: 1 participant
Duration: 2 Days
Level: Intermediate (basic Excel knowledge assumed)
HRD Corp Claimable
Certificate included

Frequently Asked Questions

RM 2,000 per day.

Participants should be comfortable with basic formulas and navigation. This is not a beginner course.

Yes. This course is more focused on analytical thinking, advanced formulas, and dashboard design rather than general Excel skills.

Yes, this programme is HRD Corp claimable.

Yes, for in-house sessions we can incorporate real datasets from your business context.

Yes.

In-person or online. In-house delivery is available.

Up to 20 participants per session to maintain quality of hands-on work.

Yes. Any programme can be booked as a team day. Everyone works the same brief together, so your people come away having built something and knowing each other better.

If you are claiming under HRD Corp, the session has to fall at least 14 days after your HRD Corp approval. If you are not claiming, the date is flexible and we work around your calendar.

At your own office or venue, online, or at our training space in Cyberjaya. It can also be delivered entirely through our LMS as self-paced e-learning.

Put them on the self-paced e-learning instead. Your team works through the modules on our LMS in their own time, sits the assessment, and earns the same certificate, so nobody has to clear a full day together.