Install Windows 7 or 8 From USB

Requirements:

USB Flash Drive (Minimum 4GB)
Windows 7 or Windows 8 installation files.

To install the Windows USB/DVD Download Tool:

1. Click to open the Windows USB/DVD Download Tool page. Download then Run.
2. Follow the steps in the setup dialogs. You'll have the option to specify where to install the Windows USB/DVD Download Tool.

You must be an administrator on the computer on which you are installing the Windows USB/DVD Download tool. It requires the Microsoft .NET Framework version 2.0 or higher.

To make a copy of your Windows ISO file:

1. Click the Windows START button, and click WINDOWS USB/DVD DOWNLOAD TOOL in the ALL PROGRAMS list to open the Windows USB/DVD Download Tool.

2. In the SOURCE FILE box, type the name and path of your Windows ISO file, or click BROWSE and select the file from the OPEN dialog box. Click NEXT.

3. Select USB DEVICE to create a copy on a USB flash drive or select DVD disk to create a copy on a DVD disk. 

4. If you are copying the file to a USB flash drive, select your USB device in the drop-down list and click BEGIN COPYING. If you are copying the file up to a DVD, click BEGIN BURNING.

When your Windows ISO file is copied to your drive, install Windows by moving to the root folder of your DVD or USB drive, and then double-click Setup.exe.

Always works with : Lenovo, Dell, Asus, Acer, Samsung, Toshiba, HP

Change All Text to Capitals in Excel

If you need to apply uppercase change for some columns or cells:

Use the UPPER function to convert all letters in a text string to uppercase.

   

 WATCH THE TUTORIAL
(Upper Function - Convert text to upper case in Microsoft Excel 2013)

If you need to apply uppercase change for all text in excel sheet:

Copy the text you need to apply changes

Paste the text in Word Office 

  Select the complete text (CTRL + A) 

  Convert the text to uppercase with shortcut (CTRL + Shift + A) 

  Copy Converted text & Do "paste special" in excel

  Check or Choose "text"