Generate a Random Character String in Excel

You may find yourself faced with a need to generate a ton of random strings of characters.
For example, you may have a list of usernames that need passwords – you could be lazy and say everyone’s password is password, but I will assume you know better than that!

Generate Random Number String

To generate a random number string in Excel, simply use a formula like this:

=RANDBETWEEN(0,9)

This will randomly display a number between 0 and 9 each time the page is refreshed. Read More

Computer shutdown (remote)

Shutdown Command Examples

To bring this all together, let’s go over a few examples. First, let’s say that you are connected to your office PC via Remote Desktop and you want to reboot it immediately. You know that no one else is using it and all of your documents and data are saved. While in the Remote Desktop session, launch Command Prompt on your office PC and type the following command:

shutdown -r -f -t 0

Read More

How to create hotkeys for Windows sleep and shutdown

Your computer has one, and maybe two, special buttons that you can configure for just these purposes. In addition, you can create shortcuts for these tasks, and assign hotkeys to the shortcuts.
Let’s start with the special buttons that already exist.
In Windows 7, click Start, or in Windows 8, go to the Search charm. Once there, type power, and select Power Options. In the resulting Control Panel window’s left pane, select Choose what the power buttons do. Read More