Transform Your Data with Power Query
in Microsoft Excel

Overview:

This module is designed to teach participants how to use Power Query in Microsoft Excel to efficiently import, transform, and organise data from various sources. Power Query is a powerful tool that simplifies data preparation and enhances analytical capabilities.

Target Audience:

This module is ideal for:

  • Beginners with little to no Excel experience
  • Professionals looking to refresh their basic Excel skills
  • Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

  • Understand the fundamentals of Power Query and its role in data transformation.
  • Import data from multiple sources into Excel using Power Query.
  • Clean and prepare data for analysis by removing errors, duplicates, and inconsistencies.
  • Transform and reshape data using advanced Power Query features.
  • Combine data from different sources to create comprehensive datasets.

Topics include:

  • Overview of Power Query and its benefits in Excel
  • Connecting to various data sources including Excel files, databases, and web data
  • Importing data from text files, CSVs, and other formats
  • Removing duplicates and handling missing data
  • Correcting data entry errors and outliers
  • Applying basic transformations: numeric, date/time, and text adjustments
  • Advanced transformations: transposing, pivoting, and unpivoting data
  • Using conditional logic and custom calculations
  • Appending and merging queries from multiple sources

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Date with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data


Back to Training Courses
Submit
Thank you! Your message has been sent.
Unable to send your message. Please fix errors then try again.
Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help  improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

  01274 024 353

Last Updated : 04/08/2024