Nov 27 2008
Power Excel
This is going to be a two-part series when I’m done. In the first part, I’ll focus on Excel, so you have the necessary knowledge. In the second part, I’ll focus on Excel applications, that is, the analysis of data and various problem types.
The second part will be inspired by Spreadsheet Modeling and Applications: Essentials of Practical Management Science, S. Christian Albright and Wayne Winston (if you don’t know how expensive university textbooks are, look for this book on Amazon). Inspired by, and certainly not copied from, because I don’t engage in illegal activities, because I have too much respect for the authors, and because this is perhaps one of the best in print and if you’re interested in the topic, the expense is well worth the investment. The statistics portion will be my material, some of which is inspired by Learning Business Statistics with Microsoft Excel 2002, by John L. Neufeld, an excellent book which I’m sorry to say has not been updated, and seems to be out of print.
Excel:
o.k. we finally sat down and worked our way through this. whew! thank you! let us know when you have more. this is great!
a couple of notes: in part 2, your first graphic: it looks like you added a row after you started writing your ‘range names used’. the first range name should be demand =$B$11. [instead of $B$10]
also, some of the graphics in part 4 didn’t open all the way for us. we saw a blue graphics box with a title, but didn’t realize that there was anything more in it until we cut and pasted the whole thing to a word doc for offline perusal later. it cut and pasted beautifully. [note: this problem could have been due to our dialup connection.]