Power Query Tutorials and Blogs

Power Query is an Excel add-in that you can use for ETL. That means, you can extract data from different sources, transform it, and then load it to the worksheet. You can say POWER QUERY is a data cleansing machine as it has all the options to transform the data. It is real-time and records all the steps that you perform.
You will learn more about Power Query with the help of this category tutorial blogs by Excel Downloads.

How to convert JSON into Excel Format Tutorial by Excel Downloads

Converting JSON into Excel Format

We often come across JSON File formats. For example, in GST Filing or regulatory filing

How to Merge Combine Multiple Excel FILES into ONE WORKBOOK

How to Merge /Combine Multiple Excel FILES into ONE EXCEL WORKBOOK ?

If you ask people who work with data, you will get to know that combining

How to Load Data Back to the Worksheet in Power Query ?

How to transform and load data Once you transform your data, you can load it

How to remove negative values in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to use prefix and suffix option in Power Query Editor

How to add prefix and suffix in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to use trim and clean option in Power Query Editor

How to use trim and clean options in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to change case type in Power Query Editor

How to change case in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to change data type in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to replace or remove errors in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to transpose column or row in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to duplicate a column in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to rename a column in Power Query Editor ?

Introduction to Power Query Power Query Editor is a data transformation and cleaning tool that

How to split column in Power Query Editor

How to split columns in Power Query Editor ?

In this blogpost we will learn about splitting columns in Power Query Editor while working

How to remove columns in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to sort data in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

How to replace values in Power Query Editor ?

Introduction to Power Query Power Query is a data transforming engine which you can use

What is Power Query Language i.e. M Code

What is Power Query Language (M Code) ?

Introduction to Power Query Power Query is a data transforming engine which you can use

A Complete Power Query tutorial for Excel Users

A Complete Power Query Tutorial with Examples

In this tutorial we will discuss about Power Query tool in Microsoft Excel. We will

Learn More
Basic Excel Tutorials
Excel Shortcuts

SlidesGeek.com

Free Presentation Templates & Slides

Download thousands of free Presentation Templates, PowerPoint Presentation Ideas, Google Slides Layout and Designs.

SlidesGeek.com

Free Presentation Templates & Slides

Data Analytics and Computation Made Easier with Free Excel Templates

Blogs & Articles for Spreadsheet Ideas

Any Query ? Mail us at admin@exceldownloads.com

Templates

Tutorials

Tools

Other Links