Isaac Gottlieb – Next Generation Excel. Modeling in Excel for Analysts and MBAs
Take Excel to the following degree in accounting and monetary modeling
In this new Second Edition of Next Generation Excel, Isaac Gottlieb exhibits monetary analysts harness the complete energy of Excel to maneuver ahead into the brand new world of accounting and finance. Companies of all sizes use monetary fashions to investigate their funds and plan enterprise operations, in addition to to create monetary accounting stories like stability sheets, revenue statements, and statements of money flows.
While many businesspeople are fairly conversant in the stories created with monetary fashions, most usually are not as conversant in the creation of the fashions themselves. This guide exhibits them construct an correct and efficient monetary mannequin utilizing the strong performance and simple usability of Excel. * Fully up to date and revised to incorporate help for Apple customers * Written by a professor of administration and statistics who has taught the self-discipline for fifteen years * Appropriate for skilled monetary analysts, in addition to MBA college students
For professionals and college students whose tasks or research embrace a full understanding of economic modeling, Next Generation Excel, Second Edition provides complete coaching.
From the Inside Flap
Most Excel customers by no means understand simply how highly effective this system actually is. Featuring greater than 400 features, Excel is full of an array of advanced knowledge mining, analytical, statistical, and graphical illustration instruments and different highly effective options of inestimable worth to enterprise professionals. But studying exploit these options with confidence could be tough, even overwhelming, for the informal consumer.
Enter Next Generation Excel, Second Edition.
Growing out of Dr. Gottlieb’s a few years of instructing college courses, in addition to his extraordinarily widespread company workshops, Next Generation Excel, Second Edition is predicated upon his well-founded conviction that, in relation to instructing folks use and get essentially the most out of advanced software program, “show, don’t tell” is the golden rule.
Staying true to that philosophy, he eschews the prolonged, typically perplexing, verbal explanations typical of such guides in favor of bite-sized descriptive passages, liberally supplemented with Excel-in-action screenshots, skill-building workout routines, and overview questions. Also, for ease of reference, every subject-specific chapter is self-contained, affording you the choice of specializing in solely these options of quick curiosity to you.
Demystifying the obscure and simplifying the advanced, Dr. Gottlieb walks you, step-by-step, via all of Excel 2010’s superior enterprise and finance features (with explanations for customers of Excel 2007, 2003, and earlier variations, as wanted), together with:
- Financial instruments, together with NVP and IRR
- Data mining utilizing Pivot Tables
- Charting, sparklines, and different superior charting choices
- Data evaluation instruments
- What-if evaluation
- Statistics for non-statisticians
- Accounting features, together with amortization tables and depreciation features
Not simply one other normal how-to Excel information, this absolutely up to date and expanded Second Edition of Isaac Gottlieb’s internationally acclaimed Next Generation Excel exhibits you harness the complete energy of Excel that will help you to carry out an array of superior enterprise resolution making, monetary, and accounting features. You’ll discover ways to shortly create fashions that ship correct, related data to spice up effectivity, enhance your forecasting capacity, and carry out an array of different essential enterprise and reporting features.