In this blog-Post, we will discuss the feature “Group By” from the Microsoft Power Query Add-In. When we need to get the summary of any database in excel. we have been using a Pivot table, SumIF, SumIFS from a long time in excel for the same. we all are very well versed with Pivot Table, …
Hi All, When we download data from any software then we have two choices one is to copy and paste it or directly import in excel. We are importing so many files in Text or CSV (Comma separated value) format on a daily basis. If we guys are doing it manually till now, this is …
Hi All, In this blog-post, we would understand the group “From Number” in Microsoft Power Query. In our previous blog-post, we had discussed the split number and Text function in Microsoft Power Query. One question which is most likely asked by the people that when we can do the calculation in Ms-Excel, then why we …
Hello Readers, Hope you all are doing great. Sometimes, in excel we want to act against some specific cell, However, it becomes a big task for the end user to search those specific cells and select them. For example, we want to delete all the comments from the current sheet at one click. But How? …
Hi all, We have two types of tool to maintain data. One is Excel and the second one is Ms-Access. If we are maintaining our database in Ms-Access, however, we all know that Excel is the best tool to do data analysis. Therefore, we need to Import the access file in excel. But How? In …
Hi Guys, When we are dealing with large data set in excel, Pivot table comes in the right way to help us to create an interactive summary from different records. Apart from these things, the pivot table automatically do short the data and apply the filter button as well. Also, it can Create a tabulation …
Hi All, When we think of the analysis of data into excel, what comes first in our mind? Yes! The correct answer is the Pivot table. However, we know that the pivot table has its own limitation and we know that, when we want to do the analysis of any data, we need to convert …
Unpivot Column Data Using Power Query Excel 2016 Read More »
Array function is one of the powerful formulas. Array formula can do multiple tasks and multiple calculations can replace multiple formulae in one cell. And guys, still approximately 80-90% of the people do not know, how to use this formula? And the reason because they scare to learn it. No doubt, Array function is a …
Hi, Sometimes, we need to get data from the webpage. What we do, we simply copy and paste it in excel however, most of the time, excel does weird data paste because the margin and alignment of the web page are different from excel. In Today’s blog-post we will get rid of this kind of …
How to Import Live Data from Web to Microsoft Excel Read More »
