ONLINE - Excel Cleanup Data Using Power Query - Short Course 10/13/2020

Length/CPE Hours

3.5 hours

Class Time

8:30 AM – Noon Central Time

Start Time: 8:30 AM

Break: 10:00 – 10:15 AM

Class Time 12:00 Noon

Method of Delivery

This class will be held online using GoTo Metting. Class participants will receive a PDF of the book. Instruction will be using Outlook for Office 365. However, if you have Office 2016 or Office 2013, you will be able to follow along with minor exceptions.

When you register, be sure to use the email that you would like your GoTo Metting invitation sent to. The meeting invitation and materials are usually sent after the cancellation deadline which is 5 days prior to the class start date. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Meeting subscription to participate.

The web browser client will download automatically when you start or join your first GoTo Metting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Course Description

In this online class you will learn how to make connections to data and then modify the data to meet your data analysis needs. Power Query is a powerful data tool that helps Excel users clean up and transform data. The steps are recorded and then the same query can be used every time you need to clean up a similar file. We often get files from various sources that need to be cleaned up before they can be used. This class will show you a tool that can often help with that cleanup.

NOTE: You must have a good understanding of Excel Tables and PivotTables before you take this class. You must also have either Office 365 or Office 2016.

Power Query Basics

  • Define Power Query and Understand What it is
  • Find Power Query in the Ribbon
  • Get Data from a CSV file and transform it
  • Understand the Data Load Options
  • Edit a Query

Use Power Query Editing Tools

  • Use the Text Editing Tools
  • Work with the Number Editing Tools
  • Unpivot Data
  • Use Conditional Columns

Formulas in Power Query

  • Using IF, ELSE and AND Functions
  • Using JOIN like a VLOOKUP

Bonus Material

  • Work with Modulo

Who Should Attend?

Intermediate/Advanced Excel users who would like to expand their knowledge and skills, especially those that clean up data for data analysis.

Prerequisites: Attendees need a good understanding of Excel Tables and PivotTables. Attendees should first take a class like Excel to the Max or have equivalent knowledge.

Cancellation Deadline

For class fees paid directly to Cloud Training Services a person must cancel by the class deadline to receive a full refund. The cancellation deadline varies based upon location but it usually 5 to 10 days prior to the class. The cancellation deadline is stated at the top of this page.

If you are unable to attend and do not cancel prior to the class, you may send a substitute. Cloud Training Services will consider emergency situations such as a death in the family, illness and weather, and will make every attempt to work with the person in the event of an emergency.

Note

Cloud Training Services partners with other training vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.

Event Properties

Event Date 10-13-2020 8:30 am
Event End Date 10-13-2020 12:00 pm
Capacity 14
Registered 2
Available place 12
Cut off date 10-13-2020 8:00 am
Individual Price $159.00
Location ONLINE

Group Rate

#Registrants Rate/Person($)
3 139.00