Would you like to learn how to create a spreadsheet on Microsoft Excel? This spreadsheet software is capable of performing a lot of calculations quickly on a long list of data. You can subtract, find averages, add, and more. This article will show you how to find the sum of multiple columns of numbers, however you can easily adapt this process to your own computational needs. So if you'd like to learn how to create a spreadsheet to sum monthly earnings or expenses, read on!
Enter your subjects into the spreadsheet. Anyone who wants to know how to create a spreadsheet on excel for budgeting should follow this example. Here you will find sums over time. Enter the dates beside each subject. Enter the data for the first time period you set. Notice each entry is in a separate box (cell). Enter the data for the first time period you set.
Credit: Amberdawn 2011Use Excel for a variety of algorithms
Click format, cells, then currency. Notice where it says decimal places and enter 2, if you prefer. Click okay. Then click the cell below the list of numbers. Then click the fx button beside the entry bar. An "=" should appear in both places, as well as a dialogue box. If you want to add the numbers, click sum. Credit: Amberdawn 2011
Use Excel for a long list of data
Check the cell names in the "Number 1" box. In the example, you want to add the cells C2 through C4. Type C2:C4 to include data between and including these cells.
Credit: Amberdawn 2011Use the algorithm for your full list of data
Use a shortcut to find the other sums. Simply click the first sum to highlight it. Hover your cursor over the bottom right corner of the cell. It should look like a black cross. Drag toward the right. When you release the mouse button you should see the sums appear. That's how to create a spreadsheet on excel if you are adding costs from month to month. The program is capable of much more, so please visit the resource links below for help with more complex algorithms. Good luck!