Calculations without formulas

Of course, formulas in Excel have been and remain one of the main tools, but sometimes, in a hurry, it would be more convenient to do calculations without them. There are several ways to implement this.

Paste special

Suppose we have a range of cells with large amounts of money:

It is necessary to turn them into “thousand rubles”, i.e. divide each number by 1000. You can, of course, go the classic way and make another table of the same size next to it, where you can write the corresponding formulas (= B2 / 1000, etc.)

And it can be easier:

1. Enter 1000 in any free cell
2. Copy this cell to clipboard (Ctrl + C or right click – Copy)
3. Select all cells with amounts of money, right-click on them and select Paste special (Paste Special) or click Ctrl + Alt + V.
4. Select from context menu The values (Values) и To divide (Divide): 

Excel will not insert 1000 into all selected cells instead of sums (as it would with a normal paste), but will divide all sums by the value in the buffer (1000), which is what is required:

It is easy to see that this is very convenient:

• Calculate any taxes with fixed rates (VAT, personal income tax …), i.e. add tax to existing amounts or subtract it.

• Turn cells with large amounts of money into “thousand”, “million” and even “billion”

• Convert ranges with monetary amounts to other currencies at the rate

• Shift all dates in the range to the past or future by a specified number of calendar (not business!) days.

Status bar

Cheap, cheerful and known to many. When a range of cells is selected, the status bar displays information on them:

Less well known is that if you right-click on these totals, you can choose which features to display:

Simple and convenient.

Calculator

My keyboard has a separate dedicated button for quick access to the standard Windows calculator – an extremely useful thing in a work environment. If your keyboard does not have one, then you can create an alternative in Excel. For this:

1. Right-click on the Quick Access Toolbar in the top left corner and select Customizing the Quick Access Toolbar (Customize Quick Access Toolbar):



2. In the window that opens, select All teams (All Commands) in the top dropdown instead of Frequently used commands (Popular Commands).
3. Find the button Calculator(Calculator) and add it to the panel using the button Add (Add):