Office 2010 Digital Classroom Book

Office 2010 book
Microsoft Office 2010 Digital Classroom is like having a personal instructor guiding you through each lesson, while you work at your own pace. This Office 2010 book includes 27 self-paced lessons helping you learn essential skills and explore new features and capabilities of Microsoft Office 2010.
  • Full color lessons with easy to follow step-by-step instructions | view sample lesson
  • Video tutorials highlight key topics in each lesson | view sample Office video tutorial
  • Covers all essential Office skills | view Table of Contents
  • Gets you up-and-running quickly with included lesson files
  • Written by expert instructors – it's like having your own personal tutor
  • Used by hundreds of schools and more than 100,000 readers

Are you an Instructor or Professor?

Contact your Wiley higher education representative to obtain a review copy or use the contact form to obtain an instructor's guide for using the Digital Classroom as your Office 2010 class textbook.

Starting Up

  • About Microsoft Office 2010 Digital Classroom
  • Prerequisites
  • System requirements
  • Fonts used in this book
  • Loading lesson files
  • Video tutorials
  • Additional resources

Word Lesson 1: Microsoft Word 2010 Jumpstart

  • Starting up
  • Creating a new document
  • Customizing the Quick Access Toolbar
  • Applying Styles
  • Applying a theme
  • Adding and positioning a graphic
  • Changing background color and margins
  • Deleting a blank page
  • Inserting additional pages
  • Inserting a blank page
  • Adding page numbers
  • Protecting the document
  • Self study
  • Review

Word Lesson 2: Getting Started with Microsoft Word 2010

  • Starting up
  • Understanding Microsoft Word
  • Creating a new document from template
  • Customizing the workspace
  • Formatting using the Ribbon
  • Using the View options
  • Getting help
  • Converting Word documents from prior versions to Word 2010
  • Self study
  • Review

Word Lesson 3: Editing the Document

  • Starting up
  • Opening and editing an existing document
  • Working with text
  • Viewing documents
  • Selecting text
  • Copying and pasting
  • Paste options
  • Clipboard options
  • Working with fonts
  • Reducing font size
  • Changing the case
  • Emphasizing text
  • Character Formatting tools
  • Protecting a document from editing
  • Protect Document options
  • Self study
  • Review

Word Lesson 4: Formatting Paragraphs

  • Starting up
  • Working with paragraghs
  • Applying paragraph alignment
  • Changing line spacings
  • Creating lists
  • Displaying formatting marks and rulers
  • Displaying formatting marks
  • Display rulers
  • Indenting paragraphs
  • Setting tabs
  • Adding paragraph borders
  • Self study
  • Review

Word Lesson 5: Working with Pages

  • Starting up
  • Introducing the page tools
  • Setting the page size
  • Choosing a layout
  • Setting margins
  • Working with columns
  • Inserting column breaks
  • Adding a page boarder
  • Adding headers and footers
  • Adding a background color
  • Adding a watermark
  • Adding pages and page numbers
  • Inserting a section break
  • Controlling text flow
  • Self study
  • Review

Word Lesson 6: Working with Styles and Themes

  • Starting up
  • Understanding styles
  • Introducing the styles tool
  • Applying a style
  • Understanding heading styles
  • Switching between style sets
  • Identifying the current style
  • Removing a style
  • Creating a new style
  • Deleting a style
  • Modifying a style
  • Assigning a style shortcut key
  • Customizing the Quick Styles Gallery
  • Applying a document theme
  • Customizing a theme
  • Self study
  • Review

Word Lesson 7: Working with Tables

  • Starting up
  • Introducing the table tools
  • Creating a table
  • Moving around in a table
  • Formatting a table and adding text
  • Selecting cells within a table
  • Showing and hiding gridlines
  • Changing the row height or column width
  • Resizing a table
  • Moving a table
  • Adding and deleting rows
  • Adding and deleting columns
  • Enlarging a table
  • Combining and splitting cells
  • Splitting a table
  • Aligning text in cells
  • Adding shading to cells
  • Formatting a table
  • Adding a formula to a table
  • Self study
  • Review

Word Lesson 8: Working with Graphics

  • Starting up
  • Introducing the graphics tools
  • Adding WordArt
  • Adding a picture
  • Cropping a picture
  • Cropping with a special shape
  • Adding a screenshot
  • Adding a caption
  • Inserting a clip art image
  • Adding a shape
  • Inserting a clip art image
  • Adding a shape
  • Wrapping text around an image
  • Adding a picture effect to a graphic
  • Working with diagrams
  • Self study
  • Review

