Summary: Working with dates requires those dates to be in an Excel date format. Here's how to convert a text date to one of the many Excel date formats:
- Select the range of text dates.
- Click on the Data tab.
- Select Data Tools | Text to Columns.
- In the Wizard dialog box, click Next twice to go to Step 3 of the wizard. Use the default settings in the first two steps.
- In Step 3, select the Date option and select your desired format.
- Click Finish and the text dates will convert to dates that can be formatted and used in calculations.
Summary: If you have dataset with duplicate entries you can easily remove the rows of duplicate data: Here is how to do this:
To create a custom list follow these steps:
- Select any cell in the dataset.
- Go to the Data tab.
- Select Data Tools | Remove Duplicates.
- Excel will highlight the dataset.
- From the Remove Duplicates dialog box, make sure that My Data Has Headers is selected, if you have column headers in the first row of the dataset.
- By default, all columns are selected.
- A selected column means that Excel will use the columns when looking for duplicates.
- Duplicates in an unselected column will be ignored.
- Select the columns to search for duplicates.
- Click OK and the dataset will be updated, deleting any duplicated rows.
A message box will appear telling you the number of rows deleted and the number of rows remaining in the dataset. Note that there is no undo when you remove duplicates. Make sure you save your workbook before you remove duplicates.
Summary: Vertical text can be very difficult to read, but sometimes space limitations make it necessary. The Orientation button allows you to display text on an angle. Here is how to rotate your text:
- Select the cell that contains the text you want to rotate.
- Select the Home tab in the Ribbon.
- In the Alignment Group click on the Orientation icon, which looks like ab written at a 45 degree angle.
- Select one of the five options. These are Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up and Rotate Text Down.
When you click on a selection your text will rotate accordingly.
Back to top
Summary: To wrap text around a picture you need to position the picture independently of the text on the page. This is called "absolute positioning."
This offers the following three features. You can:
- Position a picture in a document so that it keeps its position, even if other content shifts on the page.
- Drag a picture to any location on a page, regardless of other paragraph settings.
- Define the location of the picture in relationship to the surrounding text.
Here are the steps to do this:
- Select the Picture.
- Click on the Picture Tools tab at the top of the screen.
- Click on the Position icon.
- Select an appropriate position for the picture relative to the surrounding text.
- Click on the Wrap Text icon.
- Select an appropriate wrapping style.
You can now drag the picture to anywhere in the document.
Summary: When you embed a picture in a document you increase the file size. It does not take many pictures in a Word document to increase the file size beyond the threshhold for e-mailing a document. Fortunately, you have some options to reduce the file size of a picture. Here is how to do this:
- Select the picture whose file size you want to reduce.
- Click on the Picture Tools format tab at the top of your screen.
- In the Adjust Group, click Compress Picture.
- Click on Apply Only to this Picture.
- Choose whether to delete cropped areas of the picture, which will remove any cropped areas, not only from view, but also from the document.
- Choose whether the target area should be printing the document, viewing it on the screen, sending it via e-mail, or the current document resolution.
- For each option, except the last, the resolution of the resulting picture will be shown in pixels per inch (ppi). The greater the ppi, the higher the resolution.Click OK to close the Compress Picture dialog box.
The file size will be reduced according to which option you selected.
Back to top
|Printing Your Calendar in Outlook
Summary: There are a number of different formats that you can use when you are printing your calendar in Outlook. Here is a summary of your options.
- Daily Style Prints the selected date ranger with one day per page. Printed elements include the date, day, TaskPad, reference calendar for the current month, and an area for notes.
- Weekly Agenda Style Prints the selected date range with one calendar week per page, including reference calendars for the selected and following month.
- Weekly Calendar Style Prints the selected date range with one calendar week per page. Each page includes date range and time increments, reference calendars for the selected and following month and TaskPad.
- Monthly Calendar Style Prints a page for each month in the selected date range. Each page includes the selected month with a few days showing from the previous and subsequent months, along with reference calendars for the selected and following month.
- Tri-Fold Calendar Style Prints a page for each day in the selected date range. Each page includes the daily schedule, weekly schedule and TaskPad.
- Calendar Details Style Lists your appointments for the selected date range, as well as the accomanying appointment details.
You can select the date or range of dates to be printed and modify the page setup options to fit your particulare needs.
Back to top