Rob Collie of PowerPivotPro has the details. Until this realease of the Power Pivot add-in with Excel 2013 Standalone, you would have had to purchase a subscription to Office 365 ProPlus or have a volume license for Office 2013 Professional Plus.
This video will help you learn:
- if your version of Excel 2013 has it
- some advantages the Data Model offers
This is a newly updated multi-media training kit focused on building cube formula reports and dashboards from Analysis Services Multidimensional cubes, Tabular models, or both. It complements the Excel training kit: PowerPivot Formula Reporting Made Easy.
Users of Excel 2010/2013 may be familiar with using Slicers to filter data in a PivotTable. But they can also significantly enhance the user experience with reports and dashboards built from Excel cube functions.
Analysis Services cubes commonly have user-defined hierarchies, such as a date hierarchy. Getting a table of data at the right level of detail can be tricky. Large PivotTables can be slow to set up and manipulate. Learn more on how best to complete this task.
From time to time you may want to retrieve text (as opposed to numeric) values into a PivotTable to slice-dice-pivot the text. Or you want to get properties/attributes of a dimension member in a PowerPivot model using Excel cube functions. Here is one solution.
At its recent Worldwide Partner Conference, Microsoft announced Power BI for Office 365. Power BI encompasses Power Pivot (a slight name change from PowerPivot), Power View, Power Query (previously Data Explorer), Power Map (previously GeoFlow) together with other tools. Important is the shift of Power View towards HTML5 and CSS3 so it can be used on a variety of mobile devices, including the iPad. The Power BI platform is very much cloud-based. More information, including help in Getting Started is available at the above link. Chris Webb has an excellent review of the recently released preview on his BI Blog.
Excel 2013 is now publicly available. If you have the Microsoft Office 2013 Professional Plus version and you enable the PowerPivot add-in you can open and modify PowerPivot models from Excel 2010.
If you upgrade an Excel/PowerPivot 2010 workbook to Excel 2013 your Linked Tables may not behave the way you expect.
Learn how to build your PivotTable and get the benefits of Excel's OLAP Tools
Some reports, such as financial reports, require a very specific layout that PivotTables don't allow. Find out how Excel Cube Functions make it easy to build these reports and stay live-linked to your database. Helps with dashboards too!
The frequent requirement to compare actual performance to budget can be difficult to achieve with a Pivot Table because Actual and Budget data often come from two different sources. With PowerPivot or the Excel 2013 Data Model you can leverage cube functions to obtain the layout you need.
PowerPivot for Excel does not support write-back to a data model and as Personal BI it is not intended for shared usage. But it still offers some planning capabilities. This multi-part section describes how.
Check out Cell Mate for a various wish-I'd-known-that-before video Excel tips, trickery, and shortcuts, many demonstrated with videos.
This is a real time-saver when copying a cell down hundreds of rows.
This trick can be more useful than Find as it identifies all cells that include the words/phrases at the same time. Great for auditing descriptions in a list of transactions.