Isaac Gottlieb – Next Generation Excel. Modeling in Excel for Analysts and MBAs

Description

Isaac Gottlieb – Next Generation Excel. Modeling in Excel for Analysts and MBAs

Take Excel to the following stage in accounting and monetary modeling

In this new Second Edition of Next Generation Excel, Isaac Gottlieb reveals monetary analysts easy methods to 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 steadiness sheets, revenue statements, and statements of money flows.

While many businesspeople are fairly acquainted with the stories created with monetary fashions, most will not be as acquainted with the creation of the fashions themselves. This e book reveals them easy methods to construct an correct and efficient monetary mannequin utilizing the stable performance and straightforward usability of Excel. * Fully up to date and revised to incorporate assist 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 duties or research embody a full understanding of economic modeling, Next Generation Excel, Second Edition presents 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 capabilities, Excel is filled with an array of advanced information mining, analytical, statistical, and graphical illustration instruments and different highly effective options of inestimable worth to enterprise professionals. But studying easy methods to exploit these options with confidence could be difficult, even overwhelming, for the informal consumer.

Enter Next Generation Excel, Second Edition.

Growing out of Dr. Gottlieb’s a few years of educating college courses, in addition to his extraordinarily standard company workshops, Next Generation Excel, Second Edition relies upon his well-founded conviction that, in terms of educating folks easy methods to 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, usually 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 evaluate questions. Also, for ease of reference, every subject-specific chapter is self-contained, affording you the choice of specializing in solely these options of instant curiosity to you.

Demystifying the obscure and simplifying the advanced, Dr. Gottlieb walks you, step-by-step, by all of Excel 2010’s superior enterprise and finance capabilities (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 capabilities, together with amortization tables and depreciation capabilities

Not simply one other common how-to Excel information, this absolutely up to date and expanded Second Edition of Isaac Gottlieb’s internationally acclaimed Next Generation Excel reveals you easy methods to harness the complete energy of Excel that will help you to carry out an array of superior enterprise choice making, monetary, and accounting capabilities. You’ll discover ways to shortly create fashions that ship correct, related data to spice up effectivity, enhance your forecasting potential, and carry out an array of different essential enterprise and reporting capabilities.