Microsoft Excel Training

Microsoft Excel — Basic to Intermediate

Build a confident working foundation in Excel — from clean data entry and formatting through formulas, functions and pivot tables that turn raw spreadsheets into usable reports.

Enquire on WhatsApp

Topics

What this course covers

Formulas, functions and cell referencing

Sorting, filtering and data validation

PivotTables and summary reporting

Charts and presentation-ready formatting

What You'll Learn

After This Course, You'll Be Able To

Build and audit formulas confidently, using correct relative and absolute cell referencing

Clean, sort, filter and validate real-world spreadsheet data

Summarise large datasets quickly with PivotTables and PivotCharts

Produce polished, presentation-ready charts and print-ready reports

Course Curriculum

From Clean Data to Confident Reports

A practical, hands-on curriculum that builds from clean data entry through to formulas, PivotTables and presentation-ready reports.

Excel Foundations & Clean Data Entry

Start every workbook on solid ground — a well-structured, error-resistant worksheet.

Worksheet navigation, formatting basics and building a clean, well-structured worksheet
Data types, number formatting and consistent input for reliable calculations
Freeze panes, cell styles and keyboard shortcuts for a faster workflow
Common data-entry mistakes that break formulas later, and how to avoid them

Formulas, Functions & Cell Referencing

The core formula skills that everything else in Excel is built on.

Relative vs absolute cell referencing ($ locking) and why it matters
Core formula families: SUM, AVERAGE, COUNTIF and IF logic
TEXT functions and simple lookups with VLOOKUP
Troubleshooting common formula errors (#REF!, #VALUE!, #N/A)

Sorting, Filtering & Data Validation

Keep large, messy datasets under control and catch bad data before it spreads.

Single and multi-level sorting for large datasets
AutoFilter and custom filter criteria
Data validation rules — dropdown lists, input restrictions and alerts
Conditional formatting to flag outliers and trends at a glance

PivotTables & Summary Reporting

Turn a raw data range into a live, re-arrangeable summary report.

Building a PivotTable from a raw data range
Grouping, summarising and slicing data by category, date and value
PivotCharts and slicers for interactive summaries
Refreshing and maintaining PivotTables as source data changes

Charts & Presentation-Ready Formatting

Package your analysis into a report that is ready to share.

Choosing the right chart type for the story your data tells
Formatting charts, axes and labels for a professional report
Print setup — page layout, headers/footers and print areas
Preparing a finished workbook for sharing or presentation

Who Should Attend

Built For You

Admin & Support Staff

Build and maintain the day-to-day spreadsheets, trackers and reports your role runs on, with fewer manual mistakes.

Executives New to Structured Excel

Move from ad-hoc typing and copy-pasting to formulas, validated data entry and reports you can trust.

Finance & Operations Staff

Turn raw exports into reliable summary reports using PivotTables, without rebuilding them from scratch each time.

About HRD Corp claims

AISynergy's training programmes are designed to be claimable under the HRD Corp SBL-Khas scheme for registered Malaysian employers. We'll confirm this course's specific claim documentation and schedule when you enquire.

In the Room