Log in
Log in

Build Self-Updating Dashboards with Excel Power Query and Power Pivot (Online Workshop)

  • 09/20/2024
  • 2:15 PM - 3:45 PM
  • Zoom
  • 17



Build Self-Updating Dashboards with Excel Power Query and Power Pivot

H-PEA Online Post-Conference Workshop
Sept. 20, 2024 2:15- 3:45 pm HST

Dr. Yao Hill, University of Hawai'i at Mānoa

Workshop Description

Are you a program evaluation or assessment professional who frequently handles recurring data? Tired of the time-consuming and error-prone processes of data analysis and visualization? Join this 90-minute hands-on workshop and discover how Excel's Power Query and Power Pivot can revolutionize your workflow.

Workshop Requirements

  • Participants should have Excel 2010 or later installed.
  • Familiarity with Excel pivot tables is necessary.
  • The demonstration will be conducted using Microsoft Excel 365.

In this workshop, you will learn to:

  • Efficiently clean and transform your data.
  • Seamlessly merge multiple data sources.
  • Generate tables and create dynamic dashboards that update automatically with new data.

By using these tools, you'll save valuable time, allowing you to focus on collaborative data interpretation and stakeholder engagement. Through step-by-step guidance, you will gain practical skills to apply immediately.

Dr. Yao Hill is a specialist in the Assessment and Curriculum Support Center at the University of Hawai‘i at Mānoa. She has 15 years of experience providing resources, consultations, and training on learning assessment techniques and approaches to faculty in higher education and fellow program evaluators.

Contact Us

Hawai'i-Pacific Evaluation Association

P.O. Box 283232, Honolulu, HI 96828

H-PEA is a tax-exempt charitable organization under Section 501(c)(3) of the Internal Revenue Code and is eligible to receive tax-deductible contributions.

Copyright 2021 - Hawai'i-Pacific Evaluation Association

Powered by Wild Apricot Membership Software