By Bob Mugge – TVCUC Instructor
Revised 4/10/2017
Contact: home: 865-458-2544
Cell: 865-803-2699
Abstract
The Basic Spreadsheets course is for people who have never used a spreadsheet program before. It teaches the fundamentals of how to get around in a spreadsheet and through the use of step-by-step keystroke instructions given in three sessions, creates a small spreadsheet file.
Three other existing spreadsheet files will be examined and analyzed in detail, covering a wider range of Excel capabilities so students can better create spreadsheets for their own use.
Files required are listed below:
- Basic Spreadsheets – Sesson 1.docx
- Sales Data – Reference 1.xlsx
- Basic Spreadsheets – Sesson 2.docx
- Sales Data – Reference 2.xlsx
- Basic Spreadsheets – Sesson 3.docx
- Sales Data – Reference 3.xlsx
- Formulas in Sales Data – Reference 3.xlsx
- Basic Spreadsheets – Supplementary Files.docx
- Mortgage Amortization blank.xls
- Explaining the Mortgage Amortization template.docx
- Bridge Score Sheets.xlsx
- Making Bridge Score Sheets.docx
- Trip Calendar.xls
This abstract, course documents, and Excel files are available for download here Download Files