000 04261nam a2200601 i 4500
001 11420761
003 CaPaEBR
005 20241023114853.0
006 m eo d
007 cr cn |||m|||a
008 170811s2017 nyua foa 001 0 eng d
020 _a9781631579479
_qe-book
035 _a(BEP)4935577
035 _a(OCoLC)1000457636
035 _a(CaBNVSL)swl00407733
040 _aCaBNVSL
_beng
_erda
_cCaBNVSL
_dCaBNVSL
050 4 _aHF5548.4.M523
100 1 _aMian, M. A.
_q(Mohammed A.),
_eauthor.
245 1 0 _aTips & tricks for Excel-based financial modeling :
_ba must for engineers & financial analysts.
_nVolume I /
_cM. A. Mian.
246 3 _aTips and tricks for Excel-based financial modeling :
_ba must for engineers & financial analysts.
_nVolume I
250 _aFirst edition.
264 1 _aNew York, New York (222 East 46th Street, New York, NY 10017) :
_bBusiness Expert Press,
_c[(c)2017.]
300 _a1 online resource (xi, 143 pages) :
_billustrations.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _adata file
_2rda
490 1 _aFinance and financial management collection,
_x2331-0057
500 _aIncludes index.
505 0 _a1. Introduction --
_t2. Overview of project economics --
_t3. Excel's financial functions --
_t4. Most used Excel functions --
_t5. Data management --
_t6. Evaluating data --
_tAbout the author --
_tIndex.
506 _aAccess restricted to authorized users and institutions.
520 3 _aThe purpose of this work is to show some advanced concepts related to Excel based financial modeling. Microsoft Excel (TM) is a very powerful tool and most of the time we do not utilize its full potential. Although not very difficult to use but it needs practice and continuously striving to use the full potential of Excel. Of course, any advanced concepts require the basic knowledge which most of us have and then build on it. It is only by hands-on experimentation that one learns the art of constructing an efficient worksheet. It is hoped that the examples herein will aid the reader to develop his or her own worksheets using advanced concepts. The biggest advantage of Excel is that it is not a black box, especially if you have built the model yourself rather than working with somebody else's model. The basic requirement for most financial modeling is to keep them simple so anyone can look at it can easily figure out how most of the calculations are performed. The two volumes of this book cover dynamic charting, macros, goal seek, solver, the routine Excel functions commonly used, the lesser known Excel functions, the Excel's financial functions, and so on. The introduction of macros in these books is not exhaustive but the purpose of what is presented is to show you the power of Excel, and it can be utilized to automate most repetitive calculations at a click of a button. For those who use Excel on a daily basis in financial modeling and project/investment evaluations, this book is a must. It contains a wealth of practical examples, tips, new techniques all designed to help quickly exploit and master Excel to its full advantage and therefore use spreadsheets more effectively in your jobs.
530 _a2
_ub
530 _aAlso available in printing.
538 _aMode of access: World Wide Web.
538 _aSystem requirements: Adobe Acrobat reader.
588 _aTitle from PDF title page (viewed on August 11, 2017).
630 0 0 _aMicrosoft Excel (Computer file)
650 0 _aBusiness enterprises
_xFinance
_xData processing.
653 _aadvance Excel
653 _aExcel based financial modeling
653 _afinancial modeling
653 _ainvestment evaluation
653 _ainvestment evaluation modeling
653 _aMicrosoft Excel (TM)
653 _aproject economics
655 0 _a[genre]
655 0 _aElectronic books.
776 0 8 _iPrint version:
_z9781631579462
830 0 _aFinance and financial management collection.
_x2331-0057
856 4 0 _uhttps://go.openathens.net/redirector/ciu.edu?url=https://portal.igpublish.com/iglibrary/search/BEPB0000632.html
942 _2lcc
_bCIU
_cOB
_eBEP
_QOL
_zBEP11420761
999 _c74364
_d74364
902 _c1
_dCynthia Snell