• Share

# Articles Index

### How to Use Excel - Excel Tutorials for Beginners

How to Use Excel is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts, and how to use Excel's format options including autoformat.

### Excel Formulas Tutorials

These tutorials work for all versions of Excel. Spreadsheet formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. These tutorials walk you through creating formulas in Excel.

### Hide and Unhide Columns and Rows in Excel

This series of tutorials cover how to hide and unhide columns and rows in Excel worksheets.

### Data for Excel Basic Format Tutorial

This document contains the tutorial data for the Excel basic format tutorial. The data is to be copied and pasted into the tutorial worksheet.

### Excel Tips IV - Excel 2007

This list of Excel tips covers a variety of topics in Excel 2007.

### Excel Tips

This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel.

### Excel Database Functions Tutorial Data

This document contains data for the Excel database functions step by step tutorials. Instruction are included to explain how to copy the data into a blank worksheet.

### Excel IF Functions

This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.

### Excel 2003 Lessons

Excel lessons cover how to carry out basic operations in a spreadsheet program such as Excel. The topics deal with how to perform basic math with a spreadsheet - such as addition or subtraction; how to format your spreadsheet; how to create a chart; and how to print a spreadsheet.

### Insert and Delete Columns and Rows in Excel

This series of tutorials cover the basics of how to insert and delete columns and rows in Excel worksheets. It is often necessary to alter the layout of a worksheet due to the addition or removal of data.

### Data for Excel AVERAGE IF Tutorial

This document contains data for the Excel AVERAGE IF step by step tutorial. The AVERAGE IF data is to be copied and pasted into the tutorial worksheet.

### Data for the Excel VLOOKUP Array Formula Tutorial

This document contains the tutorial data for the Excel VLOOKUP Array Formula Tutorial. The data is to be copied and pasted into the tutorial worksheet.

### Free Microsoft Excel Tutorial Series

Each tutorial in this free series covers either an introductory or intermediate level topic in Microsoft Excel. The tutorials include step by step examples related to each topic.

### Excel Math

These tutorial cover how to carry out basic math operations in Excel using formulas. The tutorials cover how to add, subtract, multiply, or divide numbers in Excel using formulas.

### Data for the Excel 2007 / 2010 IF Function Step by Step Tutorial

This document contains the tutorial data for the Excel 2007 IF Function Step by Step Tutorial. The data is to be copied and pasted into the tutorial worksheet.

### How to Use Excel 2003 - Excel Tutorials for Beginners

How to Use Excel 2003 is a series of free Excel tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, how to use Excel formulas and functions, adding and removing columns and rows, how to create charts with the Excel Chart Wizard, and how to use Excel's format options.

### Data for the Excel Nested IF Function Step by Step Tutorial

This document contains the tutorial data for the Excel 2007 Nested IF Function Step by Step Tutorial. The data is to be copied and pasted into the tutorial worksheet.

### Data for the Excel IF Function Format Tutorial

This document contains the tutorial data for the Excel 2007 IF Function Formatting Tutorial. The data is to be copied and pasted into the tutorial worksheet.

### Basic Calculations in Excel Spreadsheets

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

### Beginners Guide to Microsoft Works Spreadsheets

Beginners Guide to Microsoft Works Spreadsheets is a series of articles and tutorials for the absolute beginner. Learn about the parts of the Microsoft Works Spreadsheets screen, how to enter data, how to use formulas and functions, adding and removing columns and rows, how to create charts, and how to use the program's format options.

### Data for Excel 2007 SubTotal Tutorials

This document contains subtotal data for the Excel 2007 subtotal tutorials. The subtotal data is to be copied and pasted into the tutorial worksheet.

### Data for Excel 2007 Pivot Table Tutorial

This document contains pivot table data for the Excel 2007 pivot table tutorial. The pivot table data is to be copied and pasted into the tutorial worksheet.

### Excel Tips III - Formulas

This list of Excel tips on formulas will give you straightforward answers on how to carry out a variety of tasks related to formulas in Microsoft Excel.

### Excel Tips II - Functions

This list of Excel tips will give you straightforward answers on how to carry out a variety of tasks in Microsoft Excel. Examples are included to make understanding the steps involved even easier to follow. The list keeps growing so check back often to see what new Excel tips have been added.

### Excel Functions

This series of tutorials and articles will teach you the basics of using Excel functions to perform a variety of tasks in Excel spreadsheets.