After you watch your video clips, you might notice that you were shaking the camera at the beginning and end of each clip, or that you want to remove a part that is not pertinent to the message of your video.
Fortunately, you can fix these problems with the Trim Video feature by trimming the beginning and end of your video clip.
- In Normal view, on the video frame, press Play.
- Select the video on the slide.
- Under Video Tools, on the Playback tab, in the Editing group, click Trim Video.
- In the Trim Video dialog box, do one or more of the following:
- To trim the beginning of the clip, click the start point (shown in the image below as a green marker, on the far left). When you see the two-headed arrow, drag the arrow to the desired starting position for the video.
- To trim the end of the clip, click the end point (shown in the image below as a red marker, on the right). When you see the two-headed arrow, drag the arrow to the desired ending position for the video
Let us assume that you have a range of numbers in an Excel worksheet. You want to sum all numbers in the range that fall under a certain condition. You also want to know how many such numbers are there in that range that satisfy the condition. Here is how you can do this:
Go to the cell where you want the sum of the numbers that fall under the condition
Enter the formula =sumif(range, condition). For example, if you want sum of all numbers that are less than 500 in the range B2 to H17, enter =sumif(B2:H17, "<500").
Go to the cell where you want to display the number of cells that contain numbers that fall under your condition
Enter the formulaEnter the formula =countif(range, condition). For example, if you want count of all numbers that are less than 500 in the range B2 to H17, enter =countif(B2:H17, "<500").
This is one of the ways of using the sumif and countif functions
Color adds visibility to your Outlook items. Color categories can be assigned to email messages in Microsoft Outlook, which enables you to quickly identify them and associate them with related items. You can assign more than one color category to messages, or use a Quick Click category to click once and assign a color category to a message in your Inbox.
Assign a color category to a message
A color category must be in the color category list before you can assign it. If a color category is not listed, you can create a color category and assign it to an item for the first time. You can also choose from several default color categories and rename them to be more meaningful to you.
To assign a color category, do the following:
- For a message in your Inbox or any message list Right-click the message, point to Categorize, and then click a color category.
- For an open message On the Message tab, in the Options group, click Categorize, and then click a color category.
To see more categories or to create a category, click All Categories to open the Color Categories dialog box. To assign a color category from the Color Categories dialog box, you must select the check box next to the color category. The Color Categories dialog box is also a quick way to assign multiple categories to an item.
The first time that you assign a default color category to an item, you'll be prompted to rename the category. At this time, you can also change the color of the category and choose a keyboard shortcut.
- You can change the color associated with a category at any time.
- Another way to open the Categorize menu and Color Categories dialog box is by clicking Categorize on the ribbon, on the Tags tab.
- Only the 15 most recently used color categories appear on the Categorize menu. To see the rest, click All Categories on the Categorize menu.