Excel 2010

Excel Basics

• 1

  Getting Started with Excel arrow_forward_ios ✓ Learn your way around the Excel 2010 environment.
• 2

  Cell Basics arrow_forward_ios ✓ 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 arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel.
• 4

  Formatting Cells arrow_forward_ios ✓ Learn all about formatting text in Excel.
• 5

  Saving arrow_forward_ios ✓ 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 arrow_forward_ios ✓ Learn how to create a simple formula in Excel.
• 7

  Worksheet Basics arrow_forward_ios ✓ Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets and freeze rows and columns.
• 8

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

Common Tasks in Excel

• 9

  Creating Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
• 10

  Working with Basic Functions arrow_forward_ios ✓ Learn how to use functions to find values for a range of cells.
• 11

  Sorting Data arrow_forward_ios ✓ Learn how to sort data to better view and organize the data in your spreadsheet.
• 12

  Outlining Data arrow_forward_ios ✓ Learn how to outline your worksheet to summarize and control how your data is displayed.
• 13

  Filtering Data arrow_forward_ios ✓ Learn how to filter the data in your worksheet to display only the information you need.
• 14

  Formatting Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel.

Doing More with Excel

• 15

  Reviewing and Sharing Workbooks arrow_forward_ios ✓ Learn how to track changes, add comments, compare two versions of a worksheet, and share a worksheet.
• 16

  Using Templates arrow_forward_ios ✓ Learn how to create a new workbook using an Excel template.
• 17

  Working with Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to communicate information.
• 18

  Working with Sparklines arrow_forward_ios ✓ Learn how to insert sparklines and change their type and appearance.
• 19

  Using Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel.
• 20

  Creating PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis.
• 21

  Using What-If Analysis arrow_forward_ios ✓ Learn how to use what-if analysis to answer different types of questions.

Extras

• 22

  Merging Copies of a Shared Workbook arrow_forward_ios ✓ Learn how to merge copies of a shared workbook in Excel.
• 23

  What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel.
• 24

  4 Free Alternatives to Microsoft Office arrow_forward_ios ✓ Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice.
• 25

  More Resources arrow_forward_ios ✓ Use these free resources to better work with and manipulate data in Excel.

Quiz

• 26

  Excel Quiz arrow_forward_ios ✓ Test your knowledge of Excel by taking our quiz.