Next Generation Excel (eBook)
416 Seiten
John Wiley & Sons (Verlag)
978-1-118-46909-5 (ISBN)
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.
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.
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
Chapter 8
IF Functions
Chapter 9
Text Manipulation
Part Three
Statistical Tools
Chapter 10
Descriptive Statistics
Chapter 11
Frequency Distributions
Chapter 12
Statistical Regression
Chapter 13
Data Analysis--The Excel Easy to Use Statistics Add-in
Chapter 14
Data Analysis - Multi-Regression
Part Four
What-if Analysis
Chapter 15
Naming Cells--for Meaningful Decision Making and Modeling
Chapter 16
What-if Analysis and Goal Seek
Chapter 17
Sensitivity Analysis--One- and Two-way Data Tables
Chapter 18
Using Scroll Bars for Sensitivity Analysis
Part Five
Multi-Page Systems and Lookups
Chapter 19
Multi-Page Budgets--Going to the Third Dimension
Chapter 20
Lookup Tables
Part Six
The Data Menu and Ribbon
Chapter 21
Sorting Data
Chapter 22
Auto Filter
Chapter 23
Data Forms and Features Eliminated in Excel 2007 and 2010
Chapter 24
Group and Outline Data
Chapter 25
Excel Subtotals
Chapter 26
Pivot Tables
Chapter 27
Data Mining Using Pivot Tables
Chapter 28
Using Slicers to Filter Pivot Tables
Part Seven
Excel Financial Tools
Chapter 29
NPV and IRR--Evaluating Capital Investments
Chapter 30
Unconventional Financial Functions: XNPV and XIRR
Chapter 31
Frequently Used Financial Functions
Chapter 32
Amortization Tables
Chapter 33
Accounting Depreciation Functions
Part Eight
Using the Solver Add-In
Chapter 34
Beyond the Goal Seek--More Than One Changing Cell? Use the Solver
Chapter 35
The Solver Add-In--Optimizer
Appendix A
Summary Case Study - Supply Chain Management Example
About the Author
Index
Erscheint lt. Verlag | 4.2.2013 |
---|---|
Reihe/Serie | Wiley Finance Editions | Wiley Finance Editions |
Sprache | englisch |
Themenwelt | Sachbuch/Ratgeber ► Beruf / Finanzen / Recht / Wirtschaft ► Geld / Bank / Börse |
Informatik ► Office Programme ► Excel | |
Recht / Steuern ► Wirtschaftsrecht | |
Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung | |
Schlagworte | Finance & Investments • Finanz- u. Anlagewesen • Institutional & Corporate Finance • Institutionelle Finanzplanung |
ISBN-10 | 1-118-46909-7 / 1118469097 |
ISBN-13 | 978-1-118-46909-5 / 9781118469095 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 129,3 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich