Available Date(s): July 9-13, 23-27, August 6-10, 20-24, September 17-21
Format: Instructor-led, Classroom training

In Microsoft Excel 2007

Microsoft Word 2007: Prevent page breaks in the middle of a paragraph

Create a formula in a PivotTable report

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.

Microsoft Word 2007: I Can't Insert Text Before a Table

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.

Microsoft Outlook 2007: Change your Calendar Work Days

By default in Microsoft Office Outlook 2007, the work week is set from Monday through Friday with a work day extending from 8 A.M. to 5 P.M.. The first day of the week in Calendar is Sunday.

You can choose the days of the week that are a part of your work week, the time when your work day starts and ends, and the day of the week that you want to be the start of your week.

Change your Calendar work days

1. On the Tools menu, click Options.
2. Click Calendar Options.
3. Under Calendar work week, select the check boxes for the days that are a part of your work week. Clear the check boxes for the days that are not a part of the work week.

Microsoft Outlook 2007: Add Holidays to Calendar

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, click Add Holidays.
3. Select the check box next to each country/region whose holidays you want to add to your calendar, and then click OK.

Note Your own country/region is automatically selected.

If you already added a country's or region's holidays to your calendar, the check box for that country/region is selected in the Add Holidays to Calendar dialog box. If you try to add the same items again, you receive the following message:

Holidays for country/region are already installed. Do you want to install them again?

If you click Yes, the holidays and events are installed a second time, and you see duplicate holiday and event entries.

Note The holiday information that is provided with Outlook includes items during calendar years 2006 through 2012. If you are using a non-Gregorian calendar, items that occur during the same time period are included.

Microsoft Outlook 2007: Prevent meeting request replies

Microsoft Office Outlook 2007: Change the sound played for reminders

Restrict formatting in Word 2007 Documents

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

Microsoft Office Excel 2007: Clear a PivotTable report or PivotChart report

Microsoft Office Excel: Edit a macro

Before you edit a macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), you should be familiar with the Visual Basic Editor (Visual Basic Editor: An environment in which you write new and edit existing Visual Basic for Applications code and procedures. The Visual Basic Editor contains a complete debugging toolset for finding syntax, run-time, and logic problems in your code.). The Visual Basic Editor can be used to write and edit a macro that is attached to a Microsoft Office Excel workbook.

1. If the Developer tab is not available, do the following to display it:
a. Click the Microsoft Office Button Button image, and then click Excel Options.
b. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
2. To set the security level temporarily to enable all macros, do the following:
a. On the Developer tab, in the Code group, click Macro Security. 2.
b. Under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
3. On the Developer tab, in the Code group, click Macros.
4. In the Macro name box, click the macro that you want to edit.
5. Click Edit.