ConvertTo-DataRange converts tables in all sheets of an Excel workbook to data ranges, and then saves the changes. The path to the workbook to convert is supplied to the Path parameter. Workbooks with tables cannot be shared, so this command is useful in preparing a workbook to be shared.

Get-ADSiteName retrieves the name of the site the computer(s) specified to the ComputerName parameter is a part of.

Set-ADAccountStatusByOu sets the status of accounts (enabled or disabled) by an entire Organizational Unit. You may specify the OU by name or distinguished name. Enabling or disabling is handled by the Enable or Disable switch parameters, with Disable being the default. The SearchScope parameter is for controlling whether child ojbects of the OU ar... More info