Login
Password

Forgot your password?

How to Create a Spreadsheet on Excel

By Edited May 22, 2016 0 0

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!

Add data
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.

How to Create a Spreadsheet on Excel
Use 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.
How to Create a Spreadsheet on Excel(52910)

 

 

 

 

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.


How to Create a Spreadsheet on Excel(52911)
Use 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!
Advertisement
Advertisement

Comments

Add a new comment - No HTML
You must be logged in and verified to post a comment. Please log in or sign up to comment.

Explore InfoBarrel

Auto Business & Money Entertainment Environment Health History Home & Garden InfoBarrel University Lifestyle Sports Technology Travel & Places
© Copyright 2008 - 2016 by Hinzie Media Inc. Terms of Service Privacy Policy XML Sitemap

Follow IB Technology