Office

Sometimes, you may want to create two Pivot tables in single Excel worksheet to report data in two different ways. You can find below the steps to create Two Pivot […]

If there are multiple worksheets in an Excel Workbook, you may find the need to hide few worksheets to reduce the clutter or for any other reason. This can be […]

After Creating Pivot Table and using it to create reports, the quickest way to Delete Pivot Table in Excel is to delete the worksheet containing the Pivot Table. Another way […]

The default setting in Excel Pivot Tables is to show blank cells when there is no applicable data for a row or column label. You can find below the steps […]

Sometimes, you may find it better to hide the zero values in your data and show cells with zero values as blank cells in the report that you are submitting […]

Sometimes, the presence of zeros in Excel data field can make histograms and other type of graphs look inaccurate. Hence, you might be interested in knowing the steps to replace […]

Having the Source Data on a single Worksheet makes it easy to Create Pivot Table. However, it is also possible to Create Pivot Table From Multiple Worksheets, if the Source […]

The Pivot Table function in Microsoft Excel allows you to summarize, tabulate and analyze data with effortless ease. You can find below the steps to Create Pivot Table in Excel. […]

A common task given in an Excel class and also in practical work related situations is to separate First and Last Names. You can find below the steps to separate […]