Learning Lab - Microsoft Excel: How to Save Countless Hours with Excel PivotTables

  • Date: 03/03/2021
  • Start Time: 2:00 PM Eastern Time
  • End Time: 4:00 PM Eastern Time
  • Instructor: Ms. Dawn Bjork, MCT
    Owner/Software Trainer
    Ms. Dawn Bjork, MCT
    With over 25 years' experience as a tech translator and problem solver, Dawn Bjork is The Software Pro®. Dawn shares smart and easy ways to save you time and increase your productivity through her work as a nationally recognized technology speaker, software trainer, and computer consultant. The author of 9 books, Dawn is a Microsoft Certified Trainer and has also earned more than 30 other professional certifications including Microsoft Office Specialist Master (MOSM). Dawn is also the Past President of the Colorado chapter of the National Speakers Association.
  • Level: Foundation
  • Format: Virtual Instructor-Led
  • Contact Hours: 2
  • CEUs: 0.2
  • Recertification: Accredited
How can you answer data-related questions quickly, easily, and applicably? When your procurement projects require synthesizing large amounts of data, Excel PivotTables are often a great solution. With PivotTables, you can potentially save hours, or even days, when you need to summarize and evaluate your key data. In this session, explore the steps to quickly work with PivotTables to manage and analyze complex Excel worksheets.
Member$79.00 03/03/2021
Non-Member$179.00 03/03/2021
Member $79.00
Non-Member $179.00
Spots available: 45


By the end of this Lab, learners will be able to:
1.  Create, format, and modify a PivotTable
2.  Sort, and filter a PivotTable with slicers and timelines
3.  Summarize, calculate and customize data
4.  Create a PivotChart 

Intended Audience

This offering is targeted to individuals who meet or exceed the following professional demographics:  

  • Entry-level public procurement and central warehouse professionals who serve as assistants, coordinators, buyers, or equivalent functions within their respective entities.   

  • Non-procurement managers and supervisors who are responsible for either the procurement function or staff who provide procurement functions under delegated authority.   

  • Professionals who are employed by governing entities and special authorities (such as K-12 and higher education, publicly-owned utilities, transportation providers, and other publicly-funded or created organizations) that either serve within or manage the procurement function.  

  • Suppliers or representatives of suppliers seeking to understand the public procurement function from a holistic level, including the policies, standards, and procedures by which public entities must function.  


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


Cancellation Policy

Registration and payment must be received 24 hours prior to the course start date. After this time, registrations will be based on space availability.  A full refund, less a $75 administrative fee will be given for cancellations made in writing 31+ days prior to the seminar date by emailing No refunds are given for cancellations received within 24 hours of the seminar start date. There are no refunds for no-shows. If the seminar is cancelled for any reason, NIGP's liability is limited to the registration fee only.  

Attendee substitutions within the same agency may be done at any time with email notification to NIGP. If attending via scholarship, please provide documentation verifying the scholarship issuer's name and contact information in lieu of payment information. 

Register Today

Learning Lab - Microsoft Excel: How to Save Countless Hours with Excel PivotTables

Similar Courses