will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Find Office Files with Keywords
When you save a Microsoft Office file, you can store keywords to help you find that file later. For example, when you're creating an estimate for a client's Excel project:
- In Excel, click on the File menu, and click on Properties
- On the Summary tab, enter Estimate, Excel in the Keywords box, then click OK.
Later, you can use one or more keywords to find relevant files:
- In Excel, click the Open button on the toolbar.
- At the top right of the Open dialog box, click the arrow on the Tools button
- Click Search
- In the Search dialog box, click the Advanced tab.
- From the first drop down, select Keywords
- Enter a keyword in the third box, and click Add
- Enter more keywords, or any other search criteria, including location.
- Click the Go button, to start the search.
June 26th, 2008 at 12:48 pm
Interesting. I can't seem to find this in Excel 2007. Removed Functionality?
June 26th, 2008 at 3:49 pm
Mike, in Excel 2007 click the Office button.
Then click Prepare, and click Properties.
The property boxes appear above the worksheet.
Debra
June 26th, 2008 at 4:23 pm
I meant to say that the Open dialog box doesn't seem to have the Search tool. Maybe it's just my version?
June 26th, 2008 at 7:13 pm
Hey, it's missing in my version too! All you can do is view the properties of a file that you select, which isn't much help.