Microsoft Office 2007 on demand
Chapter 1 Getting Started with Office 1 Chapter 2 Using Shared Office Tools 33 Chapter 3 Adding Art to Office Documents 57 Chapter 4 Adding Shapes to Office Documents 93 Chapter 5 Formatting Office Documents 115 Chapter 6 Creating a Document with Word 131 Chapter 7 Formatting a Document with Word 15...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Indianapolis, Ind.
Que
2006
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Creating theme colors
- Choosing theme fonts
- Choosing theme effects
- Creating a custom theme
- Choosing a custom theme
- 6. Creating a document with Word
- Viewing the Word window
- Moving around in a document
- Changing document views
- Reading a document
- Setting up the page
- Setting up the page margins
- Creating an outline
- Selecting text
- Checking spelling and grammar
- Inserting new pages and sections
- Adding headers and footers
- Inserting page numbers and the date and time
- Customizing how you view items
- Creating and modifying notes
- Previewing items from Outlook
- Printing items from Outlook
- Customizing panes
- Sharing calendars over the Internet
- Adding and viewing an RSS feed
- 19. Creating a publication with Publisher
- Viewing the Publisher window
- Creating a quick publication
- Creating a new publication
- Creating a blank publication
- Changing your view
- Inserting and deleting pages
- Inserting and editing text
- Creating a Web site
- Adding a hot spot hyperlink
- Applying color
- Adding design gallery elements
- Checking your design
- Setting up the page
- Using commercial printing tools
- Printing publications.; 20. Designing a publication with Publisher
- Setting up layout guides
- Creating a frame
- Working with text
- Connecting text frames
- Creating a consistent look
- Creating tables
- Working with pictures and shapes
- Wrapping text around an object
- Layering objects
- Grouping objects together
- Changing text spacing
- Rearranging slides
- Using slides from other presentations
- Making your presentation look consistent
- Controlling slide appearance with masters
- Controlling a slide layout with masters
- Modifying placeholders
- Controlling a slide background with masters
- Adding a background style
- Inserting a table
- Modifying a table
- Formatting a table
- Adding a quick style to a table
- Creating a text box.; 13. Delivering a presentation with PowerPoint
- Changing page setup options
- Adding animation
- Using specialized animations
- Coordinating multiple animations
- Adding slide timings
- Creating slide transitions
- Recording a narration
- Inserting movies and sounds
- Setting movies and sound play options
- Setting up a slide show
- Creating a custom slide show
- Starting a slide show
- Navigating a slide show
- Annotating a slide show
- Packaging a presentation on CD
- Saving a presentation as a slide show
- Preparing handouts
- Preparing speaker notes
- Adding a footer and header
- Inserting the date and time
- Inserting slide numbers
- Previewing slides
- Printing a presentation
- 14. Creating a database with Access
- Understanding how databases store data
- Creating a database
- Viewing the Access window
- changing database display options
- Viewing database objects
- Working with database objects
- Planning tables
- Creating a table by entering data
- Creating a table using a template
- Creating a table using SharePoint
- Working with a table
- Importing data into tables
- Working with a table in design view
- Working with fields
- Specifying data types and field properties
- Changing field properties
- Creating input masks
- Creating a lookup field
- Planning tables relationships
- Defining tables relationships
- Ensuring referential integrity.; 15. Locating and managing data with Access
- Sorting records
- Filtering out records
- Creating complex filters using forms
- Receiving and reading messages
- Flagging messages
- Categorizing messages by color
- Deleting messages
- Replying to and forwarding a message
- Finding and filtering messages
- Organizing messages in folders
- Managing messages with colors and rules
- Using search folders
- Reducing junk e-mail
- Archiving messages
- Working with Outlook data
- Sending and receiving instant messages
- Enabling instant messaging.; 18. Managing information with Outlook
- Viewing the calendar
- Customizing the calendar
- Scheduling an appointment and event
- Scheduling meetings
- Responding to meeting requests
- Updating and canceling meeting requests
- Creating an online meeting workspace
- Creating and updating tasks
- Organizing tasks
- Assigning tasks to others
- Monitoring task progress
- Managing tasks
- Tracking activities with contacts
- Recording items in the journal
- Opening and modifying journal entries
- Organizing items by categories
- 10. Building a worksheet with Excel
- Understanding formulas
- Understanding cell referencing
- Creating a simple formula
- Creating a formula using Formula AutoComplete
- Editing a formula
- Naming cells and ranges
- Entering named cells and ranges
- Managing names
- Simplifying a formula with ranges
- Calculating totals with AutoSum
- Correcting formulas
- Auditing a worksheet
- Creating functions
- Creating functions using the library
- Calculating multiple results
- Using nested functions
- Using text functions
- Using lookup and reference functions
- Summarizing data using subtotals
- Summarizing data using functions
- Converting text to columns
- Creating a table
- Formatting a table
- Formatting table elements
- Creating calculations in a table
- Removing table rows and columns
- Working with tables
- Sorting data in a table
- Displaying parts of a table with AutoFilter
- Creating custom searches
- Creating groups and outlines
- Modifying an organization chart
- Inserting and creating a chart
- Changing a chart type
- Changing a chart layout and style
- Changing chart titles
- Changing chart labels
- Formatting line and bar charts
- Editing chart data
- Saving a chart template
- 4. Adding shapes to Office documents
- Drawing and resizing shapes
- Adding text to a shape
- Creating and editing freeforms
- Adding a quick style to a shape
- Adding a quick style to shape text
- Applying color fills
- Applying picture or texture fills
- Applying gradient fills
- Applying shape effects
- Aligning and distributing objects
- Aligning objects to grids or guides
- Changing stacking order
- Rotating and flipping objects
- Grouping and ungrouping objects
- Selecting objects using the selection pane.; 5. Formatting Office documents
- Formatting text
- Changing alignment
- Using the format painter
- Adding custom colors
- Understanding themes
- Viewing and applying a theme
- Setting ActiveX security options
- Setting macro security options
- Changing message bar security options
- Setting privacy options
- Setting external content security options
- Working with Office safe modes
- Marking a document as read-only.; 23. Reviewing and sharing Office documents
- Sharing workbooks
- Creating and reading a cell comment
- Editing and deleting a cell comment
- Adding comments to a presentation
- Tracking changes
- Sending a document for review using e-mail
- Sending a document by Internet fax
- Working with XML
- Creating an XML data map
- Exporting and saving data in XML
- Creating a PDF document
- Creating an XPS document
- Sharing information between programs
- Exporting and importing data
- Linking and embedding files
- Consolidating data in Excel
- Linking data in Excel
- Getting external data in Excel
- Connecting to data in Excel
- Getting query data from a database
- Getting data from Access
- Getting text data in Excel
- Working with a shared workspace
- Working with Excel services
- Publishing slides to a library
- Saving a document to a document management server
- 24. Expanding Office functionality
- Viewing and managing add-ins
- Loading and unloading add-ins
- Enhancing a document with VBA
- Viewing the Visual Basic editor
- Setting developer options
- Understanding how macros automate your work
- Recording a macro
- Creating a macro
- Running a macro
- Controlling a macro
- Adding a digital signature to a macro project
- Assigning a macro to a toolbar
- Saving a document with macros
- Opening a document with macros
- Inserting ActiveX controls
- Using ActiveX controls
- Setting ActiveX control properties
- Adding VBA code to an ActiveX control
- Playing a movie using an ActiveX control
- Changing the document information panel
- New features
- Microsoft certified applications specialist
- Understanding the different types of queries
- Creating a query using a wizard
- Creating a query in design view
- Getting information with a query
- Modifying query in design view
- Performing calculations in queries
- Summarizing values with a crosstab query
- Creating a parameter query
- Finding duplicate fields
- Identifying object dependencies
- Backing up a database
- Compacting and repairing a database
- Introduction
- 1. Getting started with Office
- Starting an Office program
- Viewing an Office program window
- Using the Ribbon
- Choosing commands
- Working with toolbars
- Choosing dialog box options
- Using the status bar
- Creating a blank Office document
- Creating a document using a template
- Opening an existing Office document
- Converting an existing Office document
- Using task and window panes
- Arranging windows
- Getting help while you work
- Saving an Office document
- Saving an Office document with different formats
- Checking compatibility
- Documenting properties
- Switching views
- Getting updates on the Web
- Recovering an Office document
- Diagnosing and repairing problems
- Closing a document and exiting Office
- 2. Using shared Office tools
- Editing text
- Copying and moving text
- Finding and replacing text
- Correcting text automatically
- Inserting information the smart way
- Checking spelling
- Changing proofing options
- Creating a table of figures
- Creating footnotes or endnotes
- Creating a bookmark
- Inserting cross references
- Comparing and merging documents
- Using track changing
- Adding a cover page.; 9. Creating a worksheet with Excel
- Viewing the Excel window
- Selecting cells
- Moving around the workbook
- Entering labels on a worksheet
- Entering values on a worksheet
- Entering values quickly with AutoFill
- Editing cell contents
- Clearing cell contents
- Inserting and deleting cell contents
- Selecting rows, columns, and special ranges
- Selecting and naming a worksheet
- Inserting and deleting a worksheet
- Moving and copying a worksheet
- Hiding and unhiding worksheets and workbooks
- Hiding and unhiding a column or row
- Inserting a column or row
- Deleting a column or row
- Adjusting column width and row height
- Splitting a worksheet into panes
- Freezing and unfreezing a column or row
- Showing and hiding workbook elements
- Using custom dictionaries
- Inserting symbols
- Finding the right words
- Inserting research material
- Translating text to another language
- Using multiple languages
- Undoing and redoing an action
- Zooming the view in and out
- Previewing a document
- Printing a document
- Creating a template.; 3. Adding art to Office documents
- Locating and inserting Clip Art
- Inserting a picture
- Adding a quick style to a picture
- Applying a shape to a picture
- Applying a border to a picture
- Applying picture effects
- Modifying picture size
- Compressing a picture
- Modifying picture brightness and contrast
- Recoloring a p picture
- Cropping and rotating a picture
- Scanning and imaging documents
- Managing pictures
- Creating WordArt text
- Formatting WordArt text
- Applying WordArt text effects
- Modifying WordArt text position
- Creating SmartArt graphics
- Formatting a SmartArt graphic
- Modifying a SmartArt graphic
- Creating an organization chart
- 16. Presenting data with Access
- Creating a form
- Working with a form in design view
- Entering and editing data in a form
- Modifying a form
- Creating a report
- Modifying a report in design view
- Performing calculations in reports
- Formatting a form or report
- Aligning and grouping controls
- Grouping and sorting in reports
- Formatting a datasheet
- Changing the page setup
- Previewing and printing information
- Creating mailing labels
- 17. Communicating with Outlook
- Preparing for Outlook
- Using Outlook for the first time
- Viewing the Outlook window
- Using Outlook today
- Using the navigation pane
- Viewing items and folders
- Creating a contact
- Sorting contacts
- Creating a distribution list
- Creating and addressing and e-mail message
- Formatting message text
- Attaching a file or item to a message
- Using stationery
- Creating a signature
- Inserting message content
- Sending messages
- Setting message delivery options
- Aligning with precision
- Rotating and flipping objects
- 21. Publishing Office documents on the Web
- Opening a Web page
- Previewing a Web page
- Creating a hyperlink
- Adding hyperlinks to slide objects
- Formatting a cell hyperlink
- Changing Web page options
- Saving a Web page
- Publishing a Web page
- Saving slides as Web graphics
- Creating refreshable Web queries
- Getting data from Web queries
- Saving Web queries
- Accessing Office information on the Web
- Getting documents from the Web
- 22. Protecting and securing Office documents
- Inspecting documents
- Protecting a worksheet
- Locking and unlocking worksheet cells
- Adding security encryption to a document
- Adding password protection to a document
- Restricting document access
- Adding a digital signature
- Adding a signature line
- Avoiding harmful attacks
- Using the trust center
- Selecting trusted publishers and locations
- Setting add-in security options
- 7. Formatting a document with Word
- Formatting text for emphasis
- Finding and replacing formatting
- Changing paragraph alignment
- Changing line spacing
- Displaying rulers
- Setting paragraph tabs
- Setting paragraph indents
- Changing character spacing
- Applying a quick style
- Changing a style set
- Creating and modifying styles
- Creating bulleted and numbered lists
- Hiding text
- 8. Enhancing a document with Word
- Adding desktop publishing effects
- Adding a watermark
- Adding page backgrounds
- Adding text in columns
- Wrapping text around an object
- Working with text boxes
- Inserting building blocks using Quick Parts
- Creating a table
- Entering text in a table
- Modifying a table
- Adjusting table cells
- Formatting a table
- Calculating a value in a table
- Addressing envelopes and labels
- Creating a form letter
- Creating labels
- Inserting a table of contents
- Creating an index
- Creating captions
- Adding data validation to a worksheet
- Creating a drop-down list.; 11. Designing a worksheet with Excel
- Formatting numbers
- Applying and creating cell styles
- Applying conditional formatting
- Applying specialized conditional formatting
- Creating conditional formatting
- Managing conditional formatting
- Controlling text flow
- Formatting tabs and background
- Adding borders to cells
- Setting up the page
- Adjusting page margins
- Adding headers and footers
- Inserting page breaks
- Customizing worksheet printing
- Setting the print area
- 12. Creating a presentation with PowerPoint
- Viewing the PowerPoint window
- Browsing a presentation
- Understanding PowerPoint views
- Creating new and consistent slides
- Working with objects
- Entering and editing text
- Resizing text while typing
- Changing character direction
- Inserting and developing an outline
- Moving and indenting text
- Modifying a bulleted and numbered list
- Creating text columns