Carol Bratt

Sometimes you insert a picture into your slide and you decide you don't need all of it. Hmmm... what to do? After you select a picture you can cut or crop the edit the edges off of pictures using either of the two procedures below: Click the Crop ... button on the picture toolbar. The mouse pointer changes to indicate cropping. Position the cropping pointer over one of the sizing handles. Press and hold the left mouse button and drag inward. The pointer changes again. To use the menus, follow these steps: Access the Format Picture dialog box and click the Picture tab. The Crop from area shows the ... (view more)

You have inserted a picture on your slide in PowerPoint and you can see straight away that although it is close to what you had wanted, it's not exactly they way you anted it either. Rather than repeating the process of searching for another picture ... and then inserting it, you can modify it to suit your specific needs. You can customize pictures and clip art in many ways. Below are some of the ways that you can do this: Resize to smaller or larger dimensions Scale or resize in proportion to the original Crop or trim off one or more edges Change to black and white or grayscale Increase or ... (view more)

Outlook's Calendar folder can keep track of any number of appointments and meetings, whether they are one-time-only meetings or recurring events that repeat on a regular basis. If you want to see more than one month in the Date Navigator, drag the ... border between the Navigation pane and the contents pane to the right. If the Taskpad is visible, drag its border to the left and/or down. Outlook will show as many months as will fit it he space you allot. Appointments have starting and ending times blocked out in your schedule. Events, such as trips, etc. last 24 hours or more. Meetings are ... (view more)

When AutoFilter is activated, Excel recognizes that a calculated total should reflect only the record that are currently displayed in the data list. For example, in a data list of business expenses with an Amount field, it would be possible to ... create a formula at the bottom of the field that reflects the total amount of only those amounts displayed by the filter. The SUBTOTAL function is used to calculate a total amount based on a filter. Follow these steps to use the SUBTOTAL function with AutoFilter: Click in a cell in the column to subtotal. Click Sort Ascending or Sort Descending. On the ... (view more)

Custom AutoFilters can be created to meet specific needs. A custom AutoFilter could be used to display records that contain either one value or another. A custom AutoFilter could also be used to display records that meet more than one condition for ... a column, such as records that contain values within a specific range, such a values between 50 and 1,000. Follow the easy steps below to apply a Custom AutoFilter: Position the active cell anywhere within the data list or within the header row. Choose Data | Filter | AutoFilter. Drop-down arrows appear along the top row of the list. Click on the ... (view more)

In addition to filtering a data list based on unique values in a data field, Excel provides a Top 10 filter which that displays the top 10 (or a number that the user defines) values in amount or percent, based on numeric data. Follow the steps below ... to apply the top 10 filter: Position the active cell anywhere within the data list or within the header row. Choose Data | Filter | AutoFilter. Drop-down arrows appear along the top row of the list. Click on the drop-down arrow of the field to filter. The Top 10 filer can only be applied to numeric fields. Choose Top 10. Select the desired options ... (view more)

A single data list may contain records that fall into several categories or groups. Depending on the size of the data list, it may be difficult to focus on all of the records that belong to a specific group. Data filtering in MS Excel enables the ... user to work with a subset of data within the data list. When a filter is created, only the records that contain the values specified are displayed. Other records in the data list are hidden temporarily. AutoFilter is an automated filtering tool included in Excel. When AutoFilter is applied to a data list, the column headings change to drop-down list ... (view more)

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)

There may be times when you will find it necessary to sort a data list on something other than the alphabet. You can define a custom list of elements on which to base the criteria for a sort. Excel provides a built-in custom sort routine that lists ... months in their chronological order from January to December. Other lists can be created from an existing range of cells or simply entered on the Custom Lists tab of the Options dialog box. Follow the steps below to see how it works: Choose Tools | Options. The Options dialog box opens. Click on the Custom Lists tab. Choose New List in the Custom ... (view more)

There will be some occasions when you will want to perform a sort using more than one column in MS Excel. You already know how to perform a sort using one column and now if you follow the steps below you can add a little to your Excel knowledge of ... sorting. Position the active cell anywhere within the data list. Choose Data | Sort The Sort dialog box will appear. Select the first column to sort by in the Sort by List box. Choose Ascending or Descending. The names of the columns appear if the list is designed correctly and the Header row option is selected in the My list has area of the Sort ... (view more)