Skip to content
2026/2027 in-house training dates are now open.Request a proposal →
Digital & AI training

Excel for Corporate Professionals (Intermediate)

Transforming Excel skills into business productivity

This two-day Intermediate level takes participants into the formulas and tools that make Excel faster and more reliable: IF and nested IF, XLOOKUP, INDEX & MATCH, SUMIFS and COUNTIFS, advanced conditional formatting, PivotTables and PivotCharts. Everything is practised on realistic business cases with fictional company data, and the programme ends with a final project: an AP/AR ageing dashboard.

2 days
Excel for Corporate Professionals (Intermediate) corporate training session

Learning outcomes

  • Write formulas that make decisions with IF and nested IF.
  • Build lookups with XLOOKUP and INDEX & MATCH that keep working when the data changes.
  • Summarise data by several criteria with SUMIFS and COUNTIFS.
  • Highlight exceptions and trends with advanced conditional formatting.
  • Analyse large datasets with PivotTables and PivotCharts.

Course outline

  1. 1

    ADVANCED EXCEL FORMULAS

    • • Write formulas that do more of the work.
  2. 2

    XLOOKUP

    • • Look up data in any direction.
  3. 3

    INDEX & MATCH

    • • Flexible lookups for any layout.
  4. 4

    SUMIFS & COUNTIFS

    • • Totals and counts by several criteria.
  5. 5

    ADVANCED CONDITIONAL FORMATTING

    • • Let the sheet point out what matters.
  6. 6

    PIVOT TABLES

    • • Summarise large datasets in minutes.
  7. 7

    PIVOT CHARTS

    • • Turn summaries into charts.

Quick facts

How long is the programme?
2 days. The schedule can be adjusted, for example split into half-day sessions, to suit your operations.
Who should attend?
Executives, Finance Staff, Analysts, Managers.
Where is it held?
In-house at your premises, at an external venue or hotel of your choice, or virtually, anywhere in Malaysia including Kuala Lumpur, Selangor, Penang and Johor.
Can the content be customised?
Yes. We tailor examples, case studies and activities to your industry, KPIs and company values while keeping the programme's learning outcomes.

Related programmes