SharePoint Immersion Experience

A journey of a TSP for Collaboration

Some Key Excel Formulas

Convert date into Monday, Tuesday and etc. =CHOOSE(WEEKDAY(<date column>,2),...

Author: WKNG Date: 01/25/2017

Power BI - Data Preparation Workflow

Steps in preparing Power BI Click on "Get Data", select your source data. Click on "Edit Queries"....

Author: WKNG Date: 09/23/2016

Power BI - Add Custom Column - Date

In Power BI Desktop, if you an Excel with columns of year, month and day, and needed to create a...

Author: WKNG Date: 09/13/2016

Migrating from Google Apps to Office 365

Office 365 deployment guide https://technet.microsoft.com/en-us/library/hh852466.aspx Migrate email...

Author: WKNG Date: 03/15/2015

SharePoint 2013 Workflow Tutorials

Getting started with SharePoint Server 2013 workflow...

Author: WKNG Date: 02/12/2015

Office 365 Starter

At Microsoft, we care deeply about supporting compliance with specific standards and regulations...

Author: WKNG Date: 12/01/2014

Enable Administrator to access all users' OneDrive for Business

Download, install and run the SharePoint Online Management Shell...

Author: WKNG Date: 11/26/2014

SharePoint hybrid training videos

SharePoint hybrid training videos...

Author: WKNG Date: 07/31/2014

Color Code Calendar Events in SharePoint 2013

Here's a good step-by-step on doing color coding on SharePoint 2013 Calendar....

Author: WKNG Date: 07/16/2014

Office 365 Adoption Kit and Change Management Plan

Office 365 Adoption Kithttps://aka.ms/o365kit Office 365 Change Management...

Author: WKNG Date: 06/11/2014

Bulk remove user from Office 365

Prepare a CSV File to Import New Exchange Online...

Author: WKNG Date: 03/06/2014

Add Search Refiner counts

By default, the Refinement Web Part doesn't show refiner counts — that is, the number of...

Author: WKNG Date: 08/23/2013

Scanning to SharePoint Online in Office 365

You will need third party solution if your Multi-Function Printer (MFP) does not support scanning...

Author: WKNG Date: 06/30/2013

SharePoint and Yammer Integration

Yammer integrates with SharePoint via Web Parts. Yammer maximizes the power of SharePoint and turn...

Author: WKNG Date: 06/09/2013

Securing SharePoint 2013

Security planning for SharePoint 2013 farms Plan security hardening for SharePoint 2013

Author: WKNG Date: 06/04/2013

Optimize Performance for SharePoint 2013

Here's a list of links related to optimizing SharePoint 2013 performance. Optimize performance for...

Author: WKNG Date: 05/29/2013

Why is the "Connect to Outlook" button is grayed out in SharePoint 2013?

The reason is because the Minimal Download Strategy feature does not download all the necessary...

Author: WKNG Date: 05/07/2013

SharePoint 2013 Trainings

SharePoint 2013 Trainings IT Prohttp://msdn.microsoft.com/en-us/sharepoint/Fp123606...

Author: WKNG Date: 02/19/2013

Some of my findings on SharePoint 2013

Office Web Apps can be used only by SharePoint 2013 web applications that use claims-based...

Author: WKNG Date: 01/26/2013

Temporary fixing "This content cannot be displayed in a frame" in Office365 with Internet Explorer

When I was branding an Office365 SharePoint 2013 site, I'm getting an error when viewing apps that...

Author: WKNG Date: 01/01/2013

Key InfoPath Information and Training

Introduction to designing a form in InfoPath 2010...

Author: WKNG Date: 12/12/2012

InfoPath: Converting data to Upper Case or Lower Case

Here's the formulas to convert the data of the current textbox to UPPER case or lower case. Convert...

Author: WKNG Date: 12/09/2012

Error in copying item in SharePoint 2010 Workflow

If you are experiencing the following error: "The workflow could not copy the item. Make sure the...

Author: WKNG Date: 11/24/2012

Changing the location of the offline Outlook Data File (.ost) in Microsoft Outlook 2013

While setting up my new machine, I wanted to relocate the default Outlook 2013 OST file to another...

Author: WKNG Date: 11/12/2012

Enable Acer Aspire One to run Windows 8 display and applications

A registry needs to be added to enable the higher resolution (1024 x 768) for Windows 8...

Author: WKNG Date: 11/11/2012

SharePoint Server 2013: Drag and drop contents to Library

To have the drag and drop feature to SharePoint Server 2013, here are the scenario or requirements...

Author: WKNG Date: 11/07/2012

Deleting unused application pool in SharePoint 2010

There is no GUI available in the SharePoint Central Administration website to delete a SharePoint...

Author: WKNG Date: 10/18/2012

CIE v4.0 is now available!

CIE v4.0 platform showcases the following products: Windows 8 Enterprise Consumer Preview version of...

Author: WKNG Date: 10/16/2012

Changing the VL Key for Windows 8 Enterprise

Open the command prompt with the Admin rights. Input "slui 3". The Windows Activation window will...

Author: WKNG Date: 09/09/2012

Passing multiple parameters in XsltListViewWebPart

Passing a single parameter in XsltListViewWebPart: <a...

Author: WKNG Date: 09/01/2012

InfoPath Web Form repeating attachment error in SharePoint Server 2010

Recently, I created a custom InfoPath form which worked fine on the preview. After publishing to a...

Author: WKNG Date: 08/29/2012

Windows 8 RTM now available in MSDN and TechNet Subscriptions!

For those developers and IT Pros with MSDN or TechNet Subscriptions, Windows 8 RTM is now available...

Author: WKNG Date: 08/21/2012

Exporting and Importing SharePoint Designer 2010 List Workflow

Exporting and importing of the List Workflow to and from another list or site is actually a...

Author: WKNG Date: 08/21/2012

SharePoint Web Part Maintenance Page

Web Part Maintenance page is one of the most important tip for SharePoint designers or developers....

Author: WKNG Date: 08/11/2012

Upgrading Samsung Slate PC to Windows 8 RP

We have a couple of Samsung Series 7 Slate PC in our Customer Immersion Experience setup. With...

Author: WKNG Date: 07/05/2012

Renew CIE v3.5 FAST Search Certificate

The FAST Search certificate in the Customer Immersion Experience (CIE) v3.5 expires on June 15th...

Author: WKNG Date: 07/01/2012