• Welcome.
• Last Updated: Apr.16.2003
• Remember to link back to us! Thank you for visiting!

Web-Site General

- Home
-FAQ
- WebMasters
-E-mail Us
-Page Information
- Legal Information

Web-Creation

-Layouts
- BackGrounds
- CSS Scripts
- JavaScripts
-Blogs
-HTML
-HTML Color Chart
- DHTML
-Frames
- GUI

Graphics

- Paint
- Paint Shop Pro
- Flash
- Gif Animators
-Microsoft Photo Editor
- Movie Maker

Windows Programs

-Access
- Excel
- Internet Explorer
-PowerPoint
-Microsoft Works
-Misc.
-MS Dos Prompt
- Outlook
-Win-Zip
-Windows Explorer
-Word

Operating Systems

- 3.1
-95
-98
-ME
-NT 2000
-XP
-XP Pro.
-Linux
-Unix

Other Tips

- Keyboard ShortCuts
-TroubleShooting
-Media and Music
-Binary
-Macros
-Files

### Excel

The Formulas...that's the part most want to know...The basic Formulas

SUM: =SUM(cellname:cellname)
Average:=AVERAGE(cellname:cellname)
Max Amount in a select area:=MAX(B2:C3)
Min Amount in a selct area:=MIN(C1:C3)
Rounding a Cell:=ROUND(C2,0) the 0 is how many digits after a decimal.

#### IF statements

Finding true and false statements:
=IF("blue"<"green","true","false")
you can use these signs for equality equasions:
= equal to
< Less Than
>Greater Than
<> Not Equal
<= Less than or Equal to
>= Greater than or Equal to
.

Anything you can do with a calculator you can do in Excel.
There are so many more formulas, like interest, percent.
* Multiply
/ divide
- Subtract
: through

#### Writing Formulas

There is more than one way to average cells for instance:
=(C2+C3)/2
=AVERAGE(C2+C3)
=AVERAGE(C2:C3)
=(C2:C3)/2
Just always start your formula with a =.
Excel also includes a feature so that you can check your fomulas. They also include some for you to use.

As a spreadsheet it stores three types of data:
Names/Labels
Numbers
Formulas

Using these three things you can create elaborate spreadsheets. You can link them together, you can pull information for formulas off other sheets. You can do anything. It's easy to create a check register. Add one column and subtract another everytime and it's automatically balanced.

Store and businesses use excel to keep track of inventory and money. There's only one problem, if you mess up a formula you can potentially mess up everything. If you keep using that messed up formula, or if you keep refering to the value created by the formula you're in for trouble.

#### A Cool Feature

A cool little feature is the fill button. You can write one formula and apply it to many colums and cells. In example if you were averaging grades for students you could do the average code once and fill down. As long as you don't make the cell referance absolute by putting \$ before the cell name, the spread sheep compensates. Cool.