Next Generation Excel Modeling in Excel for Analysts and MBAs

Name: Next Generation Excel Modeling in Excel for Analysts and MBAs
Price: 5.02 USD
Availability: InStock
ISBN: 9780470824733

ISBN-10: 0470824735

ISBN-13: 9780470824733

Edition: 2010

Authors: Isaac Gottlieb

List price: $60.00

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $5.02

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Rutgers professor, Dr. Isaac Gottlieb demonstrates an array of advanced financial and accounting functions in this practical Excel modeling book. He shows how to quickly create models that deliver accurate, relevant information related to efficiency, forecasting, and a host of other business and reporting issues. This book describes how Excel can be used efficiently to help build your spreadsheet for a variety of purposes. As an MBA student, an analyst or an executive you could become a spreadsheets expert.

Book details

List price: $60.00
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 4/28/2010
Binding: Hardcover
Pages: 348
Size: 7.40" wide x 10.31" long x 1.06" tall
Weight: 2.222
Language: English



A Word from the Author


Acknowledgments


Introduction and Overview



Using Excel Efficiently



AutoFill



Selecting Efficiently In Excel



Formulas, Functions, Relative and Absolute Addressing



Naming Cells and Ranges



Excel Charts



If Functions and Text Manipulations



If Functions



Text Manipulation



Statistical Tools



Descriptive Statistics



Frequency Distributions



Statistical Regression



Data Analysis-The Excel Easy to Use Statistics Add-in



What-If Analysis



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 Systems and Lookups



Multi-Page Budgets-Going to the Third Dimension



Lookup Tables



The Data Menu and Ribbon



Sorting Data



AutoFilter



Data Forms and Features Eliminated in Excel 2007



Group and Outline Data



Subtotals



Pivot Tables



Data Mining Using Pivot Tables



Excel Financial Tools



NPV and IRR-Evaluating Capital Investments



Unconventional Financial Functions: XNPV and XIRR



Frequency Used Financial Functions



Amortization Tables



Accounting Depreciation Functions



Using the Solver Add-In



Beyond the Goal Seek-More than One Changing Cell? Use the Solver



The Solver Add-In-Optimizer


Index