Microsoft – Page 2 – McAvatar.com

PowerShell Commands for connecting to Office 365

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook
.com/powershell/ -Credential $Cred -Authentication Basic –AllowRedirection

Connect to Office 365 via PowerShell

https://technet.microsoft.com/en-us/library/dn975125.aspx

PowerShell Commands to remove Office 365 users

Remove-MsolUser -UserPrincipalName user@example.com
Remove-MsolUser -UserPrincipalName user@example.com -RemoveFromRecycleBin

Removing orphaned local AD accounts from Azure AD

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

Source

Azure AD Connect sync: Configure Filtering

Source

Object deletions aren’t synchronized to Azure AD when using the Azure Active Directory Sync tool

Source

How to delete an ‘orphaned’ synced account from Office 365 when using Managed Workplace

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.