Install Windows 7 or 8 From USB

Install Windows 7 or 8 From USB (lenovo dell asus acer hp samsung toshiba etc)

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

Change all text to capitals in excel (excel 2003 2007 2010 2013)

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.

  Change all text to capitals in excel 




 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
Change all text to capitals in excel



Paste the text in Word Office 

Change all text to capitals in excel


  Select the complete text (CTRL + A) 
Change all text to capitals in excel



  Convert the text to uppercase with shortcut (CTRL + Shift + A) 
Change all text to capitals in excel


  Copy Converted text & Do "paste special" in excel
Change all text to capitals in excel


  Check or Choose "text"
Change all text to capitals in excel

                                 
Change all text to capitals in excel