Absolute Beginner's Guide to Microsoft® Office 2003系列翻译（一）

Part I

第一部

Chapter 1.  A Quick Tour of Office

第一章 Office快速旅程

Why Office?

为什么是Office？

There are a handful of key tasks that most people want to accomplish with a computer, particularly in a business setting, and this is probably true of you. For example, it's a good bet that you need to manage your email and contacts, work with letters and other documents, and maybe even keep track of some information in a database. There are no doubt several other tasks you need to perform on a regular basis with your computer.

有很多手工完成的工作是大多数人都想用计算机自动完成的，特别是在商务环境下，对于你来说这真的很有可能。

举例来说，当你要管理你的邮件和联系人的时候，要制作书信和其他文档的时候，或许要在数据库中追踪一些信息。还有一些其他毋庸置疑的工作是你必须用计算机才能完成的。

Microsoft Office is a suite of applications designed to give you the programs you need to accomplish most of your tasks. If you're not familiar at all with Microsoft Office, you might think it's mainly for creating documents. Although Office does include Word to help you create, view, and modify documents, it also includes several other applications, each with a specific purpose. These productivity applications include the following:

微软的Office是一整套的应用程序，专门为你完成上述工作设计。如果你对Office一点都不熟悉的，那么你可能会觉得它主要是用来创建文档的。尽管Office包含Word这个应用程序来帮助你创建，查看以及修改文档，但是Office同样也包含其他的应用程序，每一样都针对特定的目的设计。这些生产力应用包括：

• Word You can use Word to create and manage documents such as reports, letters, research papers, and signs.

• Outlook You can use Outlook to manage your email, contact list, to-do list, schedule, and other personal or business-related information.

• Excel You can use Excel to store and analyze mainly numeric information, such as sales, grades, bills, and so on.

• Access You can use Access to create, view, and modify relational databases. For example, you might track inventory, customers, students, or similar information with a database.

• PowerPoint You can use PowerPoint to create presentations for meetings, sales calls, classes, and the Web.

Word

你可以使用Word来创建和管理文档，如报告，书信，研究论文以及签名。

Outlook

你可以使用Outlook来管理你的邮件，联系人列表，to-do清单，日程安排以及其他的个人或商务相关的信息。

Excel

你可以使用Excel来存储和分析主要是数字的信息，如销售，学生成绩，订单等等。

Access

你可以使用Access来创建，查看和修改关系型数据库。例如，你可以用数据库追踪库存，客户，学生或者相似的信息。

PowerPoint

你可以使用PowerPoint来创建展示用的幻灯片，可以在会议，销售访问，班级以及网页中使用。

There are certainly other programs that let you accomplish these tasks. For example, Microsoft's own Works application suite offers some of the same capabilities as Word, Excel, and Access. Applications from other vendors also offer the same or more advanced features.

当然，还有很多其他的程序可以帮助你完成以上任务，例如微软自己的Works应用程序套件提供了一些相同的功能，还有一些其他厂商也提供了同样的甚至更高级的功能。

So why choose Microsoft Office? Although some would argue that popularity is not a good reason to pick a particular application or suite, Microsoft Office is by far the most popular productivity suite. Why do I think that's important? If you change jobs, it's a good bet that the next company will be using Microsoft Office, so you won't have to learn a new set of applications. If you're a student, learning Office is important because that first job will probably require that you use at least one Office application. It's also likely that the people with whom you need to share documents—whether in your own company or another—will be using Microsoft Office because of its popularity. What's more, Office can import and export in several popular formats to help you share documents with others who do not use Office.

那为什么还要选择微软Office呢？尽管某些人会争论流行度不是使用某种程序或套件的好原因，但是微软Office到目前为止都是最流行的生产力套件。我为什么会觉得这很重要呢？假如你换工作了，那么在下一家公司很可能使用的就是微软Office，就是因为它很流行。这种流行对于和你共享文档的人也是很有意义的，无论在哪，其他人都在使用微软Office，就是因为它很流行。另外，Office还能导入和导出几种流行的格式来帮助你与其他不使用Office的人共享文档。

Another important reason Office is a good choice is the integration between the programs. You can easily use data from one Office program in another. For example, you can create a mass mailing in Word by using contacts you have stored in Outlook or in an Access database.

