Business Managers Conference

September 22, 2009

12:30-2:30

Beginning Excel Session

Cells: Understanding how Excel handles text, numbers, and formulas/functions separately

State Monthly Allocations
Inserting rows and columns
Creating formulas

Fill down, Fill right

Fall Enrollment 2007
Fall Enrollment 2008
Selecting large sections of cells
Hide, Unhide cells

Worksheets within spreadsheets

Formatting of Cells: Number, Font, Border/Fill

Freeze Pane

Intro to Charts

Excel Help



3:00-5:00

Intermediate Excel Session


Functions

Merging Spreadsheets (moving worksheets)
Fall Enrollment 2007
Fall Enrollment 2008
Referencing cells within worksheet and other worksheets
State Monthly Allocations

Contrast Copy vs. Cut vs. Fill Down

Paste and Paste Special

Formatting text and numbers

Sorting
Filtering
State 1:1 Rankings


Charts: Formatting
Using Census Data

Reading Spreadsheets (If Function): District Need Docs

Understanding the powerful use of spreadsheets:
1) communicating complexity
2) what-if scenarios

Future with spreadsheets: Google Docs Example



Shortcuts


Keystroke
Task
Crtl-Z
Un-Do
Crtl-1
Format Cell(s)
Ctrl-D
Fill Down
Ctrl-R
Fill Right
Alt-I, C
Insert Column
Alt-I, R
Insert Row
Alt-E, S
Paste Special