Learning Windows Movie Maker

Product(s): Microsoft Windows.
Audience(s): Business Professional.
Date(s): Thursday, December 10, 2009, 3:00PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:

Windows Movie Maker enables you to create home movies and slide shows on your computer, complete with professional-looking titles, transitions, effects, music, and even narration. And when you’re ready, you can use Windows Movie Maker to publish your movie and share it with your friends and family. Our free Webinar is designed to help new and existing Movie Maker users obtain a thorough understanding of this latest version of Movie Maker. This Webinar shows you how to use Movie Maker’s many features to create exciting movies from captured video, digital photos, graphic files and more. The training begins with a basic overview of the Movie Maker interface and quickly advances to cover topics such as capturing video, importing pictures, editing clips, adding special effects, inserting transitions, creating titles, adding music and much more.

To register: Click Here.  Fee: FREE

Microsoft Office Excel: Select a hyperlink without activating the link

To select a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) without activating the link to its destination (destination: General term for the name of the element you go to from a hyperlink.), do one of the following:  

* Click the cell that contains the hyperlink, hold the mouse button until the pointer becomes a cross Excel selection pointer, and then release the mouse button.
* Use the arrow keys to select the cell that contains the hyperlink.
* If the hyperlink is represented by a graphic, hold down CTRL, and then click the graphic.

Embracing Change, Uncovering the New Features of Office 2007 (Word, Excel & Outlook)

Product(s): Microsoft Office 2007.
Audience(s): Business Professional.
Date(s): Monday, November 30, 2009, 11:00AM (EDT) U.S.
Duration: 60 Minutes  

Event Overview:

Change; Love, or hate it, it’s a way of life. Coming to understand can help you embrace it and the new possibilities that come along with that change. This is true of Microsoft Office 2007. Office 2007 has a whole new look and new features to go with it. This Webinar explores the new Office interface and the dynamic features of the Office Suite. While each application has new features, we will look at the common elements throughout the new interface. We will also go into Word, Excel and Outlook to point out some of the big changes. If you have Office 2007, this webinar is a must to get you on the path to embracing the change. Word has exciting new features to help you create, manage, and distribute documents. Excel has Smart Art, tables, and improved conditional formatting. Outlook’s To Do Bar is a way to view dates, upcoming calendar appointments, and tasks all while looking at your email.

Some of the things you will learn:

* The Office Interface (The Office Button, Ribbons, Quick Access Toolbar, Contextual Tabs and Dialog Box Launchers)
* How to deal with documents from  earlier versions of Office
* How to use SmartArt
* New distribution features in Word
* Improved conditional formatting in Excel
* Benefits of the To-Do Bar in Outlook
* Improved Calendar and Task features

To register: Click Here.   Fee: $79

Microsoft Word 2007: Turn on or off automatic bullets or numbering

By default, if you type an asterisk or a number 1., Word recognizes that you are trying to start a bulleted or numbered list. You can turn off the automatic list recognition feature.
Note: If you turn the feature off and create your list manually, you can’t select and change the list all at once. For example, you can’t select the list and change the color of all of the numbers at one time. 

1. Click the Microsoft Office Button Button image, and then click Word Options.
2. Click Proofing.
3. Click AutoCorrect Options, and then click the AutoFormat As You Type tab.
4. Under Apply as you type, select or clear the Automatic bulleted lists check box or the Automatic numbered lists check box.

SHORTCUT:  The shortcut to achieve this is to click on the “lightning bolt” to the left of the number and select “Stop Automatically Creating Numbered Lists“.

Create Dynamic PowerPoint Presentations with Charts and Diagrams (PowerPoint 2007)

Product(s): Micorosoft Office PowerPoint 2007.
Audience(s): Business Professional.
Date(s): Monday, November 30, 2009, 3:00PM (EDT) U.S.
Duration: 60 Minutes  

Event Overview:

PowerPoint is an effective tool for creating Organization Charts for presentations or print. In addition PowerPoint offers several other templates for creating diagrams that measure workflow and mapping processes. In this workshop we show users how to create diagrams and charts in PowerPoint, edit those diagrams to custom specifications and use the auto format options to make the diagrams visually appealing. We also cover how to customize the look of the diagrams using the object formatting tools within PowerPoint.

To register: Click here.   Fee: $79.00

KnowledgeWave is pleased to bring you Log On To Learn – a virtual learning environment that includes computer instruction, professional development and office productivity.

Here, you will find hundreds of titles and all of the educational content and tutorial clips you need to sharpen your skills and increase your productivity – anytime, anywhere. The Member’s Area of Log on to Learn is updated weekly with fresh, new content covering everything from Microsoft Office to Adobe Creative Suite, Google Analytics, Professional Development and much more!  