另外一个选择Office的重要原因就是程序之间的集成。你可以轻松的在Office程序之间使用数据。比如说，你可以通过Outlook或者Access中存储的联系人信息，在Word中创建一个群发的邮件。

Over the many years it has been in development, Office has become easier to use. That's particularly true with this latest edition. Lots of wizards, a streamlined user interface, good Help documentation, and other features (not to mention this book!) will help you get up to speed with all your Office applications.

经过多年的发展，Office已经成为非常易于使用的套件。大量的使用向导，流线型的用户界面，良好的帮助文档，以及本书中并未提及的特性，都将帮助你提高使用Office的速度。

Although Microsoft Office doesn't do everything, it can probably handle a big portion of the things you need to do in a given day. Add in a few special-purpose applications, including a nice streaming audio player for your favorite online radio station, and your day is set!

尽管微软Office不是尽善尽美，它仍旧处理了大部分的日常工作。加入几个有特殊目的的应用，包括一个漂亮的流媒体播放器，连接到你最喜欢的网络广播站，你的一天就妥了。

Back Up Anything You Can't Lose

把你所有不能丢的东西都做个备份

Unless you haven't used your old copy of Office, you probably have at least some documents on the computer that you wouldn't want to lose. Maybe they are letters or reports you created in Office, email messages or contacts stored in Outlook, or Access databases. Whatever the case, you should back up these documents. It's unlikely that upgrading to Office 2003 will cause any of those documents to be lost, but why take the chance?

除非你不曾使用过旧版的Office，否则的话你可能或多或少都在计算机中存了一些旧的文档，还不想弄丢。或许是些信件，或许是些报告，邮件，联系人信息等等。不管是什么，你都应该把这些文档备份一些。当然了，你的Office升级的时候肯定不会把这些旧文档弄没了，但是为啥不借此机会整理下文档呢？

The documents can be almost anywhere on your computer, so unless you've been really conscientious about organizing your documents, you should search the hard disks for them. Here's a list of the file types for which you should search:

文档在你的电脑里面几乎随处可见，所以除非你一直有整理文档的好习惯，否则你就该搜搜你的电脑了，下面的是你应该搜索的文件类型：

• .DOC and .DOT .DOC files are documents, and .DOT files are templates that help define the look and content of a .DOC file. Both are created with Word.

• .XLS These are Excel spreadsheet files.

• .PPT These are PowerPoint presentation files.

• .PST and .OST .PST files are personal folder files that store Outlook data (email, contacts, and so on). .OST files are offline store files used in conjunction with Exchange Server mailboxes. They enable you to work with Outlook data when you can't connect to your Exchange Server.

• .MDB These are Access database files. You'll probably find a few .MDB files on your computer that you didn't create. Many programs, Office included, use Access databases to store content and other information.

DOC和DOT

DOC文件是文档，而DOT文件是帮助生成DOC文件的模板。两类文件都使用Word来创建。

XLS

这种类型的文件是Execl表格文件。

PPT

这种类型的文件是PowerPoint演示文稿文件。

PST和OST

PST文件是Outlook存储数据的个人文件夹文件（注意是文件），而OST文件是与Exchange服务器邮箱关联的离线存储文件。

MDB

这种类型的文件是Access数据库文件。你可能会在你的电脑发现一些MDB文件，但是你却从来没创建过，事实上，包括Office在内的许多文件都使用Access数据库存储内容和其他信息。

In general, you can back up to any medium, including another hard disk, a floppy disk, ZIP media, and recordable CD (CD-R). If you back up to a CD-R and later have to restore the files from the CD to your hard disk, you just need to remember to change the file attributes so that the files are no longer read-only. You right-click a file or folder and choose Properties to change the read-only attribute.

通常来讲，你可以把文档备份到任何介质中，包括另一个硬盘，软盘，ZIP文件或者CD中。如果你备份到CD中，随后你还可以还原到硬盘里，你只需要记得把文件属性改成不是只读的就可以了。在文件或文件夹的属性中设置只读选项。

Note
注意

In Windows 2000, you can select Start, Search, For Files or Folders to begin searching for files on your computer. In Windows XP, you can select Start, Search to open the Search Companion pane, and then click All Files and Folders to begin searching for document files.

在Windows 2000中，你可以选择开始，搜索文件或文件夹来开始搜索你的电脑。而在Windows XP中，你可以选择开始，搜索来打开搜索面板，然后点击全部文件及文件夹来搜索文档。

