Course

Learning Lab - Microsoft Excel: Transforming Data with Power Query

  • Date: 03/22/2023
  • 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®. Her informative and engaging style helps you discover easy ways to be more productive with software. The author of hundreds of training programs, Dawn is a Microsoft Certified Trainer as well as a Microsoft Office Specialist Master and Certified Virtual Presenter. In addition, Dawn has earned the Certified Speaking Professional designation or CSP, a credential held by less than 850 professional speakers worldwide. Fun Fact: Dawn is the only female CSP that is also a Microsoft Certified Trainer.
  • Level: Foundation
  • Format: Virtual Instructor-Led
  • Contact Hours: 2
  • CEUs: 0.2

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

Pricing:
PriceCostBeginsEnds
Learning Lab: Microsoft Excel: Transforming Data with Power Query (Member)$85.00 03/21/2023
Learning Lab: Microsoft Excel: Transforming Data with Power Query (Non-Member)$185.00 03/21/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 21, 2023)
Spots available: 25

Objectives

  • 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

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.  


Miscellaneous

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.

Sessions

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 RegistrationInfo@nigp.org. 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: Transforming Data with Power Query