Power Query Training | Excel VBA Training | SharePoint Training

On-site Computer Training Courses - 0800 998 9248

  • Home
  • Courses
    • On-site Courses
      • Adobe On-site Courses
      • Microsoft On-site Courses
      • Web Development On-site Courses
    • Scheduled Courses
      • Adobe Scheduled Courses
      • Microsoft Scheduled Courses
      • Web Development Scheduled Courses
    • Online Courses
      • Web Development Online Courses
      • Adobe Online Courses
      • Microsoft Online Courses
  • SharePoint
    • SharePoint Training
    • SharePoint Hosting
    • SharePoint Tutorials
  • Cart
  • My Account
  • Contact Us

Excel Power Query Introduction (One day)

Home  / Courses / On-site Courses / Microsoft On-site Courses / Excel Power Query Introduction (One day)

Excel On-site Courses

Excel Power Query Introduction (One day)

This course will show experienced Excel users and data analysts how to use Microsoft’s Power Query technology to import data from multiple sources, transform it in numerous useful ways, before outputting it to an Excel table or adding it to the data model. The course is suitable for users of Excel 2016, 2013 and 2010.

Price:£795.00

Category: Microsoft On-site Courses. Tags: excel courses, excel training, microsoft excel advanced.
  • Description

Product Description

This course will show experienced Excel users and data analysts how to use Microsoft’s Power Query technology to import data from multiple sources, transform it in numerous useful ways, before outputting it to an Excel table or adding it to the data model. The course is suitable for users of Excel 2016, 2013 and 2010.

Getting Started with Power Query

What Is Power Query?, Installing And Activating Power Query, Overview Of Data Sources, Overview Of Power Query Workflows

Query Basics

Creating A Query, Understanding Power Query Steps, Automatically Generated Steps, Renaming A Query, Renaming Columns, Changing Data Types, The Close & Load Command, The Close & Load To Command, Using The Workbook Queries Pane, Creating A Query from an Excel Table, Creating A Query from A Named Range, Importing Native Excel Data, Importing from Relational Databases, Importing from .CSV And .TXT Files, Importing Tabular Data From A Web Page, Importing From XML Sources

Combining Data

Appending Queries, Rationalising Column Names, Performing Merge Operations, Performing Expand Operations

Transforming Data Columns

Transforming Column Data Types, Removing Columns, Shifting Columns Around, Merging Columns, Splitting Columns, Creating Custom Columns

Transforming Rows of Data

Sorting Rows of Data, Filtering Rows of Data, Using Text, Date and Number Filters, Filtering Out Duplicate Rows, Filtering Out Rows with Errors, Transposing Data, Unpivoting Data, Grouping Data

Handling Power Query Output

Loading Queries to an Excel Table, Working with Connection-Only Queries, Loading To The Data Model, Default Query Load Settings

Introduction to Power Query Formulas

Using The Formula Bar, Using The Advanced Editor, Overview of The M Language

Related Products

  • Access On-site Courses
    Details Add to cart

    Microsoft Access On-site Training – Introduction (One day)

    £595.00 Read More
  • Access On-site Courses
    Details Add to cart

    Access Intermediate
    (One day)

    £595.00 Read More

Make an Enquiry

Your Name (required)

Company/Organisation

Email (required)

Telephone

Training Course(s)

Subject

Your Message

Upload Example Document(s) (Zip multiple files)

Copyright Power Query Training | Excel VBA Training | SharePoint Training 2015