Microsoft Office 2007 In Simple Steps

Top 10 Office 2007 Tips

1. Launch an Office application
2. Select and edit text
3. Insert an image
4. Apply a theme
5. Create an outline
6. Enter values in an Excel worksheet
7. Insert a PowerPoint template
8. Manage Access database objects
9. Add a new contact
10. Send an email message

Chapter 1 – Getting acquainted with Office 2007

• Manually activate Office 2007
• Launch an Office application
• Work with the Office program window
• Open a new blank Office file
• Open an existing Office file
• Explore the Ribbon
• Choose menu commands
• Work with toolbars
• Manage the Quick Access Toolbar
• Customise the Quick Access Toolbar
• Choose dialogue box options
• Use the status bar
• Add or remove status bar contents
• Change task panes
• Manage multiple windows
• Create a document from a template
• Save a file
• Save an Office file in a different format
• Find Help while you’re working
• Change preferences
• Change views
• Update Office from the Web
• Close a file and exit Office

Chapter 2 – Working with text

• Select text
• Edit text
• Copy and move text
• Use the Office Clipboard task pane
• Find and replace text

• Correct text automatically

• Check spelling and grammar
• Consult the thesaurus
• Create text boxes
• Translate text

• Import text files

• Insert a symbol
• Load a custom dictionary

Chapter 3 – Working with art and photos

• Browse Office clip art
• Browse clip art online
• Insert clip art
• Place a picture
• Adjust picture size
• Specify image size
• Add a border to a picture
• Brighten up an image
• Modify a picture’s contrast
• Change an image’s colour scheme
• Crop and rotate a picture
• Rotate an image
• Create WordArt text
• Format WordArt
• Apply special effects to WordArt
• Create SmartArt graphics
• Draw and resize shapes
• Align and distribute objects
• Manage your images

Chapter 4 – Applying themes and formatting

• Apply a theme to an existing document
• Apply a theme to a new document
• Apply a theme from another document
• Change the default Office theme
• Change theme colours
• Create your own theme colours
• Change theme fonts
• Add special effects to themes
• Create a custom theme
• Rotate and flip objects
• Make an object 3D
• Change stacking order
• Adjust shadows
• Format text in tables
• Use Quick Styles to format a table
• Format numbers in worksheets
• Use the Format Cells dialogue box
• Work with the Format Painter

Chapter 5 – Creating a Word document

• Change document views
• Make text easier to read
• View multiple pages
• View a document map
• Set up the page
• Set page margins visually
• Create an outline
• Add a new page or section

• Add headers and footers

• Insert page numbers
• Add the date and time
• Find and replace formatting
• Set paragraph tabs
• Change character spacing
• Apply a style set
• Create a style
• Modify a style
• Create bulleted and numbered lists
• Modify bullet or number styles
• Create a table

Chapter 6 – Working with Excel spreadsheets

• Select cells
• Jump to a specific location
• Create labels
• Enter values in a worksheet
• Edit cell contents
• Clear cell contents
• Select rows, columns and special ranges
• Name a worksheet
• Delete a worksheet
• Move or copy a worksheet
• Insert a column or row
• Delete a column or row
• Adjust column or row size
• Divide a worksheet into panes
• Create a basic formula
• Display formulas
• Use formula AutoComplete
• Edit a formula
• Apply conditional formatting

Chapter 7 – Assembling PowerPoint presentations

• Navigate a presentation
• Switch views
• Create a new slide
• Change a slide’s layout
• Work with objects
• Insert a template
• Use text placeholders
• Select and modify text
• Create a list
• Take advantage of AutoFit
• Develop an outline
• Duplicate a slide
• Manage slides with Slide Sorter
• Import slides
• Insert a Slide Master
• Insert placeholder content
• Change the page setup
• Adjust slide timing
• Edit slide timing

Chapter 8 – Creating an Access database

• Use a template to create a database
• Assemble a blank database
• Work with the Access window
• Customise Access display options
• Add fields from templates
• Reuse existing fields
• Explore database objects
• Manage database objects
• Create a table with a template
• Enter and find new table records
• Find records
• Create a database query
• Configure and view query results
• Create a form, Part 1
• Create a form, Part 2
• Enter data into a form
• Create a report
• Change page setup
• Back up a database

Chapter 9 – Getting organised with Outlook

• Start Outlook for the first time
• Customise your ‘to do’ list
• Add a task
• Enter a calendar item
• Navigate through your Outlook data
• Customise the Navigation pane
• View items
• View folders
• Subscribe to an RSS feed
• Add a new contact
• Display and edit a business card
• Create a distribution list
• Create and address an email message
• Attach a file to an email message
• Create a signature file
• Send an email message
• Reading email messages
• Searching your email

Top 10 Office 2007 problems solved

1   How do I maintain or repair Office applications?

3 I need to enable Safe mode, what do I do?

4 How do I start user-initiated Safe mode?

5 I need to correct an Excel formula

6 I need to check an Excel worksheet for errors

7 I think my Access database needs repairing

8 I can’t send or receive emails

9 How do I repair a damaged document?

10 I need to recover a damaged file