Event Profile

Microsoft Office Essentials Webinar Series: Excel - Get and Transform

Date(s):
November 4, 2021
Venue:
Online
Description:

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 Event(s):

Microsoft Office Essentials Webinar Series: All 17 Webinars, September 1 - December 16, 2021

Microsoft Teams Essentials, September 1, 2021

Excel Essentials, September 15-16, 2021

Build Your RFPs and Specifications Efficiently in Word, September 21-22, 2021

Excel Calculations and Charts, September 29-30, 2021

Fast Start to OneNote, October 6, 2021

Reuse Microsoft Office Content the Right Way, October 7, 2021

Excel Database/List Management, October 12-13, 2021

Lean Outlook – Simplify and Get More Done, October 26-27, 2021

Find Stuff Fast, November 9, 2021

Microsoft Planner Essentials, November 10, 2021

PowerPoint for Presenters, November 17-18, 2021

Word for Contracts, Procedures, and Manuals, December 1-2, 2021

M365 - The Mysterious Apps, December 8, 2021

Excel Conditional Formatting, December 9, 2021

Troubleshooting Problem Word Documents, December 15, 2021

End-of-Year Digital Cleanup Workshop, December 16, 2021

Webinar Overview:

This half-day course is for Excel users who spend too much time manipulating data into the right format before they even begin to analyze it month after month or week after week or day after day. 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, CSV, and text, but the concepts taught can be applied to many different sources. Upon successful completion of this 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
Once Get and Transform is set up, simply click the Refresh button. You’ll save hours!

A quick-reference guide will also be provided that includes highlights of the course content, as well as additional tips and tricks. 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.

Webinar Instructor:

Neal Otto, Jumpstart Computer Training

Webinar Schedule:

The webinar will be held on November 4 from 1 to 5 p.m. Pacific Time. Attendees will be admitted 15 minutes before the webinar begins.

How to Participate:

Instructions will be emailed to attendees within 12 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.

Webinar Fees:

Utility Member Rate: $180
Associate Member Rate: $270
Non-Member Rate: $540

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:

Cancellations are accepted with a full refund as follows:

For webinars and virtual classes, if the request is made at least five days prior to the course, then 100% of the registration fee will be refunded.

For in-person events, the following fee structure applies: cancellation at least 30 days prior to the event, full refund; within 15-29 days, $100 fee; and within 1-14 days or no show, 100% of the registration fee. When possible, please send a substitute instead of canceling because NWPPA does not charge a fee for substitutions.

Continuing Hours:

This course qualifies for four continuing hours. Certificates are issued upon full completion of the course.

For More Information:

To find out more about this event, or to learn about other events, view the Training and Event Catalog.