Advanced Microsoft Excel

Training Image

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

Date:

July 23, 2020 -

 

Closing Date for registrations:

16 July

Course Venue:

BrainsOn Training Hub, Midrand

Cost:

See more...

R 8900 excluding VAT

More Information
*
*
*
*
*
I want to receive training newsletters and procurement updates

Course Objectives

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

Other dates:

23-24 July: Virtual class

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

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)

UPCOMING EVENTS

Preferential Procurement (B-BBEE)
Next Date: 8 Jul 2020
Risk Management in Procurement
Next Date: 8 Jul 2020
Strategic Sourcing and Category Management
Next Date: 9 Jul 2020
Managing Total Cost of Ownership
Next Date: 10 Jul 2020
Practical Procurement
Next Date: 13 Jul 2020
Procurement Analytics
Next Date: 13 Jul 2020
Critical Negotiation Skills for the Procurement Professional
Next Date: 16 Jul 2020
Developing Effective and Compliant Bid Specifications
Next Date: 16 Jul 2020
Enterprise and Supplier Development for Procurement Professionals
Next Date: 20 Jul 2020
Developing and Managing Contracts and SLA's
Next Date: 22 Jul 2020
Advanced Microsoft Excel
Next Date: 23 Jul 2020
Ethics in Procurement and Supply Chain Management
Next Date: 24 Jul 2020
Fundamentals of Stores and Stock Control
Next Date: 27 Jul 2020
Project Management for Procurement Professionals
Next Date: 29 Jul 2020
Implementing the Three Bid Committees
Next Date: 29 Jul 2020
Negotiation Skills for Procurement Professionals
Next Date: 5 Aug 2020
Introduction to Supplier Relationship Management
Next Date: 11 Aug 2020
Preventing Fraud and Corruption in the Public Sector
Next Date: 12 Aug 2020
Tender Specification Writing in Procurement
Next Date: 20 Aug 2020
Supervisory Skills for Procurement Managers
Next Date: 24 Aug 2020
Public Sector Supply Chain Management
Next Date: 24 Aug 2020
SAP Procurement Performance Optimisation
Next Date: 26 Aug 2020
Communication Intelligence for Procurement Professionals
Next Date: 27 Aug 2020
Legal Aspects in Purchasing and Supply Management
Next Date: 27 Aug 2020
Deviations from Open Competitive Bidding
Next Date: 8 Sep 2020
Effective Tendering and Supplier Management
Next Date: 14 Sep 2020
Finance for Procurement Professionals
Next Date: 21 Sep 2020
Value Analysis/Value Engineering for Supply Chain Professionals
Next Date: 14 Oct 2020