Clean Up the Computer

清理你的电脑！

No, this doesn't mean wiping the grime off the top of the monitor, although that's not a bad idea. Before installing Office, you should take the time to defragment the computer's hard disk. Setup is going to copy a ton of files to your computer, and having the disk in good shape will make for a faster installation and better performance afterward.

这可不是说要给你的显示器清灰，虽然说这也不失为一件该做的事。在安装Office之前，你应该花些时间来清理电脑的硬盘。做一些磁盘清理，这样更容易安装Office，也能保证更好的性能。

You can find the Disk Defragmenter by selecting Start, All Programs, Accessories, System Tools. You can also right-click a drive in My Computer, choose Properties, and click the Tools tab in the System Properties dialog box to access the Disk Defragmenter.

可以使用附件中的磁盘清理程序，也可以在我的电脑的属性中找到磁盘清理的快捷方式（其实一点也不快捷）。

Tip
小技巧

A disk that is fragmented has pieces of its files scattered across the hard disk. Defragmenting a drive rewrites the files into contiguous space on the disk, providing quicker disk access and ultimately better performance.

一块磁盘会分成很多个扇区，而一个文件可能会分成很多块放在不同的扇区中。进行磁盘清理可以使得访问这些磁盘空间更快更容易。

Working with Letters and More with Word

用Word处理书信等工作

Letters, reports, and similar correspondence are the mainstay of business, and creating them is one of the most common tasks you're likely to perform with Office. I've been using Word since version 1, which first saw the light of day around 1983. 

书信，报告等是商务中的主要内容，Office常用于创建这些材料。我从1983就开始使用第一版的Word，

Word isn't limited to creating just letters and boring, dry reports. Word includes several templates and wizards to help you quickly and easily create legal pleadings, faxes, Web pages, memos, agendas, resumes, brochures, manuals, directories, and lots more. Anything that gets read on paper or online can probably be created with Word.

Word不是只能创建书信和枯燥的报告，它还包含了许多模板和想到来帮助你快捷的创建法律信函，传真，网页，备忘录，议程，简历，手册，字典等等。只要能在纸上或者网上看的东西，就都能用Word来创建。

Document and Font Formatting

文档与字体格式

Word gives you control over almost every aspect of how a paragraph or even a single letter appears in a document. You can control paragraph spacing, indents, justification, and more. You can use different fonts, colors, sizes, and other properties for characters in a document. The result is that you have the ability to control to a fine degree how a document looks onscreen as well as how it looks on paper or online.

Word可以控制文档中的所有内容，不论是段落还是单个文字。你可以控制段落的间距，缩进，对齐；可以控制文字的不同字体，颜色，大小。并且你在屏幕上看是什么样，在纸上或者网上就是什么样。（这个有点扯，译者）

Note
注

The following sections explore just a few of Word's main features. There are many others not listed here that are included in Word and discussed inPart III, "Writing with Word."

下面这几部分概述了Word的主要功能，还有许多没有提及的功能将会在第三部 - 使用Word写作 中探讨。

 

Chapter 10, "Adding Pizzazz with Word," explains how to add formatting to a document.

第十章，Word如风 将会讲述如何向文档添加格式。

Word also makes it easy to add tables and columns to a document. You can draw tables with the mouse or simply tell Word how many columns and rows you want and let it do the work for you. In either case, you can merge table cells, change cell width and height, and make lots of other changes after the fact. You can also use Word's AutoFormatfeatures to automatically format the appearance of a table.

Word也使得向文档添加表格变的容易，只要告诉Word要画多少行多少列就可以轻松的绘制表格。除此之外，还可以合并单元格和修改表格中的每一个单元格的宽度和高度等等。可以使用Word的自动格式化功能来自动格式化表格。

Styles

样式

If you frequently work on a particular type of document, you'll find thatdocument styles are a very handy Word feature. Styles let you apply complex formatting to a paragraph and its contents with just a few mouse clicks. You can create a collection of styles and save them as a template, which you can then use to create documents. Templates make it easy to create and use styles in multiple documents, such as one book to another.

如果你经常使用某种特殊类型的文档，你就会发现，Word的文档格式功能非常的善良。样式功能使得你只要点击几下，就可以对一个段落以及其中的内容添加样式。你可以创建一个样式的集合，并保存为模板，然后使用这个模板来创建文档。模板使得在多个文档中创建和使用样式变得简单，比如说不同的书籍之间。

