Excel

Karen Forster and Julie Koesmarno join us for this episode as they discuss the new Power View capabilities found in Excel 2013. Tune in as they chat about Power View’s many advantages for self-service BI analysis and how you can use this new feature to easily build your own simple BI solution.  If…

News: Windows Server "8" will be called Window Server 2012 The Release Candidate (RC) build for Windows Server 2012 and Windows 8 will be early June Join David for the Consumerization of IT Jump Start on May 15th and 16th The General Availabilty (GA) of System Center 2012 was annouced at…

Download the spreadsheet here: http://media.ch9.ms/content/megamillions_template.xlsx There's currently a lot of attention on the MegaMillions lottery here in the United States.  The MegaMillions lottery is a multi-state game of chance which has a cumulative jackpot that increases every time a…

This demonstration identifies and loads unique (non-duplicate) resellers into the Reseller entity of a Master Data Services (MDS) model. It involves creating a Data Quality Services (DQS) knowledge base and matching policy, and then using this matching policy with the MDS Excel add-in. Peter Myers…

This demonstration creates a new model and then uses the Master Data Services (MDS) Add-in for Excel to create and load two entities. Then in the Master Data Manager web application, the loaded members are explored. A new member is added, and an existing member is updated. Finally, a subscription…

This demonstration uploads an Excel workbook to the SharePoint PowerPivot Gallery library, and then uses it to produce a Power View report. Peter Myers Mentor, SolidQ  

All the boss asked for was a report in Excel, but the panicked worker gave him a heart attack instead. If only she'd seen this episode of the Office Show first, then she'd know about the Excel Skills Builder page on Office.com. After all, the path she actually took is way harder than consulting the…

Kevin McGuire has produced a short introduction to Project Barcelona video.  Enjoy! For more information on Project Barcelona (@projbarcelona), please visit: http://blogs.msdn.com/b/project_barcelona_team_blog/ Andy Conrad Project Barcelona lead    

The Office Show is in a budget crisis, and the numbers are a mess. In this episode, watch how we use Excel PivotTables and the super-powerful PowerPivot add-in to pull in all the data and discover some, um, surprising results. And once we get that figured out, Doug Thomas shows us how to…

Hi folks. Today I'm demonstrating how to use the Excel add-in for Microsoft Solver Foundation 3.0. This is an intro demo for getting started with solver. For examples of more complex models, see the product/doc links below.Solver Foundation is a set of tools for mathematical simulation,…