Excel 2010 Intermediate - 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:

  • Create and modify charts and Sparklines
  • Calculate with advanced formulas
  • Sort and filter data
  • Customize the Excel window

Course Content

Lesson 1: Working with Charts

  1. Creating and Customizing a Chart
  2. Selecting Data for a Pie Chart
  3. Change the Chart Layout and Style
  4. Adding Chart Elements
  5. Moving a Chart to a Different Excel Worksheet
  6. Working with Sparklines

Lesson 2: Calculating with Advanced Formulas

  1. Naming Cells
  2. Sharing Data between Worksheets
  3. Calculating Across Worksheets
  4. Calculating with Date Functions
  5. Calculating with Financial Functions
  6. Calculating with Lookup and Reference Functions
  7. Calculate with Logical Functions

Lesson 3: Working with Tables

  1. Creating a Table
  2. Using a Form to Add Records
  3. Using Conditional Formatting

Lesson 4: Sorting and Filtering Data

  1. Sorting by Columns
  2. Creating an Advanced Sort
  3. Using AutoFilter to Filter by Columns
  4. Creating Advanced Filters
  5. Adding Subtotals to a Worksheet

Lesson 5: Customizing the Excel Window

  1. Splitting a Worksheet
  2. Freezing Panes

If you would like to customize this training class, contact 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!