Amazon cover image
Image from Amazon.com

Tips & tricks for Excel-based financial modeling : a must for engineers & financial analysts M. A. Mian.

By: Material type: TextTextSeries: Publication details: New York, New York (222 East 46th Street, New York, NY 10017) : Business Expert Press, (c)2017.Edition: First editionDescription: 1 online resource (xi, 139 pages) : illustrationsContent type:
  • text
Media type:
  • computer
Carrier type:
  • online resource
ISBN:
  • 9781631579493
Other title:
  • Tips and tricks for Excel-based financial modeling : a must for engineers & financial analysts Volume II
Subject(s): Genre/Form: LOC classification:
  • HF5548 .T577 2017
Online resources: Available additional physical forms:
Contents:
2. Using Excel's data tab -- 3. Presenting information using charts -- 4. Automating worksheets -- About the author -- Index.
Abstract: 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.
List(s) this item appears in: IZZY- duplicates
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number URL Status Date due Barcode
Online Book (LOGIN USING YOUR MY CIU LOGIN AND PASSWORD) Online Book (LOGIN USING YOUR MY CIU LOGIN AND PASSWORD) G. Allen Fleece Library Non-fiction HF5548.4.M523 (Browse shelf(Opens below)) Link to resource Available 11420760

1. Creating dropdown lists -- 2. Using Excel's data tab -- 3. Presenting information using charts -- 4. Automating worksheets -- 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.

COPYRIGHT NOT covered - Click this link to request copyright permission:

https://lib.ciu.edu/copyright-request-form

Mode of access: World Wide Web.

System requirements: Adobe Acrobat reader.

Title from PDF title page (viewed on August 11, 2017).

There are no comments on this title.

to post a comment.