Who Should Attend:

Accountants and finance professionals who use Excel for reporting and analysis and want to work faster, reduce errors, and replace manual processes with modern tools.

Overview:

The Excel skill set your team has developed over the last 30 years is likely inefficient, time-consuming, and opens you up to dozens of errors. Over the last few years, Microsoft has introduced several features that reshape your data pipeline completely. Power Query automates the import, cleaning, comparison, and combination of data from multiple data sources, while Power Pivot builds a sophisticated data model for analysis and visualization. After this class, your approach to workbooks will be changed forever.

Objectives:

In this course, you will learn how to:

• Import external data with Power Query.
• Combine multiple data files with joins and appends.
• Clean problem data with just a few clicks.
• Analyze multiple related data tables with interactive visualizations.
• Replace antiquated functions with modern tools.

Instructor:

Neil Malek, President, Knack Training

Schedule:

The webinar will be held 10 a.m.-noon. Pacific Time. 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 your phone and 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 Standard: $200
Associate Member Standard: $300
Non-Member Standard: $400

Canadian utility members, please contact registration@nwppa.org for pricing and to register.

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. 

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 class qualifies for 2 continuing hours. Certificates are available upon full completion of the class.