Posts Tagged ‘Tips and Tricks’

60 Minutes of Excel 2010 Tip and Tricks: Discover the Hidden Power of Shortcuts that will Save You Hours!

Monday, December 5th, 2011

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!

PC Tip of the Week: Microsoft Word 2007: Easily Create Long Documents with Microsoft Word’s Outline View

Friday, October 1st, 2010

Microsoft Word 2007
Easily Create Long Documents with Microsoft Word’s Outline View

Microsoft Word 2007′s Outline view enables you to organize your information. In this short video let us show you how to create a simple list of items or more complex lists with topics and subtopics.

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

This short tip is brought to you by Log on to Learn.

PC Tip of the Week: Microsoft Project 2010

Tuesday, August 17th, 2010

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.

TIP: Quick Ways to Create or Populate Lists on a SharePoint List.

Sunday, April 19th, 2009

Here’s How:

1.)  Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database.

2.) Create a new list.  Click Create, click SharePoint lists, and then select whichever list is appropriate. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name.

3.) Fill in the data on the data entry page, or populate it from another source by using the data import features of Access.

4.) Save the content in Access.

5.) Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published.

Keep Up With Your Busy Life by Learning All of the Bells and Whistles in Outlook’s Calendars and Tasks (Outlook 2007)

Tuesday, April 7th, 2009

Don’t miss this one! Make your life easier by learning the bells and whistles of Outlook 2007!

Product(s): Microsoft Outlook 2007
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: Wednesday, April 15, 2009 9:00 AM EST

Event Overview:
Whether you still rely on some form of paper calendar to get you through the day or you just need a better way to keep track of your appointments, have we got a webinar for you. From the ancient Chinese to the Aztecs to the Romans, a time-keeping mechanism like a calendar has always been an essential part of life. Now, in the 21st century, a trusty calendar is more important than ever. Outlook’s powerful yet user-friendly Calendar and Tasks list is the answer to staying organized.

* Changes to the 2007 Environment
* How to create Appointments and Meetings
* How to create a recurring appointment
* Track responses to a Meeting Request
* Create Tasks
* Assign Tasks to other users
* Monitor your task list from throughout Outlook

Register Online Fee: $79.00