Articles Index
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.
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 IF Functions
This series of articles and tutorials the basics of using IF functions to perform calculations in Excel.
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.
Hide and Unhide Columns and Rows in Excel
This series of articles cover how to hide and unhide columns and rows in Excel worksheets.
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.
Excel Formulas
These tutorials are for versions of Excel from Excel 97 to Excel 2010. 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.
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.
Data for the Excel 2010 Format Tutorial
This document contains the tutorial data for the Excel 2010 Basic Tutorial. The data is to be copied and pasted into the tutorial worksheet.
Data for Excel 2007 SUMIF Tutorial
This document contains subtotal data for the Excel 2007 SUMIF step by step tutorial. The SUMIF data is to be copied and pasted into the tutorial worksheet.
Data for the Excel 2007 VLOOKUP Array Formula Tutorial
This document contains the tutorial data for the Excel 2007 VLOOKUP Array Formula Tutorial. The data is to be copied and pasted into the tutorial worksheet.
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.
Add and Delete Columns and Rows in Excel
This series of articles cover the basics of how to add and delete columns and rows in Excel worksheets. It is often necessary to alter the layout of a worksheet due to the addtion or removal of data.
Excel Tips IV - Excel 2007
This list of Excel tips covers a variety of topics in the newest version of Microsoft Excel - Excel 2007.
Spreadsheet Lessons
Spreadsheet 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.
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 Tips
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.