Office

Whenever you make changes to Source Data, it is important to make sure that Pivot Table is refreshed. You can find below the steps to Automatically Refresh Pivot Table Data […]

It is really easy to change Pivot Table Name in Microsoft Excel. You can find below the steps to change the name of a Pivot Table, along with relevant screenshots. […]

Depending on the type of change in the Source Data used for Pivot Table, you may find the need to either Change Pivot Table Data Source or simply Change Pivot […]

Blank values in a Pivot Table look unnecessary and they can be distracting. You can find below the steps to hide Blanks in Pivot Table. Hide Blanks in a Pivot […]

Depending on your requirements, you may or may not want to show Grand Totals in your reports. You can find below the steps to Add or Remove Grand Total in […]

Adding Subtotals to Pivot Table provides an additional level of breakdown, which can be useful. You can find below the steps to add or remove subtotals in Pivot Table. 1. […]

In this tutorial you will find the steps to Add or Insert Checkbox in Excel, in order to create an interactive checklist, inspection report or a to-do list. Insert Checkbox […]

The COUNTIF Function in Microsoft Excel is used to count cells matching a particular criteria or condition. You can find below a number of examples explaining the use of COUNTIF […]

Microsoft Excel stores date and time in the form of serial numbers, which allows it to accurately Add and subtract dates. You can find below various examples and useful formulas […]

In this article, we are taking a look at how to effectively use Concatenate Function in Excel to combine contents of multiple cells or to add Prefix and suffix to […]