Excel 2010
In this free Excel 2010 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
search
menu
Excel Basics
-
1
Getting Started with Excel arrow_forward_ios ✓
Learn your way around the Excel 2010 environment.
-
2
-
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
-
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
-
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.