Log on to Learn is an online library of our exclusive recorded webinars (webcasts) and short screencasts (videos) with tips and tricks for various applications including but not limited to the Microsoft Office System Suite for your learning needs. New webcasts and screencasts are added weekly, keeping the content coming for our members.

Check it out today and see what all of the buzz is about!  http://www.logontolearn.com

Making Headlines with PowerPoint: A Beginners Guide to Learning the Power of Visual Presentations using Microsoft PowerPoint 2007

Product(s): Microsoft Office PowerPoint 2007.
Audience(s): Business Professional.
Date(s): Wednesday, November 18, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes 

Event Overview:

You’ve been asked to put together a presentation using PowerPoint, and you have no idea how to begin. Get equipped with the skills to do the job. We’re not talking fancy; the goal is to prepare you with the basics, how to put content on slides and get ready to present a show. The bells and whistles can come later.

* Interface Tour
* Create & Edit Slides
* Add Pictures from Computer
* Add ClipArt
* Animations & Transitions
* Run a SlideShow

To Register: Click Here.   Fee: $79.00

Make an Appointment or Meeting Private

1. Create or open the appointment or meeting that you want to make private.
2. On the Appointment tab, in the Options group, click Private.

Note: You should not rely on the Private feature to prevent other people from accessing the details of your appointments, contacts, or tasks. To ensure that other people cannot read the items that you mark as private, do not grant them Read permission to your Calendar, Contacts, or Tasks folders. A person with Read permission to access your folders could use programmatic methods or other e-mail applications to view the details of your private items. Use Private only when you share folders with people whom you trust.

Lights, Camera, Action! Making Movies in Adobe Flash CS4

Product(s): Adobe Flash CS4.
Audience(s): Business Professional.
Date(s): Thursday, November 24, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:
Have you always wondered how people create some of those clever little animations you see on websites? Or, have you been asked to create an interactive graphic and have no idea where to start? If so, this is the Webinar for you! Learn how to morph an image into text and vice versa. Learn how to quickly and easily make an animated movie for your website in this 60-minute Webinar.

This webinar covers the following Flash topics:

* Importing a bitmap image into Flash
* Creating and Modifying Text in Flash
* Converting Text to Shapes
* Converting Shapes to Text
* Create Animation with Frames and Keyframes
* Create a Motion Tween Animation
* Create a Shape Tween Animation

To Register: Click Here.   Fee: $89.00

Mastering Excel – Advanced Formulas and Functions

Product(s): Microsoft Office Excel.
Audience(s): Business Professional.
Date(s): Friday, November 13, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes  

Event Overview:
Excel has well over 300 functions – surely you don’t need to know them all, but you might easily be overlooking significant analytical tools that give you tremendous capabilities to tackle a myriad of statistical, mathematical, and financial challenges.

This 60 minutes webinar gives you exposure to those “buried” functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel even more powerful and efficient.

Also included are some of those valuable formula and function tips that you may have picked up in the Excel Power Tips and Shortcuts webinar – quick formula copying methods, creative use of Ctrl to create formulas in multiple locations simultaneously, and a host of others.

Specific functions that will be covered include: IF, AND, OR, MATCH, INDEX, , FREQUENCY, TREND, GROWTH, TRANSPOSE,  PROPER, UPPER, TRIM, LEFT, RIGHT, INDIRECT, OFFSET, MOD, WEEKDAY, NETWORKDAYS, and DATEDIF.

Power Tips
* Quick cell value changes without formulas
* Displaying Formulas and selecting formula cells
* Multiple cell formulas with the Ctrl key
* Debugging tools and 3-D formulas

Power Functions
* Extended uses of the IF and VLOOKUP Functions using AND, OR, NOT
* MATCH and INDEX functions for complex 2-way lookups

Array Formulas
* Simple applications
* Counting unique entries in a range
* Condense long IF functions substantially
* MATCH and VLOOKUP array formulas

Special Array Functions
* FREQUENCY
* TEND and GROWTH
* TRANSPOSE

COUNTIF, SUMIF, AVERAGEIF and new 2007 functions

Specialized Text Functions
* PROPER, UPPER
* TRIM, LEFT, RIGHT
* Concatenation without CONCATENATE

The INDIRECT Function
* Used with Data Validation for multi-layered pick list scenario

The OFFSET  and MOD Functions

Date Functions
* WEEKDAY – extract day of the week
* NETWORKDAYS – Calculate working days in a time frame
* DATEDIF – Excel’s powerful (but undocumented) date calculator

To Register: Click Here.    Fee: $99.00