The Institute for Continued Learning (ICL) icl-logo

Excel for the Rest of Us

Welcome to the Course Page for Excel for the Rest of Us. Fall 2024

Course Description: Most people think that Excel is only for complicated formulas and calculations. However, it can also be very useful for organizing and managing data, such as rosters, mailing lists, inventory lists, charts, etc. This 5-week course will focus on those features such as sorting, calculating totals, integrating with Word mail merge, generating charts, and formatting for printing, but will not delve into complex formulas/calculations.

Special Note: See preparation notes at the Class 1 link.

Contact Information
Instructor: Read Gilgen
read@gilgenart.com
435-313-3905 (text)

Syllabus for Fall 2024

(Files updated: November 11, 2024 )

A general outline of things we can cover, but we’ll be flexible. Check back regularly to see the revised syllabus.
Click on the class number to see files related to that class (examples, exercises, etc.)

Class 1: October 15

  1. Intro to Spreadsheets
  2. Spreadsheet Basics
  3. Entering/Editing Data

Class 2: October 22 (updated with new classroom exercise file)

  1. Database Basics
  2. Basic Formatting
  3. Sorting Data

Class 3: October 29 (several new and revised files to download!)

  1. Basic Formulas
  2. Relative/Absolute Cell References

Class 4: November 5

  1. Review and Practice Sorting
  2. Excel Tools (Hide/Unhide Rows/Columns, and Freeze/Unfreeze Panes
  3. Advanced Formatting
  4. Printing
  5. Excel Templates

Class 5: November 12

  1. Importing/Exporting Data
  2. Using Excel Data for Word documents, mailing labels, etc.
  3. Creating Basic Charts
  4. Finding/Using/Modifying existing Excel Templates