How To Take This Class

Course Overview

In this Microsoft Excel 2010 Intermediate Training course, students will learn how to manage multiple worksheets and workbooks, apply special formals, define and apply cell and range names, sort and filter data, share worksheets as web pages and email attachments, use trendlines and sparklines, track changes in a workbook and use PivotTables to analyze large amounts of data.

Course Prerequisites

Students should have completed, or have experience with, topics covered in the Microsoft Excel 2010 Introduction Training course.

Course Audience

This course is designed for students who have some experience with Microsoft Excel and are ready to explore more advanced features.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace.
  • Apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark.
  • Create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings.
  • Define and apply cell and range names; use names in formulas; and define and apply 3-D names.
  • Sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and use structured references.
  • Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment.
  • Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images.
  • Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final.
  • Change Excel’s default application settings and customize the Ribbon; work with Excel templates; and create and manage templates.
  • Create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotChart to graphically display data from a PivotTable.

Course Duration

1 Day

Course Outline

  1. Using multiple worksheets and workbooks
    • Using multiple workbooks
    • Linking worksheets with 3-D formulas
    • Linking workbooks
    • Managing workbooks
  2. Advanced formatting
    • Using special number formats
    • Using functions to format text
    • Working with styles
    • Working with themes
    • Other advanced formatting
  3. Outlining and subtotals
    • Outlining and consolidating data
    • Creating subtotals
  4. Cell and range names
    • Creating and using names
    • Managing names
  5. Tables
    • Sorting and filtering data
    • Advanced filtering
    • Working with tables
  6. Web and sharing features
    • Saving workbooks as Web pages
    • Using hyperlinks
    • Sharing workbooks
  7. Advanced charting
    • Chart formatting options
    • Combination charts
    • Graphical elements
  8. Documenting and auditing
    • Auditing features
    • Comments in cells and workbooks
    • Protection
    • Workgroup collaboration
  9. Templates and settings
    • Changing application settings
    • Using built-in templates
    • Creating and managing templates
  10. PivotTables and PivotCharts
    • Working with PivotTables
    • Rearranging PivotTables
    • Formatting PivotTables
    • Using PivotCharts

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2010 Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2010 Training course
  • Six months of post-class live, online chat support from a Microsoft Excel Instructor