In this article we would learn how to combine data from multiple rows into one single string in Excel There is no specific function in Excel to concatenate data from multiple rows into one field. […]
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 […]