Tips & Tricks for Excel-Based Financial Modeling, Volume I: A Must for Engineers & Financial Analysts

The purpose of this work is to show some advanced concepts related to Excel based financial modelling. Microsoft Excel(TM) 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.

M. A. Mian has more than 35 years of practical experience in the oil and gas industry. He has worked with major oil companies such as Saudi Aramco and Qatar Petroleum. His working experience includes petroleum reservoir engineering and economic evaluation of multi-billion-dollar oil and gas projects. He had been involved in developing economics models for the economic evaluation of oil and gas field development projects, LNG plants, power plants, oil refineries, NGL recovery plants, and Oil & Gas fiscal regimes. He delivers short courses on project economics, risk & decision analysis (intermediate and advanced levels), and international fiscal regimes. He has delivered courses in more than 25 countries worldwide and recognized as a subject matter expert (SME) in project economics. Mian is the author of four books and technical articles. He has a BSc in mechanical engineering, MSc in petroleum engineering, and MSc in mineral economics.