|
Brilliant Office 2007 Pocket Book
Exactly what you need to know - just when you need it !
Brilliant Office 2007 Pocket Book is a handy, visual quick-reference guide to the most common features, tasks and problems, that you will come across when using any of the Office 2007applications in any day-to-day situation at home or in the office.
brilliant Microsoft
Office 2007 Pocket Book
Brilliant Pocket Books delivers the answers you need when you are using your computer and are faced with an unfamiliar or problematic task in Office 2007. Short, concise explanations and a highly visual, step-by-step approach make it really easy to learn and master any task or problem that you come across. Keep it on your desk, in your bag - or even in your pocket - and you will always have the answers you need - just when you need them.
Brilliant Office 2007 includes:
* Foolproof step-by-step instructions for accomplishing specific tasks
* Numerous screenshots illustrating every step
* Jargonbuster boxes explaining new or unfamiliar terms in plain English
* Timesaving tips to give you ideas on cutting corners and avoiding confusion
* Additional information on key topics to expand your knowledge of a particular feature or concept.
* Important information boxes identifying areas where new users often run into trouble, and offering practical hints and solutions to these problems
Brilliant Pocket Books are handy, accessible resources that you will turn to time and time again when faced with a problem or an unfamiliar task and need an answer at your fingertips.
CONTENTS:
[TOC]
[TTL]Contents
Part 1 Office 2007 Overview
1 Getting Started with Office 2007
What's New in Office 2007
Installing Office 2007
Activating and Registering Office
2 Getting to Know Office 2007
Opening Office 2007
Exploring the New Workspace
Navigating Office
Using the Ribbon
Using the Contextual Tabs
Using Command Icons
Using Styles and Galleries
Using Live Preview
Finding Help
3 Customising Office 2007
Changing the Appearance of Office
Using Different Office Views
Customising Name, Initials and Language
Customizing Ribbons and Toolbars
Creating Custom AutoCorrect Entries
4 Creating Office Users and Groups
Understanding Users and Groups
Configuring User and Group Permissions
Deleting Permissions for Files and Folders
Managing Project Data
5 Collaborating with Others
Understanding SharePoint Services
Understanding Groove 2007
Part 2 Overview of Outlook 2007
6 Using Outlook 2007
What's New in Outlook 2007
Starting Outlook
Activating Outlook
Customising Outlook
The Navigation Pane
The To-Do Bar
The Reading Pane
Toolbars and the Status Bar
The Quick Access Toolbar
Navigating Around Outlook 2007
Creating a New Profile in Outlook
Editing and Removing Profiles
7 Sending and Receiving Email in Outlook 2007
An Introduction to Email
Creating and Sending Email
Respond and Forward
Changing the Message Format
Working with the Address Book
Creating Some Contacts
Using the Address Book
Receiving Emails
Notification Options
Previewing Messages
Navigating Messages with the Reading Pane
Previewing Attachments with the Reading Pane
8 Adding Visual Appeal to Your Emails
Using Stationery and Themes
Creating a Single Message with Stationery or Theme
Setting a Default Stationery or Theme
Adding Colour and Graphics to Your Messages
Adding Illustrations
Themes
Using Email Signatures
Creating an Email Signature
Edit or Delete an Email Signature
How to Use a Signature
Equations, Symbols and Horizontal Lines
9 Working with Email Options
What Are Email Options?
Message Settings
Security Settings
Voting Options
Delivery and/or Read Receipts
Additional Delivery Options
Email Options
10 Managing Email
Using Categories
Flagging Messages for Follow-up
Adding a Quick-Click Flag
Send a Message Flag to Others
Completing a Follow-up
Creating Message Folders
Where to Place Your New Folders
Using Search Folders
Searching for Items in Outlook 2007
Instant Search and Query Builder
Advanced Find
Working with Outlook Rules
Create a Rule
Out-of-Office Replies
Fight Spam with Junk Email Filters
11 Using the Outlook Calendar
Navigating the Calendar
Customising Your Calendar
Calendar Options
Time Zone Settings
Adding Calendar Items
Creating Our First Appointment
Create a Recurring Appointment
Create a Meeting
Cancelling a Meeting
12 Collaborating with Others
Sharing Your Calendar with Others
Sharing Your Calendar with Exchange
Sending Calendar Sharing Invitations
Sharing Your Calendar without Exchange Server
Publishing Your Calendar on the Internet
Sending a Calendar in Email
Printing Your Calendar
Group Scheduling
13 Organising Schedules with Tasks and the To-Do Bar
Working with the To-Do Bar
Working with Tasks
Create a Task
Working with Task Options
Recurring Tasks
14 Using Outlook Contacts
The Contacts Folder
Creating a New Contact
Changing the Business Card
Using Contacts to Communicate
Printing Contacts
15 Using Outlook's RSS Feeds
What is RSS?
Accessing RSS Feeds
Read the RSS Feed
Managing RSS Feeds
Change the Folder to Which an RSS Feed is Delivered
Deleting Feeds
Part 3 Overview of Word 2007
16 Familiarising Yourself with Word
Opening Word
Using the Word Ribbon
Changing Your View
Saving Files and Closing Word
Customising Word
17 Getting Started with Word Documents
Starting and Opening Documents
Adding Text to Your Document
Saving and Closing Documents
18 Editing Your Documents
Adding, Replacing and Rearranging Text
Using the Clipboard
Navigating Your Document
Selecting Text
Deleting Text
Moving Text Between Documents
19 Adding Visual Appeal to Your Documents
Working with Fonts
Selecting Fonts
Changing Fonts
Working with Styles
Creating and Saving Styles
Working with Text Alignment
20 Using Proofreading Tools
SpellCheck and AutoCorrect
Proofing as You Type
Using Grammar Check
Using Find and Replace
Word Counts, Page Counts and Character Counts
Using the Thesaurus
Using Microsoft's Research Services
21 Using AutoFormat
Understanding AutoFormat
Applying AutoFormat
22 Using Special Formatting Tools
Inserting Citations
Inserting Bibliographies
Using Special Characters and Symbols
Inserting Equations
23 Adding Graphics to Your Document
Inserting Clip Art and Pictures
Adding a Caption
Using SmartArt
Adding Charts
Using WordArt
24 Using Quick Parts
Understanding Quick Parts
Creating Building Blocks
Adding Quick Parts to Your Document
Customising Quick Parts
25 Printing Your Documents
Sending Your Documents to the Printer
Changing Your Print Settings
Previewing Your Print Job
Part 4 Overview of Excel 2007
26 Getting Started with Excel
Opening Excel
Using the Excel Ribbon
Changing Your View
Customising Excel
Starting and Opening Workbooks
Saving and Closing Workbooks
Closing Excel
27 Working with Data
Understanding Data Types
Entering Data
Entering Text
Entering Numbers
Entering Dates and Times
Copying Data to Other Cells
Using the AutoFill Function
28 Understanding Formulas and Calculations
Understanding Formulas
Using Formula Operators
Understanding Order of Operations
Entering Formulas in Cells
Using the AutoSum Feature
Displaying, Editing and Deleting Formulas
29 Working with Graphs and Charts
Understanding Graphs and Charts
Adding Graphs and Charts
Editing Graphs and Charts
Deleting Graphs and Charts
30 Editing Excel Spreadsheets
Correcting Data
Undoing an Action
Using the Replace Feature
Copying and Moving Data
Deleting Data
31 Getting Started with PowerPoint
What's New in PowerPoint
Customising PowerPoint
Starting a New Presentation
Saving and Closing a Presentation
32 Working with Presentation Views
Understanding Presentation Views
Using the Outline Pane
Using the Slide Sorter
Using the Notes Page
Using the Slide Show
Understanding and Using Master Views
33 Creating a Presentation
Using Slide Libraries
Using Colour Schemes
Using Themes
Working with Text
Using Formatting Tools
34 Working with Graphics
Adding Pictures and Clip Art
Creating Diagrams and Charts
Inserting Bulleted or Numbered Lists
Converting Lists to Diagrams
35 Adding Media to Your Presentation
Working with Sounds
Adding Animation
Using Transitions
36 Finishing Your Presentation
Using the Quick Print Option
Choosing What to Print
Packaging Your Presentation for CD
37 What's New with Access 2007
Using the Ribbon
Take Advantage of the Quick Access Toolbar
Working with the Navigation Pane
Understanding the New File Format
Convert a Database to an Access 2007 File
38 Access 2007 Fundamentals
Opening Access
Working with the Northwind Sample Database
Function Keys
View Options
Saving in Access
Exiting Access
39 Understanding Access 2007
Databases and Objects
Tables
Forms
Queries
Reports
Macros
Modules
The Sandbox Operating Mode
Change the Registry Key
40 Working with Security Settings
TrustCenter
Adding or Removing a Developer from a Trusted Location
Changing a Trusted Location
Encrypting Your Database
Open an Encrypted Database
Remove a Password from an Encrypted Database
Using the Package-and-Sign Feature
|