Category Archives: Microsoft Office

Excel cell data type

This post shows you a workaround to handle Excel data type. The Excel empty cell data type does not belong to any common type such as string, integer, or datetime. The data type is actually called System.RuntimeType. So if you … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged , | Leave a comment

SharePoint Site Contents doesn’t load in Chrome

This post shows you a quick fix when your SharePoint Site Contents doesn’t load in Chrome. You can check through the Internet people is talking about Ad Blocker like this one, https://techcommunity.microsoft.com/t5/SharePoint/Site-Contents-doesn-t-load-in-Chrome/td-p/59227. For me, there is one versions of Chrome … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

SSIS convert Excel IF to Derive Column component

This post shows how to convert Excel IF function to SSIS Derive Column component. In Excel you have the expression as below. =IF([@[REHANDLE_REASON]]=”TERMINAL”,”RHCDCTERM”,IF([@[REHANDLE_REASON]]= “VESSELOP”,”RHCDCOPER”,IF([@[REHANDLE_REASON]]=”NONE”,IF([@[move_kind]]= “UNIT_DISCH”,”DISCHARGE”,IF([@[move_kind]]=”UNIT_LOAD”,”LOAD”,””))))) You will convert to SSIS Derive Column as below. You release in Excel you ended … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office | Tagged | Leave a comment

PowerPoint screen recording not working

In one of my previous blog https://chanmingman.wordpress.com/2019/07/07/record-video-using-powerpoint/, I show you have to enable screen capturing or recording using PowerPoint. I have come to realize that, in order for mine recording to work. I cannot disable my Microphone, https://chanmingman.wordpress.com/2019/07/06/windows-turn-off-microphone/. Of course, … Continue reading

Posted in Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

Record video using PowerPoint

This blog showing you how to record video using Microsoft PowerPoint. My version is Office 365 Pro Plus. When you stat PowerPoint click File. Click Options. Choose Customize Ribbbon. Check the Recording.

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, Uncategorized | Tagged | 1 Comment

Outlook ProPlus cannot access to Office 365 email after migrating from Exchange 2007

This post shows you one of the possibilities to resolve the Outlook ProPlus issue. Outlook ProPlus cannot access to Office 365 email after migrating from Exchange 2007, this has been happening to many people. One of the ways to resolve … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365 | Tagged | Leave a comment

Microsoft Graph Client Secret for Postman

This post shows you where to get Client Secret from Microsoft Graph if you want to use Postman, https://github.com/microsoftgraph/microsoftgraph-postman-collections. The link never showed you how to get that. If you follow the link you will arrive on the following screen … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Microsoft Office, Office 365, sharepoint | Tagged , | Leave a comment