Custom Columns in Table in Excel Power Query
The Excel Power Query feature, popularly known as ‘Get & Transform’, is a life-saver tool used to extract and transform data from various sources into… Read Article
“Arrow Keys Not Working in Excel” – Solved
If you want to move your active excel cell from one cell to another, you probably have three different ways. You may directly click on… Read Article
How to Add Conditional Column in Excel Power Query
Excel Power Query feature is an amazing tool provided by Microsoft in Excel to get the data from various sources and transform it according to… Read Article
Group and Summarize Data in Excel Power Query
The Excel Power Query tool is like a lifesaver tool when you want to extract some of the data from external files and folders or… Read Article
Transpose Data in Excel Using Excel Power Query
Transpose Data excel function is used to change the orientation of the data in excel. By changing the orientation, it means to convert the vertical… Read Article
Using Fill Down or Fill Up in Excel Power Query
In our overview blog on the excel power query feature, we had learned about the basics and the introduction of power query in Excel. We… Read Article
How to Replace Values in Excel Power Query
The Power Query Excel feature is one of the amazing Excel features. Using this feature, you can extract data from current excel workbook tables and/or… Read Article
All About Microsoft Forms in Office 365
Microsoft Forms is a new functionality introduced by Microsoft in Office 365 version. Using the Microsoft Form, you can create a data entry form and… Read Article
How to Filter and Sort Data in Excel Power Query
The Microsoft Excel Power Query feature is an amazing feature pre-provided by Microsoft in Excel 2016 and the later versions. I call this feature –… Read Article
Split Cells or Columns in Excel Using Power Query
The Power Query Excel feature is a magical tool available inbuilt in newer excel versions. This tool assists excel users to import data and tables… Read Article
Merge Data in Excel from Different Tables – Power Query
In this blog, we would learn how to merge data in excel from two or more different tables using the Excel Power Query feature.… Read Article
Merging or Combining Multiple Excel Files without VBA
A question that is being asked on various forums from excel users – “How to combine multiple excel files into one?”. Many excel experts suggest… Read Article