Tom McLaughlin mcse, mct, a+, b-admin firstname.lastname@example.org
Similar Look and Feel
All Office programs have a similar look and feel. Looks the same for those who have used to Office 97 products.
There is a tutorial and helps for WordPerfect users.
Word and Excel
Word Processing Word is a word processor application. It is the best choice for text-heavy documents such as letters, reports, resumes, and fax cover sheets.
Keeping Track of Data Excel is a spreadsheet program. It's useful for keeping large quantities of numeric data organized and for performing calculations on that data.
Outlook and PowerPoint
Organizing Your Life Outlook is a personal organizer that keeps track of your calendar, your To Do list, and your address book, and sends and receives e-mail.
Creating Presentations PowerPoint is a presentation program. It generates multimedia computer shows, 35mm slides, and overhead transparencies for use in sales presentations and informational briefings.
Publisher and Access
Desktop Publishing Publisher is a desktop publishing program. Like Word, Publisher also focuses on text, but it has fewer text-management capabilities and more layout utilities. Managing Databases Access is a database management program. Access organizes data in a tabular format, with more features that enable you to enter, organize, edit, and search large amounts of data.
Front Page & Photo Draw
Creating for the Web FrontPage is a Web-site creation program. Use FrontPage to design Web pages for Internet use and to link them together into a cohesive Web site.
Editing Images Photo Draw is an image-editing program. Use Photo Draw to create and modify images for to be used with other Office programs.
Most Recently Opened Files
The four most recently opened files appear at the bottom of the File menu.
If you wish more then the default four, click on Tools/Options/General and type in 9 for the maximum amount.
Or Start / Documents and find the document there.
Special Dialog boxes
Publisher, PowerPoint, and Access all start up with special dialog boxes on the screen that help you open existing files and start new ones.
Menu’s, Toolbars, & Shortcuts
In this section, you will learn about the three main methods of issuing commands in a program:
Application & Shortcuts
Application Menu Each program has a row of menu names directly under the program's title bar at the top of the screen.
Taking a Shortcut Some commands have a key combination listed next to them (such as Ctrl+X for Cut).
Unavailable, Icons, & Ellipsis
Unavailable Commands Some commands appear dimmed, such as Cut shown here.
Icon Shortcuts Some commands have icons to their left. These represent toolbar buttons that serve as alternatives to the command.
Ellipsis (three dots)… This indicates that choosing that command will open a dialog box. Such as Find…
The More Buttons Button
You may often find, however, that the button you need isn't displayed. This is usually not a problem, since you can always access the hidden button you need by clicking the More Buttons button.
Help is a click away!
Office Help Assistant
Help is provided either by clicking HELP on the menu bar or pressing F1 on your keyboard.
Here’s another great tip:
Shift + F1 over an Icon, your mouse will turn to a “?” question mark. Click on the icon and it will describe what it does!
Drop Down Menus
Depending on how your PC is set up, double arrows may appear at the bottom of the menu.
Saving Files in Office 2000
By default, the data files that you create in Office programs are stored in the folder called My Documents.
If you save all of your files to the My Documents folder, you will not have any trouble remembering where you stored your files.
Find & Saving To Other Places
If you decide to save files to different drives and folders, you may forget where a particular file is stored.
Office 2000 and its applications include a Find command that locates elusive files for you.
Save vs. Save As
You will normally want to save your work in the default or “native” format of the program.
However you may need to save in a different format to share files with someone who does not have the same version of Office, or make a second working copy to preserve the first version.
Draw your table one cell at a time, erase several lines at once, and even split cells diagonally!
Tables Made Really Easy!
Manage & Share Information
Just click to open the new Office E-mail header in Word and send your document as an e-mail message that retains your original formatting.
Live Hyperlinks in Documents
Insert hyperlinks into your documents more easily with the improved hyperlink interface.
Quickly create links to other documents, Web pages, graphics, and pictures—and even customize how text is displayed in your links.
As part of Office 2000, Microsoft Excel 2000 adopts HTML as its companion file format
You can easily share data-rich spreadsheets in a Web browser—letting even those who don't have Excel view your data.
If you need to identify a particular cell, refer to it by its cell address. A cell address is made up of the cell's column letter and row number. So the address of the first cell in the worksheet is A1. The cell below it is A2, and so on.
Excel workbook, or file, is made up of three worksheets that are accessible through the sheet tabs at the bottom of the Excel window.
You can change sheet names to make them more meaningful.
You can also add or delete worksheets from a workbook as needed.
If needed, you can insert a cell or range of cells within a worksheet. When you do so, existing data remains intact, but is shifted over to make room for the new cell(s).
Inserting a Row or Column
If you delete a column or row that contains a cell that's used in a formula, that formula could result in an error.
Easily Access and Analyze Data
Microsoft Excel 2000 makes it easier to access vital business information using your organization's intranet.
Too Much Text
If, for example, cell A1 has too much text, its contents will spill over into cell B1, so long as B1 is empty.
If B1 contains data, the contents cell A1 will appear to be cut off.
There are several different number formats that you can use in your worksheet. The three most popular are Currency Style, Percent Style, and Comma Style. Each format has a button on the toolbar for easy application.