Share | Bookmark | Print:
ExecuTrain can provide you with the training you need to prepare for your Microsoft Business Certification path. With our bundled package of online training and instructor led classes, you can keep on track for your certification preparation.
Our bundled package includes one year of access to our Microsoft Office Pack online library and a coupon for attendance in five of our one day Microsoft instructor led classes. Instructor led classes are available in the following areas:
Microsoft Office Access 2007
Microsoft Office Excel 2007
Microsoft Office Outlook 2007
Microsoft Office PowerPoint 2007
Microsoft Office Word 2007
Contact us today for more information on preparing for your Microsoft Business Certification Path!
Tags: Access 2007, economy, Excel 2007, PowerPoint 2007, training
Posted in Company Blog, General | Comments Off
Share | Bookmark | Print:
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.
Tags: Excel 2007, Office 2007, weekly tip
Posted in Company Blog, Tip of the Week | Comments Off
Share | Bookmark | Print:
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 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 adivisor for pricing and delivery.
Tags: Excel 2007, Office 2007, weekly tip
Posted in Company Blog, Tip of the Week | Comments Off
Share | Bookmark | Print:
This tip will help you protect your Microsoft Excel Worksheet.
1.) Click the Office Button, and then click the Save As button.
2.) In the Save As dialog box, click the Tools button and the select General Options.
3.) Complete the necessary following actions:
- Enter a password in the Password to open text box to keep anyone from viewing the file without the password.
- Enter a password in the Password to modify text box to keep anyone from saving changes to the file with the same filename.
4.) Click the OK button.
5.) In the Confirm Password dialog box, retype the password, and then click the OK button.
This Tip of the Week was brought to you by ExecuTrain Houston.To learn more, sign up for one of our Excel 2007 Public classes or ask about our Private Consults or Client-Site learning events.
Tags: Excel 2007, weekly tip
Posted in Company Blog, Tip of the Week | Comments Off
