ExecuTrain Austin

At ExecuTrain we drive performance and opportunity

Jan

12

Weekly Tip: Windows 7 | Searching for Files

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

Search for Files in Windows® 7

Windows 7 includes several different tools for locating files stored on your computer or your company network.

Searching from the Start Menu

  1. 1. Click the Start button.
  2. 2. On the Start menu, enter the known criteria. Note: Windows will show the matching results as you enter the criteria. In most cases you only have to enter the first part of the search information.
  3. 3. In the results list, click the desired item. Note: If necessary click the See more results hyperlink.

Start Menu Search

 

Windows Explorer Search

  1. 1. Access the Windows Explorer window.
  2. 2. In the Search text box, located in the upper, right-hand corner of the window, enter the search criteria. Note: A list of matching results will display in the Windows Explorer window as you enter the information for the search.
    – OR –
    Click the drop-down arrow in the Search text box, to select a previously used search option.

Explorer Search

3. Click the Show Preview button to view the contents before opening the file.

Oct

05

Weekly Tip: Office 2007 | Ribbons

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

One of the biggest changes in Microsoft® Office 2007 is the addition of the Office Ribbon which includes the Office Button, Quick Access Toolbar, and Tabs. The Tabs replace the Menus and Toolbars with a graphical representation of the available options within the application.  The options are grouped based on common actions and page elements, allowing you to apply the options to your document, spreadsheet or presentation rapidly.

The Tabs available change depending on the application in which you are working and the type of element you are working with. For example, if you select a photo or graphic within your document, the Picture tab displays. When you click off of the object, the Picture tab is then hidden.

To minimize the tabs, complete the following action:
· Click the Customize Quick Access Toolbar button, and then click the Minimize the Ribbon link. – OR – Double-click any tab name.

ribbon-450

Sep

02

Weekly Tip: Access 2007 | Displaying a Calendar

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

Displaying a Calendar
image0021
1. Open the form in Design view.
2. On the Design tab, in the Controls gallery,
click the Insert ActiveX Control button.
image0051
3. In the Insert ActiveX
Control dialog box, click the Calendar Control 12.0 option,
and click the OK button.
4. Click in the form at the location for the
calendar.

image0061
5. Size and arrange the calendar on the form.
Use the calendar’s Properties dialog box to
customize its looks.

This Tip of the Week was brought to you
by the learning professionals at ExecuTrain Austin.

To learn more, sign up for one of our Microsoft Office Access 2007 public classes
or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office,
contact a learning specialist for pricing and delivery.

Jul

29

Weekly Tip: PowerPoint 2007
Grouping Objects

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

Grouping Objects

image004

Grouping and Ungrouping Objects
1. Press and hold the SHIFT key and select the objects you want to group.
· To group:
Click the Home tab, in the Drawing gallery, click the Arrange drop-down arrow, and then click the Group option.
· To ungroup:
Click the Home tab, in the Drawing gallery, click the Arrange drop-down arrow, and then click the Ungroup option.


This Tip of the Week was brought to you by the learning professionals at ExecuTrain Austin. To learn more, sign up for one of our Microsoft Office PowerPoint 2007 public classes or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.

Jul

21

Weekly Tip: Excel 2007
Merging Excel Workbooks

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

1. On the Quick Access toolbar, click the Customize Quick Access Toolbar button, and then click the More Commands option.
2. In the Excel Options dialog box, in the Choose commands from drop-down list, click the Commands not in the Ribbon option.
3. Locate and click the Compare and Merge Workbook command, click the Add button and then click the OK button.
4. Open the copy of the shared workbook into which you want to merge changes.image0031
5. On the Quick Access tool bar, click the Compare and Merge Workbooks button.
6. In the Select Files to Merge Into Current Workbook dialog box, select all copies of the shared workbook containing changes to be merged.
7. Click OK.

Note: Cells that have been modified are marked with a black triangle. Place the mouse over the cell to view the change.

This Tip of the Week was brought to you by the learning professionals at ExecuTrain Austin. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.

Jul

15

Weekly Tip: Outlook 2007
Send a Calendar via E-Mail

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

image0021

Send a Calendar Via E-Mail

This feature allows for a snapshot of calendar items to be sent to an e-mail recipient.

