List of Sidebars


Introduction

Office enhancements

Chapter 1: Carrying Out Basic Office Tasks

Other ways to start Office programs
Different configurations
Correcting mistakes
Whole word selection
Different Word views
Using keyboard shortcuts
Corresponding buttons
Quick toolbar expansion
Personalized toolbars and menus
Saving in a different folder
Changing the default save folder
Changing the file format
Creating a new Folder
Security options
Finding files
Managing files
The Office Clipboard
Undoing and redoing multiple actions
Changing the default font and font size
Click and type
Editing in Print Preview
Setting up for printing
About the Office Assistant
Using the Table of Contents
Using the Answer Wizard
Keeping up to date

Chapter 2: Editing and Organizing Word Documents

AutoText vs. AutoCorrect
FAQs
Formatted entries
Using AutoComplete
Using AutoText to write a letter
Deleting entries
AutoCorrect options
Activating drag and drop
Extending a selection
Smart editing
Smart tags
Moving to specific parts of a document
Creating master documents and subdocuments
Deleting headings
Jumping to a specific location
Editing during a find or replace
Finding and replacing formats
Refining your searches
Proofreading
Smart checking
Spelling and grammar options
Creating a Custom Dictionary
Using the thesaurus

Chapter 3: Formatting Eye-Catching Word Documents

Creating custom templates
Wizards
Install on demand
Date fields
Rebreaking titles and headings
Painting formats
Inserting lines
Using section breaks
Using bulleted lists
Automatic formatting
Keeping lines together
More about page numbers
Character styles vs. paragraph styles
Hyphenating a document
Copying styles
Modifying styles
Adjusting Column Widths and Row Heights
Other ways to create tables
Moving and deleting table elements
Totaling cells to the left
Inserting rows or columns

Chapter 4: Setting Up Excel Worksheets

When you need more sheets
Using the tab scrolling buttons
Correcting mistakes
Checking spelling
Changing the action of Enter
Long numeric values
Date and time arithmetic
Other ways of selecting
Copying and moving with the keyboard
Attaching comments to cells
Inserting and Deleting Cells
Grouping and Ungrouping Worksheets
AutoFormats
Changing the standard width
Displaying formulas
Function names
AutoCalculate
Naming conventions
Calculation area advantages
Displayed values vs. underlying values
Conditional formatting
A function for every task
Adding headers/footers
Changing page orientation

Chapter 5: Performing Calculations and Graphing Excel Data

Opening a recently used workbook
Copying and moving sheets
Text values as arguments
Operators in IF functions
More about AutoFill
The Fill command
Outlining worksheets
Consolidating from multiple worksheets
X axis and y axis
The default graph format
Formatting graph elements
Creating graphs on chart sheets
Adding notes
Adding values to an existing graph
Combination graphs
Deleting graphs
Printing from Print Preview

Chapter 6: Developing Simple PowerPoint Presentations

Bypassing wizard pages
Presentation tips
Previews
Positioning and sizing text areas
Moving among slides
The fewer bulleted items, the better
Selecting parts of a slide
Changing the bullet character
The Show Formatting button
Customizing a presentation

Chapter 7: Adding Graphics, Graphs, and Special Effects to Slides

Adding shapes
The Clip Organizer
Adding new clip art slides
Clip art keywords
Adding a background graphic to all slides
Customizing AutoContent Wizard graphs
By row or by column
Adjusting column width
Adding an axis title
Removing the legend
Formatting parts of a legend
Formatting with fills
Adding text boxes and arrows
Changing the animation order
Erasing pen marks

Chapter 8: Developing Access Database Tables

Fields and records
Selecting a file format
Installing Access features
Ready-made business and personal tables
Primary key
Closing databases
Fast navigation
Saving in Access
Delete with care
Deleting AutoNumber fields
Flexible buttons
Data type restrictions
Restructure warning
Including spaces in field names
What is null?
The Input Mask List
Data integrity
Another way to restrict data
Format vs. Input Mask
Filtering records
Hiding fields
Freezing fields
Multi-column sorting

Chapter 9: Making Access Data Easily Available

Copy with caution
Copying records
Creating forms from scratch
Graphing Access data
More about moving controls and labels
Changing the input order of controls
Changing or deleting relationships
Wrong field name ?
Using Wildcards
Using the OR Operator
More logical operators
Creating a report from scratch
Preview before printing
Customizing reports
Creating mailing labels
Creating data access pages from scratch
Protecting fields on a data access page

Chapter 10: Managing E-mail and Contacts with Outlook

Automatically starting Outlook
Customizing the Outlook bar
Viewing messages with Word
Address books
Setting message options
Specifying message format
Attaching a signature
Inbox message symbols
More about the preview pane
Saving messages and attachments
No original message in replies
No sent messages
The folder list
Creating personal folders
Other ways to add contacts
Printing the contact list
Using distribution lists
Custom contact forms

Chapter 11: Managing Schedules and Task Lists

PDAs and printed schedules
Outlook Today
Setting work days and holidays
Creating appointments from messages
Making existing appointments recur
Attaching files to appointments
Scheduling recurring events
More complex searches
Network options
Creating recurring meetings
Using NetMeeting
Canceling meetings
Jotting down notes
Other ways to add tasks
The Details tab
Making a task list available for viewing
Using the Journal
Other task views
Assigning existing tasks
Owning tasks
Reassigning tasks

Chapter 12: Integrating the Office Programs

Creating custom toolbars
Hiding vs. removing
Graphing Word tables
More about linking
Embedding documents as icons
Embedding presentations
Online collaboration
Editing a web page



Online Traning Solutions - Quick Course in Microsoft Office XP
Online Traning Solutions - Quick Course in Microsoft Office XP
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 116

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net