Archive for April, 2010

PC Tip of the Week: Microsoft Word 2007

Tuesday, April 27th, 2010

Insert a Blank Line Before a Table

Use this procedure to insert a blank line before a table that is on the first line of the first page in a document.

1. Click in the upper-left cell in the first row of the table.
**Note   If you have text in the upper-left cell, place the insertion point before the text.
2. Press ENTER.

PC Tip of the Week: Microsoft Office Outlook 2007

Tuesday, April 20th, 2010

Change the appearance of your e-mail message

Add a background color, gradient, texture, pattern, or picture

1. On the Message Options tab, in the Themes group, click Page Color.
2. Click a color on the Theme Colors or Standard Colors palette. To remove the color, click No Color.
3. If you want to add a gradient, texture, pattern, or picture, click Fill Effects.
4. Select the fill options that you want.

Tip: The color of the gradient, texture, or pattern is based on the color that you select in step 2.

Webinar: Using Macros in Microsoft Excel 2007

Monday, April 19th, 2010

Save Time, Work Less: The Power of Using Macros to Complete Repetitive Tasks in Microsoft Excel 2007

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

Event Overview:
Do you wish you could find a way to increase your accuracy in data manipulation and get it all done faster? These days, it seems there’s more to do and less time in which to do it, so it’s crucial to find ways to automate your every day tasks. Efficiency will help eliminate your daily grind. With so much information on your hands, it can be painstaking and time-consuming to sift through data and manipulate it to present exactly what you’re looking for.

Macros are one of Microsoft Excel’s most powerful, yet most underused, tools. Many users are familiar with the term but have never learned how to take advantage of all macros have to offer. They might sound complicated; within this one hour Webinar we will show you how to become a more proficient user with automating your tasks. You will be working smarter and faster than ever before!

About the Presenter: With 8+ years of experience teaching the Microsoft Office Suite, David Thibault, Director of Education for KnowledgeWave Training in South Burlington, VT uses his upbeat, high energy teaching style in the classroom and online.  David has led corporate implementations of new software and written courseware for all applications in the Office Suite and 3rd party software.  He continues to specialize in classroom instruction as well as delivering corporate and open enrollment webinars.  His years in the field managing consulting projects have ranged from rollouts to upgrades and mentoring services, giving him the “real-world” knowledge that brings so much value to his classroom and online lessons.

To Register: Click Here. Fee: $99.00

No-Fee Videos: Google Apps Tutorials

Friday, April 16th, 2010

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.

No-Fee Video: Introduction to Google Drawing

Thursday, April 15th, 2010

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!

Webinar: PivotTables in Microsoft Excel 2007

Thursday, April 15th, 2010

Look at Your Data in a Whole New Way with PivotTables in Microsoft Excel 2007

Product(s): Microsoft Office Excel 2007
Audience(s): Business Professional.
Date(s): Wednesday, April 21, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Grab a comfortable seat and we’ll walk you through a one-hour Webinar on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do.

About the Presenter: With 8+ years of experience teaching the Microsoft Office Suite, David Thibault, Director of Education for KnowledgeWave Training in South Burlington, VT uses his upbeat, high energy teaching style in the classroom and online.  David has led corporate implementations of new software and written courseware for all applications in the Office Suite and 3rd party software.  He continues to specialize in classroom instruction as well as delivering corporate and open enrollment webinars.  His years in the field managing consulting projects have ranged from rollouts to upgrades and mentoring services, giving him the “real-world” knowledge that brings so much value to his classroom and online lessons.

To Register: Click HereFee: $99.00

PC Tip of the Week: Microsoft Excel 2007

Tuesday, April 13th, 2010

Change the Chart Type of an Existing Chart

For most 2-D charts, you can change the chart type of the whole chart to give the chart a different look, or you can select a different chart type for any single data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), which turns the chart into a combination chart.
For bubble charts and most 3-D charts, you can only change the chart type of the whole chart.

NOTE:   To complete this procedure, you must have an existing chart. For more information about how to create a chart, see Create a chart.

1. Do one of the following:
* To change the chart type of the whole chart, click the chart area (chart area: The entire chart and all its elements.) or plot area (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.) of the chart to display the chart tools.
* To change the chart type of a data series, click that data series.

NOTE:    You can change the chart type of only one data series at a time. To change the chart type of more than one data series in the chart, repeat the steps of this procedure for each data series that you want to change.

Tip:   This displays the chart tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Change Chart Type.
3. In the Change Chart Type dialog box, do one of the following:
* Click a chart type in the first box, and then click the chart subtype that you want to use in the second box.
* If you saved a chart type as a template, click Templates, and then click the chart template that you want to use in the second box.
Tip: If you use a specific chart type frequently when you create a chart, you may want to set that chart type as the default chart type. After you select the chart type and the chart subtype in the Change Chart Type dialog box, click Set as Default Chart.

MS6291: Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta

Thursday, April 8th, 2010

Date(s): April 26-28, 2010
Duration: 3 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to introduce MS6291: Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta.  This three-day instructor-led course provides students with the knowledge and skills to work with the new technologies in Windows Vista and Windows 7 Beta. This course is intended for individuals who already have experience with Windows XP to upgrade their skills to Windows 7 Beta.  Seating is limited so call us today for more information!

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

Objectives:

Module 1: Introduction to User Productivity Enhancements
Module 2: Managing Desktop Configurations
Module 3: Introduction to Remote Access
Module 4: Introduction to Windows 7 Beta Security Components
Module 5: Deploying Windows 7 Beta Images
Module 6: Troubleshooting in Windows 7 Beta

CISSP: Certified Information System Security Professional

Wednesday, April 7th, 2010

Date(s): May 3-7, 2010
Duration: 5 days
Format: Instructor-led, Classroom training

KnowledgeWave is pleased to present: Certified Information Systems Security Professional (CISSP): Second Edition! This course will expand upon your knowledge by addressing the essential elements of the 10 domains that comprise a Common Body of Knowledge (CBK) for information systems security professionals. The course offers a job-related approach to the security process, while providing the basic skills required to prepare for CISSP certification. Seating is limited so call us today for more information!

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

Objectives:

Lesson 1: Information Systems Access Control
Lesson 2: Security Architecture and Design
Lesson 3: Network and Telecommunications Security
Lesson 4: Information Security Management Goals
Lesson 5: Information Security Classification and Program Development
Lesson 6: Risk Management and Ethics
Lesson 7: Application Security
Lesson 8: Cryptography
Lesson 9: Physical Security
Lesson 10: Operations Security
Lesson 11: Business Continuity and Disaster Recovery Planning
Lesson 12: Legal, Regulations, Compliance, and Investigations

PC Tip of the Week: Microsoft Excel 2007

Tuesday, April 6th, 2010

Rename a PivotTable or PivotChart Report

When you create a PivotTable or PivotChart report, Microsoft Office Excel assigns default names to each of these objects by using the following naming conventions: PivotTable1, PivotTable2, and so on; and Chart 1, Chart 2, and so on. However, you can change the name of each object to make it more meaningful to you.

PivotTable report

1. Click the PivotTable report.
2. On the Options tab, in the PivotTable group, click the PivotTable Name text box.
3. Type a new name.
4. Press ENTER.

PivotChart report

1. Click the PivotChart report.
2. On the Layout tab, in the Properties group, click the Chart Name text box.
3. Type a new name.
4. Press ENTER.