Ad - leaderboard

Thursday, November 17, 2005

Excel workshop outline & lesson plan for Support staff

Welcome
Thank you for taking your valuable time to attend this workshop. My name is Steve Edwards. The workshops are held on Thursday November 17th and Friday November 18th from 9 AM to 4 PM in lab B111.

Day 1, Excel

  1. Opening question and answers
  2. Review of formulas and order of operations (BEDMAS)
  3. Using built-in functions
  4. Creating templates
  5. Conditional formatting
  6. Subtotals and pivot tables
  7. Creating and formatting charts
  8. Introduction to macro commands

Day 2, morning session, Word

  1. Opening question and answers
  2. Review paragraph formatting (with tabs)
  3. Tables
  4. Page layout (vertical alignment, header footer, image borders)
  5. Merge
  6. Styles

Day 2, afternoon session, Outlook

  1. Opening question and answers
  2. Review send options and receive email
  3. FIle management (create folders, move documents to folders, personal folder)
  4. Sending email with attachments.
  5. Finding contacts
  6. Agenda

Steve Edwards