1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Use Excel - Excel Tutorials for Beginners

Beginner's Guide to Excel

By

Excel Spreadsheet Example

Excel Spreadsheet Example

© Hcadelo

Related Tutorial: Beginner's Guide to Excel 2003

How to Use Excel is a Series of Excel Tutorials designed with the absolute beginner in mind. These tutorials include step by step examples and will show you how to use Excel to create a basic spreadsheet.

Parts of the Excel Screen

This tutorial 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.

Excel Math

If you are looking for tutorials on how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how to do it. Each tutorial includes a step by step example on how to create a formula that will carry out one of the four basic math operations in Excel.

Entering Data in Excel

This tutorial 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.

Basic Excel Spreadsheet Tutorial

The tutorial covers the basics of creating a spreadsheet in the latest versions of Excel. Topics covered include entering data, creating simple formulas, and formatting a worksheet.

Working with Data, Formulas, and Functions Step by Step Tutorial

Formulas, and functions are two of the most frequently used features in Excel. This tutorial covers using formulas and functions in more detail than the basic tutorial listed above. The tutorial includes step by step examples to show you how to create and use a variety of formulas and functions in Excel.

Formatting a Worksheet in Excel

Formatting is a big part of completing a worksheet. This tutorial covers applying such formatting features as:
  • shading alternate rows of data
  • adding currency and percent symbols
  • widening columns
  • changing data alignment

A Guide to Creating and Formatting Excel Charts

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.

This list of step by step tutorials covers how to create the most commonly used charts in Excel - column chart (bar graph) pie chart, line graph, and even how to use the Sparklines - which are new to Excel 2010.

Printing in Excel

Use the print options in Excel to print entire spreadsheets or just selected areas. You can also choose to change the worksheet's orientation before you print or adjust the size of your printout so that it fits on one page.

Excel's SUM Function Tutorial

Since adding rows and columns of numbers is one of the most common operations in Excel, Microsoft has included a shortcut to make the job easier. This step by step tutorial walks through how to use Excel's SUM function.

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'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 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.

©2014 About.com. All rights reserved.