Marmel E. Office 2010 Just the Steps For Dummies

Wiley – 2010, 364 pages
ISBN: 047053219X, 0470622849Quickly and easily perform tasks in any Microsoft Office 2010 application.
As the world's leading suite of productivity software, Microsoft Office enables you to complete common business tasks, including word processing, e-mail, presentations, data management and analysis, and much more. With this fun and friendly guide, veteran author Elaine Marmel presents you with concise, step-by-step instructions for quickly and easily accomplishing the most popular tasks in Word, Excel, Outlook, and PowerPoint.
Decide on a task you are eager to undertake, find it quickly in the featured easy-to-read format, and get it done smoothly with this Just the Steps guide! You’ll discover how to insert pictures into a Word document, create PivotTables in Excel, add sound to a PowerPoint presentation, import contacts into Outlook, create a mail merge document with Outlook contacts, and much more.
Presents indispensible advice for accomplishing specific tasks in any of the applications included in Microsoft Office 2010, including Word, Excel, Outlook, and PowerPoint
Demonstrates how to insert pictures in a Word document, create PivotTables in Excel, add sound to a PowerPoint presentation, and import contacts into Outlook
Includes unique coverage of performing tasks that work across programs, such as creating a mail merge using Word and Outlook, and embedding an Excel chart in PowerPoint
With this efficient guide helping you quickly accomplish specific tasks in Office 2010, you won't know what to do with all your free time!Word.
Handling Document Files.
Open and Explore Word.
Enter Text in a Document.
Move Around in the Document Area.
Save a Document.
Set Options for Saving Documents.
Start a New Document.
Open a Document.
Convert a Prior Version Document to a Word 2010 Document.Exploring the Basics of Editing.
Insert Additional Text.
Insert Text by Replacing Existing Text.
Switch between Insert and Overtype Modes.
Delete Text.
Undo Changes.
Select Text.
Move or Copy Text.
Copy Blocks of Text.
Mark Your Place in a Document.
Find a Marked Place in a Document.
Start a New Paragraph.
Insert a Line Break.
Switch Document Views.Proofing Documents.
Find Text.
Replace Text.
Automatically Correct Typing Mistakes.
Create a Quick Part Entry to Insert
Frequently Used Phrases.
Insert a Quick Part Entry.
Check Spelling and Grammar.
Disable Automatic Grammar and
Spell Checking.
Use the Thesaurus to Find a Synonym or an Antonym.Focusing on Text.
Change Text Case.
Change the Font.
Select a New Default Font for All New Documents.
Apply Bold, Italics, or Underline.
Change Text Color.
Highlight Text with Color.
Copy Text Formatting.Formatting Paragraphs.
Display Formatting Information.
Hide and Display Rulers.
Align Text.
Work with Tabs.
Indent Paragraphs.
Add a Border to a Paragraph.
Set Line Spacing within a Paragraph.
Set Line Spacing between Paragraphs.
Create a Bulleted or Numbered List.
Create a Multilevel List.
Format with Styles.
Switch All Text of One Style to a Different Style.
Save Formatting in a Style.Managing Pages and Printing.
Change Margins.
Change Page Orientation.
Insert a Page Break.
Insert a Section Break.
Add a Header or Footer.
Use Different Headers or Footers within a
Document.
Control Text Flow and Pagination.
Add Document Page Numbers.
Create a Table.
Create Newspaper Columns.
Preview a Document Before Printing.
Print a Document.Excel.
Getting Started with Excel.
Open and Explore Excel.
Create a New Excel File.
Save an Excel Workbook.
Save a File in a Different Format.
Open an Existing File.
Convert a Prior-Version File to Excel 2010.
Delete a File.
Change the Active Cell.
Enter Cell Data.
Undo Data Entry.
Edit Cell Data.
Select Multiple Cells.
Extend a Series with AutoFill.
Copy and Paste Cell Data.
Move Data.
Drag and Drop Data.
Transpose Data.
Insert Rows and Columns.
Insert Cells.
Delete Rows and Columns.
Delete Cells.Working with Excel Formulas.
Create Simple Formulas with Operators.
Create Compound Formulas.
Add Numbers with AutoSum.
Find an Average Value.
Copy Formulas with AutoFill.
Edit a Formula.
Define an Absolute Reference.
Copy Values by Using Paste Special.
Build a Formula with the Function Wizard.
Name Cell Ranges.
Use Named Ranges.
Manage Range Names.
Validate Data Entry.Formatting Worksheets.
Format Values.
Add or Remove Decimal Points.
Adjust Column Width.
Change Row Height.
Align Data.
Create a Title by Merging Cells.
Change Font Color.
Select Font Attributes.
Apply Cell Background Colors.
Wrap Text in a Cell.
Place Borders around Cells.
Work with Date Formats.
Copy Formatting.
Indent Data in Cells.
Use Cell Styles.Managing Workbooks.
Insert Additional Worksheets.
Delete Worksheets.
Rename Worksheets.
Copy Worksheets.
Move or Copy Worksheets to a Different Workbook.
Hide and Unhide Worksheets.
Change Worksheet Tab Colors.
Generate References to Other Worksheets.
Cross-Reference Other Workbooks.
Zoom In or Out.
Use the Zoom Controls.
Change Worksheet Views.
Freeze Worksheet Titles.Using Excel Tools.
Use the Ribbon to Sort.
Work with the Sort Command.
Sort by Multiple Criteria.
Sort by Cell Format.
Search for Data.
Find All Data Occurrences.
Locate Cells by Format.
Use the Replace Command.
Create an AutoFilter.
Generate a Subtotal.
Control Individual Subtotals.
Remove Subtotals.
Work with Assistance Tags.
Split Data into Multiple Columns.
Merge Columns.Creating Charts in Excel.
Add Sparklines.
Add Sparkline Markers.
Change Sparkline Styles.
Edit Sparkline Data.
Create a Basic Chart.
Insert a Chart.
Change the Chart Type.
Adjust the Chart Location.
Display a Chart Title.
Customize the Chart Legend.
Add a Data Table.
Show Data Labels.
Select a Chart Color Style.
Place a Picture in a Data Series.
Adjust Chart Data.Printing in Excel.
Preview Before Printing.
Add a Manual Page Break.
Specify a Print Area.
Adjust Paper Orientation and Size.
Make Worksheets Fit Better on a Page.
Set Page Margins.
Specify Repeating Rows and Columns.
Print Gridlines and Row and Column Headings.
Add a Standard Header or Footer.
View Other Header and Footer Options.
Create a Custom Header or Footer.
Print Worksheets and Charts.
E-Mail a Workbook.
PowerPoint.
Creating a Presentation.
Start PowerPoint.
Open a Saved Presentation.
Create a New Presentation.
Use Slides from Another File.
Save a Presentation.
Save a Presentation in a Different Format.
Close a Presentation.
Exit PowerPoint.
Create an Outline.
Import a Microsoft Word Outline.
Add a New Slide.
Delete a Slide.Editing a Presentation.
Change a Slide Type.
Copy Slides.
Add Text to a Slide.
Edit Slide Text.
Move a Text Placeholder.
Resize a Text Placeholder.
Format Text.
Organize Slides in the Slide Sorter.
Insert Clip Art.
Insert a Saved Picture.
Insert a Sound.
Insert a Video File.Working with Objects.
Crop a Picture.
Resize a Picture.
Rotate a Picture.
Flip a Picture.
Adjust Picture Brightness and Contrast.
Add Transparency to an Object.
Draw Shapes.
Change the Shape Style.
Change Line Color.
Change Line Style.
Move Objects.
Stack Objects.
Align Objects.
Distribute Objects.
Group Objects.
Add Frames to Objects.
Add Effects to Objects.Adding Tables, Charts, and Diagrams.
Insert a Table.
Copy a Table from Word or Excel.
Format Table Text.
Format the Table Style.
Modify Table Size.
Insert a Chart.
Change a Chart Type.
Edit Chart Data.
Embed an Excel Chart.
Modify the Chart Title.
Modify the Chart Legend.
Create a SmartArt Diagram.
Modify a Diagram Style.
Format and Edit Diagrams.
Add Shapes to a Diagram.
Delete Shapes from a Diagram.
Change the Diagram Color Scheme.
Change the Diagram Type.Finishing the Presentation.
Apply a Theme.
Change Theme Colors.
Change Theme Fonts.
Choose Theme Effects.
Work with Slide Masters.
Change a Slide Master Background.
Create Your Own Background.
Create Speaker Notes.
Edit the Notes Master.
Establish Print Options.
Print Audience Handouts.
Print Speaker Notes.
Print the Outline.
E-Mail the Presentation.Presenting the Presentation.
Set Up Your Show.
Set Slide Transitions.
Apply Animation to Bullets.
Animate a Chart by the Components.
Apply Timing to Individual Slides.
Rehearse Timings.
Start the Slide Show.
Pause and Resume the Slide Show.
Use Slide Show Controls.
Navigate with the Keyboard.
Use Hidden Slides.
Annotate Slides.
Package the Presentation.
Run a Packaged Presentation.Outlook.
Getting Started with Outlook.
Open and Explore Outlook.
Work with the Navigation Pane.
Work with the Outlook Ribbon.
Use Outlook Today.
Set the Outlook Starting Folder.
View the To-Do Bar.
Use the Reading Pane.
Set Outlook Options.
Clean Up Outlook Data.
Compact Outlook Data Files.Working with E-Mail.
Work with Conversation View.
Create and Send an E-Mail.
Select Mail Message Recipients from the Address Book.
Reply to an E-Mail.
Forward an E-Mail.
Display the BCC Field.
Send an E-mail without Displaying Recipient Names.
Control the Appearance of Original Message Text in Replies or Forwarded E-Mails.
Add a Message’s Sender to the Address Book.
Attach a File to an E-Mail Message.
Send an E-Mail to a List of Contacts.
Use Quick Steps.
Create Your Own Quick Step.
Create E-Mail Signatures.
Select an Alternate Signature for an E-Mail Message.
Search E-Mail.
Sort and Group Messages.
Automatically Move Messages to a Specific Folder.
Categorize E-Mail.
Follow Up on a Mail Message.
Create a Reminder.
Set Up an Out-of-Office Reply Message.
Turn On an Out-of-Office Reply Message.
Manage Junk Mail.Managing Contacts.
Add Contacts.
Search for a Contact.
Create a Contact Group.
Work with Views.
Create Color Categories for Contacts.
Assign a Category to a Contact.
Print a View.
View One Category of Contacts in Any Contact View.
Print a Category of Contacts.
Customize a View to Display and Print Address Information.
E-Mail a Contact’s Information.
Forward Contact Information from an E-Mail Message.
Include Your Electronic Business Card as Your Outlook E-Mail Signature.
Send an E-Mail to All Contacts in a Category.Using the Calendar.
Set Up an Appointment.
Set Up a Recurring Appointment.
Change an Appointment Date or Time.
Set Up a Meeting.
Create a Recurring Meeting.
Accept or Decline a Proposed Meeting Time.
Propose a Different Meeting Time.
Change a Meeting Time or Date.
Set Up an Appointment from an E-mail Message.
Create a Reminder for an Existing Appointment or Meeting.
Set Default Reminder Information.
Show Week Numbers in the Month View.
Display Two Time Zones.
Add Holidays to the Calendar.Using Tasks and To-Do Items to Manage Your Time.
Create a Task Using the Task Window.
Use the To-Do Bar to Create a Task.
Create a Task in the Calendar Daily Task List.
Create a To-Do Item.
Create a Recurring Task.
Complete a Task.
Display Completed Task in the To-Do Bar.
Hide Completed Tasks in the To-Do Bar.
Hide or Display Completed Tasks in the Calendar’s Daily Task List.
Reinstate a Completed Task.
Sort Tasks in the Task List.
Reorder Tasks with the Same Due Date.
Link a Task to a Contact.
Display Only Today’s Tasks in the To-Do Bar.
Using Office Products Together.
Features Common to Office Programs.
Select Commands from the Ribbon.
Use Backstage View.
Open a Dialog Box.
Use the Status Bar.
Work with the Mini Toolbar
and the Contextual Menu.
Customize the Ribbon.
Customize the Quick Access Toolbar.Using Information from
One Office Program in Another.
Transfer Excel Data into PowerPoint.
Transfer an Excel Chart to a PowerPoint Slide.
Create a PowerPoint Slide from a Word Outline.
Place a Word Table in Excel.
Place a Word Table in PowerPoint.
Place Excel Data in Word.
Place an Excel Chart in Word.
Import Contact Information from Excel into Outlook.
Export an Outlook Category of Contacts to Excel.
Display Outlook Calendar Information in Another Office Program.Handling Mail Merges.
Create a Mailing List in Excel.
Create an Address List in Word.
Create a Mail Merge Letter with Excel Data.
Create Mail Merge Envelopes in Word with Excel Data.
Create Mail Merge Labels in Word with Excel Data.
Create Mailing Labels with Outlook
Contact Information.
Using the Mail Merge Wizard with Selected
Outlook Contact Information.Working in Groups with Office Programs.
Add a Comment to a Word Document.
Track Changes to a Word Document.
Review Tracked Changes in a Word Document.
Combine Tracked Changes from Versions of a Word Document.
Add Comments to Excel Workbook Cells.
Display a Cell Comment in an Excel Workbook.
Display All Comments in an Excel Workbook.
Share an Excel Workbook.
Track Changes in an Excel Workbook.
Review Tracked Changes in an Excel Workbook.
Print Comments in an Excel Workbook.
Add a Comment to a PowerPoint Slide.
Edit a PowerPoint Slide Comment.
Delete a PowerPoint Slide Comment.
Review PowerPoint Slide Comments.
Print PowerPoint Slide Comments.