Excel for the Rest of Us

Class 3

Last update: October 29, 2024

It looks like we'll be stretching our syllabus (I over prepared once again!) The topics for this session will include some from previous classes, plus a couple more. Check back here regularly to see any updates.

Homework Assignment

• Try out the things we learned today so you can be comfortable navigating and entering data
• Begin to create a basic spreadsheet that would be useful to you.
  • Start with just the basic text and layout.
  • You can add/edit/modify as you learn more.
• Bring your spreadsheet with you to the next class.

Class #3 Topics:

1. Basic Formulas
2. Calculation Order
3. Relative/Absolute Cell References

Download the following file(s) to your thumb drive or laptop. Right-click on the link and choose Save Link As, and select the location you want to download to (e.g., your thumb drive). If you just click on the link, it will open it in your browser, but you want to download, not open. Always choose Save Link As to download.

The file name notation is: XL3 (Excel Class 3), Ex# (which exercise it is). The rev files have been mostly completed, with formulas and data. You can check these to see what results you should have.

The Slides are in PDF format. I'll be interested to know how helpful (or not) they are.

• XL3-Slides Slides (in PDF format)
• XL3-Ex1
• XL3-Ex2 (revised after class to correct errors on 10/29/24)
• XL3-Ex2rev (revised with formulas/results)
• XL3-Ex3
• XL3-Ex3rev (revised with formulas/results)
• Excel Extra Practice Sorting (We'll use this to review/practice sorting in Class 4)