Print

Agenda

  1. 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?
  2. Excel Versions and Alternatives - Open Office, Google
  3. Create simple data - First, Last, ID, Date, Donation
  4. Data Entry - Tab vs Enter
    1. Basic Formatting - bold, italic, alignment, font, color
    2. Selecting columns, rows, whole table, areas
    3. Cutting & Pasting (crtl vs shift), Inserting rows & columns, Undo/Redo
    4. Wrapping Text, Merging, Alignment (Cell Properties)
    5. Row/Column height & width
    6. Formatting numbers, currency...
    7. Automatic numbering and dates
    8. Getting around: Ctrl+Home, Ctrl+End, Home, Mouse, PgUp/PgDn
  5. Freezing Data
  6. Hiding Data
  7. Printing
    1. Normal vs Layout
    2. Print Preview
    3. Set Print Area
    4. Margins
    5. Orientation
    6. Centering
    7. Headers and Footers
  8. Worksheets - Add, Rename, Switch between
  9. Validation Tables
  10. Paste to Word, Difference between tables and spreadsheets
  11. Difference between spreadsheets and databases
  12. Help
    1. F1
    2. Google Excel tutorial
  13. Show & Tell
 
Print

Agenda

  1. Review
    1. discuss formatting and print options
    2. practice with review file
  2. Sorting
    1. teach with review file
    2. practice with sort file
  3. Calculations
    1. teach entering equations with blank spreadsheet
    2. practice with deposit file
    3. teach copying equations
    4. practice with budget file
    5. discuss other simple equations
    6. List of functions
  4. Grouping
    1. teach with grouping with review file
    2. practice with sort file
  5. Subtotaling
    1. teach with review file
    2. practice with sort file

Excel Files for Practice

Review Start

Review Finish

Sort Start Sort Finish
Budget Start Budget Finish Deposit Start Deposit Finish
All Files Zipped

 

 

 

 

 
Joomla16 Appliance - Powered by TurnKey Linux