About the Book :
Temple University professor Dr. Isaac Gottlieb demonstrates an array of advanced business decision making, 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. The manuscript and figures are both for Excel for Windows and Excel for Mac.
AutoFill Selecting Efficiently in Excel Formulas, Functions and Relative and Absolute Addressing Naming Cells and RangesConditional and Advanced Conditional Formatting in Excel Excel Charts Sparkline and Advanced Topics in Excel Charts IF FunctionsText 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 AnalysisMulti-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
About the Author :
Dr. Isaac D. Gottlieb. is a professor of Management and Statistics at the Fox Business School of Temple University and the of the China and Singapore programs. Over the last 15 years, he has taught how to use Excel -- and how to apply it effectively to various business disciplines -- to thousands of MBA and Executive MBA students at Rutgers, Temple, NYU, Columbia and other universities. He has also instructed Excel application in business settings to over 20,000 participants in corporate seminars, conferences and workshops.