Hi Friends, we are starting with a new series of articles on a very important feature of MS Excel. Yes, that is Power Query. It was first introduced with Excel 2010 version and started gaining attention of users due to its capabilities and features. So, what is Power Query, let’s start from this question.
Power Query is a business intelligence tool available in Excel and Power BI that allows you to import data from many different sources and then transform and analyze the data.
The user interface is also very intuitive and does not require special skill to learn it. With the easy navigation, you can quickly import your data and start analyzing in few minutes only.
So what you can do with your data through Power Query. Well the answer is Almost Everything. It allows multiple ways to import the data then transform it using cleanup, filters, sort etc. and finally Publish or export the data.
Using Power Query, you can import data from various source such as Excel, Text, Access, SQL, Web, Facebook, Azure and many more.
Once you have imported the data, the next step is to clean and transform it. You can do it through the amazing features provided by Power Query such as changing data types, removing columns rows, blanks, find and replace, text to column, split column, sum, rounding, calculations, filters, sort, transpose etc.
If you have multiple data sets that you want to consolidate into one query, then you can use append or merger queries feature.
The next step is to summarize your data through Group By option.
The final step is to publish or export your data to Excel file. You can do this through “Close & Load” button and your data is ready to share.
There are majorly two advantages of Power Queries as mentioned below
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
This Excel VBA Code converts the excel range into HTML and also can convert Excel to HTML Table to paste data on Outlook Email Body
This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.
VBA Code To Delete All Shapes On A Excel sheet Here is a VBA code which deletes all the shapes from an Excel sheet. Code is simple but you have to be bit careful while…
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…
VBA Code To Add New Sheet In VBA, it is sometime important to add a worksheet at the right place in the Excel. Here is a simple an effective code that adds a new worksheet…
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
Very clear explanations.. Thanks.. Need more videos on PQ…