Archive for June, 2010

PC Tip of the Week: Microsoft PowerPoint 2007

Thursday, June 24th, 2010

Record a Narration During a Presentation

If you want to capture your own comments, the comments of your audience, or both during your presentation, you can turn on narration before you begin your presentation.

1. In Normal view, select the slide that you want to start the recording on.
2. On the Slide Show tab, in the Set Up group, click Record Narration Button image.
3. Click Set Microphone Level, follow the directions to set your microphone level, and then click OK.
4. Do one of the following:
* To embed (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.) the narration, click OK.
* To link the narration, select the Link narrations in check box, click Browse, click a folder in the list, and then click Select.
5. If you selected the first slide to begin the recording on, go to step 6.
If you selected a different slide to begin the recording on, the Record Narration dialog box appears. Do one of the following:
* To start the narration on the first slide in the presentation, click First Slide.
* To start the narration on the currently selected slide, click Current Slide.
6. In Slide Show view, add your speaker comments along with any audience comments, and then click the slide to advance to the next slide. Repeat this process for all the slides in your presentation.
Tip: To pause and resume the narration, right-click the slide, and then on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.), click either Pause Narration or Resume Narration.
7. Click the black Exit screen.
8. The narration is automatically saved, and a message appears asking if you want to save the timings for the presentation as well. Do one of the following:
* To save the timings, click Save. Your slides appear in Slide Sorter view, with the slide timings shown below each slide.
* To cancel the timings, click Don’t Save.

Webinar: Microsoft Excel 2007

Tuesday, June 22nd, 2010

Unlock the Power and Potential of Formulas and Functions in Microsoft Excel 2007

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Wednesday, June 23 2010, 3:00PM (EST) U.S.
Duration:
60 Minutes 

Event Overview:
Don’t spend another day manually filtering information from your spreadsheets in order to find the answers to your most pertinent business questions. Utilize the built-in formulas that Excel has to offer and get accurate results in a snap! This Webinar focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in your Excel worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Learn formulas that will help you with specific business tasks, such as:

* Calculating loan repayment
* Creating amortization tables
* Identifying the potential future value of investments
* Using Excel’s discounting functions to analyze cash flow values and rates of return

To Register: Click Here. Fee: $99.00

PC Tip of the Week: Microsoft Excel 2007

Thursday, June 17th, 2010

Insert a Picture in a Chart

1. Click the chart area of the chart.
*This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Layout tab, in the Insert group, click Picture.

3. Locate the picture that you want to insert, and then double-click it.
*Tip: To add multiple pictures, hold down CTRL while you click the pictures that you want to insert, and then click Insert.

4. To change the size of the picture, drag a sizing handle (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) away from or toward the center of the picture while doing one of the following:
* To keep the center of the picture in the same place, hold down CTRL while you drag the sizing handle.
* To maintain the proportions of the picture, hold down SHIFT while you drag the sizing handle.
* To both keep the center of a picture in the same place and maintain its proportions, hold down CTRL+SHIFT while you drag the sizing handle.

Tip: You can also resize a picture to an exact height and width by selecting the picture and then entering the size that you want in the Shape Height and Shape Width boxes (Format tab, Size group).
5. To move the picture, drag it to the location that you want.

Note   Pictures that you insert in your chart are embedded in your chart and therefore increase the file size. To reduce the file size, you can link to a picture instead of inserting it. In the Insert Picture dialog box, click the picture that you want to insert, click the arrow next to Insert, and then click Link to File.

No-Fee Webinar: First Look at Windows 7

Tuesday, June 15th, 2010

First View of Windows 7: Change is Good!

Product(s): Microsoft Windows 7
Audience(s): Business Professional.
Date(s): June 22, 2010, 10:00AM (EST) U.S.
Duration: 30 Minutes

Event Overview:
Windows 7 is new from the ground up. In this session we will uncover many of the new features that distinguish this version of Microsoft’s operating System from its predecessors. Windows 7 offers new features to view and organize open windows, search for files and programs and even control the number of notifications we see. We’ll demonstrate all this and much more as we reveal the workings of this eagerly awaited upgrade. Whether you’re already using Windows 7 or planning on making the switch, let us guide you on your way.

About the Presenter: Matt Wohl is a Senior Applications Instructor with a background in Microsoft Office and Adobe’s design software. Matt has been an Instructor for 8 years. He has created and delivered multiple “Train the Trainer” programs. As a designer, Matt first began using Adobe software in 1996, has worked for several advertising agencies and also as a freelance designer. He’s led corporate implementations of new software and written courseware for all applications in the Office Suite. He currently specializes in classroom instruction as well as designs and delivers corporate and open enrollment webinars.

To Register: Click Here. Fee: $0.00

Webinar: Microsoft Outlook 2007

Thursday, June 10th, 2010

Taming the Beast: An Introduction to Outlook and Unlocking the Power of Organizing and Managing Your Inbox (Outlook 2007)

