Who Should Attend:
Any users of Microsoft Office products who would like to enhance their skills, learn expert tips, and receive advice to improve performance with their daily duties.
Related Events:
PowerPoint for Presenters, May 28-29, 2025
Excel Essentials, June 10-11, 2025
Excel Calculations and Charts, June 25-26, 2025
Excel Power Calculations, July 22-23, 2025
Excel Database and List Management, Aug. 5-6, 2025
Lean Outlook - Simplify and Get More Done, Aug. 20-21, 2025
Microsoft To Do, Sept. 18, 2025
Word for Contracts and Procedures, Oct. 15-16, 2025
Excel Conditional Formatting, Nov. 13, 2025
Overview:
This two-part course is for Excel users who regularly spend too much time manipulating data into the right format before they even begin to analyze it. Get and Transform, aka Power Query, can perform repetitive data cleansing such as deleting rows and columns, merging data from various data sources, and fixing layout issues without macros or VBA. Data source examples used in this class include Excel, comma-separated values, and text. However, the concepts taught can be applied to many different sources.
Upon successful completion of the course, you will be able to:
- Create query connections to a variety of data sources.
- Cleanse data for use in an Excel PivotTable.
- Consolidate data from multiple datasets.
A quick-reference guide will also be provided that includes highlights of the course content and additional tips. Classes will be small to ensure interactive, personalized instruction.
Note: This course is taught from a Windows perspective. Apple users are welcome to join, but not all features are available for MacOS or function the same way that will be shown in class.
Instructor:
Neal Otto, Jump-start Computer Training
Schedule:
The webinar will be held 10 a.m.-noon Pacific Time on Dec. 9-10. Attendees will be admitted 15 minutes before the webinar begins.
How to Participate:
Instructions will be emailed to attendees within 24 hours of the webinar, and we recommend that you test the link to the meeting as soon as you get the instructions. The webinar is best viewed using Chrome as your browser. We recommend that you use a landline for both your phone and your internet connections.
This registration is for one person to attend. We manage our webinars on an honor-system basis; if more than one person from a utility wishes to attend, each is to register separately.
Fees:
Utility Member Rate: $235
Associate Member Rate: $350
Non-Member Rate: $470
Note: Organizations that register a group of employees will receive every fifth registration for free. For example, if you register five employees, you only pay for four; register 10 employees, you only pay for eight; and so on. There is nothing additional you need to do to receive this discount.
Cancellation Policy:
For webinars, virtual classes, and section meetings: cancellations at least five days prior to the event will receive a full refund; within 1-4 days or no show, the charge will be 100% of the registration fee.
For in-person events: cancellations at least 30 days prior to the event will receive a full refund; within 15-29 days there will be a $100 fee; and within 1-14 days or no show, the charge will be 100% of the registration fee.
When possible, please send a substitute instead of canceling. NWPPA does not charge a fee for substitutions. To request a refund, please contact us at registration@nwppa.org or (360) 254-0109.
Continuing Hours:
This course qualifies for 4 continuing hours. Certificates are issued upon full completion of the course.