Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
- 3h 32m
- Isaac Gottlieb
- John Wiley & Sons (US)
- 2013
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.
About the Author
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.
In this Book
-
AutoFill
-
Selecting Efficiently in Excel
-
Formulas, Functions, and Relative and Absolute Addressing
-
Naming Cells and Ranges
-
Conditional and Advanced Conditional Formatting in Excel
-
Excel Charts
-
Sparklines and Advanced Topics in Excel Charts
-
IF Functions
-
Text Manipulation
-
Descriptive Statistics
-
Frequency Distributions
-
Statistical Regression
-
Data Analysis—The Excel Easy to Use Statistics Add-In
-
Data Analysis—Multi-Regression
-
Naming Cells—For Meaningful Decision Making and Modeling
-
What-If Analysis and Goal Seek
-
Sensitivity Analysis—One- and Two-Way Data Tables
-
Using Scroll Bars for Sensitivity Analysis
-
Multi-Page Budgets—Going to the Third Dimension
-
Lookup Tables
-
Sorting Data
-
AutoFilter
-
Data Forms and Features Eliminated in Excel 2007 and 2010
-
Group and Outline Data
-
Excel Subtotals
-
Pivot Tables
-
Data Mining Using Pivot Tables
-
Using Slicers to Filter Pivot Tables
-
NPV and IRR—Evaluating Capital Investments
-
Unconventional Financial Functions: XNPV and XIRR
-
Frequently Used Financial Functions
-
Amortization Tables
-
Accounting Depreciation Functions
-
Beyond the Goal Seek—More Than One Changing Cell? Use the Solver
-
The Solver Add-In—Optimizer
