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 …
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 »
The people often say, “What’s in the Name”. we would learn the importance of the name in this article. Yes, In Excel we can define a name of the cell, range or in Formula. This is an incredible feature given by Microsoft in Excel however, a very few people know about it. In day to …
In this article, we would put lights on the most mysterious concern of all time in Excel The Offset Function. So, what Offset does in Excel? Basically, the OFFSET formula returns a reference to a range that is offset from a starting cell or a range of cells by a specified number of rows and …
Hi All, When we are copying or importing a database in our excel file, we are facing a big problem which is related to “Text Alignment”. Some texts are in vertical form, some texts are in horizontal form and they are not in justified form. Isn’t it? By default, Microsoft Excel aligns text to the …
