To fix Windows Update issues, Windows 8 and newer have the built-in DISM command. Windows 7 has a System Update Readiness tool that can be downloaded.
This page has information on both tools.
Category: Microsoft
PowerShell Commands for connecting to Office 365
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook
.com/powershell/ -Credential $Cred -Authentication Basic –AllowRedirection
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.