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

Size: 42.5 MB

You Just Pay: $9

$9.00

Description

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

Take Excel to the next level in accounting and financial modeling

In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows.

While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel. * Fully updated and revised to include support for Apple users * Written by a professor of management and statistics who has taught the discipline for fifteen years * Appropriate for professional financial analysts, as well as MBA students

For professionals and students whose responsibilities or studies include a full understanding of financial modeling, Next Generation Excel, Second Edition offers comprehensive training.

 

From the Inside Flap

Most Excel users never realize just how powerful the program really is. Featuring more than 400 functions, Excel is packed with an array of complex data mining, analytical, statistical, and graphical representation tools and other powerful features of inestimable value to business professionals. But learning how to exploit those features with confidence can be tricky, even overwhelming, for the casual user.

Enter Next Generation Excel, Second Edition.

Growing out of Dr. Gottlieb’s many years of teaching university classes, as well as his extremely popular corporate workshops, Next Generation Excel, Second Edition is based upon his well-founded conviction that, when it comes to teaching people how to use and get the most out of complex software, “show, don’t tell” is the golden rule.

Staying true to that philosophy, he eschews the lengthy, often perplexing, verbal explanations typical of such guides in favor of bite-sized descriptive passages, liberally supplemented with Excel-in-action screenshots, skill-building exercises, and review questions. Also, for ease of reference, each subject-specific chapter is self-contained, affording you the option of focusing on only those features of immediate interest to you.

Demystifying the obscure and simplifying the complex, Dr. Gottlieb walks you, step by step, through all of Excel 2010’s advanced business and finance functions (with explanations for users of Excel 2007, 2003, and previous versions, as needed), including:

  • Financial tools, including NVP and IRR
  • Data mining using Pivot Tables
  • Charting, sparklines, and other advanced charting options
  • Data analysis tools
  • What-if analysis
  • Statistics for non-statisticians
  • Accounting functions, including amortization tables and depreciation functions

Not just another general how-to Excel guide, this fully updated and expanded Second Edition of Isaac Gottlieb’s internationally acclaimed Next Generation Excel shows you how to harness the full power of Excel to help you to perform an array of advanced business decision making, financial, and accounting functions. You’ll learn how to quickly create models that deliver accurate, relevant information to boost efficiency, improve your forecasting ability, and perform an array of other crucial business and reporting functions.