How to skip Windows 7 login screen?

If you have been running Windows 7 on your personal computer, chances are high that you haven’t assigned a password for your user account. Whenever you start your computer / laptop, the boot process will stop at the Login screen and you need to hit enter or click on your user account picture to see the desktop.

As you need to hit enter each time you start your your computer / laptop, here is quick solution to skip the Login screen.

1. Click on Start and then enter the following command in the search box, then "netplwiz" and press the ENTER key. Or Open Run dialog box by using Windows + R keyboard shortcut and type "control userpasswords2" in Run dialog box and hit enter. This command will load the Advanced User Accounts Control Panel applet.

2. Under User Accounts tab, uncheck the box named Users must enter a user name and password to use this computer.
3. Click Apply button to see Automatically Log On dialog box. If you have a password for your user account, simply enter the password and click ok. If you don’t have a password for your account, simply click Ok.
4. You are done. Reboot your Windows 7 to see the change.

Continue Reading...

How to calculate person's age in Excel

There are many ways to calculate a person's age in Excel.

To calculate the age of a person on date since their birthdate:

=INT((date-birthdate)/365.25)

To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.

Let's say suppose Cell A1 contains "13-11-1984", then you can find person's age by enterring the following formula as

=INT((A1-birthdate)/365.25)

To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.

=DATEDIF(A1,TODAY(),"Y") & " years, " & DATEDIF(A1,TODAY(),"YM") & " months, " & DATEDIF(A1,TODAY(),"MD") & " days"

Continue Reading...

Convert the case of text (Upper, Lower or Proper) in Excel

If you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, you can use the UPPER, LOWER, or PROPER functions as shown below:

1. Let say cell A1 contains "suneel gudipati"
2. To convert the text into upper case enter the formula =UPPER(A1)
3. It changes text to all Upper case as "SUNEEL GUDIPATI"
4. Similarly to convert into lower case enter the formula =LOWER(A1)
5. It changes text to all lowercase as "suneel gudipati"
6. Similarly to convert into Title case enter the formula =PROPER(A1)
7. It changes text to all lowercase as "Suneel Gudipati"

Continue Reading...

How to extract Year, Month, or Day from the Date in Excel?

If you need to use the year, month or day referred to in a date cell in a separate cell follow the step:

1. Lets say that cell A1 contains the date November 13, 2007 (entered as 13/11/2007 or 11/13/2007 depending on your date system). 
2. Now you want to extract the year i.e., 2007 from the date you entered. Simply enter the formula =YEAR(A1). 
3. Similarly you can extract the month and day from the date using the formulas =MONTH(A1) and =DAY(A1).

Continue Reading...