Posts Tagged ‘Weekly Tip’
Monthly Tip | Customizing the Ribbon
Thursday, September 2nd, 2010
Customizing the Office® 2010 Ribbon
In Windows® Office® 2010 you can create a custom ribbon tab with custom groups for your frequently used commands.
- 1. Click the File tab and choose Options.
- 2. In the Options dialog gox, click Customize Ribbon.
- 3. Click the New Tab button.
- 4. In the Customize Ribbon area, click on New Tab (Custom) and click the Rename button. Type the name for the tab. Click OK.
- 5. Click on New Group (Custom) and click the Rename button. Key in the name for the group. Click OK.
- 6. Populate the new ribbon: click the appropriate command from the Commands list and click the Add button. Continue until finished.
- 7. Rearrange the buttons on the tab, if needed. Rearrange the placement of the tab on the Ribbon, if needed.
- 8. Click the OK button.
NOTE: Return to the Customize Ribbon window and add and delete buttons to your Custom tab.
Tags: Office 2010, Weekly Tip
Posted in Company Blog, Featured Products, Tip of the Week | Comments Off
Monthly Tip: Windows 7 | Customizing a Library
Thursday, July 1st, 2010
Customizing a Library in Windows® 7
Setting a Library Type
- 1. Open the Library window
- 2. Right-click the appropriate library icon.
- 3. On the shortcut menu, click the Properties command.
- 4. In the Properties dialog box, click the Optimize this library for drop-down list, and select the appropriate option.
- 5. Click the OK button.
Remove a Folder for a Library
- 1. In the Properties dialog box, click the appropriate folder, and then click the Remove button.
- 2. Click the OK button.
Tags: Weekly Tip, Windows 7
Posted in Company Blog, Tip of the Week | Comments Off
Weekly Tip: Word 2007
Working With Styles
Wednesday, July 8th, 2009
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.
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.
Tags: Office 2007, Weekly Tip, Word 2007
Posted in Company Blog, Tip of the Week | Comments Off
Weekly Tip: SharePoint 2007
Add New Calendar Entries
Monday, June 22nd, 2009
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.
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.
Tags: SharePoint 2007, Weekly Tip
Posted in Company Blog, General, Tip of the Week | Comments Off
Weekly Tip: Visio 2007
Placing Shapes
Wednesday, June 3rd, 2009
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.
Tags: Office 2007, visio 2007, Weekly Tip
Posted in Company Blog, General, Tip of the Week | Comments Off
Weekly Tip: Project 2007
Resolving Resource Conflicts
Wednesday, May 27th, 2009
When a resource is scheduled over its predetermined availability, it is said to be overallocated. You can resolve this issue by delaying or splitting its tasks until it can handle the load. This process is known as leveling.
1.) Save the file to protect your information in case you decide the process of leveling does not give you satisfactory results.
2.) From the Tools menu, click the Level Resources command.
3.) In the Resource Leveling dialog box, under the Leveling Calculations section, click the Manual radio button.
4.) Under the Leveling Range group, click the Level Entire Project radio button to level the entire project plan - OR - click the Level radio button to level a portion of the project within a date range.
5.) Under Resolving Overallocations heading, select the appropriate options.
6.) Click the Level Now 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 Project 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.
Tags: Office 2007, Project 2007, Weekly Tip
Posted in Company Blog, General, Tip of the Week | Comments Off
Weekly Tip: Access 2007
Enhancing Forms and Reports
Wednesday, May 20th, 2009
Labels
1.) On the Design Tab, in the Controls gallery, click the Label button.
2.) Click and drag to draw label.
3.) Enter and format the text.
Lines
1.) In the Controls gallery, click the Line button.
2.) Click and drag to draw the line.
NOTE: To draw a straight line, hold the Shift key and then click and drag.
Images
1.) In the Controls gallery, click the Image button.
2.) Click and drag to draw the picture area.
3.) In the Insert Picture dialog box, locate the desired image, and then click the OK button.
Rectangles
1.) In the Controls gallery, click the Rectangle button.
2.) Click and drag to draw the box.
3.) Format as needed.
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 Refrence Card for Microsoft Office Access 2007, contact an adviser for pricing and delivery methods.
Tags: Access 2007, Office 2007, Weekly Tip
Posted in Company Blog, General, Tip of the Week | Comments Off
Weekly Tip: PowerPoint 2007
Collaborating with Others/Reviewing
Monday, May 11th, 2009
Reviewing and Commenting
1.) Open the presentation.
2.) Click the item to add a comment.
3.) Click the Review tab, in the Comments gallery, click the New Comment button.
4.) Enter your comment.
5.) Click outside the comment area or pressing the CTRL + Enter keys to end comment.
NOTE: To change the name used for your comments, click the Office Button, and then click the PowerPoint Options button.
Viewing Others’ Comments
1.) Open the commented presentation
2.) Click the Review tab, in the Comments gallery, and then click the Show Markup button.
3.) Click the Next and Previous buttons to cycle through and read all comments.
4.) Click the Show Markup button to hide the comments.
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 PowerPoint 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Excel 2007 contact an advisor for pricing and delivery.
Tags: Office 2007, PowerPoint 2007, Weekly Tip
Posted in Company Blog, Tip of the Week | Comments Off
Weekly Tip: Excel 2007
Logical Functions
Monday, May 4th, 2009
Using IF
1.) Select the IF function from the Insert Function dialog box.
2.) In the Logical test box, type the condition.
3.) In the Value if true box, type the result if the condition is true.
4.) In the Value is false box, type the result if the condition is false, and then click OK.
NOTE: the Value if true or Value if false can contain a test statement (has quotes), a value, or another formula.
Making Conditions or Criteria
You may want to change your formula if a certain condition is true, or you want to include only values that meet certain conditions.
Using AND or OR
1.) Select the IF function
2.) In Name box, click AND or OR in list.
3.) in Logical 1 box, type the first condition.
4.) in Logical 2 box type the second condition.
5.) Click IF in the formula in the Formula Bar. The IF Function Arguments displays with AND or OR conditions in the Logical test box.
6.) Complete the Value if true and Value if False boxes, and then click OK.
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 Excel 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Excel 2007 contact an advisor for pricing and delivery.
Tags: Excel 2007, Office 2007, Weekly Tip
Posted in Company Blog, Tip of the Week | Comments Off
Weekly Tip: Excel 2007
Sorting Using the Sort Dialog Box
Monday, April 27th, 2009
The Sort dialog box allows you to select different criteria for sorting a list. Using the dialog box allows you to sort by multiple columns and select from several sort methods.
1.) Click a cell in the list.
2.) Click the Data tab, in the Sort & Filter gallery, click the Sort button.
3.) In the Sort dialog box, select the appropriate Column, Sort on and Order options.
4.) Click the Add Level button to add additional criteria, if neccessary.
5.) In the Then by row, select the appropriate options.
6.) 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 Excel 2007 public classes or ask about our Private Consults or Client-Site learning events.
To get the complete Quick Refrence Card for Excel 2007 contact an adivisor for pricing and delivery.
Tags: Excel 2007, Office 2007, Weekly Tip
Posted in Company Blog, Tip of the Week | Comments Off