Decision Making Using Excel
Abstract
This course is intended for those students who are familiar with the fundamentals of working with spreadsheets, but want to know more about using Excel logic functions to solve problems.
For those of you who have taken my older 2016 Basic Excel class, it is a total replacement for all the material related to the file “StockPurchasingTable.xls”, and contains many enhancements. So even if you understood the older file, you will probably benefit from examining this new course.
All files and documents pertaining to StockPurchasingTable are now deleted.
The material in the new course is based on an investing concept (the same as before) but is considerably expanded, and appears to possibly have application in other areas, such as retail sales. I am working on the retail aspect, but it is not mature enough yet to be included in the course at this time. If anyone is interested in working with me on the possibilities for a retail application, please contact me.
This course uses four new Excel files and three Word supporting files, listed below:
For Part 1:
- Decision Making Using Excel-Part 1.docx
- Redistributing A-Z – Initial.xlsx
- Redistributing A-Z – Equalized.xlsx
- Formulas Used in Redistributing A-Z.docx
For Part 2:
- Decision Making Using Excel-Part 2.docx
- Redistributing A-Z – Final1.xlsx
- Redistributing A-Z – Final2.xlsx
This abstract, course documents, and Excel files are available for download here===>> Download Files
Contact Bob Mugge at bob.mugge@tvcuc.org