Showing posts with label microsoft. Show all posts

Excel: Converting word cases for spreadsheets

Here's how you can change the case of text in an excel spreadsheet:

Microsoft Excel has the following three worksheet functions that you can use to change text case:

LOWER - Converts all uppercase letters in a text string to lowercase.

UPPER - Converts all lowercase letters in a text string to uppercase.

PROPER - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
By using these functions, you can change the case of existing text in a worksheet. Consider the following example.

Type the following values in a worksheet:
   A1: ABCD
   A2: EFGH
   A3: IJKL
   A4: MNOP
   A5: QRST
   A6: UVWX
   A7: YZ
    
To make these cells lowercase in Excel 2007 or Excel 2010, follow these steps:  
  1. Type the following formula in cell B1:
    =LOWER(A1)
  2. In column B, select all the cells to the right of the cells that contain data in column A. In this example, highlight cells B1 through B7.
  3. Click Home, click Fill, and then click Down.

    Note The new column now contains the lowercase version of the text in column A.

    Note You can also fill cells B2 through B7 by clicking cell B1, and then dragging the fill handle to cell B7.
  4. Highlight cells B1 through B7, click Home, and then click Copy.
  5. Click cell A1, click Paste, click Paste Special, click Values, and then click OK to paste the converted values back onto column A.
  6. Delete column B. To do this, click Home, click column B, and then clickDelete.
The text that was in column A is now in lowercase:
   A1: abcd
   A2: efgh
   A3: ijkl
   A4: mnop
   A5: qrst
   A6: uvwx
   A7: yz
    


To make these cells lowercase in Excel 2003 and earlier versions of excel, follow these steps:
  1. Insert a column to the right of column A by selecting column B and clicking Columns on the Insert menu.
  2. Type the following formula in cell B1:
    =LOWER(A1)
  3. In column B, select all the cells to the right of the cells that contain data in column A.
  4. On the Edit menu, point to Fill, and then click Down.

    The new column now contains the lowercase version of the text in column A.
  5. With the same range selected, click Copy on the Edit menu.
  6. Select cell A1, and click Paste Special on the Edit menu. Under Paste, click Values, and click OK to paste the converted values back on top of column A.
  7. Delete column B by selecting the column and clicking Delete on the Edit menu.
The text that was in column A is now in lowercase:
   A1: abcd
   A2: efgh
   A3: ijkl
   A4: mnop
   A5: qrst
   A6: uvwx
   A7: yz
    


Revised from Microsoft's article "How to change the case of text in Excel":
http://support.microsoft.com/kb/263580

Ctrl+Alt+Del for Remote Desktop

When you're using Remote Desktop, you can't use ctrl+alt+del to bring up the remote computer's task manager. Here's an easy solution: use ctrl+alt+end

Also, here's a video on the history of Ctrl+Alt+Del:


Get Windows 7 Pro for cheap (or free)!


If you have a valid .edu email address and want to get Windows 7 for cheap then check out http://www.win741.com


Similar to Microsoft's Ultimate Steal program for Office 2007, you can pick up a copy of Windows 7 Professional for only about $65!

Also, check with your college to see if they have a program to get a copy of Windows 7 for free. It may not be available at your school but it's definitely worth it to ask your instructor/tech support team!

Disable IE8 First Run Customize


Ask me later! Ask me later! Ask me later!

When you upgraded to Internet Explorer 8 did you get this message? The easy way to get rid of it is to click on Next and then customize your settings. Once you're finished, this pop up shouldn't show up again.

If you are in an environment where you're setting up computers for use with multiple users, you can save your users time by disabling this welcome screen through the Local Group Policy Editor:


Go to your start menu and select Run
(in Vista/7, go to the start menu and find the "start search" area at the bottom)
Type gpedit.msc
Under Local Computer Policy, Expand Computer Configuration
Under that, expand Administrative Templates
Under that, expand Windows Components
Under that, select Internet Explorer
On the right panel, look for "Prevent performance of First Run Customize settings" and double-click it
Select Enabled and then select your choice (on the drop down menu) to be "Go Directly To Home Page"
Click OK and then close out of the Local Group Policy Editor

SkyDrive & SDExplorer - Backup your files!


There is no excuse for it. No form of technologic wizardry will bring it back. Your hard drive is dead and you neglected to make any backup of your files whatsoever. Years of family pictures and important documents, gone. Your personal collection of hilarious cat pictures, all gone. Sure, you could send in your hard drive to a restoration service (that could cost you a pretty large amount of cash), but couldn't this tragedy have been avoided?!?! Keep the following quote in mind when you think about your hard drive:

"There are only two types of hard drives - the ones that have failed and the ones that will fail."

So what can you do next time you're working on an important project??? BACK IT UP!!! In fact, you should back up all your "mission critical" files on a regular basis if they're so important.

You might be asking yourself, "What am I supposed to do? I don't have a USB drive/external hard drive/DVD burner, how am I gonna do this?" Well, if you have an email account @hotmail.com and an active internet connection then you've already taken a step in the right direction!

Windows Live! SkyDrive - http://skydrive.live.com
An online storage tool where you can store up to 25GB of files for FREE! Even though I have a Gmail account, I was able to sign up for Windows Live! without having to sign up for a @hotmail.com or @live.com email account. Go to https://signup.live.com and use your existing email account to set up your live account. You can access your SkyDrive account by going to http://skydrive.live.com were you can add folders and start uploading files.

If you're running Windows and you've signed up with an account, you can use a program called

Outlook: Autocomple for Adding Addresses in an Email

Found this useful article that explains Outlook's Auto-Complete feature:

http://www.outlookpower.com/issues/issue200506/00001584001.html

"If the users are losing addresses of people they recently replied to, it's because Outlook crashes or does not close properly and the changes aren't written to the NK2 file. The existing *.NK2 shouldn't be replaced by a clean *.NK2 if this happens, but new addresses you've sent mail to, or replied to won't be saved to the file. Less used addresses are replaced by new addresses when the NK2 contains 1000 addresses, but if something is corrupt, Outlook replaces the current NK2 with a new, clean one. We don't know what causes it to become corrupt, but we suspect a large number of addresses in the cache is part of the problem."