Microsoft Excel Workshop at HFCL
Successfully Completed 1 Day Microsoft Excel Workshop at HFCL (Himachal Futuristic Communications Ltd), Gurgaon on 17 Feb 2020.
Power Query – Grouping Option
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, …
Text/CSV Database Import Into Excel
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 …
Microsoft Power Query – Number Column
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 …
Go to Special Features In Microsoft Excel
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? …
Microsoft Access Data Import In Microsoft Excel
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 …
How to use Pivot Table in Microsoft Excel
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 …