$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook
.com/powershell/ -Credential $Cred -Authentication Basic –AllowRedirection
Category: Microsoft
PowerShell Commands to remove Office 365 users
Remove-MsolUser -UserPrincipalName user@example.com
Remove-MsolUser -UserPrincipalName user@example.com -RemoveFromRecycleBin
Connect to Office 365 via PowerShell
https://technet.microsoft.com/en-us/library/dn975125.aspx
Removing orphaned local AD accounts from Azure AD
You can’t manage or remove objects that were synchronized through the Azure Active Directory Sync tool
Azure AD Connect sync: Configure Filtering
Object deletions aren’t synchronized to Azure AD when using the Azure Active Directory Sync tool
Change font case in Excel
I needed to change the format of some text in Excel 2016 today. Excel doesn’t have the same font controls as Word, so it’s not as intuitive as one would expect.
The process in Excel is to use formulas (in my case, it was UPPER) to create the text you wish to see in the world, then paste those values into their final destination.
Thanks to Andre at GroovyPost for the tutorial!
Making a drop-down list in Excel
If you’re creating a form in Excel, a drop-down list can be super helpful. This page has a great walkthrough for doing just that.
Enter BIOS on a Windows 10 computer
If you are stuck working on a Windows 10 computer with EFI and need to access the system settings, here’s how.