From Ted French,
Your Guide to Spreadsheets.
FREE Newsletter. Sign Up Now!

How to Use Excel is a Series of Excel Tutorials designed with the absolute beginner in mind. These tutorials will show you how to use Excel to produce a complete spreadsheet. The tutorials cover:

• the parts of the Excel screen
• entering data into Excel
• Excel Math
• Excel formulas step by step tutorial
• SUM and AutoSUM step by step tutorial
• how to use Excel's DATE functions
• Excel's formatting features
• add and delete columns and rows
• how to use the Excel Chart Wizard
• Excel printing
• how to widen columns in Excel

Parts of the Excel Screen

This article identifies the main parts of the Excel spreadsheet work area. There are links from each label to glossary items describing each part in greater detail.

Entering Data in Excel

This article covers the basics of how to enter data into an Excel spreadsheet. Items such as the importance of planning your spreadsheet before you enter data, widening columns, the types of data that can be entered, and editing cells to change data, are covered in this tutorial.

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 Step by Step Tutorial

Formulas are a very important and a frequently used feature in Excel. This article uses a step by step example to show you how to create and use formulas in Excel.

SUM and AutoSUM Step by Step Tutorial

This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations.

How to Use the Excel's Date Function

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most commonly used date functions used in Excel.

How to Use Excel Formatting Features

There are a variety of formatting options available in Excel - conditional formatting, number formatting, text and general spreadsheet formatting techniques. This two part tutorial covers the basics of number formatting – adding commas, currency symbols, percent signs, and decimal spaces to cells in the worksheet, as well as changing cell colors, adding text formatting, and changing the alignment of text in cells.

Add / Delete Columns and Rows

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.

How to Use the Excel Chart Wizard

A graph, or a chart as it is known in Microsoft Excel, is a visual representation of worksheet data. A chart often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see. The quickest and easiest way to create a chart in Excel is to use the Chart Wizard. This step by step tutorial leads you through the four steps of using the Chart Wizard.

Excel Printing

Use the print options in Excel to print entire spreadsheets or just selected areas. The printing options can be accessed through a number of locations including the print button on the standard toolbar and several options under the File menu.

How to Widen Columns in Excel

Widening columns in Excel is one of the most commonly performed operations. This article will show you how to carry out this task easily.