$450.00 CAD / 1 DAYS

1) Select Location for Dates in Your City:


Choose Date

Date is Guaranteed to Run

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,
Canada
,

Jump to Shopping Cart Continue shopping

EXC13PQ: Power Query for Excel 2013

 

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