Cargando…

Tips & tricks for Excel-based financial modeling : a must for engineers & financial analysts. Volume II /

The 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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Mian, M. A. (Mohammed A.) (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York, New York (222 East 46th Street, New York, NY 10017) : Business Expert Press, 2017.
Edición:First edition.
Colección:Finance and financial management collection.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000Mi 4500
001 EBOOKCENTRAL_on1000456495
003 OCoLC
005 20240329122006.0
006 m eo d
007 cr cn||||m|||a
008 170811t20172017nyua foa 001 0 eng d
040 |a NYBEP  |b eng  |e rda  |e pn  |c NYBEP  |d OCLCO  |d OCLCF  |d MERUC  |d EBLCP  |d UAB  |d IDEBK  |d N$T  |d YDX  |d UWO  |d LOA  |d W2U  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OSU  |d LIP  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
019 |a 1000453788  |a 1002564266  |a 1069630855  |a 1099702117 
020 |a 9781631579493  |q (electronic bk.) 
020 |a 1631579495  |q (electronic bk.) 
020 |z 9781631579486  |q (paperback) 
020 |z 1631579487  |q (paperback) 
029 1 |a AU@  |b 000065222583 
035 |a (OCoLC)1000456495  |z (OCoLC)1000453788  |z (OCoLC)1002564266  |z (OCoLC)1069630855  |z (OCoLC)1099702117 
037 |a 1025179  |b MIL 
050 4 |a HF5548.4.M523  |b M5272 2017 
072 7 |a COM  |x 054000  |2 bisacsh 
082 0 4 |a 005.54  |2 23 
082 0 4 |a 005.369  |2 23 
049 |a UAMI 
100 1 |a Mian, M. A.  |q (Mohammed A.),  |e author.  |1 https://id.oclc.org/worldcat/entity/E39PCjxCrwwmkfhQhDcwM68kwy 
245 1 0 |a Tips & tricks for Excel-based financial modeling :  |b a must for engineers & financial analysts.  |n Volume II /  |c M.A. Mian. 
246 3 |a Tips and tricks for Excel-based financial modeling :  |b a must for engineers & financial analysts.  |n Volume II 
250 |a First edition. 
264 1 |a New York, New York (222 East 46th Street, New York, NY 10017) :  |b Business Expert Press,  |c 2017. 
264 4 |c Ã2017 
300 |a 1 online resource (xi, 139 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a electronic  |2 isbdmedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Finance and financial management collection,  |x 2331-0057 
500 |a Title from PDF title page (viewed on August 11, 2017). 
500 |a Includes index. 
505 0 |a 1. Creating dropdown lists -- 2. Using Excel's data tab -- 3. Presenting information using charts -- 4. Automating worksheets -- About the author -- Index. 
520 3 |a The 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. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Business enterprises  |x Finance  |x Data processing. 
650 7 |a COMPUTERS  |x Desktop Applications  |x Spreadsheets.  |2 bisacsh 
650 7 |a Business enterprises  |x Finance  |x Data processing  |2 fast 
653 |a advance Excel 
653 |a Excel based financial modeling 
653 |a financial modeling 
653 |a investment evaluation 
653 |a investment evaluation modeling 
653 |a Microsoft Excel (TM) 
653 |a project economics 
758 |i has work:  |a Volume II (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGrfvbQJmMkjJdfVmKWVqP  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |z 9781631579486 
830 0 |a Finance and financial management collection.  |x 2331-0057 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=4935576  |z Texto completo 
938 |a Business Expert Press  |b BEPR  |n 11420760 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL4935576 
938 |a EBSCOhost  |b EBSC  |n 1568560 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis38650086 
938 |a YBP Library Services  |b YANK  |n 14739794 
994 |a 92  |b IZTAP