Excel Lesson 1: Microsoft Excel 2010 Jumpstart

  • Starting up
  • Inserting rows and columns into a worksheet
  • Merging and formatting cells
  • Adjusting cell width and increasing font size
  • Copying and pasting to a range of cells
  • Adding a column of numbers
  • Adding a fill
  • Self study
  • Review

Excel Lesson 2: Getting Started with Microsoft Excel 2010

  • Starting up
  • What is Excel?
  • How can you use Excel?
  • Exploring the Excel workspace
  • Worksheet basics: a quick tour
  • Exploring worksheets
  • The Excel user interface
  • Customizing the Quick Access Toolbar
  • Removing buttons from the Quick Access Toolbar
  • Using the Zoom and Page view options
  • Naming a worksheet
  • Naming and saving workbooks
  • Changing page setup options
  • Shading cells and changing Font Color
  • Working within a workbook
  • Understanding the worksheet area
  • Convert Excel documents from prior versions to Excel 2010
  • Getting help
  • Self study
  • Review

Excel Lesson 3: Editing cells

  • Starting up
  • Generating a new workbook from an existing one
  • Selecting cells
  • Deleting data or cells
  • Using the Clear command
  • Entering data
  • Copying and pasting within Excel
  • Copying from Word and pasting into Excel
  • Formatting cells for numbers
  • Self study
  • Review

Excel Lesson 4: Formatting Cell Ranges

  • Starting up
  • Working with fonts
  • Aligning cell data
  • Formatting text
  • Using the format painter
  • Adding borders and shading
  • Adding columns and rows
  • Resizing colums and rows
  • Assigning Number Formats
  • Finding the sum of a column
  • Self study
  • Review

Excel Lesson 5: Building Formulas and Functions

  • Starting up
  • Understanding Excel formulas
  • Operator precedence
  • Bulding a formula
  • Understanding Excel functions
  • Adding a function to a formula
  • Adding a row or column of numbers
  • Building an AutoSum formula
  • Copying a formula
  • Defining and using range names in formulas
  • Self study
  • Review

Excel Lesson 6: Displaying Data with Charts

  • Starting up
  • Exploring chart elements
  • Understanding chart types
  • Creating a chart
  • Adjusting and moving the chart
  • Adding chart titles
  • Adding a horizontal axis title
  • Adding a vertical axis title
  • Positioning a chart legend
  • Displaying gridlines
  • Displaying a data table
  • Changing the chart layout and style
  • Formatting chart elements
  • Customizing a chart background
  • Changing a chart type
  • Editing a chart element
  • Applying a style to a chart element
  • Adding Sparkline graphics to a worksheet
  • Self study
  • Review

Excel Lesson 7: Analyzing Excel Data

  • Starting up
  • Understanding data lists
  • Sorting a range
  • Sorting data on a single field
  • Sorting data on multiple fields
  • Filtering a range
  • Setting data validation rules
  • Converting a range to a table
  • Creating a data table
  • Summarizing data with subtotals
  • Exporting Excel data to Word
  • Exporting data
  • Exporting data and tools
  • Creativing a PivotTable
  • Creating a PivotChart
  • Self study
  • Review

Excel Lesson 8: Adding Graphic Objects

  • Starting up
  • Manipulating graphics
  • Moving graphic objects to a new layer
  • Aligning graphics
  • Grouping graphics
  • Importing and adjusting graphics
  • Importing clip art
  • Importing picture files
  • Formatting clip art and imported pictures
  • Adjusting images
  • Working with shapes
  • Working with text boxes
  • Addign a text box
  • Resizing and formatting a text box
  • Inserting WordArt
  • Inserting SmartArt graphics
  • Adding a screenshot
  • Adding a theme
  • Self study
  • Review

PowerPoint Lesson 1: Microsoft PowerPoint 2010 Jumpstart

  • Starting up
  • Creating a presentation from an existing file
  • Saving and converting a presentation from prior versions
  • Applying a theme and changing colors
  • Changing the slide layout and aligning text
  • Adding pictures and text to the slide
  • Adding a style to a picture
  • Applying slide transitions
  • Adding effects and animating text
  • Applying animation to pictures and text boxes
  • Self study
  • Review

