book

Absolute Beginner’s Guide to Microsoft® Office 2003

by Jim Boyce

September 2003

Beginner

504 pages

11h 10m

English

Que

Read now

Unlock full access

Dedication
How This Book Is OrganizedConventions Used in This BookWeb Page AddressesSpecial ElementsLet Me Know What You Think
Why Office?Tips for Upgrading from Previous VersionsBack Up Anything You Can’t LoseClean Up the ComputerBe Prepared for the UnexpectedWorking with Letters and More with WordDocument and Font FormattingStylesSpelling and GrammarOutlining and the Document MapManaging Your Day with OutlookUsing MailFaxingUsing the Contacts FolderUsing the Calendar FolderUsing the Tasks and Notes FoldersUsing the Journal FolderUsing Outlook Data ElsewhereCrunching Numbers with ExcelWorking with Numbers and FormulasUsing Charts and GraphsOrganizing Data with AccessTables, Queries, and ReportsUsing Slide Shows and Presentations with PowerPoint
Installing OfficeSimple InstallationsTips for Installing OfficeCustomizing an InstallationInstalling from a Network ServerUsing Other ToolsStarting Office Programs When and How You WantStarting Office ApplicationsStarting Office Applications AutomaticallyUsing Switches to Control StartupWorking with the Navigation PaneWorking with More Than One Document at a TimeOpening, Saving, and Closing DocumentsUsing Handy Mouse and Keyboard TipsUndoing ChangesSaving Office Settings
Getting Quick HelpClicking the Question MarkSearching for Specific TopicsPressing the F1 KeyUsing the Help MenuMeeting (and Changing) the Office AssistantWorking with Help DocumentsUpdating OfficeGetting More Help on the WebWhat to Do When Office Crashes

