Excel 2013 Functionality and New Data Capability Overview - Course Technology Computing Conference

40 %
60 %
Information about Excel 2013 Functionality and New Data Capability Overview - Course...
Education

Published on March 20, 2014

Author: CengageLearning

Source: slideshare.net

Description

Excel 2013 Functionality and New Data Capability Overview - Course Technology Computing Conference

Presenter: Wilma Andrews & Bob Andrews, Virginia Commonwealth University

This session will discuss and demonstrate some of the 2013 Excel functionality and exciting new features available through the Professional Plus version. These features expand the capability to obtain, manage, analyze and visualize data. Most of these capabilities are activated thru add-ins or downloads. This session will provide an overview of Recommended PivotTables, Recommended Charts, Office Apps, PowerView, PowerPivot, PowerMap (GeoFlow), PowerQuery, and Inquire. Selected features will be demonstrated live during the session. Installation/download information will be provided to attendees. The goal of the session is for participants to be aware of and understand how these expanded Excel 2013 capabilities can be used.

Excel 2013 New Data Capability Overview Bob & Wilma Andrews Virginia Commonwealth University

OVERVIEW New Excel 2013 Data Capabilities

Session Awareness of data capabilities of Excel 2013 Professional Plus/Office 365

Data obtain manage analyze visualize

Excel 2013 Data Capabilities Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Power Pivot X X Power View X X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Power Pivot X X Power View X X Commercial Add-Ins X X Apps for Office X X

BASIC LEVEL New Excel 2013 Features

INQUIRE Analyze workbook for problems or inconsistencies See links between workbooks, worksheets or cells Compare versions of workbook - graphical dependency maps Worksheet relationship diagram

INQUIRE Add-in Turn on at Options/Add-ins/COM

INQUIRE Workbook analysis Show workbook links Relationships – workbook, works heet, cells Compare files Clean excess cell formatting Manage passwords

Workbook Analysis Report Excel Help – Analyze a workbook

Excel Help - What you can do with Spreadsheet Inquire Relationships

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

Recommended PivotTables

Recommended PivotTables

Recommended Charts

Recommended Charts

Recommended Charts

POWER USER New Excel Features

Basic Excel Power User One step up

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

Microsoft’s 4 BICapabilities Power Query Power Map Power Pivot Power View

Excel 2013 Data Capabilities Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Power Pivot X X Power View X X Obtain Manage Analyze Visualize Inquire X Recommended PivotTables X Recommended Charts X Power Query X Power Map X Power Pivot X X Power View X X Commercial Add-Ins X X Apps for Office X X

Power Query Data discovery and query tool Enhances self-service BI experience Public search feature

Power Query

Power Query

Power Query 32 or 64 bit

Power Query

Table format

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

Power Map (GeoFlow) Download

Power Map (GeoFlow)

Power Map

% Population 65 and Older by Locality

% People in Poverty by State

POWER PRO New Excel Features

Basic Excel Power User Another step up Power Pro

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

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. http://www.powerpivotpro.com/2014/01/what-is-power-pivots-1-competitor/#more-8854 Excel itself.

Power Pivot Handles massive volumes of data Builds on known pivot table skills Possible multi-table pivots “Save As” - for interactive web application

Power Pivot Add-in File/Options/Add-ins/COM Add-Ins

Power Pivot

DAX FORMULAS FOR PowerPivot, Rob Collie, p.10

DAX FORMULAS FOR PowerPivot, Rob Collie, p.11

Power Query vs Power Pivot Power Query - discover, connect to, and import data. Power Pivot - model imported data Both use Excel data in Excel to explore and visualize with Power Map, Power View, PivotTables and Pivot Charts.

Power View Explore Visualize Present

Power View Power Pivot models intuitive data visualization Joins data together in a cohesive unit = data model Data models created behind the scenes between tables and relationships

Data Model a new approach for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook

Power View Charts Filtering Slicers Sorting Reports with multiple views

Power View Add-in File/Options/Add-ins/COM Add-Ins

Power View

MICROSOFT’S POSITION IN BUSINESS INTELLIGENCE

Microsoft’s 4 BICapabilities Power Query Power Map Power Pivot Power View

Magic Quadrant for Business Intelligence

ADDITIONAL ADD-INS/DOWNLOADS

Commercial Excel Add-ins JMP - http://www.jmp.com/support/help/Import_Data_Using_the_Excel_Add-In.shtml StatTools - https://www.palisade.com/stattools/ XLMiner - http://www.solver.com/xlminer-data-mining XLSTAT - http://www.xlstat.com/en/ http://www.jmp.com/support/help/Import_Data_Using_the_Excel_Add-In.shtml http://www.jmp.com/support/help/Import_Data_Using_the_Excel_Add-In.shtml

Apps for Office

Apps for Office

Apps for Office

Apps for Office

Microsoft Support site

Videos at Excel/New

Excel Videos

Excel Videos

Resources Bill Jelen – Mr. Excel http://www.youtube.com/user/bjele123

Resources Mike Girven - Excel is Fun http://www.youtube.com/user/ExcelIsFun

Resources Rob Collie – powerpivotpro.com http://www.youtube.com/channel/UCoZckhwYkolkjBIdVXpSNSg

Resources Visualizing Data with Microsoft Power View, Larson, Davis, English and Purington Dax Formulas for PowerPivot, Collie Microsoft Excel 2013, Building Data Models with PowerPivot, Ferrai and Russo Microsoft websites videos

Lots to learn…..

Add a comment

Related presentations

Related pages

Content Index - technet.microsoft.com

... Microsoft deployed its new data warehouse technology. ... What's New in Excel 2013 ... level overview of the exciting new features in the ...
Read more

Microsoft Research Lab – Asia

Urban Computing group aims to solve urban challenges using a diversity of big data and computing technology. ... Computing Conference, ... new data formats ...
Read more

Business Intelligence and Analytics | Tableau Software

... and resources by capability and department ... examples, and resources by data source and technology. Learn More. More ... What's new in DATA ...
Read more

Database - Microsoft Research

New England Lab ... ACM SIGMOD International Conference on Management of Data (SIGMOD 2013), ... on Internet Technology,, Association for Computing ...
Read more

What's new in web content management for SharePoint 2013 ...

... Learn about web content management ... see Desktop Experience Overview. In SharePoint Server 2013, ... The new functionality for ...
Read more

Walking Randomly » Month of Math Software

... research computing. Data Science of the ... overview of what’s new in Excel 2013 is ... of A Month of Math Software where I take a ...
Read more

VIP Only | Windows IT Pro

... and how to take advantage of the new Data Loss ... Deep Dive into Business Intelligence in Excel 2013's ... there is a ton of new functionality ...
Read more

SAP Business ByDesign | Cloud ERP for Mid-Market Companies

... with SAP Business ByDesign, ... Capabilities to write back data from excel into the ByDesign system; ... What’s new in SAP Business ByDesign?
Read more

Excel4apps - SAP Financial Reporting Tools | Excel Export

Contact Sales Schedule a demo to see the full capability of Excel4apps ... functionality and technology that is ... data menu, new Excel 2013 ...
Read more