Spreadsheets - By Category

Excel 101- How to Use Excel Spreadsheets

Here you will find step by step tutorials for beginners on how to use the basic features and options of Microsoft Excel. Tutorials include how to create and use formulas for calculations, entering data, formatting worksheets, printing, and creating charts and graphs.

How to Use Formulas in Excel

Here you will find tutorials covering how to create and use formulas in Excel. Each tutorial includes a step by step example of how to create and use formulas in Excel.

Excel Function Tutorials

Here you will find step by step tutorials on the most useful and most used functions in Excel.The function tutorials are organized according to the headings found under the Formulas tab in Excel.

Excel IF Function Tutorials

The IF function is one of Excel’s most useful and most used functions. What it does is test to see whether a given condition is true or false. Depending upon the result, different outcomes for the function can be specified. The IF function has also been combined with other popular Excel functions to create such functions as SUMIF, COUNTIF, and AVERAGEIF. The tutorials below include step by step examples of using the IF function in Excel.

VLOOKUP and Other Excel Lookup Function Tutorials

These tutorials for VLOOKUP as well as Excel's other Lookup formulas and functions include step by step examples.

Data Management in Excel

Here you will find tutorials on how to create a database in Excel as well as a creating drop down lists, using the data entry form, sorting and filtering data, removing duplicate records, and more.

Excel Shortcut Keys

Excel has shortcut keys to quickly accomplish common tasks such as adding a worksheet, showing formulas, and adding the current date. These tutorials include step by step instructions on how to use shortcut keys in Excel.

Excel Format Options and Features Tutorials

Excel's format options include conditional formatting, number formatting, and text and cell formatting Here you will find step by step tutorials, to help you format your worksheets easily and effectively..

Excel Charts and Graphs Tutorials

Here you will find tutorials on how to create and format Excel's most commonly used charts and graphs. Each tutorial includes a step by step example.

Excel Tips, Tools and Templates

Microsoft Excel contains a number of tools, features, and shortcuts that, while they may not be used all that often, can really simplify working with spreadsheets. Here you will find tips and tutorials on using features such macros, freeze panes, protecting worksheets, and templates that can help to make using Excel as straightforward and as painless as possible.

Advanced Topics in Excel Spreadsheets

Here you will find tutorials on some of Excel's advanced features such as macros, lookup functions, array formulas, pivot tables, and data management.

Excel 2003 Tutorials

Excel 2003 tutorials on how to get started with Excel formulas, functions and more. Thesetutorials include step by step examples of how to use Excel 2003.

Free Spreadsheet Software - Excel Alternatives

As an alternative to Excel here you will find tutorials on free spreadsheet software such as Calc, Google Docs Spreadsheets, and Microsoft's Excel Web App Online.

Excel Glossary of Terms

Here you will find common terms and definitions used in Excel and other spreadsheet programs such as Google Docs Spreadsheets and OpenOffice Calc.