Home

Excel 97

GRAPHICS
2009/01/12
This will be a lot of fun.  We are now going to turn your spreadsheet numbers into graphics    bar charts, pie charts, etc.  This will greatly assist you in business to display and explain your work.

Read more...
Printing
2009/01/12
First move to cell A1.

All of the Window spreadsheets try to figure out what you want to print.  Sometimes they're right, sometimes they're wrong. So........


Read more...
COPYING
2009/01/12
Assuming our income and expense amounts are about the same throughout the months, we want to copy the amounts in Column C to Columns D, E and F.  To do this, first move your cursor to C6. Then we'll high-light what we want to copy, next we'll tell the spreadsheet where we want to place what we've copied. So, point to C6, hold down the left mouse button and drag down the column until cells C6 through C21 are high-lighted.
Read more...
SUBTRACTION
2009/01/12
In cell A19 type Net Income.  Next, adjust the width of column A.

In C19 we want to subtract the amount in for Expenses in cell C17 from the amount for Income in C9.  This can be accomplished by using either the Type-In Method or Point Method.  Go ahead and do this.

    [The formula should look like =C9 C17]


Read more...
TYPE-IN METHOD
2009/01/12
We want to add the three numbers in cells C6, C7 and C8.  To use this method type-in the following in cell C9:

         = C6 + C7 + C8      Tap Enter
Read more...
RETRIEVING SPREADSHEETS
2009/01/12
When you need to return to a spreadsheet you first load Excel, as you did originally.  When Excel is on the screen, click-on File in the menu bar then click-on Open.  The Open Menu will appear. 
Read more...
SAVING SPREADSHEETS
2009/01/11
We have done quite a bit of work so now is a good time to save.  Point to the File menu at the top of the spreadsheet.  Point to Save As.  Click.  A sub menu box appears. 
Read more...
ALIGNING CELLS
2009/01/11
Now we'll type some more.  Go to

C3       SEPT (Type in and tap Enter)


Read more...
INSERTING ROWS
2009/01/11
Oops... a mistake (on purpose).  I haven't left enough room at the top of the spreadsheet to insert some budget months. So... move the cursor to the gray 2 along the left edge (this is the second row) so we can insert two new rows.   Click the left mouse button.
Read more...
WIDENING COLUMNS
2009/01/11
You probably noticed, as you typed in the numbers, some of the words had the last few letters covered (just like Bonzo).  Let's widen column B to take care of this.  Slowly move the mouse arrow to the right edge of the B cell  (between the B and the C).
Read more...
Tutorials
 
RSS
Web statsMicrosoft Tools
Developed by: miniCMS™ v2