ReferenceManagerPackage fails to install, VS 2017 Community edition (unable to add reference)

CD C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PublicAssemblies

Step 1: Launch Developer Command Prompt for VS 2017
Step 2: CD C:\Program Files\Microsoft Visual Studio\2017\Community\Common7\IDE\PublicAssemblies
Step 3: Run below command
gacutil -i Microsoft.VisualStudio.Shell.Interop.11.0.dll

You should now see
Assembly successfully added to the cache

Restart Visual Studio and hopefully all will be well and you can add references.

Split Comma Separated Values Into Columns With Text To Columns Function

Step 1: Select the range of cells you want to split values into columns, and then click Data > Text to Columns. See screenshot:

Step 2: In the first Convert Text to Columns Wizard dialog box, select the Delimited option, and then click the Next button.

Step 3: In the second Convert Text to Columns Wizard dialog box, only check the Comma box in the Delimiters section, and click the Next button.

Step 4: In the last Convert Text to Columns Wizard dialog box, select a cell for locating the splitting values in the Destination box, and finally click the Finish button. See screenshot:

Now all the values in selected cells which were separated by commas are split to different columns as bellow screenshot shown.

Get App Expiry Dates using Powershell

Step 1:
Connect-MsolService

Step 2:
$applist = Get-MsolServicePrincipal -all  |Where-Object -FilterScript { ($_.DisplayName -notlike "*Microsoft*") -and ($_.DisplayName -notlike "autohost*") -and  ($_.ServicePrincipalNames -notlike "*localhost*") }

Step 3:
foreach ($appentry in $applist) {
    $principalId = $appentry.AppPrincipalId
    $principalName = $appentry.DisplayName

    Get-MsolServicePrincipalCredential -AppPrincipalId $principalId -ReturnKeyValues $false | ? { $_.Type -eq "Password" } | % { "$principalName;$principalId;" + $_.KeyId.ToString() +";" + $_.StartDate.ToString() + ";" + $_.EndDate.ToString() } | out-file -FilePath d:\appsec.txt -append
}