Product: Microsoft Excel
Duration: 60 Minutes
Date: December 21, 2011Time: 1:00 PM EST (US)
Price: Free, with code LOB10

Our 60 minute Excel Tips and Tricks Webinar will help you eliminate the anxiety
of data analysis and will help you harness the true power of Excel! In this
Webinar, you will uncover incredible data analysis tools that were created
specifically to help you achieve your information goals. Microsoft Excel can
help you sift through data to find the information you need, but the process can
be time-consuming and frustrating. Let us help you achieve your goals, don’t sit
and stare at row upon row of numbers; join us for 60 minutes and we will show
you how to zip through your tasks and turn data drudgery into data done. In this
session you will learn how to create custom AutoFill list, use Auto Calculate,
add pop-up instructions for correctly entering data in a cell, use the format
painter, create time saving macros, and much more!

After one hour with our expert, you’ll be able to:
• Create time-saving macros
• Customize your Excel environment to match what you do
and how you work.
• Organize a spreadsheet so that you can see the data you
need
• Format cell data so that it appears as it should.
• Generate shared spreadsheets that collect data consistently and correctly.
• Achieve amazing results for yourself and your organization!

Click Here To Register Online Today!

Have you ever wondered what the actual differences were between Adobe Reader and Acrobat or what Adobe Acrobat can do? Although they share a common history, these are not the same application. Adobe Acrobat has many more features and capabilities. This short clip brought to you by Log on to Learn should help.

Click Here to Watch the short Tutorial Clip

Brought to you by Log on to Learn

Join us for this brief tutorial and learn how using PowerPoint’s design themes can save you time and create eye-catching slide presentations! Themes offer consistency and they are easy to use. Let us show you how.

This video is brought to you by Log on to Learn!

CLICK HERE TO WATCH THE VIDEO

Share Your Outlook 2007 Calendar via E-Mail
If you want to share your calendar with colleagues, here’s how:

1. Open your calendar, and then click Send a Calendar via E-mail.

2. Select the period that you want to share (such as today, tomorrow, or the next 7 days).

3. You now have an e-mail message ready to send with your selective calendar details attached. Enter the e-mail addresses of those you want to receive it, and then send the message.

Microsoft Outlook offers a great feature with the Autocomplete. Everytime a new email address is used for the first time, it gets cached and Outlook will highlight the email address the next time you start to type the address. Outlook holds this in a cache file under your user profile on your computer.

What do you do if you get a new PC? You don’t have to lose Autocomplete.

Here’s an easy fix.

Copy the profile cache from the old PC onto the new PC under the same location.

On your old PC go to:  (replacing username with the your username)

C:\Documents and Settings\<username>\Application Data\Microsoft\Outlook\

The folder C:\Documents and Settings\<username>\Application Data\  hides files so make sure to turn on Show hidden files and folders under folder options. Here’s how. Go to Tools, Folder Options.

Then select the radio botton for Show hidden files and folders. Click Ok. All hidden folders should now be seen.

When you can see the folders look for the file with the extension “NK2″. This filename will be “outlookprofilename.NK2″. On my PC, outlook profile name is “outlook” and the file name is called “outlook.NK2″

The icon should look like this:

When you’ve located the file. Copy the file and then Paste it in the same location on your new PC.

Autocomplete should now work on your new PC.