Dan St. Hilaire

Recent Posts

Chart Templates in Microsoft Excel 2007

Posted by Dan St. Hilaire  /  June 9, 2010  /  Excel   —   No Comments ↓

Save a Chart as a Chart Template

1. Click the chart that you want to save as a template.

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Save As Template.

3. In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

4. In the File name box, type an appropriate name for the chart template.

Read More ›

Tags: Excel

Changing the Document Author in Microsoft Word

Posted by Dan St. Hilaire  /  June 3, 2010  /  Word   —   1 Comments ↓

Microsoft Word 2007: Change the author name for documents
Every time you create a new document, Microsoft Office Word sets the Author property based on the User name setting that appears in the Word Options dialog box. The User name setting also provides the name and initials that are displayed in comments and tracked changes.
Change the author name in an existing document
1. Click the Microsoft Office Button Button point to Prepare, and then click Properties.
2. In the Document Information Panel, type the author name in the Author box.
Note: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.

Read More ›

Tags: Word

Previewing Attachments in Microsoft Outlook

Posted by Dan St. Hilaire  /  May 27, 2010  /  Outlook   —   No Comments ↓

Microsoft Outlook 2007: Preview attachments

Read More ›

Tags: Outlook

No-Fee Webinar: What are Google Apps?

Posted by Dan St. Hilaire  /  May 10, 2010  /  Webinars   —   No Comments ↓

What are Google Apps?

Read More ›

Tags: Webinars

Using Portrait and Landscape Orientation in the Same Document

Posted by Dan St. Hilaire  /  May 4, 2010  /  Word   —   No Comments ↓

Microsoft Word 2007

1. Select the pages or paragraphs that you want to change to portrait or landscape orientation.
**Note: If you select some but not all of the text on a page to change to portrait or landscape orientation, Word places the selected text on its own page, and the surrounding text on separate pages.
2. On the Page Layout tab, in the Page Setup group, click Margins.
3. Click Custom Margins.
4. On the Margins tab, click Portrait or Landscape.
5. In the Apply to list, click Selected text.
**Note: Microsoft Word automatically inserts section breaks before and after the text that has the new page orientation. If your document is already divided into sections, you can click in a section (or select multiple sections), and then change the orientation for only the sections that you select.

Read More ›

Tags: Word

How To Get a Blank Line Above a Table

Posted by Dan St. Hilaire  /  April 27, 2010  /  Word   —   2 Comments ↓

Microsoft Word 2007: 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.

Read More ›

Tags: Word

Free Videos: Google Apps Tutorials

Posted by Dan St. Hilaire  /  April 16, 2010  /  KnowledgeWave News   —   No Comments ↓

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.


Read More ›

Tags: KnowledgeWave News

Free Video: Introduction to Google Drawing

Posted by Dan St. Hilaire  /  April 15, 2010  /  KnowledgeWave News   —   No Comments ↓

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

Read More ›

Tags: KnowledgeWave News

CISSP: Certified Information System Security Professional

Posted by Dan St. Hilaire  /  April 7, 2010  /  KnowledgeWave Courses   —   No Comments ↓

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

Read More ›

Tags: KnowledgeWave Courses

How to Change the Name of a PivotTable or PivotChart

Posted by Dan St. Hilaire  /  April 6, 2010  /  Excel   —   No Comments ↓

In Microsoft Excel 2007

Read More ›

Tags: Excel

Prevent Page Breaks in the Middle of a Paragraph

Posted by Dan St. Hilaire  /  March 30, 2010  /  Word   —   No Comments ↓

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

Read More ›

Tags: Word

Create a Formula in a PivotTable Report in Microsoft Excel 2007

Posted by Dan St. Hilaire  /  March 23, 2010  /  Excel   —   No Comments ↓

Create a formula in a PivotTable report

Read More ›

Tags: Excel

The First Page is Special

Posted by Dan St. Hilaire  /  March 16, 2010  /  Word   —   No Comments ↓

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.

Read More ›

Tags: Word

How Do I Type Text Above a Table at the Top of the Page?

Posted by Dan St. Hilaire  /  March 9, 2010  /  Word   —   No Comments ↓

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

Read More ›

Tags: Word

Presentations are Cooler with Movies

Posted by Dan St. Hilaire  /  March 2, 2010  /  PowerPoint   —   No Comments ↓

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.

Read More ›

Tags: PowerPoint