Book description
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.
Table of contents
- Cover
- Contents
- Title
- Dedication
- Copyright
- Foreword
- 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
- Part Three: Statistical Tools
- Part Four: What-If Analysis
- Part Five: Multi-Page Systems and Lookups
- Part Six: The Data Menu and Ribbon
- Part Seven: Excel Financial Tools
- Part Eight: Using the Solver Add-In
- Appendix: A Summary Case Study
- About the Author
- Index
Product information
- Title: Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
- Author(s):
- Release date: March 2013
- Publisher(s): Wiley
- ISBN: 9781118469101
You might also like
book
MS Excel, Second Edition, 2nd Edition
MS Excel is one of the most powerful tools available to a business manager. In this …
book
Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook
is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO …
book
Statistical Analysis: Microsoft® Excel® 2013
Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to …
book
Financial Modeling in Excel For Dummies
Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling …