The star of the Office show financial and budgeting episode Powerpivot for Excel, is an amazing add - in for Excel. Guest blogger and Gemini of expert Emilie Bridon and Oliver Chiu explain how it works:
Working with data in Excel 2010 can be a beautiful thing, but a huge task can always have your data in Excel, first of all, if it in different places. Powerpivot for Excel, a free add-in from Microsoft that makes it easy to consider data from multiple sources and carry you all in a workbook. It is like to the supercharging your tables with live data.
In this excerpt from The Office Show, Oliver demonstrates some of the Powerpivot for Excel the incredible features:
Integrate data from a variety of sources, such as databases corporate to explore tables, reports, text files, and Internet Datenfeeds.Interaktiv, analysis and reports without depending on expert knowledge and specialty create training.Using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis Funktionen.Verarbeiten of large amounts of data. You can easily spend hundreds of millions of rows of data.Connecting to data
It is easy to connect to live data. Use the Import Wizard in Powerpivot for Excel table the data source select, that you want to. You can virtually any type of data, including corporate databases such as SQL Server, Oracle, Teradata, Sybase, or personal sources such as access, Excel, and live data feeds. You can connect to Facebook insights OData feedeven Powerpivot for Excel.
Create an interactive dashboard
Once you have brought in the correct data, you can create dashboards to update dynamically. Only select the PivotTable drop-down list and select the format of the output that you want to. Powerpivot for Excel makes it easy to a compelling interactive image of data with Excel standard features such as charts and create slicers.
See Powerpivot client application itself
Download Excel 2010 Powerpivot for Excel for free today www.powerpivot.com.
--Emilie Bridon and Oliver Chiu
No comments:
Post a Comment