Wednesday 28 April 2010

ESI Limit enhanced to 15000 wef 01-05-2010-Notification

Friday 23 April 2010

Shortcut key for AutoSum in Excel

The most commonly used formula in any spreadsheet depending upon various application, is to sum up the total of the adjacent cells. AutoSum is the handy tool for this situation.

AutoSum in Excel

What is AutoSum? AutoSum is a simple mathematical formula to display the total sum of the neighboring cells. Excel chooses these cells automatically based on the ideal usage of the position of the result. AutoSum first checks if there is any continuous group of cells which has numbers above the result cell for its range, then it checks to the left side of the result cell. But the range of cells that are included for the calculation can be reselected manually by dragging if it's wrong.

How to use AutoSum?

In Excel 2003, you can use the AutoSum symbol (which is a sigma sign) from the toolbar and In Excel 2007, you can find the AutoSum function in the Editing section (which is on the far right side) under Home tab.

AutoSum in Excel 2003 AutoSum in Excel 2007

Keyboard Shortcut to AutoSum in Excel

But you can always use the keyboard Shortcut, ALT + = to do the AutoSum. This tip comes very handy if most of your daily calculations depend on addition of values.

Quick Tip: AutoSum can be used not only when the values are adjacent to the result cells, but even if it's randomly displayed. All that you have to do is, press ALT+= in the cell where you want the result to be displayed and while holding the CTRL key click all the cells that you want to be included in the result.

AutoSum of dispersed items in Excel
SELECTED

Thursday 15 April 2010

Wednesday 14 April 2010

Term of the Day: Hidden Taxes

Hidden Taxes

What Does it Mean?
Taxes that are indirectly assessed upon consumer goods without the consumer's knowledge. Hidden taxes are levied upon the goods at some point during the production process and therefore raise the cost of the goods sold. However, this tax is never revealed directly to the consumer, who simply pays a higher price for the good, not knowing that part of that price is due to this tax.

Friday 9 April 2010

Tax Avoidance

Tax Avoidance

What Does it Mean?
The use of legal methods to modify an individual's financial situation in order to lower the amount of income tax owed. This is generally accomplished by claiming the permissible deductions and credits. This practice differs from tax evasion, which is illegal.

"A journey of a thousand miles begins with a single step."