# Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)

John Wiley & Sons, Feb 4, 2013 - Business & Economics - 256 pages
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.

### What people are saying -Write a review

User Review - Flag as inappropriate

Great. With detail and pictures. very helpful. especially for anyone who is trying to be a excel Guru. :) . Seriously great book.

### Contents

 Foreword AutoFill Selecting Efficiently in Excel Formulas Functions and Relative iii Conditional and Advanced Conditional 12 Excel Charts 6-3 Sparklines and Advanced Topics in Excel 6-34 IF Functions 6-49
 Excel2011 67 Sorting Data 71 AutoFilter 83 Data Forms and Features Eliminated in Excel 93 Group and Outline Data 102 Excel Subtotals 110 Pivot Tables 123 Data Mining Using Pivot Tables 139

 Text Manipulation 6-59 Descriptive Statistics 6-74 Frequency Distributions 11-2 Data AnalysisThe Excel Easy to 7 Data AnalysisMultiRegression 19 Naming CellsFor Meaningful Decision 14-17 Sensitivity AnalysisOne and TwoWay Data 17 Using Scroll Bars for Sensitivity Analysis 33 MlmiPe Systws QLOLMLDS 49 Lookup Tables 60
 Using Slicers to Filter Pivot Tables 154 NPV and IRREvaluating Capital 162 Unconventional Financial Functions XNPV 169 Frequently Used Financial Functions 176 Accounting Depreciation Functions 193 Beyond the Goal SeekMore Than 34-3 The Solver AddlnOptimizer 34-15 Appendix Summary Case StudySupply Chain A-1 About the Author A-24 Copyright