IN-STEP E.X.C.E.E.D. - Excel for Essential Productivity

2 days

HRD Corp claimable

Runs in-house for your team

Overview

This programme helps admin and office staff, executives, personal assistants, supervisors and finance, HR, sales and operations personnel use Excel to organise data, build accurate formulas and produce clear reports.

Participants spend most of their time in Excel, on workbook activities, case studies and assignments with trainer feedback. Topics run from references, tables and data validation through SUMIFS, charts, conditional formatting and XLOOKUP to a PivotTable dashboard with slicers and timelines. A final session uses Copilot to turn data into an executive summary.

Participants leave able to produce management-ready reports with less repetitive spreadsheet work.

Module topics

  • Cell, sheet and name references
  • Tables, sorting, filtering and data validation
  • Statistical and logical functions
  • Charts and conditional formatting
  • Data retrieval with XLOOKUP
  • PivotTable dashboards with slicers and timelines
  • Copilot as an AI assistant in Excel

Who runs this programme

Anne Hui San Teoh

Excel, Power Query and Copilot trainer

At a glance

2 days

In-house at your premises or a venue you choose

HRD Corp claimable

Prefer to chat? WhatsApp us on 012-600 4488.

Ask about this programme

Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.

Programme enquiry