Excel
33 Entries
- Recent
- Most Viewed
- Top Rated
-
Language(s)
-
11 minutes, 35 secondsTechNet Radio: STB News Bytes: The “Power” of Power View in Excel 2013Karen 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… -
24 minutes, 58 secondsEdge Show 23 - Monitoring Service Delivery and Automation for the Private Cloud with System Center…News: Windows Server "8" will be called Window Server 2012The Release Candidate (RC) build for Windows Server 2012 and Windows 8 will be early JuneJoin David for the Consumerization of IT Jump Start on May 15th and 16thThe General Availabilty (GA) of System Center 2012 was annouced at… -
Using Excel to Calculate Your MegaMillions WinningsDownload 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… -
16 minutes, 52 secondsDemo: Deduplicating Data with SQL Server 2012 Data Quality ServicesMar 08, 2012 at 9:09 AM
1
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… -
12 minutes, 19 secondsDemo: Managing Data with SQL Server 2012 Master Data ServicesMar 07, 2012 at 8:30 PM 1
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… -
12 minutes, 47 secondsDemo: Exploring Self-Service Reporting with SQL Server 2012 Power ViewMar 07, 2012 at 9:39 AM 1
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 -
3 minutes, 35 secondsOffice 911: Don't panic, build your skillsAll 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… -
16 minutes, 49 secondsIntroduction to Project BarcelonaJun 02, 2011 at 9:57 AM 0
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 -
9 minutes, 44 secondsThe Office Show - FinancesThe 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… -
6 minutes, 21 secondsModeling with Solver Foundation 3.0Mar 22, 2011 at 9:34 AM 3
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,…
