|
 How
to create a simple budget in Excel
When you are new to using Excel you can start by creating a simple budget or
just simply adding a list of figures to show what Excel can do. Below I will
show you step by step how to create a simple budget.
-
Create a list of all
your expenses or all your earnings. See the example below.
.JPG)
-
Under all of the expenses or earnings
in this case; type ‘=’ in the box.
.JPG)
-
Then click on the first earning. For
example if I clicked on $20.00 that is listed next to Monday and the cell
coordinates will be entered after the equals sign. So therefore each box I
click on will be added to this automatically.
.JPG)
-
After the first entry put a ‘+’ or ‘-‘
to either add or subtract. In this example I will put a plus sign because I
want to add all of the figures together.
.JPG)
.JPG)
-
Repeat the last two step until you
have done all of your expenses/earnings. Go back and put a plus sign, then
click on another cell location that you want to add.
.JPG)
-
Finally push enter and the total will
appear.
.JPG)
If you wanted to subtract your expenses from your earnings you would simply
click on the box where you want the answer to go, type an = sign then click on
the total of your earnings, type a minus sign, then click on the total of your
expenses. This will take your expenses away from your earnings.
How to merge cells in
excel
How to use data from a table to create a graph
chart in excel
Change UPPERCASE text to lowercase in Word 2007
How to enable or
show the developers tab in Microsoft Word 2007
How to embed a Youtube video into a PowerPoint Presentation
Embed Youtube video into a PowerPoint 2007 presentation CD.
How to save a word 2007 document to be compatible with Word
97-2003
Add shortcut icons to your Quick Access toolbar in
Microsoft Word 2007
How to save a picture,
logo, or clip art from a word document?
Select all text with a similar format style in word 2007 document
How
to make headings and titles in a word 2007 document?
How to link
to a heading, title or bookmark in a word 2007 document
How to make a
bookmark in a word 2007 document?
Add a video or to
word 2007 and convert it to a PDF
Add a watermark
to your Word 2007 document
Shortcut to
delete all html hyperlinks from a Word document
About the Author
Jarrah Mclardy wrote this article and others for
tips4pc.com Browse
for more articles that are written in an easy to understand
way. Also see our very popular
Video Tutorials page. Watching
a video is a very easy way to learn about computers.
I hope you've found this tutorial clear and easy to
understand. If you have more questions, feel free to visit our
FORUM and we'll be
happy to help.
Get the Tips4pc newsletter
| 
