PowerQuery: Transforming Your Work Processes in Microsoft Excel

by Pentawise Sdn Bhd

Power Query allows you to search for data sources, make connections, shape the data, and perform further analysis. It’s a powerful tool for data extraction, cleaning, and transformation.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Pentawise Sdn Bhd Logo

img Duration

1 Day

Course Details

If you can related to the following, Power Query will transform the way you work far more effectively than you have ever experienced:

  • I regularly get data from multiple sources e.g. Excel files, CSV/Text files, external databases (SQL, Access etc.), and bring it into Excel and consolidate it into one table so I can analyse it.
  • My data is spread over multiple Excel worksheets/workbooks and I have to consolidate it into one table so I can use it.
  • The constant update of data received requires cleaning before I can use it - splitting text into multiple columns, remove columns/rows/duplicates, adding columns, Format text as dates or numbers, other random data cleaning tasks that drive me crazy and waste my time.
  • I currently use Excel VBA/Macro to clean my data every week/month and it’s tedious.

 

What is Microsoft Excel Power Query?

Power Query, also known as Get & Transform, is a versatile tool in Microsoft Excel and Power BI programs. It empowers you to:

  1. Import data from a wide variety of sources.
  2. Transform that data to meet your specific needs. You can:
    • Remove columns.
    • Change data types.
    • Merge tables.
    • Perform other data shaping operations.
  3. Load your transformed data into Excel or Power BI.
  4. Create charts and reports based on your query.

 

In this training, you will learn:

  • What is Power Query
  • Get started with Power Query
  • Consolidate/Appending Data
  • Merging
  • Data Cleaning
  • Mid Valley City Branch

    37-8, The Boulevard, Lingkaran Syed Putra, Mid Valley City, Kuala Lumpur
  • Teacher's Name
  • N/A
  • Teacher's Experience
  • N/A
  • Gender
  • N/A
  • Teacher's Nationality
  • Malaysian

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy