Saturday, June 25, 2011

Excel Properties

Have you ever sent an Excel spreadsheet to someone whom asks you details on when the worksheet was created or other details?

Well, this tip shows you how to add some basic contact and worksheet information for yourself and others.  Excel Properties allows users to search for spreadsheets and access some other details of the file including the Author, Company, and like information.  Excel 2007 allows "Comments" to be added for further reference and details.

To add information to the Excel Properties, follow these steps.

Click on the "Office Button," hover to "Prepare," and click on the "Properties" option.

HINT:  For Excel 2003 and earlier (and for 2010), click on the "File" Menu/Tab and select "Properties."

In Excel 2007 and 2010, the "Properties" window opens above the worksheet fields.

Information such as phone number, email, formulas, or other information may be added for reference.

In Excel 2003 and earlier, the "Properties" window opens as a pop-up window.

Notice that the "Properties" window prefills the "Author" field as the user of the said computer.

Excel 2007 Properties

In Excel 2007 and 2010, click on the "Document Properties" drop-down and select "Advanced Properties" to add further information.

This window appears similar to Excel 2003 and earlier versions.

If this window is chosen, you will need to click on the "OK" button when completed.

Simply save the workbook and the added information is saved with the workbook.

When sending Excel spreadsheets to others, this information is stored for their reference.

Saturday, June 18, 2011

Outlook Quick Tip: Navigation Pane

Quickly turn the Navigation Pane On or Off by pressing "ALT + F1" and keep more room for reading emails.

This is such an easy tip, but can provide much more room in the Outlook window.

Saturday, June 4, 2011

Outlook Calendar Tip: Date Picker

To quickly view specific days next to each other, follow this tip.

Click on the date in the "Date Picker" window.  This is the small calendar(s) usually on the left side of the screen.

Hold the "CTRL" key to select non-consecutive multiple days while clicking on each date.

As you click, each date will appear next to each other in the Calendar view.

It's that simple.

Start Outlook in a Folder other than Inbox

Many people I've trained use the Outlook Calendar to schedule their day.  So, this tip is dedicated to those that would like to start Outlook in a folder other than the Inbox.

Click on the "Tools" menu and select "Options."

Click on the "Other" tab.

Click on the "Advanced Options" button in the "General" area.

Click on the "Browse" button in the "Startup in this folder" field.

See image below.

Outlook Startup Folder

Highlight the folder you want (in our Example above, we would select the "Calendar" folder) and click on the "OK" button.

The next time Outlook is started, the "Calendar" folder will open first.

You may change this option at any time, depending on your usage.

How to Delete Blank Rows in Excel