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: WhatIf Analysis
 Part Five: MultiPage Systems and Lookups
 Part Six: The Data Menu and Ribbon
 Part Seven: Excel Financial Tools
 Part Eight: Using the Solver AddIn
 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: 9781118469088