1 / 79

Overview

New Excel 2013 Data Capabilities. Overview . Data. New Excel 2013 Features. Basic level. DAX FORMULAS FOR PowerPivot, Rob Collie, p.10. Quick Analysis. Quick Analysis. Excel 2013 Data Capabilities. INQUIRE. INQUIRE. File/Options/Add-ins/COM . INQUIRE. Workbook Analysis Report.

keisha
Download Presentation

Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. New Excel 2013 Data Capabilities Overview

  2. Data

  3. New Excel 2013 Features Basic level

  4. DAX FORMULAS FOR PowerPivot, Rob Collie, p.10

  5. Quick Analysis

  6. Quick Analysis

  7. Excel 2013 Data Capabilities

  8. INQUIRE

  9. INQUIRE • File/Options/Add-ins/COM

  10. INQUIRE

  11. Workbook Analysis Report Excel Help – Analyze a workbook

  12. Workbook Relationships Excel Help - What you can do with Spreadsheet Inquire

  13. Worksheet Relationships http://www.microsofttraining.net/b/exceltraining/2013/04/excel-2013-audit-your-spreadsheet-with-the-inquire-add-in/

  14. Recommended PivotTables

  15. Recommended PivotTables

  16. Recommended Charts

  17. Recommended Charts

  18. Recommended Charts

  19. One step up Power User Basic Excel

  20. New Excel Features Power User

  21. >300 Million Excel users worldwide • Those who create Pivot Tables • 10% - Pivot Pros (Rob Collie)

  22. Microsoft’s 4 BICapabilities • Power Query • Power Map • Power Pivot • Power View

  23. Excel 2013 Data Capabilities

  24. Power Query

  25. Power Query

  26. Power Query

  27. Power Query 32 or 64 bit

  28. Power Query

  29. Table format

  30. Power Map (GeoFlow) • 3-D data visualization of data sets

  31. Power Map (GeoFlow) • Download

  32. Power Map (GeoFlow)

  33. Power Map

  34. % Population 65 and Older by Locality

  35. % People in Poverty by State

  36. Another step up Power Pro Power User Basic Excel

  37. New Excel Features Power Pro

  38. Power Pivot • “The best thing to happen to Excel in 20 years.” • Bill Jelen, Mr. Excel “This is the rare technology that can (and will) fundamentally change the lives of millions of people.” Rob Collie, PowerPivotPro

  39. Power Pivot • By far, the biggest “competitor” to Power Pivot is…  • In other words, lack of awareness that Power Pivot even EXISTS is still the biggest “competitor” to Power Pivot today. Excel itself. http://www.powerpivotpro.com/2014/01/what-is-power-pivots-1-competitor/#more-8854

  40. Power Pivot

  41. Power Pivot • File/Options/Add-ins/COM Add-Ins

  42. Power Pivot

  43. PowerPivot Features • Filter data • Rename tables and columns • Manage model • Create relationships • Apply formatting • Define calculated fields

  44. DAX FORMULAS FOR PowerPivot, Rob Collie, p.10

  45. DAX FORMULAS FOR PowerPivot, Rob Collie, p.11

More Related