BEE Level 1 Accredited

Advanced Microsoft Excel (1 Day)

Unlock Advanced Excel for Supply Chain Reporting

Exploring Advanced Excel in your analysis and reporting in the context of Supply Chain Management
20 – 20 Aug 2026
1 day
Online

Why Choose this course

Sustainable development training for Microsoft Excel users to improve the individual’s skills in applications and development of advanced mechanisms.

It is assumed that delegates have background training and experience with Basic Microsoft Excel.

The Excellence Series is designed to equip all employees, including managers and directors at relevant levels of competence, with the skills to function optimally, producing significant time savings and professional reports.

Advanced Microsoft Excel training course Commerce Edge

What did other people say?

What does this course cover?

  • Advanced Excel functionalities in Microsoft Excel 2016
  • Rapid business reporting using formulae and functions
  • Perform advanced manipulation on worksheets
  • Customise your Excel workspace extensively for advanced functionality and standardisation
  • Conduct analysis and reporting using advanced loop-ups, functions and formulae
  • Data analysis using Pivot Tables and Pivot Charts - skills to enhance strategic decision-making
  • Managing Data lists and Macros to effectively manage data at lower cost
  • Mine massive external data tables (4,5-million lines demonstrated)
  • Create and run macros
  • Use basic code (no code writing skills required)
  • Address real internal case studies in your own environment

Is this course for me?

Career roles we recommend this course for

  • Managers
  • Department Directors
  • Procurement and Supply Chain Managers
  • Chief Procurement Officers
  • Supplier Relationship Managers
  • Cross-functional team members
  • Commercial Specialists
  • Contract Managers
  • Sourcing Managers
  • Commodity Managers
  • Category Managers
  • Supply chain Analysts
  • Buyers (Junior to Senior)

Your course facilitator

Commerce Edge

Commerce Edge

Commerce Edge has been a leading provider of World Class Procurement and Supply Chain training since 2001. We have trained hundreds of public and private sector organisations and over 10,000 individuals on various aspects of World Class Procurement, Logistics, Operations and Planning in the context of the wider Supply Chain.

Other courses you may be interested in

Risk management in procurement training course Commerce Edge

Risk Management in Procurement Training Course (1 Day)

Unsolicited proposals training course Commerce Edge

Unsolicited Proposals Training Course

Negotiations in public sector procurement training course Commerce Edge

Effective Negotiations in Public Sector Procurement Training Course

Advanced Bid Evaluation Committee workshop Commerce Edge

Advanced Bid Evaluation Committee (BEC) 1-Day Workshop

PFMA and MFMA deviations workshop Commerce Edge

Deviations in Public Procurement (PFMA/MFMA) – 1 Day Workshop

Categories

Enquire for more information

Didn’t find what you were looking for? We have many more courses available. Enquire for our full course prospectus.


Please indicate which sector you work in:

Keep me updated with upcoming Events & World Class News

* These fields are required.