the MOST

McCombs Office Solutions and Tips

Excel Logical Functions Webinar

Posted by  on Friday, March 23rd 2012     

This week the Training Team hosted a webinar for students about Excel Logical Functions. This one hour session covered:

  • COUNTIF(S)
  • SUMIF(S)
  • AVERAGEIF(S)
  • IF
  • AND
  • OR
  • IFERROR
  • Nesting Functions

Watch a Recording Online

If you”re interested in learning about these topics, you can watch a recording online.

View the Logical Functions webinar

Additional Microsoft Office Webinars

We’ve also recorded past webinars that are available online. We post links to our webinars on the Webinars tab of the Training Team Tutorials web page.

category: Excel, McCombs Tech Resources, Webinars
tags: , , , , , , ,

Change the Default Save Location for a File

Posted by  on Friday, March 16th 2012     

You’ve probably noticed that Microsoft Office automatically saves your files to your Documents folder/library (unless you’ve already changed this). But many people prefer to save their files somewhere else. A word of caution: if you save files to your desktop, Windows will run more slowly. 

Changing the file location every time you save a file can get annoying. Here’s how you can change the default file location for files saved in each program. This needs to be set for each program.

Change the Default Save Location in Microsoft Word

Word 2010

  1. In Word, go to the File tab.
  2. In the left column, click on Options.
  3. In the left column of the Word Options window, click Save.
  4. Your default location will show in the Default file location box. To change it, click the Browse button to the right of it.
  5. Navigate to the folder you would like to make your default location and click OK.
  6. Click OK again.

Word 2007

  1. In Word, click the Office button in the top left corner.
  2. At the bottom of the menu, click Word Options.
  3. In the left column of the Word Options window, click Save.
  4. Your default location will show in the Default file location box. To change it, click the Browse button to the right of it.
  5. Navigate to the folder you would like to make your default location and click OK.
  6. Click OK again.

Change the Default Save Location in other Microsoft Office Programs

The process to the change the default file location for programs like PowerPoint and Excel is exactly the same, except for some reason, these programs are missing the Browse button in step 4 (at least they are in 2010).

Here’s how to get around it:

  1. Open Windows Explorer, which is the same as the Computer or Documents folder in Windows 7. The keyboard shortcut is the Windows button + E.
  2. Navigate to the folder you would like to set as the default.
  3. Right click in the address bar across the top of the window and select Copy address as text.
  4. Follow the instructions above, but instead of steps 4 & 5, paste the address you copied (Ctrl + V) into the Default file location box.
category: Excel, General, Office 2007, Office 2010, PowerPoint, Word
tags: ,

Organize Your Favorites in Internet Explorer

Posted by  on Friday, March 9th 2012     

If you mark a lot of favorites in your browser, pretty soon it’s hard to find the one you’re looking for. If you use Internet Explorer, here’s how you can organize and alphabetize your favorites.

Open the Organize Favorites window in Internet Explorer:

  1. Click on the Favorites button.
  2. Click the drop down arrow next to the Add to favorites button and select Organize Favorites.

Make a new folder:

  1. Click the New Folder button.
  2. A new folder will appear in your favorites list with the name New Folder highlighted. Type a new name for the folder and press Enter.

Move a bookmark into a folder:

  1. In the Organize Favorites window, click on the favorite, keep holding down the left mouse button and drag it to the folder you’d like to drop it in.
  2. When the folder you want to drop it in is highlighted, release the left mouse button.

Rearrange favorites within the main list or within a folder:

  1. Click on the favorite and hold down the left mouse button.
  2. Drag the favorite to the place you would like to drop it and release the left mouse button.

Alphabetize your favorites:

  1. Right click on any favorite.
  2. Select Sort by name from the right click menu.
    Note: if you do this within a folder, it will only alphabetize within that folder.

 

category: Web Browsing
tags: , ,

Create a Distribution List/Contact Group in Outlook

Posted by  on Monday, March 5th 2012     

 

Outlook 2010 Contact Group Ribbon

 

A distribution list is one contact that contains email addresses for multiple people. In Outlook 2010, distribution lists have been re-named contact groups, but they’ve been called distribution lists for so long, I don’t expect that to change.

Whatever you call them, they are great for tons of different reasons.  Do you work on a team and want to email everyone without entering each individual email address in the To line?  Or do you have a group of fifty people you want to be able to email quickly and often?  If so, distribution lists, or contact groups, are for you.

Create a Contact Group in Outlook 2010

  1. In Outlook 2010, click Contacts folder and click the New Contact Group button on Home tab of the ribbon.
  2. A new Contact Group window will open.
  3. Type the name of your contact group in the Name box.
  4. Click Add Members, and from the drop down menu, select From Address Book or From Outlook Contacts.
  5. Double click on the name of every contact you want to add to your list and click OK.
  6. To add a someone not in your address book or contact list, click Add Members, and select New Email Contact from the drop down menu. Fill in the Display Name and Email address fields and click OK.
  7. When you’re finished adding email addresses to your Distribution List/Contact Group, click Save and Close.

Create a Distribution List in Outlook 2007

  1. In Outlook 2007, go to the File menu, select New, and select Distribution List.
  2. A new Distribution List window will open.
  3. Type the name of your distributon list in the Name box.
  4. Click Add Members.
  5. You will be shown your Contacts or your Global Address List. To switch between lists, use the Address Book drop down menu in the tip right corner.
  6. Double click on the name of every contact you want to add to your list and click OK.
  7. To add a someone not in your address book or contact list, click Add New on the ribbon. Fill in the Display Name and Email address fields and click OK.
  8. When you’re finished adding email addresses to your Distribution List/Contact Group, click Save and Close.

 Create a Distribution List/Contact Group From a List in Excel

  1. Follow steps 1 - 5 above.
  2. Click in the Members box at the bottom of the Address Book or Contacts window.
  3. Go to your Excel spreadsheet and select the email addresses you want to add to the group. Select only the email addresses.
  4. Copy (Ctrl+C or right-click and select Copy).
  5. Go back to the open Address Book or Contacts window in Outlook.
  6. Paste (Ctrl+V or right-click and select Paste).
  7. Click OK.
  8. When you’ve finished adding contacts, click Save and Close.

 

 

category: Email, Outlook
tags: , , , , , ,

Replacing With a Special Character in Microsoft Word

Posted by  on Friday, February 17th 2012     

I recently completed a document that included a log of em dashes (a dash about the width of an M). Most of the time, if you type two hyphens together, Word will replace them with an em dash. But sometimes it doesn’t. I ended up with dozens of double hyphens in my document. I needed a quick way to turn them all into em dashes.

To replace a character with a special character in Word 2007 or 2010:

  1. Click the Replace button on the Home tab of the ribbon (right side).
  2. In the Find what box of the Replace dialog box, type the character(s) you want to replace.
  3. Click inside the Replace with box.
  4. In the bottom left corner, click the More>> button. The dialog box will expand.
  5. At the bottom, click the Special button.
  6. Select the type of character you would like to replace with (in my case, the Em Dash).
  7. Click Replace to replace them one by one. Click Replace All to replace all instances.
  8. When finished, click Close.
category: Office 2007, Office 2010, Word
tags: ,
Page 4 of 37:« First« 1 2 3 4 5 6 7 »Last »