Why learn Power Query in MS Excel?

Power Query is a built in data connection technology in Microsoft Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Power Query is a data machine that helps you to perform ETL (Extract, Tranform, Load) process to make your data ready to use.

This course includes

  • 3 and 1/2 on-demand videos

  • 15 downloadable resources

  • Twelves months full access

  • Certificate of completion - 8 CPD credits

What you 'll learn

  • How to import data from multiple source and perform ETL [Extract, Transform and Load] process to sanitize data.

  • How to establish link with exisiting reports to collect data without disturbing look and structure of your report.

  • Transform data, merge tables, apply conditional logics to group and summarize large datasets.

  • Automate data import & ETL process and get latest and real time information with just one click.

  • Who should attend

    Anybody who want to learn advanced features of MS Excel.

  • Prerequisites

    Basic knowledge of Microsoft Excel.

  • Requirements

    Microsoft Excel 2016 or later. Microsoft Office 365 is preferred.

Course curriculum

  • 1

    Modern Challenges and Power Query

    • Modern Challenges for Everyone

    • What is Power Query?
  • 2

    Extract, Transform and Load

    • How to import delimited files

    • Import a named range from Excel file

    • Append Operations

    • Importing files from a filder

    • Aggregate data from Current Workbook

    • Aggregate data from other workbooks

    • Unpivoting data

    • Importing a non-delimited Text File

    • Merging Tables and Queries

    • Importing data from Web

    • Transpose and Unpivot complex data

    • Grouping and Summarizing Data

    • Transposing Stacked Data

    • Conditional Logic in Power Query

    • Practice Problem