Adding People to Your Contacts FolderSetting Other Contact PropertiesSaving a ContactImporting Addresses from Outlook ExpressViewing the Contacts Folder in Different WaysFinding a ContactFinding Email Messages and Other Items Associated with a ContactCalling or Emailing a ContactSending Email to a ContactCalling a ContactSorting and Organizing ContactsSharing ContactsSharing Contacts with Users of Your Exchange ServerSharing Contacts from a Personal Folders File
A Quick Tour of the InboxWorking in the InboxSorting MessagesMoving or Hiding the Reading PaneWorking with Different ViewsExpanding and Collapsing Message GroupsReading MessagesSending and Receiving MessagesSending MessagesReceiving MessagesWorking with AttachmentsUsing Bcc and Other Message OptionsSetting Up an Email AccountAdding an AccountSetting Up an Exchange Server AccountSetting Up a POP3 or IMAP AccountSetting Up an HTTP AccountSpecifying Where Outlook Should Deliver New MessagesAdding More Sets of FoldersChanging Account SettingsAdding or Changing an Outlook ProfileAdding a ProfileChanging Settings in a ProfileSwitching Between ProfilesDeleting, Archiving, and Recovering MessagesDeleting a MessageRecovering and Archiving MessagesManaging Mail FoldersCreating a Folder and Moving or Copying ItemsSharing a Folder (with Exchange Server Only)Filtering Out Junk MailChoosing a Junk Mail Protection LevelManaging the Safe Senders, Safe Recipients, and Blocked Senders ListsMarking Messages as Junk or Not JunkControlling Messages by Using RulesCreating a RuleRunning a Rule ManuallyOpening Another Person’s Mailbox with Your Own
A Quick Tour of the Calendar FolderAdding and Working with Events in the Calendar FolderAdding an EventViewing and Changing an EventGroup SchedulingPublishing Free/Busy InformationWorking with RemindersColoring Certain Types of EventsApplying Labels to EventsCustomizing LabelsColoring Events Automatically by Using FormattingKeeping Track of Holidays, Birthdays, and Other Special EventsAdding HolidaysAdding Birthdays and Other Special EventsPrinting a CalendarCreating a Recurring Appointment or EventCreating a Recurring EventChanging a Recurring EventTracking Documents and Events by Using the JournalUsing the JournalCreating a Journal Entry ManuallyTurning Off Journaling
About Tasks and the Tasks FolderCreating TasksCreating a Recurring TaskAssigning a Task to Someone ElseAssigning a TaskAccepting or Declining an Assigned TaskViewing and Changing Task StatusViewing Task StatusChanging Task StatusAssigning Other Outlook Items (Such as Documents) to a Task
Controlling When and How Outlook Checks Your MailCreating Custom ViewsCustomizing the Navigation PaneAdding Outlook ShortcutsAdding Other Types of ShortcutsSetting How Outlook Handles Text for Replies and ForwardsChanging How Outlook Notifies You of New MessagesSetting the Default Mail Format and EditorAdding a Signature Block to MessagesChanging the Reminder Sound and Default TimeTurning Instant Messaging On and OffSetting Calendar Week and Weekend OptionsControlling How Outlook Saves and Displays Contact Names
Starting or Opening a DocumentStarting a New DocumentOpening an Existing DocumentAdding Text Where You Want ItMoving Around in a Document and Between DocumentsBecoming Familiar with WordThe Menu and ToolbarsScrollbarsRed Squiggly UnderlineGreen Squiggly UnderlineWorking with Different Word ViewsSelecting and Deselecting TextCutting, Copying, and Moving TextAdding New Lines and Page BreaksUsing Zoom In and Zoom OutFinding and Replacing TextFinding TextReplacing TextShowing/Hiding Hidden CharactersWorking with an OutlineUsing Outline ViewAdding and Changing Outline HeadingsMoving Around an Outline
Margins and Other Page Setup FeaturesSetting MarginsSetting Paper Size and Other SettingsSetting Page Layout OptionsUsing Line NumbersUsing a Page BorderBasic Paragraph FormattingText Formatting: Fonts, Colors, and MoreUsing Fonts, Font Styles, and ColorsTabsSetting TabsAligning Tabs and Using LeadersClearing TabsBulleted and Numbered ListsUsing Bulleted ListsUsing Numbered ListsContinuing Numbering from a Previous ListRestarting Numbering a List at a Specific NumberSectionsInserting a Section BreakFormatting a SectionTemplates and StylesUsing StylesCreating a StyleApplying StylesChanging a StyleUsing TemplatesSaving a Document as a TemplateAttaching a Template to a DocumentStarting a New Document from a TemplateBorders and Shading
Using TablesSetting Up a TableInserting a TableDrawing a TableMerging and Splitting CellsAdding Text to a TableConverting Paragraphs to a Table and Vice VersaConverting Text to a TableConverting a Table to TextAdding Table CaptionsSorting TextUsing Columns
Adding Headers, Footers, and WatermarksAdding Headers and FootersAdding WatermarksInserting GraphicsInserting a PictureInserting Clip ArtInserting ChartsMoving and Resizing ImagesMoving and Resizing Images
Spell-Checking a DocumentUsing Automatic Spell-Checking: AutoCorrectChecking That Grammar!Can You Say “Thesaurus”?Using Other Languages and Custom DictionariesCustomizing the DictionaryAdding a New Custom DictionarySetting Language for Selected Text
Filenames, Locations, and FormatsChoosing Filenames and LocationsChoosing a Format for Saving a FileHaving Word Automatically Save DocumentsMaking Backup CopiesPrinting DocumentsQuick PrintingUsing a Different PrinterPrinting Pages or a Selection of TextChanging Other Common Print SettingsEasy Ways to Email a DocumentJust Email It!Sending a Document as an AttachmentRouting a Document with a Routing SlipFaxing a DocumentFaxing from the File MenuPrinting to the Fax Printer
Mailing Lists: Using Outlook or Access Instead of WordUsing Outlook for a Mailing ListWorking with Form LettersSetting Up a Form LetterCreating the Merged Document for an Outlook ListPrinting EnvelopesPrinting a Single EnvelopePrinting Many EnvelopesCreating and Printing Labels
Adding More Recently Used FilesEditing Text by Using Drag-and-DropControlling Text SelectionChanging AutoRecover TimeChanging Default File LocationsChanging Your User InformationChecking Spelling as You TypeUnderstanding Macro Security
Spreadsheets 101Using Cells and Other Interesting ThingsEntering NumbersEntering Text in CellsSelecting CellsChanging Row and Column PropertiesUsing Ranges and NamesJumping to a Named Cell or RangeIdentifying a Named Cell or RangeReferencing a Named Cell in a FormulaUsing Row and Column LabelsDefining Constants
Understanding Cell References and OperatorsUnderstanding Cell ReferencesUnderstanding OperatorsArithmetic OperatorsComparison OperatorsText OperatorsReference OperatorsCreating Simple FormulasSimple FormulasUnderstanding FunctionsWhere Are Those Functions?Combining References and FunctionsCopying Formulas Between CellsPulling Numbers from Other WorksheetsNaming and Referencing Other WorksheetsCopying and Linking Between WorksheetsReferencing Other WorkbooksPlaying What-if
Formatting Numbers and TextFormatting NumbersFormatting TextSetting AlignmentUsing Borders, Boxes, Shading, and Other JazzUsing BordersApplying Shading and PatternsOther Ways to Work with CellsMerging and Splitting CellsLocking and Hiding Cells, Rows, and ColumnsQuickly Filling Cells with a SeriesUsing Automatic FormattingAdding Comments to a WorksheetAdding CommentsEditing and Deleting CommentsReviewing Comments
Inserting a Chart QuicklyAdding a ChartPositioning and Resizing a ChartChanging Chart TypeMoving a Chart to a Different WorksheetWorking with Other Chart PropertiesChanging FontsAdjusting Colors and ShadingWorking with Titles, Legends, and Data LabelsChanging TitlesChanging a Chart LegendUsing Data LabelsPrinting Charts
Saving Excel WorkbooksChoose a File FormatUsing TemplatesPrinting Worksheets and WorkbooksPrinting a Worksheet or WorkbookPrinting Just a Selection of a WorksheetDesignating Printing and Nonprinting Information by Using Print AreasMaking It FitAdding Headers and FootersSpecifying Row and Column TitlesSetting Miscellaneous Print OptionsEmailing a Workbook
Changing How Comments AppearTurning Off Automatic CalculationZooming/Scrolling by Using the Mouse WheelSetting AutoRecover TimeChanging the Direction Excel Moves the Cursor After You Press EnterTurning AutoComplete On and Off for Text EntriesAdding More Recently Used FilesSetting the Default File LocationOpening Files Automatically at StartupChanging the Default FontCreating Custom Fill Series Lists
A Quick Tour of Microsoft PowerPointStarting a Presentation by Using the AutoContent WizardAdding Text to a PresentationNavigating, Inserting, Moving, and Deleting SlidesUsing the Slide Sorter ViewInserting a SlideMoving a SlideDeleting a SlideSwitching Slide Orientation Between Landscape and PortraitSaving a PresentationControlling Look and Feel by Using a Slide MasterAdding or Removing Slide Numbers and Dates
Adding TablesAdding Pictures and Video ClipsAdding PicturesAdding Video ClipsAdding SoundsInserting a Sound from a FilePlaying a CD TrackAnimating SlidesUsing Slide TransitionsCreating a Table of Contents or Summary SlideAdding Bullets and Numbered ListsUsing Special Text Formatting
Using Personal Notes in a PresentationAdding NotesPrinting Notes PagesCreating a Set of HandoutsPackaging a Presentation on a CDPrinting SlidesRunning a Slide ShowConfiguring Slide Show OptionsRunning a Presentation
Setting Default File LocationSetting the AutoRecover IntervalAdding More Files to the Recently Used Files ListSetting the Link/Embed File Size LimitControlling Chart FontsAdding More Undo LevelsAdding and Removing Navigation Controls for Web ViewingTurning On and Off Animations for Web Viewing
What Is a Database and Why Use One?Creating and Working with a New DatabaseCreating a Blank DatabaseCreating and Saving a TableUnderstanding KeysSwitching Between Design View and Datasheet ViewEntering Data in Datasheet ViewMoving Around a DatabasePerforming Simple SearchesForcing a Particular Format for a FieldUsing the Format PropertyUsing Input MasksUsing the Format and Input Mask Properties TogetherUsing Templates: Access’s Canned Databases
Using Forms for Data Entry and ViewingCreating a Form by Using the Form WizardLocking Controls on a FormAdding Controls and Associating Controls with FieldsUsing the Form Header and FooterBuilding a Database Interface with a Switchboard FormSorting and Filtering RecordsSorting a TableFiltering a TableFiltering by FormUsing Advanced FiltersSearching for and Selecting Data by Using QueriesCreating a Select QueryModifying a QueryChanging a Query’s TypePerforming Calculations by Using QueriesImporting Data from Other SourcesImporting Data from OutlookImporting Data from Other Access DatabasesLinking Tables
What Is an Access Report?Creating a Report by Using the Report WizardViewing and Modifying ReportsChanging a Report’s Layout and DesignAdding or Modifying Grouping and SortingUsing Summary InformationAdding Calculations to a ReportPrinting and Exporting Reports and LabelsSetting Page Layout OptionsPrinting a ReportUsing a Report in WordPrinting Labels
Enabling Single-Clicking to Open Tables and Other ItemsAdding More Recently Used FilesChanging the Default Search MethodControlling How Access Moves in a RecordSetting Default Fonts and ColorsSetting the Default Folder Location

Content preview from Absolute Beginner’s Guide to Microsoft® Office 2003

Acknowledgments

It has been a while since I wrote for Que, and this book has been a great reintroduction to the Que staff. I particularly want to thank Greg Wiegand and Angelina Ward for bringing me this opportunity. Thanks also to Tonya Simpson for a great job of managing the project, and to Howard Jones and Kitty Jarrett for their help in editing. I also thank Chris Barrick, Kathy Bidwell, the grahpics department, and Kelly Maish for their help in developing and producing the book.

I’d also like to offer a special thanks to Blair Rampling, Bill Zumwalde, and Scott Backstrom for helping with this and other projects so we could meet our deadlines and still end up with a quality product. I promise to take Bill and Scott flying as a bonus, but I ...