Excel Tips




How to add the Developer Tab in Excel 2010

Posted by on Jan 13, 2013 in MS Excel | 0 comments

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. Select it and click on “ADD” button  thats in the middle of the two box. as show in the picture.     Click OK . The Developer tab should...

read more

Remove Duplicates in Excel Records

Posted by on Jan 13, 2013 in MS Excel | 0 comments

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 and it will be easily visible to you if you want to spot any duplicate records!...

read more

Concatenate

Posted by on Dec 31, 2012 in MS Excel | 0 comments

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

Posted by on Dec 30, 2012 in MS Excel | 0 comments

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 referenced data #NAME? Text in the formula is not recognized #NULL! A space was used in formulas that reference multiple ranges; a comma separates range...

read more

Absolute Cell References vs Relative Cell References

Posted by on Dec 30, 2012 in MS Excel | 0 comments

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 pasting it (relative reference), or it can always refer to a specific cell. You can also mix relative and absolute references so that, when you move or...

read more

Excel Functions

Posted by on Dec 30, 2012 in MS Excel | 0 comments

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 condition and then returns one value or another NOW Returns the system date and time TODAY Returns the system date, without the...

read more