Get the gist of it–Excel 2013 Power View

microsoft, excel, office, 2013, power view, business intelligence

Like nearly every business in the world, we rely on Microsoft Excel to help us take care of business.  As with every new release of Microsoft Office, Excel 2013 brings us new features which just make the upgrade worth it. 

At Extended Results, we help companies around the world get more out of their Microsoft platform of Office products, we are going to give some insights into a new feature called Power View found in Excel 2013.   Power View can be utilized in Excel and published to SharePoint to make a truly cool and interactive dashboard.  Here’s a quick look at the most impactful changes:

What’s new –

  • New report themes
  • Add backgrounds and background image
  • Add drill up/drill down
  • Dynamic pie charts
  • Add hyperlinks
  • Use or create hierarchies
  • Add KPIs
  • Bing maps

Limitations –

  • Power View reports in SharePoint are RDLX files; Power View sheets in Excel are part of an Excel XLSX workbook – you cannot open one within the other.
  • Power View sheets can’t be viewed on SkyDrive.
  • Power View sheets saves to an Excel workbook are not displayed within the Gallery, however they are in the file.
  • The RT version (Surface) of Office doesn’t support Power View.

Need help? Every customer has unique needs and Extended Results can help. We offer a comprehensive, customizable suite of services to help you plan and migrate your existing Microsoft platform of SharePoint and Excel to the latest versions. Read more about our Office 2013 Readiness Services to help your organization get migrated.

Enjoy, Patrick

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s