Change all of the Slide Transitions in your Presentation

1. In the pane that contains the Outline and Slides tabs, click the Slides tab.
2. On the Home tab, click a slide thumbnail.
3. On the Animations tab, in the Transition To This Slide group, click a different slide transition effect.
To see more transition effects on the Quick Styles list, click the More button.
4. To re-set the slide transition speed, in the Transition To This Slide group, click the arrow next to Transition Speed, and then select the speed that you want.
5. In the Transition To This Slide group, click Apply to All.

What are Google Apps?

Product(s): Google Apps
Audience(s): Business Professional.
Date(s): Wednesday, May 12, 2010, 11:00AM (EST) U.S.
Duration: 30 Minutes 

Event Overview:
If you’ve been wondering what this whole Google thing is about, then this is the place to start.  Far beyond a search engine, Google has created a suite of applications and services individuals and businesses.  From email and calendars to word processing and spreadsheets, Google has an app for that.
*Getting Started
Once you’re ready to dive into the world of Google, it’s time to create an account and get the lay of the Google landscape.  This session will show you how to set up a Google account and where some of the basic applications you will use are located and how they work.
*File Sharing
One of the great features of Google Apps is the ability to share files with other Google users.  In this session we discuss the benefits of file sharing and the different methods for using this valuable tool.  We also cover creating shared folders, to share entire document collections.
Revisions
One of the great advantages of using Google Documents is the built-in ability to track revisions to documents.  We will take a look at how to track revisions of shared documents in the Google Documents environment.

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

Log On To Learn presents new short videos on the latest in Google Apps…  Available to you at no charge on You Tube.  Get the up-to-the-minute info you need to get the most out of Google Apps.

Subscribe to our You Tube channel for our continuous video additions on this exciting App and much more.  Go to http://www.youtube.com/user/LogOnToLearn and subscribe today.  Want to know what you can find on You Tube today?  See below for details and get started!

What Are Google Apps?

Product(s): Google Apps
Audience(s): Business Professional.
Duration: 06:55

Event Overview:
If youve been wondering what this whole Google thing is about, then this is the place to start. Far beyond a search engine, Google has created a suite of applications and services individuals and businesses. From email and calendars to word processing and spreadsheets, Google has an app for that!

Getting Started with Google Apps

Product(s): Google Apps
Audience(s): Business Professional.
Duration: 02:45

Event Overview:
Once youre ready to dive into the world of Google, its time to create an account and get the lay of the Google landscape. This session will show you how to set up a Google account and where some of the basic applications you will use are located and how they work.

Visit Log On To Learn for more tutorials and topics. http://www.logontolearn.com.

Log On To Learn presents: Introduction to Google Drawing.  A four-minute video tutorial available to you at no charge on You Tube.

Subscribe to our You Tube channel for our continuous video additions on Google Apps and much more.  Go to http://www.youtube.com/user/LogOnToLearn and subscribe today. 

Introduction to Google Drawing

Product(s): Google Apps
Audience(s): Business Professional.
Duration: 04:02

Event Overview:
New to Google Drawing? Watch this video to learn the basic functions!

Create a formula in a PivotTable report

NOTE: You cannot create formulas in a PivotTable report that is connected to an OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.) data source.

1. Decide whether you want a calculated field or a calculated item within a field.
* Use a calculated field when you want to use the data from another field in your formula.
* Use a calculated item when you want your formula to use data from one or more specific items (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field “Month” could have items such as “January,” “February,” and so on.) within a field.
2. Do one of the following.

Add a calculated field
1. Click the PivotTable report.
2. On the Options tab, in the Tools group, click Formulas, and then click Calculated Field.
3. In the Name box, type a name for the field.
4. In the Formula box, enter the formula for the field.

To use the data from another field in the formula, click the field in the Fields box, and then click Insert Field. For example, to calculate a 15% commission on each value in the Sales field, you could enter = Sales * 15%.
5. Click Add.

