Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel 101- How to Use Excel Spreadsheets

Here you will find step by step tutorials for beginners on how to use the basic features and options of Microsoft Excel. Tutorials include how to create and use formulas for calculations, entering data, formatting worksheets, printing, and creating charts and graphs.
1. Excel Ecourse (18)

How to Use Excel - Free Email Course
How to Use Excel is a free ten part email course intended for those just getting started with this powerful spreadsheet program.

Excel Math
These articles cover how to carry out basic math operations Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these articles will show you how.

Excel Formulas - Free Email Course
Excel Formulas is a free email course intended for those just getting started with using formulas and functions in Excel.

Parts of the Excel Screen
This labeled picture shows the main parts of the Microsoft Excel screen. Descriptions of each of the screen parts is included.

Beginner's Guide to Excel
A Twelve Part Series of Free Excel Tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, use Excel headers and footers and to freeze panes so that you can always see column and row headings.

Basic Excel Tutorial - Working with Data, Formulas, and Functions
This tutorial covers creating a basic spreadsheet in Excel. The topics covered include how to enter data, add rows and creating and using formulas and functions.

Beginners Guide to Excel 2003
This Ten Part Series of Free Excel Tutorials is intended for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, widen columns, and how to add and remove columns and rows.

Learn Excel
This series of tutorials will help you learn the small things in Excel that are often overlooked in other tutorials. Learn how to how to add a new worksheet, how to wrap text in a cell, learn how to quickly undo mistakes you just made. Each tutorial in Learn Excel includes a step by step example.

What is Excel?
Microsoft Excel is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.

Add and Remove Columns and Rows in Excel
It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.

Here is a quick list of 10 of the most common Spreadsheet terms. A handy tool for those new to using a spreadsheet program like Excel or Microsoft Works.

This tutorial covers creating a basic spreadsheet in Excel 2003. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Free Microsoft Excel Tutorial Series
Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.

What is a spreadsheet program? This article explains what an electronic spreadsheet is, when you might use one, and some of the features common to all spreadsheet programs

Parts of the Excel 2003 Screen
This labeled picture shows the main parts of a Excel spreadsheet work area. Components include the active cell, name box, column letter, row number, formula bar and sheet tabs.

Print Gridlines and Headings in Excel
This article shows you how to print gridlines and headings in Excel 2007. A step by step example is included showing you how to print gridlines and headings in Excel.

#REF! - Invalid Cell Reference Errors
Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. This article discusses the causes and cures for this common error.

This series of Excel Tutorials will teach you the fundamentals of using formulas and functions to perform basic calculations in Excel spreadsheets.

How to Use Excel's Format Painter
To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. The format painter icon is on the formatting toolbar. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.

Using Excel's AutoFormat Option
Formatting a spreadsheet effectively can make the most important information on the spreadsheet stand out from the rest of the data. To accomplish this you can use one of the 17 AutoFormat styles available in Excel to give your spreadsheets a professional look that makes them easy to read.

Add and Remove Columns and Rows in Excel
Its a rare occasion when a spreadsheet doesnt need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.

Entering Data in Excel
Learn how to enter data into an Excel spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.

Excel 2007 Spreadsheet Print Options - Part 1
This tutorial on spreadsheet print options covers how to use the print options in Excel to set a print area, print an entire spreadsheet, or print just selected areas.

Excel Error Message Help
If you get an error message in Excel you might not get much help from the program in finding out the cause. The articles listed here cover the cause and cures for a number of common error messages in Excel, such as #REF!, #NULL!, and #####.

Excel 2007 Spreadsheet Print Options - Part 2
This tutorial on spreadsheet print options covers how to use the print options in Excel to set a print area, print an entire spreadsheet, or...