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
Functions
This category is dedicated to covering all the functions and formulas of Excel.
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
How to Convert CSV File To Excel Using Power Query
The Excel Power Query feature (also popularly known as ‘Get & Transform’) is an amazing excel tool used to import and transform data from external… Read Article
How to Convert JSON to Excel Using Power Query
JSON stands for JavaScript Object Notation. It is a lightweight data-interchange format used to exchange data between a browser and a server in a text… Read Article
How to Unpivot Data in Excel Using Power Query
Excel Pivot Table is an amazing excel feature which is used to create different types of summary reports based on the huge table for the… Read Article
Convert Table from PDF to Excel Using Power Query
The Power Query has proved to be a life-saver feature for many excel users. This feature helps to extract and import data from various sources… Read Article