Book description
Get the fast facts that make learning Office 2010 plain and
simple! This colorful, no-nonsense guide uses easy-to-follow steps
and screenshots, and clear, concise language to show the simplest
ways to get things done with Microsoft Word, Excel, Outlook,
PowerPoint, Access, Publisher, and OneNote.
Here's WHAT You'll Learn
Create documents, Web pages, and other publications
Organize your e-mail, calendar, contacts and tasks
Build spreadsheets to analyze and visualize data
Set up a simple database
Capture notes with ink, voice or text
Here's HOW You'll Learn It
Jump in wherever you need answers
Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
Handy TIPS teach new techniques and shortcuts
Quick TRY THIS! Exercises help you apply what you learn right away
Table of contents
- Acknowledgments
- 1. About This Book
- 2. Working in Office 2010
-
3. Common Tasks in Office
- Working with Old Documents
- Inserting Pictures
- Changing the Size of a Picture
- Editing a Picture
- Enhancing Your Pictures
- Making Your Pictures Pop
- Adding Clip Art
- Inserting Screenshots
- Adding Shapes
- Formatting a Shape
- Inserting the Date and Time
- Creating Stylized Text
- Inserting a SmartArt Diagram
- Translating Your Text
- Researching a Subject
-
4. Viewing and Editing Text in Word
- What’s Where in Word 2010?
- Creating a New Document
- Composing Different Types of Documents
- Word’s Views
- Reading a Document
- Editing Text
- Discovering the Many Ways to Work with Text
- Navigating Your Document
- Replacing Text
- Correcting Your Spelling and Grammar
- Correcting Text Automatically
- Adding Page Numbers
- Co-Authoring in Word 2010
- Marking and Reviewing Changes in a Document
- Comparing Documents Side by Side
-
5. Formatting in Word
- Controlling the Look: Themes, Styles, and Fonts
- Choosing a Theme for Your Document
- Formatting Text with Styles
- Choosing Styles from the Styles Window
- Changing Character Fonts
- Setting Paragraph Alignment
- Adjusting Paragraph Line Spacing
- Setting Spacing Between Paragraphs
- Indenting a Paragraph
- Formatting with Tabs
- Adding Emphasis and Special Formatting
- Copying Your Formatting
- Creating a Bulleted or Numbered List
- Formatting a List
- Creating a Table from Scratch
- Using a Predesigned Table
- Creating a Table from Text
- Adding or Deleting Rows and Columns
- Formatting a Table
- Improving the Layout with Hyphenation
- Laying Out the Page
- Creating Special Page Setups
- Creating Headers and Footers
- Changing Page Orientation Within a Document
- Flowing Text into Columns
- Creating Sections
- Wrapping Text Around a Graphic
- Sorting Your Information
- Reorganizing a Document
-
6. Working with Special Content in Word
- Numbering Headings and Lines
- Inserting a Cover Page
- Inserting Information with Additional Actions
- Inserting an Equation
- Adding a Sidebar or a Pull Quote
- Inserting a Watermark
- Creating Footnotes and Endnotes
- Inserting a Citation
- Creating a Table of Contents
- Printing an Envelope
- Printing a Mailing Label
- Mail Merge: The Power and the Pain
- Creating a Form Letter
- Finalizing Your Document
-
7. Working in Excel
- What’s Where in Excel?
- Excel 2010 Basics
- Using a Predefined Workbook
- Choosing a Theme for Your Worksheet
- Entering the Data
- Editing the Data
- Formatting Cells
- Formatting Numbers
- Moving, Copying, and Pasting Data
- Adding and Deleting Columns and Rows
- Hiding Columns and Rows
- Creating a Data Series
- Formatting Cell Dimensions
- Organizing Your Worksheets
- Preparing for Printing
- Printing a Worksheet
- Adding and Viewing Comments
- Working with the Excel Web App
-
8. Analyzing and Presenting Data in Excel
- Applying Conditional Formatting to Cells
- Customizing Conditional Formatting
- Cell References, Formulas, and Functions
- Adding Sparklines
- Introducing Formulas
- Doing the Math
- Summing the Data
- Making Calculations with Functions
- Creating a Series of Calculations
- Troubleshooting Formulas
- Creating a Table
- Sorting the Data
- Filtering the Data
- Separating Data into Columns
- Creating Subtotals
- Summarizing the Data with a PivotTable
- Adding Slicers
- Reviewing the Data
- The Anatomy of a Chart
- Charting Your Data
- Formatting a Chart
- Customizing a Chart
-
9. Creating a PowerPoint Presentation
- What’s Where in PowerPoint?
- Creating a Presentation
- Set the Page Background
- Entering Content
- Formatting a Slide
- Editing a Presentation
- Adding Headers and Footers
- Reusing Slides
- Modifying the Default Layout
- Inserting a Table
- Turning Text into SmartArt
- Applying WordArt Styles to Text
- Animating Items on a Slide
- Customizing Your Animation
- Adding an Action to a Slide
- Adding and Editing Video
- Adding Sound to Your Slides
- Setting Slide Transitions
- Creating a Photo Album
-
10. Presenting a PowerPoint Slide Show
- Exploring Your Presentation Options
- Recording a Narration
- Timing a Presentation
- Adding Speaker Notes
- Customizing the Presentation
- Reviewing a Presentation
- Creating Different Versions of a Slide Show
- Printing Handouts
- Running a Slide Show
- Sharing a Presentation
- Publishing Your Slides
- Packaging Your Presentation
- Creating Pictures of Your Slides
- Saving Your Presentation as a Video
- Broadcasting Your Presentation
- Changing Slide-Show Settings
-
11. Working with Messages in Outlook
- What’s Where in Outlook Messages?
- Sending E-mail
- Receiving and Reading E-mail
- Replying to and Forwarding a Message
- Staying in Touch with Outlook Social Connector
- Sending or Receiving a File
- Formatting E-mail Messages
- Managing Messages with Quick Steps
- Signing Your E-mail
- Reading RSS Items
- Setting Up E-mail Accounts
- 12. Organizing with Outlook
-
13. Creating a Publication in Publisher
- Exploring the New Look of Publisher 2010
- Starting with a Template
- Creating a Publication from Scratch
- Adding Text
- Flowing Text Among Text Boxes
- Tweaking Your Text
- Inserting and Modifying a Picture
- Adding a Table
- Repeating Objects on Every Page
- Adding Building Blocks
- Arranging Objects on the Page
- Stacking and Grouping Objects
- Flowing Text Around an Object
- Reusing Content
- Inserting Your Contact Information
- Checking Your Publication
- Sending a Publication as E-mail
- Printing Your Publication
-
14. Organize and Share Information in OneNote 2010
- What’s Where in OneNote?
- OneNote Basics: Gathering Your Thoughts
- Creating a OneNote Notebook
- Adding and Working with Sections
- Inserting and Working with Notes Pages
- Inking in OneNote
- Adding Audio Notes
- Grabbing Web Clippings
- Sharing Notes in Word and PowerPoint
- Saving Outlook Data to OneNote
- Working with Side Notes and Unfiled Notes
-
15. Working in Access
- What’s Where in Access?
- Databases: A Simple Approach
- Creating a Database from a Template
- Using an Existing Database
- Adding a Data Table
- Adding and Changing Fields and Records
- Adding Data to a Table
- Importing Data
- Exporting Data
- Defining Table Relationships
- Creating a Form
- Creating a Report from the Data
- Formatting Reports
- Querying Information from Your Data Tables
- Analyzing Data with a PivotChart
-
16. Customizing and Securing Office
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Customizing the Work Area
- Customizing Your Editing
- Changing Your User Information
- Customizing the Spelling and Grammar Checkers
- Customizing Your Spelling Dictionaries
- Changing the Location and Type of Saved Files
- Understanding Security in Office 2010
- Changing File Validation
- Choosing What’s Displayed in Protected View
- Password Protecting a File
- Limiting File Changes
- Recovering Unsaved Versions of a File
- Setting AutoRecover Options
- Signing a Document or Workbook with a Digital Signature
- Setting Macros, Add-Ins, and ActiveX Controls
- Checking File Compatibility
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® Office 2010 Plain & Simple
- Author(s):
- Release date: June 2010
- Publisher(s): Microsoft Press
- ISBN: 9780735647404
You might also like
book
David Busch's Nikon D7500 Guide to Digital SLR Photography
David Busch's Nikon D7500 Guide to Digital Photography is your all-in-one comprehensive resource and reference for …
audiobook
Transformed
Help transform your business and innovate like the world's top tech companies! Transformed: Moving to the …
audiobook
What's New in AI: Open Source Large Language Models with Eric Xing (Audio)
Join host George Anadiotis and guest Eric Xing, for a discussion about the current and expanding …
book
Microsoft OneNote Step by Step
This is the eBook of the printed book and may not include any media, website access …