注

See Chapter 10 to learn about templates and styles.

参见第十章，其中讲述了模板与样式

Spelling and Grammar

拼写和语法

Some people are whizzes at spelling; others find it a real challenge. Everyone has problems with certain words. With Word, you can concentrate on writing and let Word concentrate on spelling. Word has an extensive dictionary and can check your spelling for you as you type, underlining in red words it doesn't recognize. Word can also correct misspelled and mistyped words automatically to save you time.

虽说单词拼写的能力因人而异，但是每个人都有提笔忘字的时候。使用Word，你可以专注于写作，只要让Word帮你关注拼写问题就可以了。Word用于一个可扩展的字典，可以用来进行拼写检查，以红色波浪线来标注Word中没有保存的单词，并可进行自动的拼写修正。（对于汉语的支持在逐渐加强，译者注）

Word can also check your grammar and prose style, offering suggestions about sentence fragments, awkward sentence structure, and so on. Word underlines in green words or phrases for which it has grammar suggestions.

Word也能够检查语法和文法，提供语句的修改意见，语法问题由绿色的波浪线标注。

注

Chapter 13, "Checking Spelling and Grammar," explains how to set up and use Word's spelling and grammar features.

第十三章 拼写和语法检查 讲述如何设置和使用Word的拼写和语法功能。

If you work in a field that has special terminology, you'll be happy to know that Word can use custom dictionaries to help you with spelling of words that are not contained in the default dictionary. You can also create your own dictionary entries and control lots of other aspects of how Word checks spelling and grammar (including turning off both features).

对于特定领域的术语，Word提供了自定义字典的功能来扩展默认的字典，可以通过创建你的专属字典来定制拼写和语法检查功能，当然，也可以选择关闭这些功能。

Outlining and the Document Map

文档大纲与文档地图

Working with a long document can be a real chore if there's not a good outline. Word offers some great features that help you create an outline and work within a long document.

要使用一个文档，如果没有文档大纲的话，那简直就是噩梦。Word提供了一些非常棒的功能来帮助你创建文档大纲。

注

See Chapter 9 to learn how to create and work with outlines. Word offers several shortcuts for creating an outline. For example, you can press Ctrl+Alt+<arrow>, where <arrow> is the left or right arrow key, to promote or demote an outline head. Word also provides paragraph styles for easy outlining, the ability to automatically number an outline by using different numbering styles, and the ability to easily expand and collapse the outline to navigate through it and work with specific sections.

参见第九章，该章讲述了如果创建和使用文档大纲。Word提供了一些创建文档大纲的快捷键，例如使用Ctrl+Alt+左右方向键来升降文档大纲的题头。Word提供段落样式来轻松编制文档大纲，比如自动编号，或者在侧栏中展开或者折叠文档大纲的目录，这样就能轻松的找到想要的位置。

Crunching Numbers with Excel

用Excel来管理数字

Microsoft Excel is a spreadsheet application. You mainly use Excel to keep track of and analyze numeric information such as grades, sales figures, budgets, bills to pay, and so on. However, you can also use Excel to store and sort other types of information.

微软Excel是一个电子表格应用，主要用来追踪和分析诸如成绩，销售图表，预算，支付账单等数值信息，当然，也可以使用Excel来排序和存储其他类型的信息。

Working with Numbers and Formulas

使用数值和公式

The thing you'll most often do with Excel is enter numbers and then use formulas to analyze those numbers. A very simple example is adding a column of numbers to determine the total value of some office assets.

你肯定会经常用Excel做的一项工作就是输入数值，然后使用公式对其进行分析，例如计算一些办公设备的总价值。

Excel makes it easy to enter information and perform math operations and other manipulation on the information. It gives you quick access to common operations such as Sum, Average, Count, and many more in several different categories, including Financial, Date & Time, and Math & Trig. You can quickly add simple calculations or build very complex formulas to analyze or process information in the way you need.

使用Excel可以轻松的输入信息和执行数学运算，你能够方便的使用函数进行常用的运算，如加总，平均，计数等，这些函数涵盖金融，日期时间，数学与角度。总之，简单的计算也行，复杂的公式计算亦可。

注

Chapter 17, "Once Around the Worksheet,"introduces you to spreadsheets, andChapter 18, "From Simple Addition to What-ifs: Formulas," explains how to add formulas to spreadsheets.

