Excel 2013 Data Analysis and Business Modeling

Abstract

This edition of the book contains the following changes: An explanation of Excel’s 2013 exciting Flash Fill feature. An explanation of how to delete invisible characters which often mess up calculations. An explanation of the following new Excel 2013 functions: SHEET, SHEETS, FORMULATEXT, and ISFORMULA. A simple method for listing all of a workbook’s worksheet names. A chapter describing the exciting new field of analytics. How to create PivotTables from data in disparate locations or based on another PivotTable. How to use Excel 2013’s new Timeline feature to filter PivotTables based on dates. A description of Excel 2013’s Data Model. A description of Excel 2013’s PowerPivot add-in. How to use Power View to create mind blowing charts and graphics. A new chapter on charting tricks and a general description of charting in Excel 2013. Over 30 new problems have been added.