Next Generation Excel +Website : Modeling in Excel for Analysts and MBAs (for MS Windows and Mac OS).
Title:
Next Generation Excel +Website : Modeling in Excel for Analysts and MBAs (for MS Windows and Mac OS).
Author:
Gottlieb, Isaac.
ISBN:
9781118469088
Personal Author:
Edition:
2nd ed.
Physical Description:
1 online resource (490 pages)
Series:
Wiley Finance Ser.
Contents:
Next Generation Excel®: Modeling in Microsoft® Excel® for Analysts and MBAs (for Windows® and Mac® OS) -- Copyright -- Contents -- Foreword -- Preface -- Who Should Read This Book? -- Overview of the Contents -- Additional Materials -- Acknowledgments -- Part One: Using Excel Efficiently -- Chapter 1: AutoFill -- AutoFill Options -- Right-Drag AutoFill -- Appendix: AutoFill in Excel 2003 and Excel Mac 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions -- Answers -- Chapter 2: Selecting Efficiently in Excel -- Review Questions -- Answers -- Chapter 3: Formulas, Functions, and Relative and Absolute Addressing -- Relative and Absolute Addressing -- Other Functions -- Appendix: Doing It in Mac Excel 2011 -- Review Questions -- Answers -- Chapter 4: Naming Cells and Ranges -- Naming a Single Cell -- Naming a Range of Cells -- Using the Name Menu to Create Names -- More About Names -- Appendix: Using the Names Menu in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Excel Mac 2011 -- Review Questions -- Answers -- Chapter 5: Conditional and Advanced Conditional Formatting in Excel -- Simple Conditional Formatting -- Adding a Rule -- New Conditional Formatting Features -- Advanced Conditional Formatting -- Appendix: Using the Conditional Formatting in Excel 2003 -- Review Questions -- Answers -- Chapter 6: Excel Charts -- Quick/Instant Chart -- Creating a Chart Using the Menu -- Adding More Data to an Existing Chart -- Very Important Facts about All Excel Charts: Selecting a Series -- More about Charts -- Scatter Charts and Line Charts -- Three-Dimensional Charts-Column and Pie -- Pie Charts -- Appendix: Generating Charts in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Chapter 7: Sparklines and Advanced Topics in Excel Charts -- Sparklines -- More about Charts -- Surface Charts -- Animating Charts -- Review Questions -- Answers.
Part Two: IF Functions and Text Manipulations -- Chapter 8: IF Functions -- Simple IF Functions -- Nested IF Functions -- Nested IF-Payroll Example -- Appendix: Using the IF Function in Mac Excel 2011 -- Review Questions -- Answers -- Chapter 9: Text Manipulation -- Text to Columns -- Opening Text Files -- One More Example -- Appendix: Using Text to Column in Excel 2003 -- Opening Text Files in Excel 2003 -- Opening Text Files in the Mac 2011 -- Review Questions -- Answers -- Part Three: Statistical Tools -- Chapter 10: Descriptive Statistics -- Descriptive Statistics -- Appendix: Descriptive Statistics with the Mac Excel 2011 -- Review Questions -- Answers -- Chapter 11: Frequency Distributions -- One More Example -- Appendix: Frequency Distributions with Mac Excel 2011 -- Review Questions -- Answers -- Chapter 12: Statistical Regression -- Using the Scatter Chart in Excel -- Linear Regression-Using Excel Functions -- One More Example -- Appendix: Using the Chart Feature to Create a Trend Line in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions -- Answers -- Chapter 13: Data Analysis-The Excel Easy to Use Statistics Add-In -- Descriptive Statistics -- Frequency Distribution Using Histogram -- One More Example -- Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003 -- Review Questions -- Answers -- Chapter 14: Data Analysis-Multi-Regression -- Simple or Single Variable Regression -- Multi-Regression -- Appendix: Using Data Analysis in Excel Mac and Excel 2003 -- Review Questions -- Answers -- Part Four: What-If Analysis -- Chapter 15: Naming Cells-For Meaningful Decision Making and Modeling -- One More Example-If You Have a Ready Model -- Appendix: Create and Apply Names in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- One More Example-If You Have a Ready Model -- Mac Excel 2011 -- Review Questions.
Answers -- Chapter 16: What-If Analysis and Goal Seek -- Goal Seek -- One More Example-Break-Even Point Analysis -- Appendix: Goal Seek in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions -- Answers -- Chapter 17: Sensitivity Analysis-One-and Two-Way Data Tables -- Two-Way Table -- Data Tables-One More Example -- Break-Even Point (BEP) Chart -- Appendix: Sensitivity Analysis-One-and Two-Way Data Tables for Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions -- Answers -- Chapter 18: Using Scroll Bars for Sensitivity Analysis -- Scroll Bar Limitations -- Appendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel 2011 -- Excel 2003 -- Excel 2007 -- Mac Excel 2011 -- Review Questions -- Answers -- Part Five: Multi-Page Systems and Lookups -- Chapter 19: Multi-Page Budgets-Going to the Third Dimension -- A Payroll Example -- A Second Example-Bakers' Supplies -- Review Questions -- Answers -- Chapter 20: Lookup Tables -- Range-Approximate Match Lookup -- An Exact Match Lookup -- Review Questions -- Answers -- Part Six: The Data Menu and Ribbon -- Chapter 21: Sorting Data -- Sorting by Multiple Parameters -- More about Sorting -- Sort by Color in Excel 2010 and 2007 -- Appendix: Sorting in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Excel 2011 -- Review Questions -- Answers -- Chapter 22: AutoFilter -- Dates -- Below and Above Average -- Filter by Color -- Appendix: AutoFilter in Excel 2003 -- Review Questions -- Answers -- Chapter 23: Data Forms and Features Eliminated in Excel 2007 and 2010 -- Appendix: The Data Form in Excel 2003 or Earlier versions and Mac Excel 2011 -- Excel 2003 -- Excel 2011 -- Review Questions -- Answers -- Chapter 24: Group and Outline Data -- Appendix: Group and Outline Data Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions.
Answers -- Chapter 25: Excel Subtotals -- One More Example-Function Applied to Multiple Categories -- Copying Grouped Data -- Second Example-Larger Database -- Appendix: Creating Subtotals in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Visible Cells Only Icon in Excel 2003 -- Excel 2011 -- Visible Cells Only Icon in Excel 2011 -- Review Questions -- Answers -- Chapter 26: Pivot Tables -- PivotTable Example -- Appendix: The Pivot Table in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Excel 2011 -- Review Questions -- Answers -- Chapter 27: Data Mining Using Pivot Tables -- Appendix: Advanced PivotTable Techniques in Excel 2003 -- Review Questions -- Answers -- Chapter 28: Using Slicers to Filter Pivot Tables -- Format a Slicer -- Sharing Slicers for More Than One Pivot Table -- Review Questions -- Answers -- Part Seven: Excel Financial Tools -- Chapter 29: NPV and IRR-Evaluating Capital Investments -- The Time Value of Money -- NPV-Net Present Value -- Excel NPV-Net Present Value Function -- IRR-Internal Rate of Return -- An Example Using the IRR function -- Review Questions -- Answers -- Chapter 30: Unconventional Financial Functions: XNPV and XIRR -- Excel XNPV-The Net Present Value Function for Uneven Intervals -- Excel XIRR-The Internal Rate of Return Function for Uneven Intervals -- Review Questions -- Answers -- Chapter 31: Frequently Used Financial Functions -- Similar Excel Functions -- PV-Present Value -- FV-Future Value -- NPER-Number of Periods -- Rate -- Review Questions -- Answers -- Chapter 32: Amortization Tables -- Amortization Example -- The Amortization Table -- Principal-PPMT Function -- Interest-IPMT Function -- CUMIPMT and CUMPRINC -- Review Questions -- Answers -- Chapter 33: Accounting Depreciation Functions -- SLD Straight Line Depreciation -- SYD Sum of the Years Digits -- Review Questions -- Answers.
Part Eight: Using the Solver Add-In -- Chapter 34: Beyond the Goal Seek-More Than One Changing Cell? Use the Solver -- Example-Break-Even Point -- Using the Solver -- Appendix: Using the Solver in Excel 2003 and Mac Excel 2011 -- Excel 2003 -- Mac Excel 2011 -- Review Questions -- Answers -- Chapter 35: The Solver Add-In-Optimizer -- Solver Example -- Nonlinear Example Using the Solver -- Appendix: Using the Solver in Excel 2003 and Mac 2011 -- Review Questions -- Answers -- Appendix: Summary Case Study-Supply Chain Management Example -- The Problem -- Calculating the Basics -- Creating a Chart -- Finding the Optimal Solution -- Solution Sensitivity Analysis -- Adding Scroll Bars to Animate the Chart -- Using Advanced Chart Features -- Review Questions -- Answers -- About the Author -- Index.
Abstract:
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.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View