Add a calculated item to a field
1. If items in the field are grouped, on the Options tab, in the Group group, click Ungroup.
2. Click the field where you want to add the calculated item.
3. On the Options tab, in the Tools group, click Formulas, and then click Calculated Item.
4. In the Name box, type a name for the calculated item.
5. In the Formula box, enter the formula for the item.

To use the data from an item in the formula, click the item in the Items list, and then click Insert Item (the item must be from the same field as the calculated item).
6. Click Add.
7. If you ungrouped items in step 1, regroup them if you want. For more information, see Group items in a PivotTable field

For calculated items, you can enter different formulas cell by cell.

For example, if a calculated item named OrangeCounty has a formula of =Oranges * .25 across all months, you can change the formula to =Oranges *.5 for June, July, and August.

Do the following:

1. Click a cell for which you want to change the formula.

To change the formula for several cells, hold down CTRL and click the additional cells.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), type the changes to the formula.

If you have multiple calculated items or formulas, adjust the order of calculation by doing the following:

1. Click the PivotTable report.
2. On the Options tab, in the Tools group, click Formulas, and then click Solve Order.
3. Click a formula, and then click Move Up or Move Down.
4. Continue until the formulas are in the order that you want them to be calculated.

Microsoft PowerPoint 2007: Inserting, playing, and modifying movies

Sometimes the best way to ensure that your audience understands your message is to show a video or animation, collectively referred to in PowerPoint as movies. For example, if your company has developed a short advertising video, it makes more sense to include the video in a presentation about marketing plans than to try and describe it with bullet points or even still pictures. You can insert the following types of movies in slides:

* Video clips. You can insert a digital video file in one of two ways: If a slide’s layout includes a content placeholder, you can click the Insert Movie button in the placeholder. You can also click the Movie button in the Media Clips group on the Insert tab. Either way, the Insert Movie dialog box opens so that you can select the file. Before PowerPoint inserts the file, you specify whether the video should play automatically when the slide containing it appears or whether you will start the video manually.
* Animated clips. PowerPoint comes with several animated graphics. You insert these animated objects by clicking the Movie arrow in the Media Clips group on the Insert tab, and then clicking Movie From Clip Organizer to display the Clip Art task pane, where you can select the clip you want. If you are connected to the Internet, clicking the Clip Art On Office Online link in the task pane takes you to the Office Online Clip Art and Media Web site, from which you can download hundreds of clip art images, photos, sounds, and animated clips.

Videos and animated clips both appear on the slide as objects represented by icons that you can size and move to meet your needs. When you select an animated clip object, PowerPoint adds a Format contextual tab to the Ribbon so that you can adjust the way it looks on the slide. When you select a movie object, PowerPoint also adds an Options contextual tab so that you can adjust the object’s size and position, its volume, how it is displayed on the slide, and how it is activated.

In Normal view, you can preview a video by double-clicking its icon or by clicking the Preview button in the Play group on the Options contextual tab. You can preview the action of an animated clip by clicking the arrow that appears when you select it in the Clip Art task pane and then clicking Preview/Properties. In Slide Show view, a video plays either automatically or when you click its icon, depending on your specifications, whereas an animated clip always plays automatically.

Date(s): March 1-5, 2010
Duration: 5 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to introduce MS6231: Maintaining a Microsoft SQL Server 2008 Database.  This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. Hurry, seating is limited! 800.831.8449.

Location: 30 Community Drive, Suite 5, South Burlington VT 05403
To register: Click here or call 800.831.8449

Objectives:

Module 1: Installing and Configuring SQL Server
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning

Use Outlook with Comcast e-mail
(applies to Microsoft Office Outlook 2002 and 2003)

You can use Outlook with your Comcast e-mail account. The following steps will set up Outlook to both receive and send e-mail messages with your Comcast account.

Note:  You can receive your Comcast e-mail messages by using Outlook from most places with an Internet connection. Comcast provides you access to an authenticated SMTP server — allowing you to send e-mail messages using Outlook from your Comcast account when you are using another Internet service, such as at your office or when traveling.

Add your Comcast Email account:

