twitter facebook

Excel 2010 Digital Classroom Book

Microsoft Excel 2010
Microsoft Excel 2010 Digital Classroom is like having a personal instructor guiding you through each lesson, while you work at your own pace. This Excel 2010 book includes 8 self-paced lessons helping you learn essential skills and explore new features and capabilities of Microsoft Excel 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 Excel video tutorial
  • Covers all essential Excel 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 Excel 2010 class textbook.

Starting Up

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

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

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

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

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

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

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

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

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\
Other Books from the Digital Classroom Series
  • Photoshop CS5 book
  • Dreamweaver CS5 book
  • Creative Suite 5 book
  • Flash Professional CS5
  • InDesign CS5 book