EXC13PQ: Power Query for Excel 2013

$450.00
$450.00
$450.00
$450.00
$450.00
Start Date Time Days Price GTR Availability
May 17, 2017 09:00 (EST) 1 $450.00 Register
May 17, 2017 09:00 (EST) 1 $450.00 Register
July 19, 2017 09:00 (EST) 1 $450.00 Register
September 20, 2017 09:00 (EST) 1 $450.00 Register
November 22, 2017 09:00 (EST) 1 $450.00 Register

Duration: 1 Day

Course Description
Power Query is a data analysis feature available for Excel that lets you discover, combine and refine data. Power Query enables users to search, combine, refine, shape, and download data from all sorts of different sources and types. In this one day class you will learn how Power Query can make your life easier.

Prerequisites
Course prerequisites include taking Excel 2013 Level 3 and PowerPivot. This course is aimed at serious Excel and Power BI users who need to import data into a worksheet.

Course Objectives
Upon successful completion of this course, students will be able to organized data and work with queries.

Audience
This course is for students with a sound working knowledge of Microsoft Excel 2013 and general computing proficiency, including those who will be using Excel to make business decisions.

Course Content

Power Query and When to Use It

Data Sources

  • Connect to a web data source
  • Connect to a spreadsheet
  • Connect to a database
  • Add a Wikipedia page data source

Organizing Data

  • Build repeatable processes to filter, clean, aggregate, and transform your data.
  • Shape data in the subject table
  • Remove Other Columns to only display columns of interest
  • Replace Values to clean up values in a selected column
  • Filter values in a column

Queries

  • Name a query
  • Load the query to a worksheet
  • Share queries and their data with other users in your organization.
  • Common Problems Solved