Product(s): Microsoft Outlook 2007
Audience(s): Business Professional.
Date(s): Wednesday, June 23 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Microsoft Outlook is a messaging and personal information manager. Sending and receiving e-mail messages is the biggest reason people use Outlook. This short course explains everything you need to know about e-mail: how to compose, send, and receive e-mail messages, how to reply to and forward e-mails, how to spell-check an e-mail before sending it, sorting and filtering emails, and how to attach one or more files to an e-mail message. Learn to create and manage your emails using folders. You will even learn how Outlook can help you find a misplaced e-mail message.

To Register: Click Here. Fee: $99.00

PC Tip of the Week: Microsoft Excel 2007

Wednesday, June 9th, 2010

Save a Chart as a Chart Template

1. Click the chart that you want to save as a template.

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Save As Template.

3. In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

4. In the File name box, type an appropriate name for the chart template.

Webinar: Microsoft Publisher

Tuesday, June 8th, 2010

Extra! Extra! A Guide to Creating Dynamic Newsletters in Microsoft Publisher

Product(s): Microsoft Publisher
Audience(s): Business Professional.
Date(s): Tuesday, June 22 2010, 2:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Whether you are using newsletters to share information with family and friends or to attract new business and customers, Microsoft Publisher’s newsletter function provides total layout and design flexibility. Publisher provides an easy-to-use interface that allows you to select the design layout and color scheme, format text and insert images quickly and easily to create a custom newsletter.

This 60 minute Webinar covers the following topics:

* Exploring the Newsletter Templates
* Modifying a Template
* Creating Pages from Scratch
* Inserting Text and Frames
* Inserting Pictures and Clip Art
* Moving and Nudging Objects
* Using Text Overflow
* Formatting Text and Headings
* Working with Bullets and Numbering
* Paragraph and Line Spacing
* Spell Checking and Autocorrect
* Using the Design Checker
* Printing your Newsletter

To Register: Click Here. Fee: $99.00

PC Tip of the Week: Microsoft Word 2007

Thursday, June 3rd, 2010

Microsoft Word 2007: Change the author name for documents
Every time you create a new document, Microsoft Office Word sets the Author property based on the User name setting that appears in the Word Options dialog box. The User name setting also provides the name and initials that are displayed in comments and tracked changes.
Change the author name in an existing document
1. Click the Microsoft Office Button Button point to Prepare, and then click Properties.
2. In the Document Information Panel, type the author name in the Author box.
Note: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.

New Video Series: QuickBooks Essentials

Tuesday, June 1st, 2010

Log On To Learn Launches New Video Series: QuickBooks Essentials

Log On To Learn is excited to announce a new Video “Series” format for our online tutorial content.  The new series consist of short 3-10 minute video chapters targeted to specific topics – get what you need quickly and easily.

With the new QuickBooks Series we will begin with a brief introduction and move on to the Essentials: Setting Up a Company File, Chart of Accounts, Entering and Paying Bills and so much more!  See below for a complete list of available online chapters.  For only $129 per month you can have access to all of these titles and so many more – from Microsoft Office to the Adobe Creative Suite.  To purchase simply visit www.logontolearn.com and click “Subscribe Now & Start Learning” button.

1. Setting Up a Company File 0:39
**a. Starting the Easy Step Interview Process 11:27
**b. Open an Existing Company 1:12
**c. Modifying Company Information 1:11
2. Touring QuickBooks 0:35
**a. Using the QuickBooks menus and home page 2:06
**b. Touring the Customer, Vendor, and Employee Centers 2:14
**c. Navigating between QuickBooks windows 1:46
3. Setting Up a Chart of Accounts 1:36
**a. Creating Income and Expense Accounts 2:34
**b. Creating a Bank Account 2:18
**c. Creating a Credit Card Account 2:02
**d. Editing an Account 1:43
**e. Deleting an Account and making an Account Inactive 2:13
4. Setting Up Customers, and Vendors 0:38
**a. Creating a customer profile 2:39
**b. Adding customer information 8:40
**c. Making customers inactive 1:42
**d. Creating a vendor 4:57
5. Setting Up to Sell Services and Products 0:44
**a. Creating a Service item 2:13
**b. Creating an Inventory Item 3:49
**c. Edit an Item 1:28
**d. Deleting an Item 1:23
**e. Making an Item Inactive 1:18
6. Paying for Expenses 0:30
**a. Entering/Paying a bill 4:35
**b. Printing checks 2:25
7. Invoicing 0:30
**a. Creating an invoice 2:33
**b. Editing an invoice 2:03
**c. Printing an invoice 1:47
8. Memorized Transactions 0:27
**a. Creating a memorized transaction 2:06
**b. Editing a memorized transaction 1:43
9. Receiving Payments 0:28
**a. Receiving a payment 2:57
**b. Depositing payments 2:31
10. Reports 0:34
**a. Creating a simple Report 1:36
**b. Printing a report