Tips & tricks for Excel-based financial modeling, Volume I: a must for engineers & financial analysts
1. Introduction -- 2. Overview of project economics -- 3. Excel's financial functions -- 4. Most used Excel functions -- 5. Data management -- 6. Evaluating data -- About the author -- Index
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
New York, New York (222 East 46th Street, New York, NY 10017)
Business Expert Press
2017
|
| Ausgabe: | First edition |
| Schriftenreihe: | Finance and financial management collection
|
| Schlagworte: | |
| Online-Zugang: | FHN01 FWS01 FWS02 UBY01 Volltext |
| Zusammenfassung: | 1. Introduction -- 2. Overview of project economics -- 3. Excel's financial functions -- 4. Most used Excel functions -- 5. Data management -- 6. Evaluating data -- About the author -- Index 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 |
| Beschreibung: | Includes index |
| Beschreibung: | Online-Ressource (xi, 143 pages) |
| ISBN: | 9781631579479 9781631579462 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV045876335 | ||
| 003 | DE-604 | ||
| 005 | 20240423 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 190514s2017 |||| o||u| ||||||eng d | ||
| 020 | |a 9781631579479 |9 978-1-63157-947-9 | ||
| 020 | |a 9781631579462 |9 978-1-63157-946-2 | ||
| 035 | |a (ZDB-191-BEX)11420761 | ||
| 035 | |a (OCoLC)1000457636 | ||
| 035 | |a (DE-599)BVBBV045876335 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-863 |a DE-862 |a DE-92 |a DE-706 | ||
| 082 | 0 | |a 005.369 |2 23 | |
| 100 | 1 | |a Mian, M. A. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Tips & tricks for Excel-based financial modeling, Volume I |b a must for engineers & financial analysts |c M. A. Mian |
| 246 | 1 | 3 | |a Tips and tricks for Excel-based financial modeling |
| 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 | |
| 300 | |a Online-Ressource (xi, 143 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Finance and financial management collection | |
| 500 | |a Includes index | ||
| 520 | |a 1. Introduction -- 2. Overview of project economics -- 3. Excel's financial functions -- 4. Most used Excel functions -- 5. Data management -- 6. Evaluating data -- About the author -- Index | ||
| 520 | |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 | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Business enterprises / Finance / Data processing | |
| 653 | |a Electronic books | ||
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781631579462 |
| 856 | 4 | 0 | |u http://portal.igpublish.com/iglibrary/search/BEPB0000632.html |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-191-BEX | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031259553 | ||
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/BEPB0000632.html |l FHN01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000632.html |l FWS01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000632.html |l FWS02 |p ZDB-191-BEX |x Verlag |3 Volltext | |
| 966 | e | |u http://portal.igpublish.com/iglibrary/search/BEPB0000632.html |l UBY01 |p ZDB-191-BEX |x Verlag |3 Volltext | |
Datensatz im Suchindex
| DE-BY-FWS_katkey | 724481 |
|---|---|
| _version_ | 1824554842673119234 |
| any_adam_object | |
| author | Mian, M. A. |
| author_facet | Mian, M. A. |
| author_role | aut |
| author_sort | Mian, M. A. |
| author_variant | m a m ma mam |
| building | Verbundindex |
| bvnumber | BV045876335 |
| collection | ZDB-191-BEX |
| ctrlnum | (ZDB-191-BEX)11420761 (OCoLC)1000457636 (DE-599)BVBBV045876335 |
| dewey-full | 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.369 |
| dewey-search | 005.369 |
| dewey-sort | 15.369 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | First edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03947nmm a2200481zc 4500</leader><controlfield tag="001">BV045876335</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240423 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">190514s2017 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781631579479</subfield><subfield code="9">978-1-63157-947-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781631579462</subfield><subfield code="9">978-1-63157-946-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-191-BEX)11420761</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1000457636</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV045876335</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield><subfield code="a">DE-862</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-706</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.369</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mian, M. A.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Tips & tricks for Excel-based financial modeling, Volume I</subfield><subfield code="b">a must for engineers & financial analysts</subfield><subfield code="c">M. A. Mian</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Tips and tricks for Excel-based financial modeling</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">First edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York, New York (222 East 46th Street, New York, NY 10017)</subfield><subfield code="b">Business Expert Press</subfield><subfield code="c">2017</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">Online-Ressource (xi, 143 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Finance and financial management collection</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">1. Introduction -- 2. Overview of project economics -- 3. Excel's financial functions -- 4. Most used Excel functions -- 5. Data management -- 6. Evaluating data -- About the author -- Index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business enterprises / Finance / Data processing</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Electronic books</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781631579462</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000632.html</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-191-BEX</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031259553</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/BEPB0000632.html</subfield><subfield code="l">FHN01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000632.html</subfield><subfield code="l">FWS01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000632.html</subfield><subfield code="l">FWS02</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://portal.igpublish.com/iglibrary/search/BEPB0000632.html</subfield><subfield code="l">UBY01</subfield><subfield code="p">ZDB-191-BEX</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV045876335 |
| illustrated | Not Illustrated |
| indexdate | 2025-02-20T06:58:12Z |
| institution | BVB |
| isbn | 9781631579479 9781631579462 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031259553 |
| oclc_num | 1000457636 |
| open_access_boolean | |
| owner | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-92 DE-706 |
| owner_facet | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-92 DE-706 |
| physical | Online-Ressource (xi, 143 pages) |
| psigel | ZDB-191-BEX |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Business Expert Press |
| record_format | marc |
| series2 | Finance and financial management collection |
| spellingShingle | Mian, M. A. Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts Microsoft Excel (Computer file) Business enterprises / Finance / Data processing |
| title | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts |
| title_alt | Tips and tricks for Excel-based financial modeling |
| title_auth | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts |
| title_exact_search | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts |
| title_full | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts M. A. Mian |
| title_fullStr | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts M. A. Mian |
| title_full_unstemmed | Tips & tricks for Excel-based financial modeling, Volume I a must for engineers & financial analysts M. A. Mian |
| title_short | Tips & tricks for Excel-based financial modeling, Volume I |
| title_sort | tips tricks for excel based financial modeling volume i a must for engineers financial analysts |
| title_sub | a must for engineers & financial analysts |
| topic | Microsoft Excel (Computer file) Business enterprises / Finance / Data processing |
| topic_facet | Microsoft Excel (Computer file) Business enterprises / Finance / Data processing |
| url | http://portal.igpublish.com/iglibrary/search/BEPB0000632.html |
| work_keys_str_mv | AT mianma tipstricksforexcelbasedfinancialmodelingvolumeiamustforengineersfinancialanalysts AT mianma tipsandtricksforexcelbasedfinancialmodeling |