Microsoft Word 2007: Prevent page breaks in the middle of a paragraph 
1. Select the paragraph that you want to prevent from breaking onto two pages.
2. On the Page Layout tab, click the Paragraph Dialog Box Launcher, and then click the Line and Page Breaks tab.
3. Select the Keep lines together check box.
Date(s): March 29-31, 2010
Duration: 3 days
Format: Instructor-led, Classroom training
KnowledgeWave is pleased to introduce MS6292: Installing and Configuring Windows 7 Client. This three-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about Windows 7 Client. In this course, students learn how to install, upgrade, and migrate to Windows 7 client. Students then configure Windows 7 client for network connectivity, security, maintenance, and mobile computing. This course helps students prepare for the Exam 70-680, TS: Windows 7, Configuring. Call today for more information… Seating is limited!
Location: 30 Community Drive, Suite 5, South Burlington VT 05403
To register: Click here or call 800.831.8449
Objectives:
Module 1: Installing, Upgrading, and Migrating to Windows 7
Module 2: Configuring Disks and Device Drivers
Module 3: Configuring File Access and Printers on Windows 7 Client Computers
Module 4: Configuring Network Connectivity
Module 5: Configuring Wireless Network Connections
Module 6: Securing Windows 7 Desktops
Module 7: Optimizing and Maintaining Windows 7 Client Computers
Module 8: Configuring Mobile Computing and Remote Access in Windows 7
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.
Make the First Page Header or Footer Different from the Rest of the Pages
1. On the first page of the document, double click the header or footer area.
2. Under Header & Footer Tools, on the Design tab, in the Options group, select the Different First Page check box.
Note If your document includes a cover page from the gallery of cover pages in Office Word 2007, the Different First Page option is already turned on. Inserting or editing a header or footer on this page does not affect the other pages in the document.
3. Create a header or footer, or make changes to the existing header or footer, on the first page.
Date(s): March 22-26, 2010
Duration: 5 days
Format: Instructor-led, Classroom training
KnowledgeWave is pleased to introduce MS6419: Configuring, Managing and Maintaining Windows Server 2008 Servers. This five-day instructor-led course combines five days worth of instructor-led training content from the Network Infrastructure Technology Specialist, Active Directory Technology Specialist, and IT Professional Server Administrator courses of Windows Server 2008 to provide students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server 2008 environment. This course covers the core skills required by anyone working with Windows Server 2008 Servers. 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: Introduction to Managing Microsoft Windows Server 2008 Environment
Module 2: Creating Active Directory Domain Services User and Computer Objects
Module 3: Creating Groups and Organizational Units
Module 4: Managing Access to Resources in Active Directory Domain Services
Module 5: Configuring Active Directory Objects and Trusts
Module 6: Creating and Configuring Group Policy
Module 7: Configuring User and Computer Environments Using Group Policy
Module 8: Implementing Security Using Group Policy
Module 9: Configuring Server Security Compliance
Module 10: Configuring and Managing Storage Technologies
Module 11: Configuring and Managing Distributed File System
Module 12: Configuring Network Access Protection
Module 13: Configuring Availability of Network Resources
Module 14: Monitoring and Maintaining Windows Server 2008 Servers
Module 15: Managing Windows Server 2008 Backup and Restore
Microsoft Word 2007: I Can’t Insert Text Before a Table
Symptoms
You can’t insert text before a table that is located on the first line of the first page in a document.
Resolution
1. Click in the first cell in the first row of the table.
* Note: If text in that cell contains text, position the insertion point before the text.
2. Press ENTER.
3. Type the text that you want.
KnowledgeWave is pleased to introduce VMware vSphere: Fast Track: the intensive, extended-hours training course focusing on installing, configuring, managing, and troubleshooting VMware® vSphere™. It combines the content of the VMware vSphere 4: Install, Configure, Manage course with advanced tasks and skills for configuring a highly available and scalable virtual infrastructure. See below for a complete course outline and call us today to reserve your spot – hurry, seating is limited! 800.831.8449.
Date(s): March 15-19, 2010
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 
Objectives:
Module 1: Course Introduction
Module 2: Introduction to VMware Virtualization
Module 3: Configuring VMware ESX/ESXi
Module 4: Installing and Using VMware vCenter Server
Module 5: Networking
Module 6: Storage
Module 7: Virtual Machines
Module 8: Access Control
Module 9: Resource Monitoring
Module 10: Scalability
Module 11: High Availability and Data Protection
Module 12: Configuration Management
Module 13: Installing ESX
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.
