You can try to get a more up to date version from the internet from my main page at (http://www.suba.com/~discov/john/john.htm)!

What NOW? - Get Around¯, Create¯, Edit¯, Format¯, Save¯, Print¯, Faster & Fancier¯, Other F&F SpreadSheet Features¯, Now What Was Important?¯, Now What?¯

SPREADSHEET = fancy calculator, paper with numbers, charts and graphs. Spreadsheet allows you to deal with information in a table format. Doing numerical caculations on that information and then presenting a nice looking table and/or producing a Chart, as in a pie chart or bar chart.

(What is a spreadsheet?)¯

There are five steps to creating any SpreadSheet:

1. (Create a SpreadSheet - type Numbers, Calculations/Formulas or Text.)¯
2. (Edit a SpreadSheet - correct by either:)¯
• Deleting what you don't want with delete.¯
• Adding by typing in cell or insert a row or column (in middle) Alt+IC or Alt+IR {Lotus -/WIR or /WIC}¯
3. (Format - Make it look pretty.)¯
• Curency - Select and choose Curency tool
• Quantity - Select and choose comma tool
4. (Save - Save and bring it back from storage - Disk).¯
5. (Print - Put it in a form someone can read)¯

(Most everything else we can do is just getting Faster and/or Fancer.)¯

A Spreadsheet is rows and columns of information, where the rows & columns cross each other is one piece of information. Where this information is stored is called a cell. A spread sheet consists of many cells. Each cell has an address like A1 or B3, ect, It is just the Column letter and the row Number.

You NEED to know basic ideas of a spreadsheet, which is rows and columns of numbers, calculations, or descriptive text. You also need to know how to enter and edit that information and how to do a simple graph. But you may also want to make the table look fancier or the chart look fancier, or how to get things done faster.

Each cell can contain a Number, Calculation or Descriptive text. When typing numbers don't type any dollar signs or commas, and you don't have to type the decimal point if you are dealing with whole dollars. If you want the numbers to have dollar signs and comma's ect you can do that with Formating.

A Database and Spreadsheet share simular features. A spreadsheet can also be used to select and sort information. You must use a Database if you are dealing with more then about 8,000 records.

Step 1 - Create a SpreadSheet
Use the arrow keys to move to any cell and then type the number (No Dollar signs or comma's). A Calculation is typed like +A3*B3-C3 (Make sure it starts with "+" so the program doesn't think it's text). Text can usually just be typed in, but if it starts with a number as in "1996 Budget" then you need to type a quote ' first.

A Calculation can also be (or contain) functions and functions start with "@". If you want to sum a bunch of numbers, like 20 of them, in order to get a total you can either do +A1+A2+A3+A4+A5+A6+A7... OR you can use the sum function and type @SUM(A1..A20).

NOTE: Excel really prefers for a fuction to be written like =SUM(A1:A20), so if you are using excel just type it with the equals and colon, even though it doesn't complain.

Step 2 - Edit a SpreadSheet
[F2] to edit a cell then use [backspace], or first use arrows to move.
To delete the cell contents just move to a cell and press [delete]. {Lotus can also be done with /Range, Erase [Enter]}

NOTE: Don't use space and then Enter to get rid of a Cell, unless that is what is needed for a count or average to be right.

Insert a Row or Column
{Excel - Alt+Insert, Row or Column}
{Lotus - /Worksheet, Insert, Row or Column}

NOTE: Make sure you insert in the middle of an area, if you try to insert near the bottom or top, your totals might not be right.

Simple Copy (1 cell to 1 or more cells)
{Excel - Alt+Edit, Copy; point to first cell; Shift+Arrows to highlight all; Alt+Edit, Paste}
{Excel alternate - Ctrl+C, point to first cell; Shift+arrows to highlight all; Ctrl+V}
{Lotus - /Copy, point to first cell; . (period) and then Arrows to highlight all; [Enter]}

Step 3 - Format a SpreadSheet
Show Dollar Signs
Select with Mouse and Click on the Dollar sign in the toolbar.
{Lotus - /Range, Format, Curency, 2 [Enter]}

Show Comma's only for Quantity
Select with Mouse and Click on the comma in the toolbar.
{Lotus - /Range, Format, ,, 0 [Enter]}

Change Column Width (Data doesn't disapear or get chopped off)
Drag border at top between Column Headers A, B, C, ect.
{Lotus - /Worksheet, Column, Set Width, use arrows to change; [Enter]}

Make Numbers or Text Bold
Select with Mouse and Click on the B in the toolbar.
{Lotus: Range, }

Fancy Formating: Graphing, Sorting, Query (see below)

Step 4 - Save - Save and bring it back from storage - Disk
Save a file - (Give the file a name or add changes to disk) Alt+File, Save, FileName, [Enter]
{Lotus - /File, Save, FileName, [Enter], and if adding changes Replace}
Close a file - (Clear Screen, usually ready to type) Alt+File, Close
{Lotus - Make sure saved first then /Worksheet, Erase, Yes}
Open a file - (Bring to workarea) Alt+File, Open, Choose FileName from list or type if no list, [Enter]
{Lotus - /File, Retrieve, [F3], Choose FileName from list or type if no list, [Enter]

CAREFULL!: When you type stuff it is stored in the computers memory (Workarea or desktop) but will disapear if anything happens to the power. Like someone trippping over the power cord, the power goes out, some interference from an electrical storm, or the computer locks up or crashes and needs to be reset. So before there is a problem make sure you give your file a name when you first start. And then save every once and a while to save your changes like when you just made a major change you know you want to keep.

Step 5 - Print - Put it in a form someone can read
Print a file - Alt+File, Print, [Enter] to print everything or choose what to print, how many or how to print.

{Lotus - /Print, Printer, Range, SelectRange [Enter], Align, Go, Page, Quit}

Getting Faster and Fancer with SpreadSheets.

---

Graphing - Pie chart or bar chart;
Absolute and Relative Addressing and Copying;
Other Functions like AVG, MIN, MAX and IF: @IF(B3 = "H", Hours*Rate, Rate)
Sorting - Put in Alphabetical or Numberical Order;
Query - Ask to look at only certain things.
Range Names - Refer to a group of cells as Jan instead of A1..A20;
(Range Names need to start with a least 3 characters so as not to be confused with Cell Addresses.)
Graph Titles (don't type information again) - use /A1 to show contents of A1;

Text Information: XXXXXX
Number Information: ######

4 Diffrent types of SpreadSheets:
Regular

        Title1  Title2  Title3 ... Total
Title1  ######  ######  ######     #####
Title2  ######  ######  ######     #####
Title3  ######  ######  ######     #####
...
Total   ######  ######  ######     #####

DataBase

Field1  Field2  Field3  ...  Field15
XXXXXX  ######  XXXXXX       XXXXXX
XXXXXX  ######  XXXXXX       XXXXXX
XXXXXX  ######  XXXXXX       XXXXXX
XXXXXX  ######  XXXXXX       XXXXXX

Leger or CheckBook Type

          B               C             D
Description        Quantity         Total 
XXXXXXXXXXX              10            10
XXXXXXXXXXX              83            +D(Row-1)+C(Row) = 93
XXXXXXXXXXX          ######

Report Type

          B               C              D
XXXXXXXXXXX              10            
XXXXXXXXXXX              83            
                                  =========
TOTAL                               +C1+C2

NOW What was Important? - CREATE = Type (Backspace to correct imediate mistakes). EDIT = DELETE (Selecting and press Delete) or ADD (Type). Select = Hold down Shift and Move to end. FORMAT = Selecting then Choose Menu or Toolbars. SAVE = File Save=Record; File Open=Play; File Save As=Record to a New Tape; File Close=Put Away & Pop out Tape; File Exit=Put away Tool (Typewriter or Tape Recorder) PRINT = File Print.

NOW What? - Next read about DataBase . or go ÝBack to Top, =Back to Contents= or =Back to Main=.