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.
This tutorial identifies the main parts of the Excel
work area. There are links from each label to glossary
items describing each part in greater detail.
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.
This tutorial covers the basics of how to enter
into an Excel spreadsheet. Items such as the importance of planning your spreadsheet before you enter data, widening
, the types of data that can be entered, and editing cells to change data, are covered in this 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.
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 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 graph, or a
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.
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.
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.
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.
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.
Widening columns in Excel is one of the most commonly performed operations. This article will show you how to carry out this task easily.