HRD Corp Claimable Microsoft Office Intermediate

Advanced Microsoft Excel for Business

Master pivot tables, dashboards, Power Query and advanced formulas to turn raw data into decisions.

Microsoft Office

Course Overview

Master pivot tables, dashboards, Power Query and advanced formulas to turn raw data into decisions. This program is designed to be practical and immediately applicable, combining expert instruction with hands-on activities, real-world scenarios and group discussion.

By the end of the course, participants will have the confidence and tools to apply what they've learned directly in their day-to-day roles.

Learning Objectives

Build dynamic dashboards with charts and slicers
Automate reporting with Power Query and functions
Apply advanced lookup and logical formulas confidently
Analyse large datasets with pivot tables

Who Should Attend

Executives, analysts, finance and admin staff who work with data daily.

Course Outline

Module 1: Data cleaning & structuring best practices
Module 2: Advanced formulas (XLOOKUP, INDEX/MATCH, dynamic arrays)
Module 3: PivotTables, PivotCharts & slicers
Module 4: Power Query for automated data prep
Module 5: Interactive dashboards & storytelling

Your Trainer

Sarah Lim

Leadership & Productivity Coach

Sarah has trained over 12,000 professionals across Southeast Asia, blending practical productivity skills with people leadership.

Frequently Asked Questions

Yes. Trainova Training Academy is a registered HRD Corp training provider, and the majority of our public and in-house programs are fully claimable under the SBL-Khas scheme. We assist you with the grant application process.

Absolutely. We deliver customised in-house training at your premises or a venue of your choice, tailored to your team’s specific goals, industry and challenges.

Yes, every participant who completes a course receives a Certificate of Completion. Certification courses such as CPR & First Aid include formal certification from the relevant awarding body.

The fee includes the full training program, comprehensive course materials, a certificate, and refreshments for face-to-face sessions. Online sessions include digital materials and recordings where applicable.