Next Generation Excel + Website: Modeling in Excel for Analysts and MBAs (for MS Windows and Mac OS)

Author(s): Isaac Gottlieb

Computers

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.

$163.95 AUD

Stock: 0


Add to Wishlist


Product Information

Preface Acknowledgments Part One Using Excel Efficiently Chapter 1 AutoFill Chapter 2 Selecting Efficiently In Excel Chapter 3 Formulas, Functions, and Relative and Absolute Addressing Chapter 4 Naming Cells and Ranges Chapter 5 Conditional and Advanced Conditional Formatting in Excel Chapter 6 Excel Charts Chapter 7 Sparklines and Advanced Topics in Excel Charts Part Two IF Functions and Text Manipulations Chapter 8 IF Functions Chapter 9 Text Manipulation Part Three Statistical Tools Chapter 10 Descriptive Statistics Chapter 11 Frequency Distributions Chapter 12 Statistical Regression Chapter 13 Data Analysis--The Excel Easy to Use Statistics Add-in Chapter 14 Data Analysis -- Multi-Regression Part Four What-if Analysis Chapter 15 Naming Cells--for Meaningful Decision Making and Modeling Chapter 16 What-if Analysis and Goal Seek Chapter 17 Sensitivity Analysis--One- and Two-way Data Tables Chapter 18 Using Scroll Bars for Sensitivity Analysis Part Five Multi-Page Systems and Lookups Chapter 19 Multi-Page Budgets--Going to the Third Dimension Chapter 20 Lookup Tables Part Six The Data Menu and Ribbon Chapter 21 Sorting Data Chapter 22 Auto Filter Chapter 23 Data Forms and Features Eliminated in Excel 2007 and 2010 Chapter 24 Group and Outline Data Chapter 25 Excel Subtotals Chapter 26 Pivot Tables Chapter 27 Data Mining Using Pivot Tables Chapter 28 Using Slicers to Filter Pivot Tables Part Seven Excel Financial Tools Chapter 29 NPV and IRR--Evaluating Capital Investments Chapter 30 Unconventional Financial Functions: XNPV and XIRR Chapter 31 Frequently Used Financial Functions Chapter 32 Amortization Tables Chapter 33 Accounting Depreciation Functions Part Eight Using the Solver Add-In Chapter 34 Beyond the Goal Seek--More Than One Changing Cell? Use the Solver Chapter 35 The Solver Add-In--Optimizer Appendix A Summary Case Study - Supply Chain Management Example About the Author Index

General Fields

  • : 9781118469101
  • : John Wiley & Sons Inc
  • : John Wiley & Sons Inc
  • : Contains Hardback and Online resource
  • : 0.666
  • : February 2013
  • : 254mm X 185mm X 41mm
  • : United States
  • : April 2013
  • : books

Special Fields

  • : Isaac Gottlieb
  • : Mixed media product
  • : 2nd Revised edition
  • : 657.0285554
  • : 416