Title

Excel for Procurement Professionals

Section
Efficio Academy
Summary
Date
3 Feb 2022 - None
Time
3 p.m. - None

These courses aim to take individuals with various experience levels using Excel and teach them the tips, tools and techniques needed as a Procurement Professional.

Course content

  • Introduction to Excel: This module is aimed at users with little experience
  • The Basics: Covers tables, formatting and more complex formula and is aimed at beginners with some experience
  • Taking Formulae Further: Introduces more formulae and Pivot Tables for intermediate users
  • Complex Excel Formulae: Introduces complex formulae and useful tools for advanced users of Excel

Learning objectives

  1. Introduction to Excel:
    1. How to navigate Excel efficiently and know useful shortcuts
    2. How to use SUM, COUNT and AVERAGE
  2. The Basics: 
    1. How to format datasets as tables
    2. How to use TEXTJOIN, CONCAT, IFERROR, SUBTOTAL
    3.  Understand how referencing is used in formulae
  3. Taking Formulae Further: 
    1. How to use VLOOKUP, IF, IFS, SUMIF and COUNTIF
    2. Understand the logic of pivot tables and create basic analyses
  4. Complex Excel Formulae:
    1. How to use INDEX MATCH as an alternative to VLOOKUP
    2. How to use Conditional Formatting and Data Validation