1. In the Navigation Pane, click the Calendar button.
2. On the Calendar pane, click the Send a Calendar via E-mail link.
3. In the Send a Calendar via E-mail
dialog box, in the Calendar drop-down list, select the appropriate option.
4. In the Date Range drop-down list, select the appropriate dates.
5. In the Detail drop-down list, select the
appropriate option.
6. Click the Show button, and then select any additional options.
7. Click the OK button, and then complete and send the message.

Jul

13

ExecuTrain Virtual Campus:
Shoestring Budget

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

When your training budget is tight (and whose isn’t) what are your
options? Training continues, but sometimes on a shoestring. But
you don’t have to make concessions in your budget when it comes to
quality and effectiveness. Many companies operating on a shoestring
are incorporating e-Learning into their education mix. Simply put,
e-Learning delivers more training to more people, and can be very
cost effi cient, leaving more for your bottom line. e-Learning can be
used alone or coupled with instructor-led learning, which allows the
classroom learning experience to expand to day-to-day use. Since
learning isn’t an event, but an ongoing process, e-Learning supports
and augments each instructor-led learning experience. There are
other advantages, too:

  • Employees learn when they have the time, increasing participation.
  • A wide range of courses means employees receive all the training they need.
  • When new training needs arise, they can be met immediately.
  • Consistent training anywhere in the world.

Jul

08

Weekly Tip: Word 2007
Working With Styles

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

Working with Styles

In Microsoft® Word, a style is a set of formatting options saved with a single name. Since applying a style applies the formatting to all associated text in the document, you can change the entire document by editing the style.

Creating a Style
1. On the Home tab, in the Styles gallery, click the More button.
2. In the Styles dialog box, click the New Style button .
3. In the Create New Style dialog box, in the Name text box, enter a name for the style.
4. In the Style Type list, click either the Paragraph or Character option.
5. In the Based on area, choose a style as a starting point.
6. Click the Format button, and click the available options to set the
corresponding properties.
7. Click the OK button.

image002

Applying a Style
1. Select the desired text.
2. On the Home tab, in the Styles gallery, click the desired style.

Modifying a Style
1. Access the Styles dialog box.
2. Mouse over the desired style, click the drop-down arrow.
3. Click the Modify option.
4. Change the properties for the appropriate format option.
5. In the Styles dialog box, click the OK button

This Tip of the Week was brought to you by the learning professionals at ExecuTrain Austin. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.

Jun

22

Weekly Tip: SharePoint 2007
Add New Calendar Entries

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

image004

Calendar lists are a communication tool that provide site visitors with information about upcoming events and activities. The Calendar list is a default content area within several of the site templates for Windows® SharePoint® Services and Microsoft Office® SharePoint® Server. Calendars can include document attachments which contain additional information related to the event. Calendar lists have three default views: a summary list view, a detail list view and a calendar view.

1. On the Home page, click the Add new event link.
image0031
2. In the Calendar: New Item dialog box, in the Title text box, enter the appropriate name.
3. In the Location text box, enter the appropriate details.
4. In the Start Time and End Time text boxes, enter the appropriate details.
5. In the Description text box, enter the appropriate details.
6. In the All Day Event group, click the check box, if appropriate.
7. In the Reoccurrence group, click the check box, if necessary, and enter the appropriate information.
8. Click the Attach File button, and then locate and open the appropriate file.
9. Click the OK button.

This Tip of the Week was brought to you by the learning professionals at ExecuTrain Austin. To learn more, sign up for one of our Microsoft Office SharePoint 2007 public classes or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office, contact an adivisor for pricing and delivery.

Jun

03

Weekly Tip: Visio 2007
Placing Shapes

Share | Bookmark | Print:
  • Digg
  • del.icio.us
  • Furl
  • Google
  • Print this article!

The first step in developing a Basic Flowchart is deciding which Master Shapes to include and then placing them on the diagram. Each shape serves a specific purpose and demonstrates a particular aspect of the drawing.

1.) If necessary, display the Drawing Grid (on the View menu, click the Grid command).
2.) Click the stencil bar containing the desired Master Shape.
3.) Click and drag the shape onto the page, and then release the mouse.
4.) Repeat steps 2 and 3 for each general shape type, as needed.

To duplicate shapes easily: Press and hold the Ctrl key, then click and drag the desired shape to the new location.

Check:

Thank you! One of our advisors will contact you shortly.