Summary: It is useful at times to calculate the week number of a date. Here is how to do this:
The secret to calculating a week number is to use the =WEEKNUM() function. This function accepts a date and returns the week number. It assumes that the week containing January 1 is the first week of the year.
For example, if cell A1 contained the date March 15, 2012 and your cursor was in B1:
=WEEKNUM(A1) would return the value 11 as this date is in the 11th week of this year.
Converting Measurement Systems
Back to top
Summary: There are times when you need to convert miles to kilometers and kilometers to miles. Here is how to do this:
You need to use the CONVERT function. Assume you have 2,000 as a distance in cell A1.
In B1 enter the following function:
=CONVERT(A1, "mi", "km")
You will get the answer 3,218.69 which is the conversion of 2,000 miles to kilometers.
If you change the function to :
You will get the answer 1,242.74 which is the conversion of 2,000 kilometers to miles.
Back to top
Summary: If your hand is on your mouse, here is a fast way to move cells from one location on your worksheet to another location on the same worksheet.
Usually you would do a Cut and Paste to move cells in a worksheet. Here is a fast way to accomplish this task.
- Select the cells that you want to move by highlighting the range.
- Place your mouse over the thick border that surrounds the selected cells.
- Click and drag the selected cells to the new location. As you move your mouse the outline of the selected cells moves, as well.
- When your mouse is over the new location, release the mouse pointer.
Your selected cells will now be in the new location.
Setting the Vertical Alignment
Summary: Just as you right-align, center and left-align text between margins, you can also vertically align the text, so that the text is aligned with the top, center, or bottom of the page. Here is how to do this:
- In the Page Layout tab, click the Page Setup Dialog Box launcher (the arrow in the bottom right hand corner of the Page Setup group).
- Click on the Layout tab, under Page, click the Vertical Alignment down arrow, and select the vertical alignment that you want to use.
- Click OK.
Summary: If your recipient gets a lot of messages, you may want to identify the importance of your message, so that it will stand out in his or her In Box. Here is how to do this::
Outlook includes a red exclamation point in the message list to identify messages set with high importance. It uses a blue exclamation point to indicate messages with low priority. To set the priority go the Message Window. Then flag your e-mail message with the appropriate flag.
- Create your message.
- In the Options group on the Message tab, select one of these options:
- Click High Importance to insert a red exclamation point to indicate high importance.
- Click Low importance to insert a blue exclamation point to indicate low importance.
- Send the message as usual.
If you are using Outlook 2010 click on the Message tab and then select your priority in the Tags group.
Rehearse and Time the Delivery of Your Presentation
Summary: PowerPoint includes a tool that enables you to time your presentation and then advance each slide automatically when you deliver your presentation to your audience. Here is how to do this:
- Click on the Slide Show group.
- In the Setup Group click on Rehearse Timings.
- The Rehearsal toolbar appears, and the Slide Timer box begins timing your presentation.
- As you move to the next slide the slide clock will reset and begin timing the slide.
- The overall clock will keep track of your total time.
The Slide Sorter view appears and displays the time of each slide in your presentation.
- While you are timing presentation you have the following options:
- To move to the next slide click on Next.
- To temporarily stop recording, click Pause.
- To restart recording the time, Click Pause again.
- To restart recording the time for the current slide, click Repeat.
- After you set the time for the last slide, a message box displays the total time for the presentation and prompts you to do one of the following:
- To keep the recorded slide timings, click Yes.
- To discard the recorded slide timings, click No.
When you use the Presentation view to view your slides, each slide will advance automatically according to the time you recorded for that slide.