bxp15 2/14/00 11:24 pm
Excel usually seems more user friendly to me, but that may be attributable to the fact that I have used it at work for so long. There are several mathematical glitches in Excel though. Some of the formula functions do not calculate correctly. I have even caught it reading negative numbers as positive numbers in the past.
pabulum_8
The best book I have read in the past for Excel is "The Excel Bible." This book covers everything, and it helped me through a few very advanced worksheets.
Personally I prefer Quattro Pro because it has many financial functions and worksheets already programmed. I would also recommend for more complicated code that you add iserror code to multiple if, sumif, codeif, dateif, or other various ifs and is code so that you will have no odd answers popping up.
I agree with some of the earlier comments that Visual Basic is a great addition to your worksheet whichever product you use. Hope this helps, Christian
TototheWolf 2/11/00 10:43 am
Hello there! What about "Financial Modeling" by Simon Benninga...
It covers Financial Statement Modeling, Financial Analysis, Portfolio Models, Option Pricing Models, Bonds and Duration , and has an introduction to VB. finance_professional
Hi, SStark, These are not Excel 2000 books per se, but Excel books that I have liked in the past include Business Analysis with Excel by Conrad Carlberg (which introduces you to basic financial modeling, although more from the perspective of a company's corporate finance department rather than an investment banker's perspective), Developing Excel 5 Solutions by Eric Wells which is more VBA (visual basic for applications) related--also any of the books published by QUE I have liked as well (I own Using Excel for Windows 95 and Using Excel Visual Basic for Applications both from QUE.) There are recent editions of most of these books. You remind me that I need to look at see what recent editions are out there. Thanks. - Wayne http://www.financeprofessional.com
sstark7009 2/11/00 4:38 am
Hi Everyone! I was wondering if anyone knew of any good books for Excel 2000. I have good basic
skills, but need to learn more about using excel for financial models, functions, etc. (the really heavy
stuff). Anyone know of any good titles?
Please let me know if you do. Thanks!
Steven