Course

Learning Labs

Hands-On Workshops

An educational series that provides learners with best practice guidance on a variety of technical and hard skills needed for public procurement success.

Course Availability:

View upcoming dates for this course.

December 6, 2022
Learning Lab 6 120622: Post Evaluation Steps and RFP Misfits (Member) $159.00
Learning Lab 6 120622: Post Evaluation Steps and RFP Misfits (Non-Member) $259.00
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
February 1, 2023
Learning Lab: Microsoft Excel: Linking & Sharing Data (Member) $85.00
Learning Lab: Microsoft Excel: Linking & Sharing Data (Non-Member) $185.00
(prices valid until Jan 31, 2023)
Time: 2:00 PM - 4:00 PM Eastern Time
Instructor: Ms. Dawn Bjork, MCT
Level: Foundation
Virtual Instructor-Led
February 22, 2023
Learning Lab: Microsoft Excel: How to Visually Communicate Data with Charts and Graphics (Member) $85.00
Learning Lab: Microsoft Excel: How to Visually Communicate Data with Charts and Graphics (Non-member) $185.00
(prices valid until Feb 21, 2023)
Time: 2:00 PM - 4:00 PM Eastern Time
Instructor: Ms. Dawn Bjork, MCT
Level: Foundation
Virtual Instructor-Led
March 28, 2023
Learning Lab: Microsoft Excel: Transforming Data with Power Query (Member) $85.00
Learning Lab: Microsoft Excel: Transforming Data with Power Query (Non-Member) $185.00
(prices valid until Mar 27, 2023)
Time: 2:00 PM - 4:00 PM Eastern Time
Instructor: Ms. Dawn Bjork, MCT
Level: Foundation
Virtual Instructor-Led
April 6, 2023
Learning Lab 1 040623: Introduction to RFPs and Starting with the End in Mind (Member) $159.00
Learning Lab 1 040623: Introduction to RFPs and Starting with the End in Mind (Non-Member) $259.00
(prices valid until Apr 5, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
April 20, 2023
Learning Lab 2 042023: Engaging with Suppliers and the Importance of Flexibility & Organization (Member) $159.00
Learning Lab 2 042023: Engaging with Suppliers and the Importance of Flexibility & Organization (Non-Member) $259.00
(prices valid until Apr 19, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
May 11, 2023
Learning Lab 3 051123 Responsiveness, Compliance and Responsibility and Evaluation Criteria (Member) $159.00
Learning Lab 3 051123 Responsiveness, Compliance and Responsibility and Evaluation Criteria (Non-Member) $259.00
(prices valid until May 10, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
May 18, 2023
Learning Lab 4 051823: Treasure Map for Suppliers and the Scope of Work (Member) $159.00
Learning Lab 4 051823: Treasure Map for Suppliers and the Scope of Work (Non-Member) $259.00
(prices valid until May 17, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
June 1, 2023
Learning Lab 5 060123: Evaluation Committee and Process (Member) $159.00
Learning Lab 5 060123: Evaluation Committee and Process (Non-Member) $259.00
(prices valid until May 31, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led
June 8, 2023
Learning Lab 6 060823: Post Evaluation Steps and RFP Misfits (Member) $159.00
Learning Lab 6 060823: Post Evaluation Steps and RFP Misfits (Non-Member) $259.00
(prices valid until Jun 7, 2023)
Time: 1:00 PM - 5:00 PM Eastern Time
Instructor: Online Learning
Level: Foundation
Virtual Instructor-Led

Upcoming Learning Labs


FALL 2022 RFP LEARNING LAB SERIES

4 Contact Hours | 0.4 CEUs

$159 Member |  $259 Non-Member

Post Evaluation Steps and RFP Misfits

The RFP is not over until it is over.  Issuance of a Notice of Award is not the end.  There are several post evaluation steps to be completed.  Review how the post evaluation activities can be easier if they are considered in the beginning.  Finally wrap up the full learning lab series with samples of some unconventional RFP types:  seldom used variations/elements to customize your RFP documents and evaluation methodology.  Think of them as highly specialized tools for very specific situations.

 December 6, 1:00PM - 5:00 PM (EDT)

 

Length

90 - 120 minutes

Delivery Format

Virtual Instructor-Led

Creating Excellence: Learning from Great Procurement Teams

Full Webinar Series Recordings and Handouts

2023 EXCEL LEARNING LABS SERIES

2:00 PM - 4:00 PM EST
Contact Hours: 2 | CEUs: 0.2

SPEAKER - Dawn Bjork, MCT, CSP, MOSM

Microsoft Excel: Linking & Sharing Data

Some of the most valuable and time-saving features in Excel are the choices to link and share worksheet data. Find out how to easily reference and summarize data from other worksheets, learn how to use Excel data in other programs, and look at options to protect data.

  • Linking within a workbook
  • Linking and updating across workbooks
  • Sharing Excel data with other programs (Word, PowerPoint)
  • Applying protection
  • Handling comments
  • Creating hyperlinks to other files and resources

 February 1, 2:00 - 4:00 PM EST


Microsoft Excel: How to Visually Communicate Data with Charts & Graphics

Not all of Excel is about crunching numbers. Excel is also an easy yet powerful program for creating charts and graphics. With this training, you’ll discover how to use Excel’s graphics capabilities to quickly communicate complex data in a chart and enhance your worksheets.

  • Creating, updating, and customizing a chart
  • Modifying chart formats and options
  • Building combination charts to display diverse data
  • Saving time by working with chart templates
  • Adding mini charts with Sparklines

 February 22, 2:00 - 4:00 PM EST

 

Microsoft Excel: Transforming Data with Power Query

Power Query is an Excel tool designed to help you import, clean, and consolidate data. With Power Query, you can process data from multiple sources and apply automatic actions to the data sets. In this session, explore how to transform data without wasting time on manual steps:

  • Getting started with Power Query
  • Shaping data to delete and move rows and columns
  • Building calculations
  • Performing actions on multiple worksheets
  • Combining data into one source
  • Summarizing data with PivotTables and PivotCharts

 March 28, 2:00 - 4:00 PM EST

SPRING 2023 RFP LEARNING LAB SERIES

Introduction to RFPs and Starting with the End in Mind

An introduction to Request for Proposals and how it relates to the NIGP Global Best Practice on Request for Proposals.  Learn how to select the right type of RFP for the situation, focusing on ‘Start with the End in Mind’.

 April 6, 1:00PM - 5:00 PM (EDT)


Engaging with Suppliers and the Importance of Flexibility & Organization

Engaging with Suppliers is key for public procurement professionals.  It is also important to ensure there is communication and engagement during the solicitation process.  This adds tremendous value to both the supplier and entity.  The second part will review example RFPs and discuss the importance of using templates.

 April 20, 1:00PM - 5:00 PM (EDT)


Responsiveness, Compliance and Responsibility and Evaluation Criteria

Focus on evaluation methodologies, the process, and evaluation criteria - all of which are part of determining responsiveness, compliance, and responsibility.  Proper execution of these elements will help your entity create an RFP that will identify the best Supplier.  Use of the proper criteria is critical for the successful outcome of your RFP.  Properly crafted criteria will help identify the best proposal, the best solution.

 May 11, 1:00PM - 5:00 PM (EDT)

Treasure Map for Suppliers and the Scope of Work

Ensure you have the essential information required to portray intent correctly in the RFP.  It is important to provide Suppliers a good ‘Treasure Map’ in order for them to be successful in their quest for your entities business.  A critical component of the ‘Treasure Map’ is the Scope of Work.  What is it you want the awarded Supplier to do.  Discuss Scope of Work and dissect sample scopes of work.

 May 18, 1:00PM - 5:00 PM (EDT)


Evaluation Committee and Process

Having the right members on the evaluation committee is a critical element for a successful outcome.  Learn how having the correct members provides a defensible evaluation process.  Having a well-documented process that is understood by all participants is essential.  This session will focus on the areas that are probably the most time consuming of the RFP process; managing the evaluators and the evaluation process.

 June 1, 1:00PM - 5:00 PM (EDT)


Post Evaluation Steps and RFP Misfits

The RFP is not over until it is over.  Issuance of a Notice of Award is not the end.  There are several post evaluation steps to be completed.  Review how the post evaluation activities can be easier if they are considered in the beginning.  Finally wrap up the full learning lab series with samples of some unconventional RFP types:  seldom used variations/elements to customize your RFP documents and evaluation methodology.  Think of them as highly specialized tools for very specific situations.

 June 8, 1:00PM - 5:00 PM (EDT)

Upcoming Learning Labs