Agenda
- Introductions - History with Excel and spreadsheets? What you hope to get from class? What kind of data do you want to (or are already) work(ing) with?
- Excel Versions and Alternatives - Open Office, Google
- Create simple data - First, Last, ID, Date, Donation
- Data Entry - Tab vs Enter
- Basic Formatting - bold, italic, alignment, font, color
- Selecting columns, rows, whole table, areas
- Cutting & Pasting (crtl vs shift), Inserting rows & columns, Undo/Redo
- Wrapping Text, Merging, Alignment (Cell Properties)
- Row/Column height & width
- Formatting numbers, currency...
- Automatic numbering and dates
- Getting around: Ctrl+Home, Ctrl+End, Home, Mouse, PgUp/PgDn
- Freezing Data
- Hiding Data
- Printing
- Normal vs Layout
- Print Preview
- Set Print Area
- Margins
- Orientation
- Centering
- Headers and Footers
- Worksheets - Add, Rename, Switch between
- Validation Tables
- Paste to Word, Difference between tables and spreadsheets
- Difference between spreadsheets and databases
- Help
- F1
- Google Excel tutorial
- Show & Tell
Agenda
- Review
- discuss formatting and print options
- practice with review file
- Sorting
- teach with review file
- practice with sort file
- Calculations
- teach entering equations with blank spreadsheet
- practice with deposit file
- teach copying equations
- practice with budget file
- discuss other simple equations
- List of functions
- Grouping
- teach with grouping with review file
- practice with sort file
- Subtotaling
- teach with review file
- practice with sort file
Excel Files for Practice