第十七章 绕工作表一周 将会介绍电子表格，而第十八章 从简单的加法到公式 将会介绍向表格添加公式。

Using Charts and Graphs

使用图表和图形

Excel isn't limited to just numbers. You can also add text and other types of data, including charts and graphs. Excel offers some great charting and graphing features that make it easy to add those elements to a spreadsheet. In most cases, you just highlight a range of information, select a command from the menu, and set a few options, and you have a great-looking chart or graph.

Excel不仅能够处理数字，也可以添加文本和其他类型的数据，比如说图表和图形。Excel提供了一些非常棒的图表和图形功能，在大多数情况下，我们只要关注需要展现的信息就可以了，也就是说，从菜单选择一个命令，设置几个选项，一个非常漂亮的图表或者图形就成了。

The charts and graphs you create in Excel don't have to stay in Excel. You can easily import them into Word or other applications to create reports, Web pages, and other types of documents.

图形和图表创建出来之后，不光可以用在最初的Excel中，也可以轻松的把它们导入到Word或者其他程序中，另作他用。

Using Slide Shows and Presentations with PowerPoint

使用PowerPoint的幻灯片和演示稿

PowerPoint, another of the applications included with Microsoft Office, helps you create presentations and slide shows for meetings, classes, sales presentations, and so on.

PowerPoint，另一个Office应用程序，用来为会议，教学，销售演示等制作演示稿和幻灯片。

Each slide in a presentation can contain text, images, and even rich media such as video and audio clips. By supporting these types of media, PowerPoint makes it possible to create rich, professional-looking presentations that you can present to a live audience or broadcast across a local network or the Internet. PowerPoint is also a handy tool when you just want to create a set of printed handouts.

每片幻灯片都可以包含文本，图片，甚至是音频或者视频剪辑，通过支持这些媒体类型，PowerPoint能够创建多样，专业的演示文稿。有了PowerPoint，无论是现场还是广播，无论是本地网络还是互联网，都能轻松应对。此外，PowerPoint还是课堂讲义的好帮手。

PowerPoint includes lots of templates with predefined backgrounds and themes that you can use to create presentations with very little effort. You can also create and use your own themes.

PowerPoint内置大量模板，包含预定义的背景和主题，不用费力就能创建非常专业的演示文稿。当然，也可以创建自定义主题。

注

See Part V, "Creating Presentations in PowerPoint," to learn how to create presentations by using PowerPoint.

参见 第五部 在PowerPoint中创建演示稿 ，其中讲述了如何使用PowerPoint创建演示文稿。

The Absolute Minimum

绝对最小

Microsoft Office is by far the most popular productivity suite on the market, and it has been for a long time. Understanding how to use Office applications is probably not only important to you today, but it could be important in the future if you change jobs. Most jobs involve using at least one Office application.

到目前为止，微软Office都是市场上最流行的生产力套件，知道如何时候Office应用程序很有可能不止今天对你来讲很重要，等将来你换工作了，也是很有用的。大多数工作都至少涉及到一个Office应用程序。

Each of the applications in the Office suite is geared toward a particular type of task. For example, you might use Word to create a written report, Excel to analyze sales figures, and PowerPoint to present information in a sales meeting. One of the best things going for Office is the ease with which it enables you to use the same data in different ways and different applications.

Office套件的每个应用程序都面向一种特定类型的任务，Word用来写报告，Excel用来分析销售数据，PowerPoint用来在销售会议上展示信息。能够在不同的程序中以不同的方式展示相同的数据，也是Office的好处之一。

Now, flip that page, and let's get Office started on your computer!

现在，翻开这一页吧，这就开始用Office！

Chapter 2. Office Basics

第二章 Office基础

略（这章主要讲的是Office安装，文不对题，译者）

Chapter 3. Help!

第三章 帮我！

略（就是讲咋用帮助，可是一般这帮助都帮不上忙，还是找百度吧，译者）

======================================================

第一部完

后记

这部主要就是非常粗略的介绍下Office的套件，Access没有翻译，以为一点也不Office。

下一篇直接进入主题，从第三部 写Word 开始翻译，第二部讲Outlook的使用，暂不翻译，因为其实Outlook常用的功能比较简单，就是个邮箱。。。

很晚了，睡觉。