Friday Five – January 30, 2014

1. How to: Query SharePoint Search with PowerShell  By SharePoint MVP Corey Roth  2. Creating Reports in LightSwitch HTML Client  By Silverlight MVP Michael Washington 3. Highlighting Outliers in your Data with the Tukey Method By Excel MVP Michael Alexander 4. Comparing Columns In Power Query By SQL Server MVP Chris Webb 5. Calling C++ From SQL CLR C# Code…


Friday Five – September 13, 2013

1.  Dynamics CRM MVP Scott Sewell – @ScottSewell Too Many Emails?  Get On The Case With Microsoft Dynamics CRM   2.  Dynamics CRM MVP Roohi Shaikh Business Rules introduced in CRM 2013 (Orion)   3.  Silverlight MVP Michael Washington – @ADefWebserver Using a Visual JavaScript Code Editor With Visual Studio LightSwitch   4.  Excel MVP Michael…


Using Power Pivot and Power View for Profit Analysis

Editor’s note: The following post was written by SharePoint MVP John White Using Power Pivot and Power View for Profit Analysis Power Pivot and Power View allow end users to quickly analyze corporate data without having to go through a complex data warehouse or cube design up front. In this article we will walk through…


Excel 2013–Real World Examples of New Functions

Editor’s note: The following post was written by Excel MVP Ben Currier Excel 2013 – Real World Examples of New Functions Microsoft included over 50 new functions with Excel 2013, and I wanted to walk you through a few real world examples of these new additions. You’ll soon be able to see how handy these…


Excel 2013 Timelines

Editor’s note: The following post was written by Excel MVP Zack Barresse Let’s explore a new feature of Excel 2013 called Timelines. In this blog post we will cover what they are, what you can do with them and how to create your very first Timeline. They are one of the best additions to this…


Excel 2013 Feature – Excel Data Model Tutorial

Editor’s note: The following post was written by Excel MVP Ben Currier PivotTables have certainly become one of the most powerful ways to quickly and easily transform data into information. Yet there are still many Excel users who, for one reason or another, find themselves avoiding PivotTables. Well, Microsoft has made a lot of strides…


Friday Five-June 28, 2013

1. Incentives for Windows App devs By Silverlight MVP Cigdem Patlak – @crocusgirl 2.  Tom’s Tutorials For Excel: Conditionally Format Five Highest or Lowest Numbers in a List By Excel MVP Tom Urtis – @TomUrtis 3. Flattening A Parent/Child Relationship in Data Explorer By SQL Server MVP Chris Webb – @Technitrain 4. Windows Azure Web…


Friday Five – May 24, 2013

1. A Converged Networks Design For Hyper-V On SMB 3.0 Storage With RDMA (SMB Direct) By Virtual Machine MVP Aidan Finn – @joe_elway 2. Tom’s Tutorials For Excel: Using Data Validation to Disallow Entry of Item in a List By Excel MVP Tom Urtis – @TomUrtis 3. Create tasks for outlook.com and a second Tasks…


Friday Five – May 3, 2013

1. TFS Live app for Windows Phone By Visual Studio ALM MVP Jeff Bramwell – @jbramwell 2. Setting up Enterprise Resource for Managing your Test VM Environment By Project MVP Michael Wharton – 3. Pasting a Formulas Static Value in Cell Below By Excel MVP Tom Urtis – @TomUrtis 4. Understanding Hyper-V Error Messages By…


Friday Five–September 14, 2012

1. Reasons for Moving from Gmail/POP to Office 365 By Virtual Machine MVP Anil Desai – @AnilDesai 2.  Tom’s Tutorials For Excel: Formatting Cell Contents as Invisible By Excel MVP Tom Utris – @TomUrtis 3.  Importing Azure Marketplace Data into Excel 2013 with Web Queries By SQL MVP Chris Webb 4.  5 points developers should…