Microsoft Office Tutorials and References
In Depth Information
When you start Excel, the program displays a new, blank workbook; you can begin
to type data into the worksheet’s cells or open an existing workbook. In this topic’s
exercises, you’ll work with workbooks created for Consolidated Messenger, a fictional
global shipping company. After you make changes to a workbook, you should save it
to preserve your work.
Tip Readers frequently ask, “How often should I save my files?” It is good practice to save
your changes every half hour or even every five minutes, but the best time to save a file is
whenever you make a change that you would hate to have to make again.
When you save a file, you overwrite the previous copy of the file. If you have made
changes that you want to save, but you also want to keep a copy of the file as it was
when you saved it previously, you can use the Save As command to specify a name for
the new file.
You also can use the controls in the Save As dialog box to specify a different format for the
new file and a different location in which to save the new version of the file. For example,
Lori Penor, the chief operating officer of Consolidated Messenger, might want to save an
Excel file that tracks consulting expenses as an Excel 2003 file if she needs to share the file
with a consulting firm that uses Excel 2003.
After you create a file, you can add information to make the file easier to find when
you use the Windows search facility to search for it. Each category of information, or
property, stores specific information about your file. In Windows, you can search for
files based on the file’s author or title, or by keywords associated with the file. A file
tracking the postal code destinations of all packages sent from a vendor might have
the keywords postal , destination , and origin associated with it.
To set values for your workbook’s built-in properties, you can click the File tab, click Info,
click Properties, and then click Show Document Panel to display the Document Properties
panel just below the ribbon. The standard version of the Document Properties panel has
fields for the file’s author, title, subject, keywords, category, and status, and any comments
about the file. You can also create custom properties by clicking the arrow located just to
the right of the Document Properties label, and clicking Advanced Properties to display the
Properties dialog box.