PowerPoint Lesson 2: Getting Started with Microsoft PowerPoint 2010

  • Starting up
  • Understanding Microsoft PowerPoint
  • Presentation basics
  • Creating a new presentation
  • PowerPoint's user interface
  • Customizing the Quick Access Toolbar
  • Applying a theme
  • Adding a slide and related notes
  • Using the Notes pane
  • Adding a shaped text box
  • Adding a text box
  • Adding a picture
  • Getting help
  • Self study
  • Review

PowerPoint Lesson 3: Working with Tables and Charts

  • Starting up
  • Table basics
  • Creating a table
  • Adding text to a table
  • Selecting table elements
  • Adding rows and columns
  • Aligning text within columns and rows
  • Working with table styles and shading
  • Merging cells
  • Working with charts
  • Choosing the right chart
  • Creating a chart
  • Changing the chart type
  • Self study
  • Review

PowerPoint Lesson 4: Working with Graphic Elements

  • Starting up
  • Using the drawing tools
  • Inserting a graphic as a background
  • Working with shape styles
  • Inserting a picture and applying effects
  • Aligning graphics
  • Ungrouping and regrouping graphic elements
  • Creating a diagram
  • Customizing and saving a theme
  • Self study
  • Review

Access Lesson 1: Microsoft Access 2010 Jumpstart

  • Starting up
  • What is Access?
  • How can you use Access?
  • Database basics
  • Basic database terminology
  • Database design tips
  • Quick tour of Access 2010
  • Access 2010 components
  • Exploring a database
  • Working with records
  • Searching for a record
  • Sorting records
  • Adding and deleting records
  • Customizing the Quick Access Toolbar
  • Getting help
  • Ending an Access session
  • Self study
  • Review

Access Lesson 2: Getting Started with Access 2010

  • Starting up
  • Access 2010 database types
  • Creating a simple database
  • Creating a database using a template
  • Tables, views, and data types
  • Creating a table in Datasheet view
  • Creatomg a table in Design view
  • Adding fields to a table
  • Importing data from a Excel spreadsheet
  • Self study
  • Review

OneNote Lesson 1: Microsoft OneNote 2010 Jumpstart

  • Starting up
  • Discovering OneNote
  • Working with OneNote
  • Exploring the OneNote environment
  • Notebook view
  • Working in the Backstage view
  • Searching OneNote
  • Sharing a Notebook
  • Customizing OneNote
  • Getting help
  • Ending a OneNote session
  • Self study
  • Review

OneNote Lesson 2: Getting Started with OneNote 2010

  • Starting up
  • Managing Notebooks
  • Managing Sections
  • Grouping Sections
  • Saving a Notebook
  • Managing Pages
  • Adding content
  • Direct text entry (typing)
  • Coping and pasting
  • Creating a drawing using a mouse, touchpad, or electronic pen
  • Adding audio and video notes
  • Inserting web content
  • Self study
  • Review

Publisher Lesson 1: Microsoft Publisher 2010 Jumpstart

  • Starting up
  • What is Publisher?
  • How can you use Publisher?
  • Publication basics
  • Quick tour of Publisher 2010
  • Opening a publication
  • Changing your view
  • Saving a publication
  • Customizing the Quick Access Toolbar
  • Closing a Publisher session
  • Self study
  • Review

Publisher Lesson 2: Getting Started with Publisher 2010

  • Starting up
  • Creating a blank publication
  • Working with pages
  • Setting page margins
  • Changing page orientation
  • Changing page sizes
  • Inserting a text box
  • Formatting text
  • Flowing text
  • Inserting and modifying images
  • Printing your publication
  • Using Pack and Go
  • Sending a publication using e-mail
  • E-mail preview
  • Self study
  • Review

Outlook Lesson 1: Microsoft Outlook Essentials

  • Starting up
  • What is Outlook?
  • Setting up Outlook
  • Using more than one email account
  • Composing email, adding recipients, and sending messages
  • Adding attachments to email messages
  • Adding signatures
  • Receiving email
  • Organizing email
  • Using folders
  • Archiving old message
  • Contacts and the Address Book
  • Adding contacts
  • Finding contacts
  • Creating groups
  • Calendar
  • Appointments and meetings
  • Creating appointments and setting-up reminders
  • Setting-up meetings and inviting attendees
  • Using tasks
  • Self study
  • Review
Other Books from the Digital Classroom Series
  • Photoshop CS6 book
  • Dreamweaver CS6 book
  • Creative Suite 6 book
  • Flash Professional CS6
  • InDesign CS6 book