Insert Calculated Fields feature of Pivot table enable you to add a virtual column, based on some calculation over existing columns, which is physically not present in dataset but gets available in Pivot Table fields. […]
Protecting the excel workbook with a password is the best way to prevent others from accessing data in your excel workbook. This ensures that the data in workbook will be accessed by only authorized person, […]
In excel, if you want user to enter a value in a cell only from a set of pre defined list, drop-down list is the best way to do so. A drop down restricts a […]
As every application has its own keyboard shortcut keys, Microsoft Excel also has a variety of keyboard shortcuts you can use to boost your work speed and make things more easy. Here is a list […]