Book description
Get the fast facts that make learning Microsoft Office 2003 plain and simple! This colorful, no-nonsense guide delivers fast answers for using Microsoft Office Access, Excel, FrontPage®, InfoPath™, OneNote™, Outlook®, PowerPoint®, Publisher, and Word.
Table of contents
- Microsoft® Office System Plain & Simple 2003 Edition
- Acknowledgments
- 1. About This Book
- 2. Office Basics
- 3. Working in Word
- 4. Creating Different Types of Documents
-
5. Enhancing a Document
- Creating a Table
- Formatting a Table
- The Anatomy of a Table
- Organizing Your Information
- Inserting Frequently Used Information
- Organizing with Styles
- Numbering Headings
- Numbering Pages and Creating Running Heads
- Creating Chapters
- Creating a Table of Contents
- Creating a Drawing
- Reorganizing a Document
- Positioning a Picture
- Creating Footnotes
-
6. Working in Excel
- What’s Where in Excel?
- Entering Data
- Using a Predefined Workbook
- Excel’s Eccentricities
- Formatting Cells
- Formatting Numbers
- Adding and Viewing Comments
- Editing the Data
- Moving and Copying Data
- Adding and Deleting Columns and Rows
- Creating a Series
- Hiding Columns and Rows
- Formatting a Worksheet
- Organizing Your Worksheets
- Setting Up the Page
- Printing a Worksheet
- Reviewing Your Data
- Working with Multiple Workbooks
-
7. Analyzing Your Data
- Making Lists
- Cell References, Formulas, and Functions
- Doing the Arithmetic
- Summing the Data
- Creating a Series of Calculations
- Making Calculations with Functions
- Troubleshooting Formulas
- Sorting Your Data
- Filtering Your Data
- Creating Worksheet Subtotals
- Naming Cells and Ranges
- Summarizing Data with a PivotTable
- Automatically Highlighting Certain Data
- Importing Data from a Web Page
- Importing Data from a Service
- 8. Presenting Your Data
- 9. Communicating Using Outlook
- 10. Managing with Outlook
-
11. Working with a Database
- What’s Where in Access?
- What Is a Relational Database?
- Using an Existing Database
- Creating a Database from a Template
- Adding a Table to a Database
- Modifying a Table
- Adding Data to a Table
- Creating a Form
- Creating a Report from the Data
- Extracting Information from a Database
- Analyzing Data with a PivotChart
- Defining Relationships Among Tables
-
12. Creating a PowerPoint Presentation
- What’s Where in PowerPoint?
- Creating a Presentation
- Using a Predesigned Presentation
- Creating a Photo Album
- Editing a Presentation
- Adding Text Animation Effects
- Adding Transition Effects
- Adding Special Content
- Adding Notes and Handouts
- Including a Slide from Another Presentation
- Running a Slide Show Automatically
- Customizing a Slide Show
- Running a Slide Show Using a Single Monitor
- Running a Slide Show Using Dual Monitors
- Taking a Slide Show on the Road
-
13. Creating a Publication in Publisher
- What’s Where in Publisher?
- Creating a Publication from Scratch
- Creating a Publication from a Design
- Repeating Objects on Every Page
- Adding Text
- Flowing Text Among Text Boxes
- Tweaking Your Text
- Adding a Table
- Adding a Picture
- Adding a Design Object
- Arranging Objects on the Page
- Stacking and Grouping Objects
- Flowing Text Around an Object
- Double-Checking Your Publication
- Sending a Publication as E-Mail
- Printing Your Publication
-
14. Creating Web Pages and Web Sites
- What’s Where in FrontPage?
- Creating a Web Site
- Editing a Web Page
- Customizing Your Web Site
- Customizing a Web Page
- Creating Hyperlinks
- Creating Hotspot Hyperlinks
- Adding Pictures
- Adding a Page to a Web Site
- Adding Web Components
- Using Tables for Web-Page Layout
- Creating a SharePoint Web Site
- Creating a Web Page in Word
- Creating a Web Page in Excel
- Creating a Web Page in PowerPoint
- Creating a Data-Access Page
- Creating a Web Site in Publisher
- Creating a Calendar Web Page
- Working with HTML Code
- Double-Checking Your Web Site
- Publishing Your Web Site
- 15. Using Forms with InfoPath
- 16. Taking Notes with OneNote
-
17. Exchanging Information Among Programs
- Inserting Excel Data into a Document, Publication, or Presentation
- Inserting an Excel Chart into a Document, Publication, or Presentation
- Analyzing a Word Table in Excel
- Using Word to Prepare PowerPoint Text
- Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
- Using Publisher to Present a Word Document
- Using Word to Prepare Publisher Text
- Using Word to Present Access Data
- Analyzing Access Data in Excel
- Using Access Data in a Mail Merge
- Using Access Data to Create a Catalog in Publisher
- Adding Excel Data to an Access Database
-
18. Working with Graphics and Objects
- Creating Stylized Text with WordArt
- Inserting Clip Art
- Drawing on a Canvas
- Drawing AutoShapes
- Inserting a Diagram
- Creating an Equation
- Inserting a Picture
- Wrapping Text Around a Picture
- Editing a Picture
- Reducing the File Size of a Picture
- Formatting an Object
- Managing Pictures, Videos, and Sound Files
- 19. Alternative Ways to Add Content
-
20. Working with Others
- What’s Where in SharePoint?
- Sharing a File on a SharePoint Site
- Accessing a Shared File
- Sharing Information with Your Group
- Working in a Shared Workspace
- Managing Your SharePoint Site
- Working Simultaneously on a File
- Comparing Documents and Presentations
- Working Simultaneously on a Shared Excel Workbook
- Controlling Changes in Word
- Controlling Changes in Excel
- Discussing a File On Line
- Sending Out a File for Review
- Reviewing a Document in Word
- Reviewing a File in Excel or PowerPoint
- Reviewing a Review in Word
- Reviewing a Review in Excel
- Reviewing a Review in PowerPoint
- Combining Reviews in Word or PowerPoint
- Working with Business Manager
- Reviewing Your Business Information
- 21. Fine-Tuning Your Work
- 22. Customizing Office
- 23. Keeping Your Files Secure
- A. About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® Office System Plain & Simple -- 2003 Edition
- Author(s):
- Release date: October 2003
- Publisher(s): Microsoft Press
- ISBN: 9780735619821
You might also like
book
Microsoft® Windows® Server 2003 Insider Solutions
Rather than being a traditional planning, design, and implementation guide, this book is a serious resource …
book
Microsoft® Visual C++® .NET 2003 Kick Start
Microsoft Visual C++ .NET 2003 Kick Start is targeted toward developers interested in making the jump …
book
Microsoft® Visual C#® .NET 2003 Unleashed
Microsoft Visual C# .NET 2003 Unleashed is a comprehensive reference and learning guide for the .NET …
book
Microsoft® Office Excel® 2007 Inside Out
Learn how to conquer Microsoft Office Excel 2007—from the inside out! This book packs hundreds of …