You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
The star of The Office Show's finance and budgeting episode is PowerPivot, an amazing add-in for Excel. Guest bloggers and PowerPivot experts Emilie Bridon and Oliver Chiu explain how it works:
Working with data in Excel 2010 can be a beautiful thing, but getting your data into Excel can be a huge chore, especially if it's in different places. PowerPivot, a free add-in from Microsoft, makes it easy to pull in data from multiple sources and merge it all into one workbook. It's like supercharging your spreadsheets with live data.
In this excerpt from The Office Show, Oliver demonstrates some of PowerPivot's incredible features:
Connecting to data
Connecting to live data is simple. Utilize the Table Import Wizard in PowerPivot to select the data source that you want. You can connect to virtually any type of data, including corporate databases such as SQL Server, Oracle, Teradata, Sybase, or personal sources like Access, Excel, and live data feeds. You can even connect PowerPivot to Facebook Insights OData feed.
Creating an interactive dashboard
Once you've brought in the right data, you can create dashboards that update dynamically. Just select the PivotTable drop-down and select the style of output that you want. PowerPivot makes it easy to create a compelling and interactive view of the data, with standard Excel features like PivotCharts and slicers.
Experience PowerPivot yourself
Download PowerPivot for Excel 2010 for free today www.powerpivot.com.
-- Emilie Bridon and Oliver Chiu
very well your work!!