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

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

Other editions - View all

Common terms and phrases

About the author (2013)

Dr. Isaac D. Gottlieb, PhD, is a professor of Management and Statistics at the Fox Business School of Temple University and Director of the China and Singapore programs. Also, he is a former director of the International Executive MBA at Rutgers University Business School. The recipient of numerous excellence-in-teaching awards, Dr. Gottlieb has taught how to use Excel and apply it effectively to various business disciplines to thousands of MBA and Executive MBA students at Rutgers, Temple, New York University, Columbia, and other universities. Also, he has instructed Excel for business professionals to over 20,000 participants in corporate seminars, conferences and workshops, including staff from Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Microsoft, Intel, Boeing, Chrysler, JP Morgan, Morgan Stanley, 3M and Hewlett-Packard. Dr Gottlieb has an "Excel Tip Of The Month" newsletter that goes to over 50,000 recipients.

Bibliographic information