A Revised Investment Tracking Course Using Excel
Instructor - Bob Mugge
This course is not an introductory course in Excel, but may interest those who can get around in Excel and want some training in using Excel formulas, using a file for investment tracking as an example. It is an updated version of the course I taught in 2010, with features added for entering dividends, computing income and making buy decisions. The course is planned as a one session class lasting two hours, and takes place at the Chota Rec Center Room D classroom. This session may not be long enough to allow all students to get entirely through the material hands-on, but I expect that with the furnished step-by-step procedure, you can get through it all at home. I am willing to give additional help to those who want it. Students are encouraged to bring their own laptop to class if they have one, or they may use one of the club laptops. Bring a USB flash drive if you have one. Caveat: the investment tracking file used in this course requires the use of Excel linking features that are not available in the spreadsheet portion of the Open Offfice application program. Therefore those people who are using Open Office instead of Microsoft Excel will not be able to make use of this course.
How Your Computer Works
Instructor - Bob Mugge
Have you ever wondered what really goes on inside your computer and what the various parts do? This document will tell you. It’s not really a course. It’s just a description of how the parts of your computer work together to get things done. There are also some suggestions for keeping it in top shape. Class notes will be furnished.
Basic Spreadsheets Using Microsoft Excel or Works
Instructor – Bob Mugge
This course is intended for people who are interested in learning about how to use spreadsheets using Excel or Works, but have no or very little experience with spreadsheets. Students will get hands on experience with Microsoft Excel or Works using the club laptop computers or their own laptop if brought to class. Bring a USB flash drive to download files. The class notes contain instructions written for Excel, but Ken Ray has reviewed my notes for session 1 and says Works users can use them. This is a multi-session course and requires a fee per the club class fee guidelines. There will be at least three sessions. Later sessions are under development.