Word
• Creating, Entering Text in, and Saving DocumentsFine-Tuning Text, 55
• Correcting Spelling and Grammatical Errors, 63
• Inserting Saved Text,69
• Changing a Document’s Theme
• Manually Changing the Look of Characters
• Manually Changing the Look of Paragraphs
• Creating and Modifying Lists
• Creating Tabbed Lists
• Presenting Information in Tables
• Formatting Tables
• Changing a Document’s Background
• Inserting Building Blocks
• Adding WordArt Text
• Controlling What Appears on Each Page
• Printing Documents
• Preparing Documents for Electronic Distribution
• Modifying Diagrams
• Creating Picture Diagrams
• Modifying Charts
• Using Existing Data in Charts
• Inserting Symbols and Equations
• Drawing and Modifying Shapes
• Inserting Screen Clippings
• Arranging Objects on the Page
• Using Tables to Control Page Layout
• Creating and Modifying Web Documents
• Creating and Publishing Blog Posts
• Inserting Fields
• Adding Bookmarks and Cross-References
• Creating and Modifying Indexes
• Adding Sources and Compiling Bibliographies
• Preparing Data Sources
• Preparing Main Documents
• Merging Main Documents and Data Sources
• Sending Personalized E-Mail Messages to Multiple Recipients
• Creating and Printing Labels
• Sending Documents Directly from Word
• Adding and Reviewing Comments
• Tracking and Managing Document Changes
• Comparing and Merging Documents
• Password-Protecting Documents
• Controlling Changes
• Changing Default Program Options
• Customizing the Ribbon
• Customizing the Quick Access Toolbar
Excel
• Creating Workbooks
• Modifying Workbooks
• Modifying Worksheets
• Customizing the Excel 2010 Program Window
• Entering and Revising Data
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data
• Defining Excel Tables
• Naming Groups of Data
• Creating Formulas to Calculate Values
• Summarizing Data That Meets Specific Conditions
• Finding and Correcting Errors in Calculations
• Formatting Cells
• Defining Styles
• Applying Workbook Themes and Excel Table Styles
• Making Numbers Easier to Read
• Changing the Appearance of Data Based on Its Value
• Adding Images to Worksheets
• Limiting Data That Appears on Your Screen
• Manipulating Worksheet Data
• Defining Valid Sets of Values for Ranges of Cells
• Sorting Worksheet Data
• Organizing Data into Levels
• Looking Up Information in a Worksheet
• Using Workbooks as Templates for Other Workbooks
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data
• Defining an Alternative Data Set
• Defining Multiple Alternative Data Sets
• Varying Your Data to Get a Desired Result by Using Goal Seek
• Finding Optimal Solutions by Using Solver
• Analyzing Data by Using Descriptive Statistics
• Analyzing Data Dynamically by Using PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data
• Creating Charts
• Customizing the Appearance of Charts
• Finding Trends in Your Data
• Summarizing Your Data by Using Sparklines
• Creating Dynamic Charts by Using PivotCharts
• Creating Diagrams by Using SmartArt
• Creating Shapes and Mathematical Equations
• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing
• Printing Worksheets
• Printing Parts of Worksheets
• Printing Charts
• Enabling and Examining Macros
• Creating and Modifying Macros
• Running Macros When a Button Is Clicked
• Running Macros When a Workbook Is Opened
• Including Office Documents in Workbooks
• Storing Workbooks as Parts of Other Office Documents
• Creating Hyperlinks
• Pasting Charts into Other Documents
• Sharing Workbooks
• Managing Comments
• Tracking and Managing Colleagues’ Changes
• Protecting Workbooks and Worksheets
• Authenticating Workbooks
• Saving Workbooks for the Web
PowerPoint
• Working in the User Interface
• Creating and Saving Presentations
• Opening, Moving Around in, and Closing Presentations
• Viewing Presentations in Different Ways
• Key Points
• Adding and Deleting Slides
• Adding Slides with Ready-Made Content
• Dividing Presentations into Sections
• Rearranging Slides and Sections
• Key Points
• Entering Text in Placeholders
• Adding Text Boxes
• Editing Text
• Correcting and Sizing Text While Typing
• Checking Spelling and Choosing the Best Words
• Finding and Replacing Text and Fonts
• Key Points
• Applying Themes
• Using Different Color and Font Schemes
• Changing the Slide Background
• Changing the Look of Placeholders
• Changing the Alignment, Spacing, Size, and Look of Text
• Key Points
• Inserting Pictures and Clip Art Images
• Inserting Diagrams
• Inserting Charts
• Drawing Shapes
• Adding Transitions
• Key Points
• Setting Up Presentations for Delivery
• Previewing and Printing Presentations
• Preparing Speaker Notes and Handouts
• Finalizing Presentations
• Delivering Presentations
• Key Points
• Inserting Tables
• Formatting Tables
• Inserting and Updating Excel Worksheets
• Key Points
• Editing Pictures
• Customizing Diagrams
• Formatting Charts
• Arranging Graphics
• Key Points
• Adding WordArt Text
• Inserting Symbols and Equations
• Inserting Screen Clippings
• Creating Hyperlinks
• Attaching Actions to Text or Objects
• Key Points
• Using Ready-Made Animations
• Customizing Animation Effects
• Key Points
• Inserting and Playing Sounds
• Inserting and Playing Videos
• Key Points
• Collaborating with Other People
• Saving Presentations in Other Formats
• Sending Presentations Directly from PowerPoint
• Password-Protecting Presentations
• Adding and Reviewing Comments
• Merging Presentation Versions
• Key Points
• Creating Theme Colors and Fonts
• Viewing and Changing Slide Masters
• Creating Slide Layouts
• Saving Custom Design Templates
• Key Points
• Adapting Presentations for Different Audiences
• Rehearsing Presentations
• Preparing Presentations for Travel
• Saving Presentations as Videos
• Key Points
• Changing Default Program Options
• Customizing the Ribbon
• Customizing the Quick Access Toolbar
• Key Points
Access
• Working in Access 2010
• Understanding Database Concepts
• Exploring Tables
• Exploring Forms
• Exploring Queries
• Exploring Reports
• Previewing and Printing Access Objects
• Key Points
• 1. Creating Databases from Templates
• 2. Creating Databases and Tables Manually
• 3. Manipulating Table Columns and Rows
• 4. Refining Table Structure
• 5. Creating Relationships Between Tables
• 6. Key Points
• 1. Creating Forms by Using the Form Tool
• 2. Changing the Look of Forms
• 3. Changing the Arrangement of Forms
• 4. Key Points
• Sorting Information in Tables
• Filtering Information in Tables
• Filtering Information by Using Forms
• Locating Information That Matches Multiple Criteria
• Key Points
• Creating Reports by Using a Wizard
• Modifying Report Design
• Previewing and Printing Reports
• Key Points
• Restricting the Type of Data
• Restricting the Amount of Data
• Restricting the Format of Data
• Restricting Data by Using Validation Rules
• Restricting Data to Values in Lists
• Restricting Data to Values in Other Tables
• Key Points
• Modifying Forms Created by Using a Wizard
• Adding Controls
• Adding Subforms
• Using E-Mail Forms to Collect Data
• Key Points
• Creating Queries by Using a Wizard
• Creating Queries Manually
• Using Queries to Summarize Data
• Using Queries to Perform Calculations
• Using Queries to Update Records
• Using Queries to Delete Records
• Key Points
• Creating Reports Manually
• Modifying Report Content
• Adding Subreports
• Key Points
• Importing Information
• Exporting Information
• Copying to and from Other Office Programs
• Key Points
• Creating Navigation Forms
• Creating Custom Categories
• Controlling Which Features Are Available
• Key Points
• Assigning Passwords to Databases
• Splitting Databases
• Securing Databases for Distribution
• Preventing Database Problems
• Key Points
• Changing Default Program Options
• Customizing the Ribbon
• Customizing the Quick Access Toolbar
• Key Points
Outlook
• Read mail
• Send mail
• Compose mail by entering text
• Print mail
• Address mail by entering text
• Use mail features (forward, reply, and recall)
• Use address book to address mail
• Flag mail messages
• Navigate within mail
• Find messages
• Configure basic mail print options
• Work with attachments
• Add a signature to mail
• Customize the look of mail
• Use mail templates (themes) to compose mail
• Integrate and use mail with other Outlook components
• Customize menu and task bars
• Create folders
• Sort mail
• Set viewing options
• Archive mail messages
• Filter a view
• Navigate within the calendar
• Schedule appointments and events
• Set reminders
• Print in calendar
• Schedule multi-day events
• Configure calendar print options
• Customize the calendar view
• Schedule recurring appointments
• Customize menu and task bars
• Add and remove meeting attendees
• Plan meetings involving others
• Save a personal or team calendar as a Web page
• Book office resources directly (e.g., conference rooms)
• Integrate calendar with other Outlook components
• Use Outlook Help and Office Assistant.
• Move items between folders
• Navigate between Outlook components
• Modify the Outlook Master Categories List
• Assign items to a category
• Sort information using categories
• Use the Office Clipboard
• Create, edit, and delete contacts
• Send contact information via e-mail
• Organize contacts by category
• Manually record an activity in a journal
• Link activities to a Contact
• Sort contacts using fields
• Create and update one-time tasks
• Accept and decline tasks
• Organize tasks using categories
• Assign tasks to others
• Create tasks from other Outlook components
• Change the view for tasks
• Create and use Office documents inside Outlook 2010
• Create and edit notes
• Organize and view notes
• Customize notes