Book description
The purpose of this work is to show some advanced concepts related to Excel based financial modelling. Microsoft Excel™ is a very powerful tool and most of the time we do not utilize its full potential. 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. 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 how 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.
Product information
- Title: Tips & Tricks for Excel-Based Financial Modeling, Volume II
- Author(s):
- Release date: July 2017
- Publisher(s): Business Expert Press
- ISBN: 9781631579493
You might also like
book
Tips & Tricks for Excel-Based Financial Modeling, Volume I
The purpose of this work is to show some advanced concepts related to Excel based financial …
book
Excel® 2007 PivotTables and PivotCharts
Though many consumers know the basics of using Excel, few users understand the powerful capabilities of …
book
John Walkenbach's Favorite Excel 2010 Tips and Tricks
Build robust Excel 2010 apps quickly and efficiently Known as "Mr. Spreadsheet," John Walkenbach's name is …
book
iLife '04: The Missing Manual
iLife '04: The Missing Manual gives you everything you need to unleash your creative genius with …