Learning Lab - Microsoft Excel: Top Essential Functions

Start Date:
End Date:
Start Time:
End Time:
(GMT-05:00) Eastern Time (US & Canada)
Online Learning
Contact Hours:
Access Period:
Hosted By:

  1. Overview

    Designed to promote action-ready experiences without the need for travel, NIGP’s Learning Labs series provides learners with best practice guidance on a variety of technical and hard skills, needed for public procurement success. Tackling software, business operations, finance, and value-driven propositions, Learning Labs empowers attendees with exercise and case-study driven works, helping you learn the skills needed for success and advancement all from the comfort of your desk or at home.
    Program Highlights:
    • Earn 2 Contact Hours and .2 CEUs per workshop.
    • 90-120 minutes in time, featuring 30 participants max to provide hands-on practice.
    • Curated content based on public procurement entities across North America.
    • Interactive learning experiences, including individual, partner, and group work exercise with immediate feedback.
    • Job aids and resources to take back to your own entity.
    • Products available OnDemand upon completion of the set for re-watching at your leisure.


    Microsoft Excel: Top Essential Functions
    Which of the over 400 Excel functions are likely to be most valuable to you to build formulas, analyze procurement
    data, extract key information, and to more effectively use your worksheets? While many public procurement professionals might be familiar with some of the elements that make Excel a critical software in any office, there are hundreds of functions and capabilities that can help you address concerns you didn’t even know you have. Join us as we explore the top essential functions in the Excel program, learning how you can provide value-driven growth to your entity through superior data management.
    • Reviewing function basics; SUM, AVERAGE, MAX, MIN
    • Summarizing with COUNT functions
    • Adding ROUND functions for accurate results
    • Creating named ranges to simplify formulas
    • Applying data analysis functions including IF and VLOOKUP
    • Evaluating vendor data with RANK
    • Extracting and cleaning up data with DATE and TEXT functions

  • Member - $79.99

    Non-Member - $129.99


    Registration is limited to 30 attendees and will be accepted on a first come - first served basis. 

    Registration and payment must be received one business day prior to the online course start date.  

    Register online with credit card by clicking the register button below.


    Methods of Payment Accepted: Check (make checks payable to “NIGP”) and Credit Cards (Master Card, Visa, and American Express).


  • For questions, please contact us at registrationinfo@nigp.org
    No refunds are given for cancellations received within 30 days of the start date. There are no refunds for no-shows.
    If the online course is cancelled for any reason, NIGP's liability is limited to the registration fee only.