Advanced Microsoft Excel Training

Training Image

Exploiting 'Advanced Excel' in your analysis and reporting in the context of Supply Chain Management.

Date:

November 6, 2017

 

Closing Date for registrations:

30 October 2017

Course Venue:

Midrand

Cost:

See more...

R 7650 excluding VAT

More Information
*
*
*
*
*

Course Objectives

Exploiting 'Advanced Excel' in your analysis and reporting in the context of Supply Chain Management.

Other date:

6 & 7 November 2017 Gauteng 

4 & 5 December 2017 Gauteng 

A 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.

 

You will learn

  • Advanced Excel functionalities in Microsoft Excel 2010., 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.

Who should attend

  • 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 Analyst, Buyers (Junior to Senior)