Excel icon

Excel 2010

  • Buy with Office
  • Download a trial
Microsoft Excel
Show Lesson 1 Collapse Lesson 1

Lesson 1 Moving from lists to tables

Take the first step in growing your Excel skills. Move from creating worksheets and entering data to working with basic formulas and creating tables.

Left Arrow

  • Step 1: Create a Workbook

    Create a Workbook

  • Step 2: Customize a Worksheet

    Customize a Worksheet

  • Step 3: Enter and Edit Data

    Enter and Edit Data

  • Step 4: Format Data

    Format Data

  • Step 5: Apply Math & Formulas

    Apply Math & Formulas

  • Step 6: Sort and Filter Data

    Sort and Filter Data

  • Step 7: Create and Use Tables

    Create and Use Tables
Right Arrow
Learning Progress: Steps completed
Show Lesson 2 Collapse Lesson 2

Lesson 2 Visual Analysis - from numbers to pictures

Learn the basics of conditional formatting, creating sparklines, and applying data validation to your data.

Left Arrow

  • Step 1: Apply conditional formatting

    Apply conditional formatting

  • Step 2: Use sparklines

    Use sparklines

  • Step 3: Create a chart

    Create a chart

  • Step 4: Use shapes/diagrams

    Use shapes/diagrams

  • Step 5: Apply data validation

    Apply data validation
Right Arrow
Learning Progress: Steps completed
Show Lesson 3 Collapse Lesson 3

Lesson 3 Collaboration and sharing

Find out how to co-author content, print readable worksheets, and collaborate with others using the Web and Excel Web Apps.

Left Arrow

  • Step 1: Print worksheets

    Print worksheets

  • Step 2: Saving and opening a worksheet to the Web

    Saving and opening a worksheet to the Web

  • Step 3: Co-authoring

    Co-authoring

  • Step 4: Excel Web apps

    Excel Web apps
Right Arrow
Learning Progress: Steps completed
Show Lesson 4 Collapse Lesson 4

Lesson 4 Automation, macros, and reporting

Learn how to use PivotTables, slicers, and macros to improve your data analysis.

Left Arrow

  • Step 1: Intro to functions

    Intro to functions

  • Step 2: Using macros

    Using macros

  • Step 3: Create PivotTables

    Create PivotTables

  • Step 4: Using slicers

    Using slicers

  • Step 5: Using PowerPivot

    Using PowerPivot

  • Step 6: What-if anaylsis/Solver

    What-if anaylsis/Solver
Right Arrow
Learning Progress: Steps completed
close Close

Excel 2010: Excel skills builder Create a Workbook

close Close

Excel 2010: Excel skills builder Format Data

close Close

Excel 2010: Excel skills builder Apply Basic Math and Formulas

close Close

Excel 2010: Excel skills builder Create and Use Tables

close Close

Excel 2010: Excel skills builder
Use shapes/diagrams

close Close

Excel 2010: Excel skills builder Apply data validation

close Close

Excel 2010: Excel skills builder Saving and opening a worksheet to the Web

close Close

Excel 2010: Excel skills builder Using slicers

close Close

Excel 2010: Excel skills builder Using macros

close Close

Excel 2010: Excel skills builder What-if anaylsis/Solver