Microsoft Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be awa…

A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spr…

A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a workshe…

Workbook Security We can apply security to the workbook by the concept of protection available in the Review Tab of …

Email Workbook Microsoft Excel allows you to email the workbook very easily. To email the workbook to anyone, follow…

Quick Print If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There …

VLOOKUP VlookUp searches for a value vertically down for the lookup table. VLOOKUP(lookup_value,table_array,col_inde…

Microsoft Excel data validation feature allows you to set up certain rules that dictate what can be entered into a ce…

A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its…

Sorting data in Microsoft Excel rearranges the rows based on the contents of a particular column. You may want to sor…

Filtering data in Microfot Excel refers to displaying only the rows that meet certain conditions. (The other rows get…

Built In Functions MS Excel has many built in functions, which we can use in our formula. To see all the functions b…

Functions in Formula Many formulas you create use available worksheet functions. These functions enable you to great…