Excel 2010

Excel Basics

• 1

  Getting Started with Excel

  

  • Introduction

  • Getting to know Excel 2010

  • Working with your Excel environment

  • The Quick Access Toolbar

  • Backstage view

  • Creating and opening workbooks

  • Compatibility mode

  • Challenge!

  

  • Navigating Excel 2010

    Take a quick tour of an Excel 2010 workbook.

    03:3181,818 views

  • Exploring Your Excel 2010 Environment

    Get to know the Excel 2010 environment.

    03:4328,679 views

  • Creating Workbooks in Excel 2010

    Find out how to create new workbooks (and open existing ones) in Excel 2010.

    02:0425,270 views
• 2

  Cell Basics

  

  • Introduction

  • Introduction to cells and cell content

  • Cell content

  • Challenge!

  

  • Cell Basics in Excel 2010

    A closer look at cells and cell content in Excel 2010.

    04:2139,218 views
• 3

  Modifying Columns, Rows, and Cells

  

  • Introduction

  • Working with columns, rows, and cells

  • Wrapping text and merging cells

  • Challenge!

  

  • Modifying Cells, Rows & Columns in Excel 2010

    How to modify columns, rows, and cells in Excel, including wrapping text and merging.

    03:5058,544 views
• 4

  Formatting Cells

  

  • Introduction

  • Formatting text

  • Formatting numbers and dates

  • Challenge!

  

  • Formatting Cells in Excel 2010

    Learn to format cells in your Excel workbook to make it more appealing and easier to read.

    03:5156,420 views
• 5

  Saving

  

  • Introduction

  • Saving workbooks

  • Challenge!

  

  • Saving Workbooks in Excel 2010

    Simple ways to save a workbook and make it compatible with previous versions of Excel.

    03:2217,036 views
• 6

  Creating Simple Formulas

  

  • Introduction

  • Simple formulas

  • Creating formulas with cell references

  • Challenge!

  

  • Simple Formulas in Excel 2010

    Discover how to write simple formulas in Excel 2010.

    03:47288,616 views
• 7

  Worksheet Basics

  

  • Introduction

  • Introduction to worksheets

  • Grouping and ungrouping worksheets

  • Freezing worksheet panes

  • Challenge!

  

  • Introduction to Excel 2010 Worksheets

    An overview of Excel worksheets.

    03:2522,917 views

  • Freezing Worksheet Panes in Excel 2010

    Find out how to freeze worksheet panes to make your data easier to read.

    02:15124,069 views

  • Grouping Worksheets in Excel 2010

    Simple ways to edit multiple worksheets using the Group feature.

    02:0157,919 views
• 8

  Printing

  

  • Introduction

  • Printing

  • Challenge!

  

  • Printing in Excel 2010

    Easy ways to print your Excel 2010 workbooks.

    05:1846,021 views

Common Tasks in Excel

• 9

  Creating Complex Formulas

  

  • Creating complex formulas

  • Complex formulas

  • Working with cell references

  • Absolute references

  • Challenge!

  

  • Creating Complex Formulas with Excel 2010

    Creating Complex Formulas with Excel 2010

    05:2128,789 views

  • Working with Cell References

    Learn about absolute and relative cell references.

    05:0329,677 views
• 10

  Working with Basic Functions

  

  • Working with basic functions

  • Basic functions

  • Function Library

  • The Insert Function command

  • Challenge!

  

  • Working with Basic Functions

    Learn about AutoSum and the Function library.

    05:3740,361 views
• 11

  Sorting Data

  

  • Introduction

  • Basic sorting

  • Custom sorting

  • Sorting multiple levels

  • Challenge!

  

  • Sorting Data in Excel 2010

    Organize your data by sorting it alphabetically or numerically.

    04:0944,973 views
• 12

  Outlining Data

  

  • Introduction

  • Outlining data

  • Showing or hiding data

  • Removing groups and subtotaling

  • Creating your own groups

  • Challenge!

  

  • Outlining Data in Excel 2010

    Learn how to create subtotals and group rows or columns.

    04:4327,751 views
• 13

  Filtering Data

  

  • Introduction

  • Filtering data

  • Advanced filtering

  • Challenge!

  

  • Filtering Data in Excel 2010

    Narrow down your data by adding one or more filters.

    04:3464,699 views
• 14

  Formatting Tables

  

  • Introduction

  • Formatting Tables

  • Modifying tables

  • Challenge!

  

  • Formatting Tables in Excel 2010

    Use Table Styles to automatically format your data.

    03:0236,634 views

Doing More with Excel

• 15

  Reviewing and Sharing Workbooks

  

  • Introduction

  • Tracking changes

  • Adding and deleting comments

  • Accepting or rejecting changes

  • Adjusting how changes are viewed

  • Finalizing and protecting your workbook

  • Protecting your workbook

  • Challenge!

  

  • Reviewing Workbooks in Excel 2010

    Collaborate more easily by using track changes and comments.

    05:399,449 views

  • Finalizing Workbooks in Excel 2010

    Learn how to check spelling, inspect your document, and mark it as final.

    04:206,238 views
• 16

  Using Templates

  

  • Introduction

  • Using templates

  • Challenge!

  

  • Using Templates in Excel 2010

    Create new documents using templates to save time.

    02:2412,766 views
• 17

  Working with Charts

  

  • Introduction

  • Charts

  • Chart tools

  • Challenge!

  

  • Working with Charts in Excel 2010

    Visualize your data using Excel's wide selection of charts.

    04:5548,339 views
• 18

  Working with Sparklines

  

  • Introduction

  • Creating sparklines

  • Changing the appearance of your sparklines

  • Changing the display range

  • Challenge!

  

  • Creating Sparklines in Excel 2010

    Learn how to create miniature charts inside cells.

    05:1359,363 views
• 19

  Using Conditional Formatting

  

  • Introduction

  • Conditional formatting

  • Conditional formatting presets

  • Challenge!

  

  • Conditional Formatting in Excel 2010

    Create rules for cells that will add formatting depending on each cell's value.

    03:41229,306 views
• 20

  Creating PivotTables

  

  • Introduction

  • PivotTables

  • Pivoting data

  • Report filters

  • PivotCharts

  • Challenge!

  

  • Creating PivotTables: Part 1

    Learn the basics of creating and manipulating PivotTables.

    04:40147,998 views

  • Creating PivotTables: Part 2

    Make your PivotTables even more powerful by adding filters, slicers and PivotCharts

    03:2162,814 views
• 21

  Using What-If Analysis

  

  • Introduction

  • What-if analysis

  • Other types of what-if analysis

  • Challenge!

  

  • Using What-If Analysis in Excel 2010

    Use What-If Analysis to answer questions by working backward.

    04:3295,500 views

Extras

• Merging Copies of a Shared Workbook

• What are Reference Styles?

• More Resources

• Quiz

Learn More

• Excel Formulas

• Excel 2013

• OneDrive and Office Online

• Google Sheets