Click on the small square in the bottom right-hand side of the cell and hold the mouse button down as you drag it right to cell Z8:ģ5. We want to fill the formula in this cell across all of the months. Return to the top of the spreadsheet and click on cell B8.ģ4. Repeat this process through all of the sections.ģ3. Double-click on the square on the bottom right of the box in cell D10 to fill the contents of D10 down.ģ2. You will notice the formula in cell D10 is updated to reflect its new location.ģ1. Click con cell D6 and press CTRL+C to copy the contents of the cell.ģ0.
Www microsoft excel 2007 tutorial update#
The same update occurs if you copy the formula to a new cell. So, for example, it updated the row number for D5 to 5 (so the formula is now =C5-B5), for D6 to 6 and so on.Ģ8. Excel automatically updates formulas based on where they are copied to – reflecting the intent of the original formula based on its new position. Earlier, the formula we entered in D4 was =C4-B4, but as you can see on the spreadsheet, each cell is properly calculated the cells to its left – they don’t all have the formula =C4-B4. This will fill to the first break – the adjacent column C stops at C8, so the D column will automatically fill down to D7, stopping at D8.Ģ7. The other way to fill the contents of the cells down is to double-click on the small square in the bottom right of the cell.Ģ6. There are two ways to use it – click on the small square and drag up, down, right, or left and it will fill those cells with the contents of cell D4.Ģ5. In the bottom right of the box on cell D4 is a little square box. We could go down the spreadsheet and type the formula in each cell but there is a much easier way!Ģ4. This formula subtracts cell B4 from cell C4, providing the difference in cell D4.Ģ2. Now, we need to add some more formulas, so let’s get right back into that:Ģ1. Now, we’re going to enter some data for the month of January so when we create the formulas for each month, it will calculate and we can quickly see if we did it right. Great job on entering those formulas! Here’s a copy of the spreadsheet with the formulas in it so you see it before we move on to finishing all of the formulas: Why do we have to press it twice? The first cell in the row is already bold, pressing it once unbolds the row, pressing it a second time bolds the entire row. Rows 8 and 13 aren’t bold across all of the cells. Continue the process of holding down the CTRL key and clicking on cells B36, B43, B50, B59, B67:ġ7. Now hold down the CTRL key and click on cell B32:ġ5. In the formula bar at the top, you will see it add cell B22 to the formula:ġ4.
Go to the top of the Expenses section and click once on cell B22. Since the Expenses section contains a total row in each section, you don’t want to simply sum the entire section or you will be double counting.ġ3. When you get down to cell B68, we will need to use a different method to sum the cells. Practice your favorite method by summing each of the “total” rows in the Expenses section.ġ1. Now you’ve learned three ways to sum cells – using AutoSum, typing in the cell references directly, and using the mouse.ġ0. Click in cell B16, hold your mouse button down and drag down to cell B21. B10:B12 is a range of cells – it tells Excel to sum all of the cells in the range: B10, B11, and B12.Ĩ. It stops summing at the first break – in the case, cell B3 has no data, so it is the first break.ĥ.
The AutoSum button sums the cells which are above and closest to the cell you are in.
Click on the button in the Editing section of the Home ribbon and press Enter:Ĥ. We’ll focus in the section on the simpler formulas to calculate information we need in our budget. It has simple functions – such as summing several cells – and much more complex statistical functions. Excel is very powerful and can perform complex calculations which are updated as easily as entering data in a cell.
Www microsoft excel 2007 tutorial download#
If you’ve skipped ahead or just want to start with a fresh copy of the spreadsheet with where we are at in the tutorial, download it here:įamily Budget 6.xlsx (zipped) What is a Formula?Īn Excel formula is an equation containing functions, cell references, numbers, and/or operators.
0 kommentar(er)
