Some Key Excel Formulas

Convert date into Monday, Tuesday and etc. =CHOOSE(WEEKDAY(<date column>,2), “1-Mon”,”2-Tue”,”3-Wed”,”4-Thu”,”5-Fri”,”6-Sat”,”7-Sun”)


Power BI – Data Preparation Workflow

Steps in preparing Power BI Click on “Get Data”, select your source data. Click on “Edit Queries”. If there are individual date columns (Year, Month and Day): Then click on “Add Column”, “Add Custom Column”. Name the column as “TempDate”. Put in the custom column formula. Then click on “OK”. Select the generated column, and click on “Date”, “Parse”. A new “ParseDate” column will be…


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 custom date column. To create this custom date column, here’s the formula. =Text.From([Day]) & “-” &  Text.From([Month]) & “-” & Text.From([Year])   This is different from a hierarchy column where you can just drag and drop.


Migrating from Google Apps to Office 365

Office 365 deployment guide   Migrate email and contacts to Office 365 for business   Change Management: Switching from Google Apps to Office 365 for business


SharePoint 2013 Workflow Tutorials

Getting started with SharePoint Server 2013 workflow Workflow actions quick reference (SharePoint 2013 Workflow platform) SharePoint 2013 Workflow – Task Process Designer Developing SharePoint 2013 workflows with SharePoint Designer SharePoint 2013 Approval Workflow With Dynamic Approvers SharePoint Designer 2013 – Call Web Service Video External Version;index=3&amp;list=PL66r0mRA8am80Qsp6tRM1L_cdY3hos8Q8


Office 365 Starter

At Microsoft, we care deeply about supporting compliance with specific standards and regulations related to data security and privacy as required by our customers in various geographies and industries. We consider compliance a core feature of our services, and we make significant investments in this area to ensure that that we are continuously innovating on…


Enable Administrator to access all users' OneDrive for Business

Download, install and run the SharePoint Online Management Shell Replace <domain> with your domain name and <tenant> with your SharePoint Online tenant name. $objCreds = Get-Credential Connect-SPOService -Url https://<tenant> -credential $objCreds $colUsers = Get-SPOUser -Site https://<tenant> | Where-Object {$_.LoginName -like '*<domain>.com*'} $colUsers = $colUsers.LoginName | ForEach-Object { $_.TrimEnd("<domain>") } | ForEach-Object { $_.TrimEnd("@") } $colUsers |…


SharePoint hybrid training videos

SharePoint hybrid training videos Summary: All three topologies are supported: Inbound, Outbound and Bi-drectional