Similar Topics

Web Technologies32.1K+ articles

DSA20.4K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

JavaScript9.9K+ articles

Java9.4K+ articles

Misc7.7K+ articles

Mathematics5.7K+ articles

Excel Power Query

5 posts

Power Query – Source Reference as File Path in Cell

Last Updated: 13 June 2023

Power query helps in doing automation in an efficient manner. It allows users to utilize files stored in specific locations and apply routine transformation steps on those...read more

article_image

Excel Power Query

How to Add a Conditional Column in Power Query in Excel?

Last Updated: 31 January 2023

We may use Power Query to generate new columns whose values depend on one or more criteria that have been applied to existing columns in your database. The condition impos...read more

Technical Scripter 2022

Excel Power Query

Date Modifications with Power Query in Excel

Last Updated: 29 August 2025

A data preparation and transformation engine is Power Query. Power Query includes a Power Query Editor for implementing transformations as well as a graphical interface fo...read more

Technical Scripter 2022

Excel Power Query

Text Modifications with Power Query in Excel

Last Updated: 18 March 2026

Text Modifications with Power Query in Excel means cleaning and formatting text data using Power Query tools. It helps remove extra spaces, fix text cases, merge columns, ...read more

article_image

Technical Scripter 2022

Excel Power Query

How to Import, Edit, Load and Consolidate Data in Excel Power Query?

Last Updated: 18 March 2026

Power Query is a data preparation and transformation tool in Microsoft Excel that allows users to import, clean, transform, and combine data from different sources such as...read more

article_image

Technical Scripter 2022

Excel Power Query