Thursday, August 16, 2012

How to create a drive partition on Windows 7 Home Premium?


Want to try some programs on a partitioned drive? Dual boot Windows 7, Windows 8, Linux etc.

If you need measured steps to do it with screen shots, here it is:

Here I am trying to release some space from my C:\drive


To get to see this you need to go Start | Computer and make a right click and choose Manage from the drop-down list. In the Computer Management Screen choose Disk Management.


Right click the highlighted drive (C:) and pick up shrink Volume..
You get to the Shrink C: screen 


Enter the amount you want to shrink. This was my choice.



Hit Shrink button.

Now you are sizzling. You have 292.97 GB free.
Right click this new released space and click New Simple Volume...

New Simple Volume Wizard shows up.


Read the stuff on it. Hit Next. You need to specify the size of this volume (how many gigabits).


I chose about 40 GB (twice the minimum requirement).

Hit Next. Now in this screen you can choose to create the partitioned drive.


I assumed F: drive. Hit Next to get to the Format drive screen.


I gave Windows 8 as Volume label. Hit Next.


Now you have a F:\ drive with about 40GB. Disk Manager screen gets updated as shown.


You are cooking now. The drive appears in the Windows Explorer as shown.











Tuesday, August 7, 2012

How do you import a text file to MS EXCEL 2010?

Text file should have some delimiting characters such as comma, tab, etc. Here we assume comma as the delimiting character.

Step 1:
Download the file to a location of your choice, say C:\

Or

Click to VIEW the attachment. Select all in the view. Open Notepad and paste the selected items to Notepad.

Save the Notepad with the selection pasted to a location of your choice, say C:\. Use the file name PrincetonTemp. It will be saved with the extension .txt.
If you cannot complete Step 1 go to the end of this post.


Step 2:
Open a new EXCEL workbook.

Step 3:
Click the menu item DATA at the top.


Step 4:

Now Click the item From Text.

This opens the Import Text File window. Now you go to the location where you saved the file.

In my case it is on the Desktop in a folderr called Basic Excel Training as shown above.

Step 5:

Click PrincetonTemp in the window above and click the button Import at the bottom.

Step 1 of 3 of the Text Import Wizard is displayed as shown.


Note 1: You can see the location of your file here
Note 2: You can see part of your data.

Step 6:
Click the Next button at the bottom.



The Step 2 of 3 of the Text Import Wizard is displayed as shown above.

Since your file has (,) comma delimited. Place a check mark in the check box named  ‘Comma’ as shown below.


Notice that when you click in the box ‘Comma’, you will see the preview of your data as shown above. You are almost there!

Step 7:
Click the button ‘Next’.

Step 3 of 3 of Text Import Wizard is displayed. Here you can make changes to the data and format it. For now Just click Finish at the bottom of the screen.



The Import Data screen is displayed as shown:


If you now click OK, the Excel program will paste the imported data beginning in cell A1.
 You can post it to another location or to a new worksheet. For this exmaple let us just click OK.

The data is imported to the worksheet as shown here.


That completes the Import Process.
---------------------------------------------------
If you could not download the file from my email to you, here it is, just copy and paste it to Notepad
January, 40, 60
February, 32, 50
March, 43, 65
April, 50, 70
May, 53, 74
June, 60, 78
July, 68, 70
August, 71, 70
September, 60, 82
October, 55, 67
November, 45, 55
December, 40, 62

How to get a Windows Live account?

Even if you have Google, Yahoo and other accounts, you should try Windows Live account. It opens the door for many things including all your social networking stuff. You also get to store your stuff on 'skydrive', which is password protected and you can access it from anywhere assumign you can get to internet.

While choosing usernames try to choose a slightly longer name than your own first name or nickname. if you are john do not choose john, try john$$ for example. The same goes to password, choose one hwich has atleast 8 characters, not something like '1234'. '1234' is easy to remember but a lot easierr to hack.

Now for the step-by-step tutorial:
1.  Hold down Control key (CTRL) and click on the blue line below.


The following page is displayed:

2.  Now click on SIGN UP in blue (the above should be in the web page).

The following page is displayed.
























3.  After you finish the ‘Who are you?’ section do the following:

4.  Click on ‘Or get a new email address”.

The following is displayed:


You have already entered your personal information.  In the Microsoft account name box type in the first part of your email address. This form will add @ Hotmail.com to it. If you already have a ‘hotmail’ account you can use it. You can get a ‘Live.com’ account as well.

The other option to Hotmail.com is the following:



Make sure the name is little more than a few letters. TOM or CLARA will not do because there may be many more with the above name. Perhaps TOM_JULY30 or CLARA$ may be more easily available. Try to type in a slightly complicated account name. WRITE IT DOWN IN YOUR NOTE BOOK.



5.  In the create a password box type in a password which contains atleast 8 letters and atleast a number. WRITE IT DOWN IN YOUR NOTE BOOK.

6.  Reenter the password you just entred.

7.  Enter your telephone number (the one you access daily)

8.  If you have another email address (perhaps, someone@yahoo.com  or someone@gmail.com

9.  Next you write the ZIP code in its box.

10. In the bottom most box type exactly what you see in blue under(New|Auto).

11. Click I accept

12. If there are no issues you will see the final page which says your entry was successful. It probably opens on  your Windows Live Account page.