Excel 2010 New Features - Half Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Identify the elements of the Microsoft Office Excel 2010 environment
  • Organize data in Excel worksheets
  • Analyze Excel data by sorting, filtering, and conditionally formatting it
  • Present Excel data using charts, illustrations and PivotTables
  • Use Office Web Apps

Course Content

Lesson 1: Identifying the Elements of the Excel 2010 Environment

  1. Identify the User Interface Elements
  2. Identify the Ribbon Components
  3. Use Contextual Tabs
  4. Use Excel Galleries
  5. Customize the Excel Interface

Lesson 2: Organizing Data

  1. Identify the Enhancements to Excel 2010 Spreadsheets
  2. Insert Tables
  3. Format Tables

Lesson 3: Analyzing Data

  1. Apply Conditional Formatting
  2. Sort Data in a Spreadsheet
  3. Filter Data in a Spreadsheet
  4. Apply a Formula

Lesson 4: Presenting Data

  1. Create Charts
  2. Format Charts
  3. Work with Illustrations
  4. Create PivotTables and PivotCharts
  5. Share Excel Charts
  6. Save Data in Compatible Formats

Lesson 5: Using Office Web Apps

  1. Save Excel Spreadsheets to the Web
  2. Access and Work with Spreadsheets on the Web

Appendix A: New Features in Microsoft Office Excel 2010

Appendix B: Enhanced File and Compatibility Features in Microsoft Office Excel 2010

Appendix C: Link Formatting in Tablet PCs

Appendix D: Mobile Features

If you would like to customize this training class, please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!