Skip to main content
Excel 2010   rss
(1-6 of 6 items)
PowerPivot to the People  | TechNet Edge The two most important assets in an organization are its people and its information. Organizations that can connect the two seamlessly empower their employees to make the best decisions. IT Departments are challenged with the task of making this connection. At the backend, products like SQL Server 2... More...

Excel 2010, PowerPivot, SharePoint 2010, English, Articles, Featured, Alan Le Marquand, TechNet Edge, Articles
PowerPivot part 1 - Loading Data | TechNet Edge The first thing you need to do in PowerPivot is to load in some data. In this screencast data is pulled in from a variety of sources (including SQL Azure and Reporting Services) to show how simple and powerful the tools for this are. For more information checkout www.powerpivot.com. This is part 1 i... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Screencasts, English, Andrew Fryer, Zune, iPod
PowerPivot part 2 - Preparing data | TechNet Edge Having got all the data you need into Powerpivot, you will need to create relationships between the various sheets you have imported.  You may also need to create some additional columns of data and filter what you have retrieved. For more information check out www.powerpivot.com. This is part 2 in ... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod
PowerPivot part 4 - Sharing in SharePoint 2010 | TechNet Edge The Power of PowerPivot is for a user to be able to share their analysis with their team.  The obvious choice for doing this is SharePoint and SQL Server 2008 R2 Analysis services can be sepcially configured to support PowerPivot anlysis in SharePoint 2010.  This screencast won't show you how to do ... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Screencasts, English, Andrew Fryer, Zune, iPod
PowerPivot part 3 - Analysis  | TechNet Edge PowerPivot is there for end users to quickly analyse their data.  It does this by using the familiar pivot table and pivot chart tools, as well as the improved functionality in Excel 2010 such as slicers. for more information visit www.powerpivot.com This is part 3 in a series of 5 More...

en-GB, Videos, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, PowerPivot, Zune, iPod, TechNet Edge, Videos, en-gb, Andrew Fryer
PowerPivot part 5 - Management | TechNet Edge Allowing users to share their PowerPivots in SharePoint is very useful but does need to be managed by the IT Pro.  In this screencast you can see the management dashboard that gets installed as part of PowerPivot in SharePoint 2010 to monitor the resources and usage of these PowerPivots. For more in... More...

TechNet Edge, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, PowerPivot, Screencasts, English, Andrew Fryer, Zune, iPod