1. On the Tools menu, click E-mail Accounts.
2. Select Add a new e-mail account, and then click Next.
3. Select POP3, and then click Next.
4. Under User Information, do the following:
***In the Your Name box, type your full name the way you want it to appear to other people.
***In the E-mail Address box, type your e-mail user name followed by @comcast.net.
5. Under Server Information, do the following:
***In the Incoming mail server (POP3) box, type mail.comcast.net.
***In the Outgoing mail server (SMTP) box, type smtp.comcast.net.
6. Under Logon Information, do the following:
***In the User Name box, type your user name provided by Comcast.
***In the Password box, type your password.
***Select the Remember password check box.
Note  You have the option to have Outlook remember your password by typing it in the Password box and selecting the Remember password check box. Having Outlook remember your password means that you won’t have to type your password each time you access the account; however, it also means that the account is vulnerable to anyone who has access to your computer. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don’t have to write it down.
7. To verify that your account is working, click Test Account Settings. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it. Make sure your computer is connected to the Internet.
8. Click More Settings.
9. On the General tab, under Mail Account, type Comcast.
Note  If you are attempting to send and receive Comcast e-mail messages from a location where you are not directly connected to Comcast, such as at work or when travelling, see the Notes section for additional steps.
10. Click OK, and then click Next.
11. Click Finish.

Notes
* Do not select the Log on using Secure Password Authentication (SPA) check box.
* Unless specified by Comcast, all server and address entries are typed in lowercase letters.
* To send and receive e-mail messages with your Comcast account when you are not directly connected to the Comcast service, such as at work or when travelling, you must use the following:
***After step 9 above, click the Outgoing Server tab, and then select the My outgoing server (SMTP) requires authentication check box.
***Select Use same settings as my incoming mail server.
***Continue with step 10 above.

Microsoft Excel - Cleaning up Excel Data

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

Event Overview:

These days, Excel users are doing less data entry and a lot more downloading data from other sources. Whether that data is coming from Access, some other data base software, or a poorly designed Excel worksheet, it isn’t always in the best of shape.
Excel has a variety of functions, commands, and techniques that let you quickly re-structure data, remove unwanted characters, get rid of empty cells, rows, and columns, and prepare data for efficient analysis. This webinar will use Excel 2007, but will demonstrate techniques in Excel 2003 for those features that have been altered.

What you will learn:

The Text to Columns command
* A powerful, yet simple command sequence that lets you quickly split data (improperly grouped into one column) into multiple columns; includes techniques for handling Julian dates another unusual groupings.

How to transpose data
* a simple copy technique to convert data from a row/column into a column/row layout.
How to remove duplicate data
* Use either Excel’s new 2007 command (Remove Duplicates) or the Advanced Filter in Excel 2003 to eliminate duplicate records.

The Find/Replace command sequence, including using special wild cards.

Critical Text functions
* (LEFT, RIGHT, and MID) for character extraction; REPLACE and SUBSTITUTE for character swapping; CLEAN and TRIM functions to remove unwanted characters; PROPER and UPPER for quick uppercase/lowercase conversion.

Concatenation techniques for pulling together data from different locations

Sorting techniques to eliminate blank rows or columns from data

Techniques for learning how to:
* Convert text data to values
* Remove trailing minus signs while converting data into negative values
* Fill in missing title data from columns containing first entries only
* Alter any kind of date data into a more useful computational form

To Register: Click Here.  Fee: $99.00

KnowledgeWave is pleased to introduce MS6421: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure. This five-day course provides students with the knowledge and skills to configure and troubleshoot a Windows Sever 2008 network infrastructure. Students will learn to implement and configure secure network access and implement fault tolerant storage technologies. Students will gain an understanding of the network technologies most commonly used with Windows Server 2008 and IP-enabled networks. Students will also learn how to secure servers and maintain update compliance.

Click here for a complete course outline and call us today to reserve your spot - hurry, seating is limited! 800.831.8449.

Date(s): November 30 – December 4, 2009
Duration: 5 days
Format: Instructor-led, Classroom training
Location: 30 Community Drive, Suite 5, South Burlington VT 05403
To register: Click here or call 800.831.8449.