MS Excel

How to add the Developer Tab in Excel 2010

Adding the Developer Tab in Excel 2010     Click on the File tab to open the file menu. – its the first option in the menu.     Click on Options in the menu     Click on the Customize Ribbon option.     See the drop down list under the label” Choose Commands from” and select     Main Tabs    Under the Main Tabs section – you will see Developer option....

Read More

Remove Duplicates in Excel Records

Excel – 2010 or 2007 You can Catch  Duplicates by the feature that is available in Excel 2007 or 2010 version. Under Home tab, Under Style section – click on Conditional Formatting, Select “Highlight Cells Rules” and click on Duplicate Values . The window will popup as shown below. Select the colour from the list and click OK.  The duplicate values will be highlighted...

Read More

Concatenate

Concatenate The concatenate function strings together the contents of a series of cells (text1, text2). The order that you select the cells is the order that they are combined into the resulting cell. Syntax: CONCATENATE(text1,text2,…) Shortcut: The symbol “&” can also be used instead of the concatenate function...

Read More

Excel Error message

Excel Error Messages to Get to Know Excel gives you an error message if you create a formula in Excel that contains an error or circular reference. It also gives you a brief description about the error. Understanding the error and their meaning helps correct the problem . Error Meaning #DIV/0! Trying to divide by 0 #N/A! A formula or a function inside a formula cannot find the...

Read More

Absolute Cell References vs Relative Cell References

When you copy and paste a formula in Excel, Excel looks at how you create the references within the formula – depending on how you have created the references , the values are displayed. This is where Relative and Absolute Cell reference matter! The formula can completely give you different results  – depending on either change the references relative to the cell where you’re...

Read More

Excel Functions

MOST COMMONLY USED FUNCTIONS IN EXCEL: SUM Calculates the sum of a group of values AVERAGE Calculates the mean of a group of values COUNT Counts the number of cells in a range that contains numbers INT Removes the decimal portion of a number, leaving just the integer portion ROUND Rounds a number to a specified number of decimal places or digit positions IF Tests for a true or false...

Read More