Thursday, March 30, 2006

Excel Concept List

What is a spreadsheet, GUI overview
Select Cell
Entering Data - Text, fixing errors, autocorrect
Entering data - numbers
Calc Sum
Fill - fill handle
Formatting: Font type, size, style color, mergin cells
Name box to select cell (EX36)
Add chart
AutoCalculate
-----
Formulas: order of ops, point mode vs fill mode vs manually
Functions: average, min, max, count
Verifying formulas
Formatting: BG colors, borders, number formats, conditional formatting, widths/heights
Spell check
Print formulas version

-------

Rotate text
fill series
Copy formulas - copy/paste vs drag-n-drop
Insert/delete
Format symbols
Freeze titles
Functions: IF
Formatting: numbers, titles, shadows
Charts: Pie
Multiple worksheets
What-if & Goal seeking (EX204 ff.)

Tuesday, March 14, 2006

DB data

I'm creating a database we are going to setup in class, and then manipulate beyond what the text does. It will also from the basis for the final DB project.

So please fill out the "survey".