EXC13PQ: Power Query for Excel 2013

$450.00
$450.00
Start Date Time Days Price GTR Availability
July 19, 2017 09:00 (EST) 1 $450.00 Register
July 19, 2017 09:00 (EST) 1 $450.00 Register
September 06, 2017 09:00 (EST) 1 $450.00 Register
October 25, 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