Archive for May, 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 Houston. 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.
Posted in Monthly Tip | Comments Off
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 Houston. 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.
Posted in Monthly Tip | Comments Off
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 Houston. 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.
Posted in Monthly Tip | Comments Off
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 Houston. 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.
Posted in Monthly Tip | Comments Off
ALPHARETTA, Ga., May 1, 2009 – ExecuTrain, a leading worldwide corporate training provider, is pleased to announce a dramatic expansion in its participation in the Microsoft Certified Partners for Learning Solutions (CPLS) program. There are now ExecuTrain CPLS centers in more than 30 cities around the world, with others expected to join the program soon. Current ExecuTrain CPLS locations include:
CPLS Locations in the USA
- Texas: Austin, Dallas, and Houston
- Arizona: Phoenix
- California: Irvine, Ontario, Sacramento, and San Francisco
- Colorado: Denver
- Connecticut: Stamford
- Florida: Ft. Lauderdale
- Georgia: Atlanta
- Idaho: Boise
- Indiana: Ft. Wayne, Kokomo, and South Bend
- Kansas: Kansas City and Wichita
- Kentucky: Lexington and Louisville
- Missouri: St. Louis
- Nevada: Las Vegas
- New York: Long Island
- Utah: Salt Lake City
Global CPLS Locations
- Mexico: Guadalajara, Hermosillo, and Querétaro
- Saudi Arabia: Riyadh
- South Africa: Johannesburg (Sandton)
- UAE: Dubai
About ExecuTrain
ExecuTrain is a leading worldwide corporate training provider. The privately-held U.S. based company has 150 locations in 25 countries. For almost a quarter century, ExecuTrain has offered assessment, design, development and implementation of professional learning solutions to companies worldwide. The organization offers comprehensive, customer-focused solutions that incorporate desktop applications training, IT professional certification, online learning, business skills training, learning management systems, custom solutions, management training, training outsourcing, room rentals and project management services. ExecuTrain’s priority is to remain ahead of the curve with the most recent updates in technology, curriculum and facilities, thus allowing clients to focus on their core business. For more information, visit www.executrainhouston.com or call 713.402.1900
###
Posted in Company Blog, Press Releases | Comments Off
Microsoft, Windows, Access, Aero, Excel, Outlook, PowerPoint, and Visio are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
