iTunes for Windows crashes when opening iTunes Store

Problem: running iTunes 11 on Windows 7 or 8 64-bit, it crashes when you try to open the iTunes Store.

Solution:

Run the following command on an elevated Command Prompt or via the Run shortcut by right-clicking the Windows button:

%windir%\System32\rundll32.exe sysdm.cpl,EditEnvironmentVariables

This will launch the Environment Variables window.

Under System variables, select the Path variable, then click on the Edit button.

Type the right arrow key to go to the end of the text box, then add the following to the end of the line:

;%HOMEDRIVE%\%ProgramFiles(x86)%\Common Files\Apple\Apple Application Support

The ";" is to separate the previous path from this new one that you are adding.

Click OK.

How to rename an Android device

In order to rename an Android device:

1) From within the device itself, change the Device Name under Bluetooth Settings.
2) Connect the phone to a computer using MTP (instead of mass storage) and rename the device.
3) If you want to rename the Wi-Fi hostname, use the Change Hostname app.

Source

How to take a screenshot on Android

In order to take a screeshot on your Android 4.0 and above phone, press the Power and Volume Down buttons simultaneously.

Source

Troubleshoot Microsoft Office 2013 installation issues

It is very common to run into issues when upgrading from previous versions of Microsoft Office to the 2013 version, including the infamous "Microsoft Office Single Image 2010" error.

Most problems can be solved by running the Program Install and Uninstall Troubleshooter tool.

Source

How to prevent tables from breaking across pages on Microsoft Word

This is a very frustrating thing. By default Microsoft Word will break tables between pages, even if you deselect the "Allow row to break across pages" checkbox under Table Properties > Row.

The solution is to select the entire table, go to the Paragraph section of the Home tab, click the little icon on the bottom right to launch the Paragraph dialog box, go to the Line and Page Breaks tab, then select the "Keep with next" option, then click OK

Source

How to see the server name on the logon screen of a Windows Server 2008 or higher computer

In order to see the hostname of a Window Server 2008 or higher computer at the logon screen, just type .\ in the User name field.

Anything you type after ".\" is considered a local account.

How to insert a data validation dropdown list menu from another worksheet on Excel

1) On the worksheet that contains the list, create a range name.
2) On the worksheet where you want to use the list, click Insert > Name > Define.
3) Make sure you can see the range name specified on the other worksheet. Click OK.
4) Select the cells or the entire column or row where you want to insert the dropdown menu, then click Data > Validation.
5) In the Allow box, select List.
6) In the Source box, type =ListName (range name). Click OK.

Source