Course

Learning Lab - Microsoft Excel: Top Essential Functions

  • Date: 02/10/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
Which of the nearly 500 Excel functions are likely to be most valuable to you to build formulas, analyze procurement data, extract key information, and to use your worksheets more effectively? Join us as we explore Excel's top essential functions, learning how you can provide value-driven growth to your entity through superior data management.
Pricing:
PriceCostBeginsEnds
Member$79.00 02/10/2021
Non-Member$179.00 02/10/2021
Member $79.00
Non-Member $179.00
Spots available: 65

Objectives

By the end of this Lab, learners will be able to:
 
1.  Understand absolute and relative references and create named ranges
2.  Improve data analysis with logical functions including IF, SUMIF, AVERAGEIF
3.  Look up values with VLOOKUP and XLOOKUP
4.  Work with date and text functions

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: Top Essential Functions

Similar Courses