{"product_id":"next-generation-excel-isbn-9781118469101","title":"Next Generation Excel","description":"\u003cb\u003eTake Excel to the next level in accounting and financial modeling\u003c\/b\u003e \u003cp\u003eIn this new \u003ci\u003eSecond Edition\u003c\/i\u003e of \u003ci\u003eNext Generation Excel\u003c\/i\u003e, 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.\u003c\/p\u003e \u003cp\u003eWhile 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eFully updated and revised to include support for Apple users\u003c\/li\u003e \u003cli\u003eWritten by a professor of management and statistics who has taught the discipline for fifteen years\u003c\/li\u003e \u003cli\u003eAppropriate for professional financial analysts, as well as MBA students\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eFor professionals and students whose responsibilities or studies include a full understanding of financial modeling, \u003ci\u003eNext Generation Excel, Second Edition\u003c\/i\u003e offers comprehensive training.\u003c\/p\u003e  \u003cp\u003eForeword xv\u003c\/p\u003e \u003cp\u003ePreface xvii\u003c\/p\u003e \u003cp\u003eAcknowledgments xxi\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART ONE Using Excel Efficiently 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 1 AutoFill 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAutoFill Options 8\u003c\/p\u003e \u003cp\u003eRight-Drag AutoFill 8\u003c\/p\u003e \u003cp\u003eAppendix: AutoFill in Excel 2003 and Excel Mac 2011 10\u003c\/p\u003e \u003cp\u003eReview Questions 13\u003c\/p\u003e \u003cp\u003eAnswers 14\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 2 Selecting Efficiently in Excel 15\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview Questions 18\u003c\/p\u003e \u003cp\u003eAnswers 19\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 3 Formulas, Functions, and Relative and Absolute Addressing 21\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRelative and Absolute Addressing 22\u003c\/p\u003e \u003cp\u003eOther Functions 25\u003c\/p\u003e \u003cp\u003eAppendix: Doing It in Mac Excel 2011 28\u003c\/p\u003e \u003cp\u003eReview Questions 29\u003c\/p\u003e \u003cp\u003eAnswers 30\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 4 Naming Cells and Ranges 31\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNaming a Single Cell 31\u003c\/p\u003e \u003cp\u003eNaming a Range of Cells 33\u003c\/p\u003e \u003cp\u003eUsing the Name Menu to Create Names 34\u003c\/p\u003e \u003cp\u003eAppendix: Using the Names Menu in Excel 2003 and Mac Excel 2011 38\u003c\/p\u003e \u003cp\u003eReview Questions 41\u003c\/p\u003e \u003cp\u003eAnswers 42\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 5 Conditional and Advanced Conditional Formatting in Excel 45\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimple Conditional Formatting; Adding a Rule 45\u003c\/p\u003e \u003cp\u003eNew Conditional Formatting Features 46\u003c\/p\u003e \u003cp\u003eAdvanced Conditional Formatting 49\u003c\/p\u003e \u003cp\u003eAppendix: Using the Conditional Formatting in Excel 2003 52\u003c\/p\u003e \u003cp\u003eReview Questions 53\u003c\/p\u003e \u003cp\u003eAnswers 55\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 6 Excel Charts 57\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eQuick\/Instant Chart 57\u003c\/p\u003e \u003cp\u003eCreating a Chart Using the Menu 57\u003c\/p\u003e \u003cp\u003eAdding More Data to an Existing Chart 61\u003c\/p\u003e \u003cp\u003eMore about Charts 64\u003c\/p\u003e \u003cp\u003eThree-Dimensional Charts—Column and Pie 66\u003c\/p\u003e \u003cp\u003ePie Charts 70\u003c\/p\u003e \u003cp\u003eAppendix: Generating Charts in Excel 2003 and Mac Excel 2011 73\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 7 Sparklines and Advanced Topics in Excel Charts 81\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSparklines 81\u003c\/p\u003e \u003cp\u003eMore about Charts 83\u003c\/p\u003e \u003cp\u003eReview Questions 90\u003c\/p\u003e \u003cp\u003eAnswers 91\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART TWO IF Functions and Text Manipulations 93\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 8 IF Functions 95\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimple IF Functions 95\u003c\/p\u003e \u003cp\u003eNested IF Functions 98\u003c\/p\u003e \u003cp\u003eNested IF—Payroll Example 99\u003c\/p\u003e \u003cp\u003eAppendix: Using the IF Function in Mac Excel 2011 101\u003c\/p\u003e \u003cp\u003eReview Questions 102\u003c\/p\u003e \u003cp\u003eAnswers 102\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 9 Text Manipulation 103\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eText to Columns 103\u003c\/p\u003e \u003cp\u003eAppendix: Using Text to Column in Excel 2003 108\u003c\/p\u003e \u003cp\u003eReview Questions 111\u003c\/p\u003e \u003cp\u003eAnswers 112\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART THREE Statistical Tools 113\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 10 Descriptive Statistics 115\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDescriptive Statistics 115\u003c\/p\u003e \u003cp\u003eAppendix: Descriptive Statistics with the Mac Excel 2011 117\u003c\/p\u003e \u003cp\u003eReview Questions 119\u003c\/p\u003e \u003cp\u003eAnswers 119\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 11 Frequency Distributions 121\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOne More Example 126\u003c\/p\u003e \u003cp\u003eAppendix: Frequency Distributions with Mac Excel 2011 129\u003c\/p\u003e \u003cp\u003eReview Questions 129\u003c\/p\u003e \u003cp\u003eAnswers 130\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 12 Statistical Regression 131\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the Scatter Chart in Excel 131\u003c\/p\u003e \u003cp\u003eLinear Regression—Using Excel Functions 133\u003c\/p\u003e \u003cp\u003eAppendix: Using the Chart Feature to Create a\u003c\/p\u003e \u003cp\u003eTrend Line in Excel 2003 and Mac Excel 2011 137\u003c\/p\u003e \u003cp\u003eReview Questions 140\u003c\/p\u003e \u003cp\u003eAnswers 140\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 13 Data Analysis—The Excel Easy to Use Statistics Add-In 141\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDescriptive Statistics 141\u003c\/p\u003e \u003cp\u003eFrequency Distribution Using Histogram 143\u003c\/p\u003e \u003cp\u003eAppendix: Using Data Analysis in Excel Mac 2011 and Excel 2003 148\u003c\/p\u003e \u003cp\u003eReview Questions 148\u003c\/p\u003e \u003cp\u003eAnswers 149\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 14 Data Analysis—Multi-Regression 151\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimple or Single Variable Regression 151\u003c\/p\u003e \u003cp\u003eMulti-Regression 152\u003c\/p\u003e \u003cp\u003eAppendix: Using Data Analysis in Excel Mac 2011 and Excel 2003 160\u003c\/p\u003e \u003cp\u003eReview Questions 160\u003c\/p\u003e \u003cp\u003eAnswers 161\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART FOUR What-If Analysis 165\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 15 Naming Cells—For Meaningful Decision Making and Modeling 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOne More Example—If You Have a Ready Model 168\u003c\/p\u003e \u003cp\u003eAppendix: Create and Apply Names in Excel 2003 and Mac Excel 2011 170\u003c\/p\u003e \u003cp\u003eReview Questions 175\u003c\/p\u003e \u003cp\u003eAnswers 175\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 16 What-If Analysis and Goal Seek 177\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGoal Seek 178\u003c\/p\u003e \u003cp\u003eAppendix: Goal Seek in Excel 2003 and Mac Excel 2011 182\u003c\/p\u003e \u003cp\u003eReview Questions 183\u003c\/p\u003e \u003cp\u003eAnswers 183\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 17 Sensitivity Analysis—One- and Two-Way Data Tables 185\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTwo-Way Table 187\u003c\/p\u003e \u003cp\u003eData Tables—One More Example 189\u003c\/p\u003e \u003cp\u003eBreak-Even Point (BEP) Chart 190\u003c\/p\u003e \u003cp\u003eAppendix: Sensitivity Analysis—One- and Two-Way Data Tables for Excel 2003 and Mac Excel 2011 192\u003c\/p\u003e \u003cp\u003eReview Questions 193\u003c\/p\u003e \u003cp\u003eAnswers 195\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 18 Using Scroll Bars for Sensitivity Analysis 199\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eScroll Bar Limitations 203\u003c\/p\u003e \u003cp\u003eAppendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel 2011 205\u003c\/p\u003e \u003cp\u003eReview Questions 207\u003c\/p\u003e \u003cp\u003eAnswers 208\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART FIVE Multi-Page Systems and Lookups 211\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 19 Multi-Page Budgets—Going to the Third Dimension 213\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Payroll Example 213\u003c\/p\u003e \u003cp\u003eA Second Example—Bakers’ Supplies 217\u003c\/p\u003e \u003cp\u003eReview Questions 219\u003c\/p\u003e \u003cp\u003eAnswers 220\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 20 Lookup Tables 221\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRange—Approximate Match Lookup 221\u003c\/p\u003e \u003cp\u003eAn Exact Match Lookup 224\u003c\/p\u003e \u003cp\u003eReview Questions 227\u003c\/p\u003e \u003cp\u003eAnswers 228\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART SIX The Data Menu and Ribbon 229\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 21 Sorting Data 231\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSorting by Multiple Parameters 233\u003c\/p\u003e \u003cp\u003eAppendix: Sorting in Excel 2003 and Mac Excel 2011 236\u003c\/p\u003e \u003cp\u003eReview Questions 238\u003c\/p\u003e \u003cp\u003eAnswers 239\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 22 AutoFilter 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDates 241\u003c\/p\u003e \u003cp\u003eBelow and Above Average 243\u003c\/p\u003e \u003cp\u003eFilter by Color 243\u003c\/p\u003e \u003cp\u003eAppendix: AutoFilter in Excel 2003 244\u003c\/p\u003e \u003cp\u003eReview Questions 246\u003c\/p\u003e \u003cp\u003eAnswers 247\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 23 Data Forms and Features Eliminated in Excel 2007 and 2010 249\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix: The Data Form in Excel 2003 or Earlier versions and Mac Excel 2011 251\u003c\/p\u003e \u003cp\u003eReview Questions 252\u003c\/p\u003e \u003cp\u003eAnswers 253\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 24 Group and Outline Data 255\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix: Group and Outline Data Excel 2003 and Mac Excel 2011 258\u003c\/p\u003e \u003cp\u003eReview Questions 260\u003c\/p\u003e \u003cp\u003eAnswers 261\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 25 Excel Subtotals 263\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOne More Example—Function Applied to Multiple Categories 265\u003c\/p\u003e \u003cp\u003eCopying Grouped Data 265\u003c\/p\u003e \u003cp\u003eSecond Example—Larger Database 269\u003c\/p\u003e \u003cp\u003eAppendix: Creating Subtotals in Excel 2003 and Mac Excel 2011 269\u003c\/p\u003e \u003cp\u003eReview Questions 273\u003c\/p\u003e \u003cp\u003eAnswers 273\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 26 Pivot Tables 275\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePivotTable Example 275\u003c\/p\u003e \u003cp\u003eAppendix: The Pivot Table in Excel 2003 and Mac Excel 2011 282\u003c\/p\u003e \u003cp\u003eReview Questions 286\u003c\/p\u003e \u003cp\u003eAnswers 286\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 27 Data Mining Using Pivot Tables 289\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix: Advanced PivotTable Techniques in Excel 2003 296\u003c\/p\u003e \u003cp\u003eReview Questions 297\u003c\/p\u003e \u003cp\u003eAnswers 298\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 28 Using Slicers to Filter Pivot Tables 301\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFormat a Slicer 302\u003c\/p\u003e \u003cp\u003eSharing Slicers for More Than One Pivot Table 304\u003c\/p\u003e \u003cp\u003eReview Questions 305\u003c\/p\u003e \u003cp\u003eAnswers 306\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART SEVEN Excel Financial Tools 307\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 29 NPV and IRR—Evaluating Capital Investments 309\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Time Value of Money 309\u003c\/p\u003e \u003cp\u003eIRR—Internal Rate of Return 311\u003c\/p\u003e \u003cp\u003eReview Questions 313\u003c\/p\u003e \u003cp\u003eAnswers 313\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 30 Unconventional Financial Functions: XNPV and XIRR 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExcel XNPV—The Net Present Value Function for Uneven Intervals 315\u003c\/p\u003e \u003cp\u003eExcel XIRR—The Internal Rate of Return Function for Uneven Intervals 316\u003c\/p\u003e \u003cp\u003eReview Questions 318\u003c\/p\u003e \u003cp\u003eAnswers 318\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 31 Frequently Used Financial Functions 319\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimilar Excel Functions 320\u003c\/p\u003e \u003cp\u003eReview Questions 323\u003c\/p\u003e \u003cp\u003eAnswers 323\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 32 Amortization Tables 325\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAmortization Example 325\u003c\/p\u003e \u003cp\u003eReview Questions 334\u003c\/p\u003e \u003cp\u003eAnswers 334\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 33 Accounting Depreciation Functions 337\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSLD Straight Line Depreciation 337\u003c\/p\u003e \u003cp\u003eSYD Sum of the Years Digits 337\u003c\/p\u003e \u003cp\u003eReview Questions 339\u003c\/p\u003e \u003cp\u003eAnswers 339\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePART EIGHT Using the Solver Add-In 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 34 Beyond the Goal Seek—More Than One Changing Cell? Use the Solver 343\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExample—Break-Even Point 343\u003c\/p\u003e \u003cp\u003eUsing the Solver 343\u003c\/p\u003e \u003cp\u003eAppendix: Using the Solver in Excel 2003 and Mac Excel 2011 349\u003c\/p\u003e \u003cp\u003eReview Questions 350\u003c\/p\u003e \u003cp\u003eAnswers 352\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 35 The Solver Add-In—Optimizer 353\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSolver Example 353\u003c\/p\u003e \u003cp\u003eNonlinear Example Using the Solver 355\u003c\/p\u003e \u003cp\u003eAppendix: Using the Solver in Excel 2003 and Mac 2011 360\u003c\/p\u003e \u003cp\u003eReview Questions 360\u003c\/p\u003e \u003cp\u003eAnswers 360\u003c\/p\u003e \u003cp\u003eAppendix Summary Case Study—Supply Chain Management Example 365\u003c\/p\u003e \u003cp\u003eAbout the Author 385\u003c\/p\u003e \u003cp\u003eIndex 387\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eDr. Isaac D. Gottlieb, PhD\u003c\/b\u003e, 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 \u0026amp; Johnson, Merck, Pfizer, Procter \u0026amp; 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.\u003c\/p\u003e \u003cp\u003eMost Excel users never realize just how powerful the program really is. Featuring more than 400 functions, Excel is packed with an array of complex data mining, analytical, statistical, and graphical representation tools and other powerful features of inestimable value to business professionals. But learning how to exploit those features with confidence can be tricky, even overwhelming, for the casual user.\u003c\/p\u003e \u003cp\u003eEnter \u003ci\u003eNext Generation Excel, Second Edition.\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003eGrowing out of Dr. Gottlieb's many years of teaching university classes, as well as his extremely popular corporate workshops, \u003ci\u003eNext Generation Excel, Second Edition\u003c\/i\u003e is based upon his well-founded conviction that, when it comes to teaching people how to use and get the most out of complex software, \"show, don't tell\" is the golden rule.\u003c\/p\u003e \u003cp\u003eStaying true to that philosophy, he eschews the lengthy, often perplexing, verbal explanations typical of such guides in favor of bite-sized descriptive passages, liberally supplemented with Excel-in-action screenshots, skill-building exercises, and review questions. Also, for ease of reference, each subject-specific chapter is self-contained, affording you the option of focusing on only those features of immediate interest to you.\u003c\/p\u003e \u003cp\u003eDemystifying the obscure and simplifying the complex, Dr. Gottlieb walks you, step by step, through all of Excel 2010's advanced business and finance functions (with explanations for users of Excel 2007, 2003, and previous versions, as needed), including:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eFinancial tools, including NVP and IRR\u003c\/li\u003e \u003cli\u003eData mining using Pivot Tables\u003c\/li\u003e \u003cli\u003eCharting, sparklines, and other advanced charting options\u003c\/li\u003e \u003cli\u003eData analysis tools\u003c\/li\u003e \u003cli\u003eWhat-if analysis\u003c\/li\u003e \u003cli\u003eStatistics for non-statisticians\u003c\/li\u003e \u003cli\u003eAccounting functions, including amortization tables and depreciation functions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eNot just another general how-to Excel guide, this fully updated and expanded \u003ci\u003eSecond Edition\u003c\/i\u003e of Isaac Gottlieb's internationally acclaimed \u003ci\u003eNext Generation Excel\u003c\/i\u003e shows you how to harness the full power of Excel to help you to perform an array of advanced business decision making, financial, and accounting functions. You'll learn how to quickly create models that deliver accurate, relevant information to boost efficiency, improve your forecasting ability, and perform an array of other crucial business and reporting functions.\u003c\/p\u003e  \u003cp\u003eAdvance Praise for \u003ci\u003eNext Generation Excel, Second Edition\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\"As an avid user of Excel, I rely on Isaac's 'Excel Tip Of The Month' newsletter, which reflects his teaching methods and ability to clearly present ideas and topics. In his newest book, Isaac showcases how the reader can engage with Excel to the 'next level of usability.' This edition helps intermediate users to quickly acquire 'pro Excel' skills, while enabling advanced users to grasp concepts in a single pass-through. Isaac takes day-to-day Excel challenges and provides the reader with elegant ease of use solutions. With this newest edition, Isaac propels practical information even further.\"\u003cbr\u003e \u003cb\u003e—Moshe Castiel, Vice President, Data Management and Analytics, JPMorgan Chase\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"If you thought MS Excel was nothing more than an overpriced calculator with a pretty chart wizard thrown in, then hold your hat and get ready for some fun. \u003ci\u003eNext Generation Excel\u003c\/i\u003e will revolutionize how you do your work and make you a better manager, at any career level.\"\u003cbr\u003e \u003cb\u003e—John Tintera, VP, Sales \u0026amp; Publicity, Osprey Group\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"A detailed understanding of Excel is critical to the performance of nearly all financial analysts today. Dr. Gottlieb's book not only describes the most important Excel functions, but also dramatically increases the productivity of Excel users. My favorite parts of the book include the sections on Solver, Pivot Tables, and Sensitivity Analysis. Each of these areas is critical to the work done by advanced financial analysts. Companies are expecting more from their MBA hires today, and this book can give recent graduates a leg up on the competition.\"\u003cbr\u003e \u003cb\u003e—John M. Longo, PhD, CFA, Clinical AssociateProfessor of Finance and Economics, Rutgers Business School; Chief Investment Officer, The MDE Group, Inc.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\"Isaac Gottlieb is an Excel master and a teacher par excellence. The \u003ci\u003esecond edition\u003c\/i\u003e of \u003ci\u003eNext Generation Excel\u003c\/i\u003e improves on an already excellent first edition. New materials like multi regression simplified and the new Excel 2010 features make this an invaluable resource for the Excel user. Mac users (a growing group) will like the chapter appendices dedicated to making their lives easier.\"\u003cbr\u003e \u003cb\u003e— Simon Benninga, Professor, Faculty of Management, Tel Aviv University\u003c\/b\u003e\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989689581797,"sku":"NP9781118469101","price":115.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118469101.jpg?v=1761785114","url":"https:\/\/k12savings.com\/es\/products\/next-generation-excel-isbn-9781118469101","provider":"K12savings","version":"1.0","type":"link"}