Excel Basics

• 1

  Getting Started with Excel ✓

  Learn your way around the Excel 2010 environment.

• 2

  Cell Basics ✓

  Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.

• 3

  Modifying Columns, Rows, and Cells ✓

  Learn how to modify rows, columns, and cells in Excel.

• 4

  Formatting Cells ✓

  Learn all about formatting text in Excel.

• 5

  Saving ✓

  Learn how to use the Save and Save As commands, save as a PDF, and save as an Excel 97-2003 compatible workbook.

• 6

  Creating Simple Formulas ✓

  Learn how to create a simple formula in Excel.

• 7

  Worksheet Basics ✓

  Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets and freeze rows and columns.

• 8

  Printing ✓

  Learn how to preview your spreadsheet, modify margins, change page orientation, and print.

Common Tasks in Excel

• 9

  Creating Complex Formulas ✓

  Learn how to create a complex formula in Excel.

• 10

  Working with Basic Functions ✓

  Learn how to use functions to find values for a range of cells.

• 11

  Sorting Data ✓

  Learn how to sort data to better view and organize the data in your spreadsheet.

• 12

  Outlining Data ✓

  Learn how to outline your worksheet to summarize and control how your data is displayed.

• 13

  Filtering Data ✓

  Learn how to filter the data in your worksheet to display only the information you need.

• 14

  Formatting Tables ✓

  Learn how to use styles to format tables in Excel.

Doing More with Excel

• 15

  Reviewing and Sharing Workbooks ✓

  Learn how to track changes, add comments, compare two versions of a worksheet, and share a worksheet.

• 16

  Using Templates ✓

  Learn how to create a new workbook using an Excel template.

• 17

  Working with Charts ✓

  Learn how to insert and modify Excel charts to communicate information.

• 18

  Working with Sparklines ✓

  Learn how to insert sparklines and change their type and appearance.

• 19

  Using Conditional Formatting ✓

  Learn how to apply, modify, and delete conditional formatting rules in Excel.

• 20

  Creating PivotTables ✓

  Learn how to use PivotTables in Excel for stronger data analysis.

• 21

  Using What-If Analysis ✓

  Learn how to use what-if analysis to answer different types of questions.

Extras

• 22

  Merging Copies of a Shared Workbook ✓

  Learn how to merge copies of a shared workbook in Excel.

• 23

  What are Reference Styles? ✓

  Learn all about using reference styles in Excel.

• 24

  4 Free Alternatives to Microsoft Office ✓

  Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice.

• 25

  More Resources ✓

  Use these free resources to better work with and manipulate data in Excel.

Quiz

• Excel 2010 Quiz ✓

  Test your knowledge of Excel 2010 by taking our quiz.