Do you want to know how to do homework on calculations faster?
We have collected useful tools, tricks, and functions from the Excel program that can be completed in a couple of clicks.
Doing homework in Excel becomes easier if you use a few useful tricks.
General principles of calculations in Excel
It makes no sense to describe all the functionality of Excel. It is very broad and capable of solving both simple computation and rather complex programming problems. However, some spreadsheet principles are worth repeating. This will be needed to write formulas, including for the purpose of calculating and performing operations with percentages.
But before we move on to Excel calculations, it is important to note that such processes usually take a lot of time. If you don’t have time for this, you need to get Excel homework help. An expert who regularly works with a spreadsheet will deal with your assignment much faster than you.
Formula creation tools in Excel
Records in Excel can have different formats – numbers, dates, text, and others. There is also a percentage, but oddly enough, operations with shares can be performed in other formats.
- In order for the program to understand that the record must be taken as a formula and a calculation must be made, it is necessary to put the “=” sign in the cell.
- “*” is used to multiply numbers.
- Minus and plus are similar to the symbols on the keyboard.
- The division is indicated by a slash “/.”
- More complex entries with multiple operations are denoted by parentheses.
It looks something like this: “=10*(100-20)/2”. After entering the data, just press Enter, and the result will appear in the cell. For more complex calculations with numbers in different cells, you will need to write a formula with data binding. Here’s what it looks like in an example:
- Enter the initial data.
- In a free cell, enter a formula where, instead of writing numbers, use the addresses of the cells with the data of which you want to perform the calculation. To substitute the address of the source cell, just click on it with the left mouse button. Press Enter.
- Numeric values can also be used in the formula, including combining them with cell addresses.
- To repeat the formula for the rest of the table values, you need to “stretch” the entered formula in the initial cell by grabbing the corner of the cell with the mouse pointer and dragging it in the desired direction.
In this way, the simplest calculations in Excel are performed.
Mathematical methods for calculating interest
Let’s talk about percentages. The very concept of percentage is the calculation of a fraction of any number that is a multiple of 100. In mathematics, there are several ways to calculate the percentage.
- The basic formula looks like this: (desired part / integer) * 100. Example: (10 / 50) * 100 = 20. Thus, 10 of 50 is 20%.
- To immediately calculate a certain percentage of the original number: (number * percentage) / 100. Example: = (500*5)/100 = 25%.
- The easiest way is to immediately divide the percentage by 100 and multiply the resulting fraction by the original number. For example, 15% of 600: 15 / 100 = 0.15. Next: 600 * 0.15 = 90.
Calculating a percentage of a number in Excel
Now let’s see how all these actions can be programmed in Excel. You already know how to write formulas, so the calculation process should not be a problem. For the purity of the experiment, let’s substitute the same values as in the examples. First, set the cell format as “General” or “Numeric.” This can be done for one cell, several, or the entire sheet. Select the required area, and open the pop-up menu with the right mouse button, select “Format Cells.”
Here I apply a formula that combines two mathematical operations at once.
As you can see, the program confirmed the correctness of mathematical calculations.
Built-in Excel tools for calculating interest
The program provides simpler ways to calculate interest using the “%” icon on the keyboard. For example, you need to get the result of 20% of the number 150. The formula looks like this: “= 150 * 20%”. The result can be obtained in the same cell where the numbers are entered or through a formula using different input methods. In any case, in this example, it will be equal to 30%.
When it is necessary to calculate the percentage in the base amount of initial data, use the following method. Suppose you have 200 units of a certain product, and you need to calculate the percentage of 25 units of the same product.
- Make a table by entering the initial data into the cells.
- The cell where the total will be is formatted according to the “Percentage” parameter. See above for how to do this.
- Introduce the simplest division formula 25/200 and get 12.5%.
Adding percentages to a number
There are situations when the source data has a different format – percentage and numerical. For example, you need to add 100 and 20% of 100. Enter the following formula: 100 * 20% + 100 = 120. Repeat the operation in Excel.
The base number from which the percentage is calculated may differ from the numeral one in the amount. Then you simply refer to another cell in the formula.
Another way to add percentages to the original number is through multiplication. To do this, the percentages are converted into a coefficient according to the principle: “one comma percent” (1.%%). In our example, we get a coefficient of 1.2.
Extracting a percentage from an amount
It is a fairly familiar situation for financiers in business. Goods come at a certain cost, which includes VAT. It is necessary to select it and get two figures – the price of the goods without VAT and the value-added tax itself.
The cost of the goods is $10563.85; the VAT rate is 18%. Calculate according to the formula: 10563.85 / 1.18 = $901.57 is the price of the goods without VAT. Accordingly, the tax is $162.28.
Now you must check the correctness of the calculation in several ways. Add up the price without VAT and the tax figure: 901.57 + 162.28 = $1063.85. The second way: 901.57 * 1.18 = $1063.85. Everything is correct. Program these actions in Excel.
Use this guide, and you will do homework on calculations in Excel much faster. Good luck!