Why learn Power Query?

Power Query is a data transformation tool that helps to connect almost any data source and transform data using user-friendly features with just one click and no coding. You import and clean millions of records and load them to data model for data analysis and reporting.

This course includes

  • 3 and 1/2 on-demand videos

  • 15 downloadable resources

  • Unlimited access for 12 months

  • Certificate of completion

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

Buy now

One year subscription