Posts Tagged ‘Excel 2007’
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