How to Use Excel and Other Spreadsheet Programs
By Ted French, About.com Guide to Spreadsheets
Those who are new to spreadsheets will find all the basics needed on how to use Excel and other programs such as Calc and Microsoft Works to create effective and professional looking spreadsheets. A beginner's guide covers essential information and a labeled diagram of the Excel screen, helps you learn what some of this spreadsheet terminology means. Free step by step tutorials and tips help make that first adventure in creating spreadsheets go smoothly.
- How to Use Excel 2007
- How to Use Excel 2003
- Excel Math
- Excel Chart Tutorials and Free Excel Templates
- Excel 2003 Videos
How to Use Excel 2007
The articles and step by step tutorials in this section are intended to show beginners and near beginners how to use Excel 2007 to produce a complete spreadsheet.
- Beginners Guide to Excel 2007
- Basic Excel 2007 Spreadsheet Tutorial
- Parts of the Excel 2007 Screen
- Excel 2007 Formulas Step by Step Tutorial
How to Use Excel 2003
The articles and step by step tutorials in this section are intended to show beginners and near beginners how to use Excel 2003 to produce a complete spreadsheet.
- Beginners Guide to Excel 2003
- Basic Excel 2003 Spreadsheet Tutorial
- Parts of the Excel 2003 Screen
- Excel 2003 Formulas Step by Step Tutorial
- Basic Formatting in Excel 2003
Excel Math
Create basic math formulas in Excel -- How to add, subtract, multiply, and divide in Excel
Excel Chart Tutorials and Free Excel Templates
Create and format common charts and graphs in Excel -- How to convert bar graphs to pictographs -- Free flowcharts, timelines and other Excel templates
- Excel Charts/Graphs and their Uses
- Excel Pie Chart Tutorials
- Excel Column Chart / Bar Graph Tutorials
- Excel 2007 Line Graph Tutorial
- Excel 2007 Stock Market Chart Tutorial
- Create a Pictograph in Excel 2007
- Create a Pictograph in Excel 2003
- Free Excel Templates
Excel 2003 Videos
Watch these training videos on Microsoft Excel 2003. Through live screencasts, experts will show you how you can use a variety of features in Excel. A full transcript is provided so you can follow the training videos on your own.
- IF Function in Excel
- Find and Replace in Microsoft Excel
- Create Borders and Shading in Excel
- Hide Information in Microsoft Excel
- Headers and Footers in Microsoft Excel Spreadsheets
- Export Data From an Excel Sheet to a Word Document
- Excel Autosum Function
- How to Adjust Tabs in Microsoft Excel
- Microsoft Excel Sort Feature
Google Spreadsheets
Google Spreadsheets offers for free most of the common features available in their competitors' spreadsheet programs. In addition they also offer online benefits such as sharing spreadsheets, online storage, and real time editing over the Internet. Collaborating with colleagues was never easier.
- Review of Google Spreadsheets
- Sharing Options for Google Spreadsheets
- Google Spreadsheet Formula Tutorial
- Google Spreadsheet IF Function
- Count Days Between Dates in Google Spreadsheets
- Google Spreadsheet COUNTIF Function
- Google Spreadsheet COUNT Function
Open Office Calc
Calc is a full featured spreadsheet program similar to commercial programs like Excel. Unlike commercial software, however, Calc is offered free of charge by openoffice.org. Calc's features include formulas and functions for calculations and a variety of formatting options to help you create eye catching spreadsheets that will make your data easier to read and understand.
Microsoft Works
Microsoft Works has features most commonly used in other spreadsheets. This list of articles gives you straightforward instructions on how to carry out a variety of tasks in Microsoft Works.
- Microsoft Works Spreadsheet Screen
- Microsoft Works Task Launcher
- Basic Microsoft Works Spreadsheets Tutorial
- MS Works Spreadsheets Formulas
Spreadsheet Lesson Plans
Spreadsheet Lesson Plans contain step by step examples that can be used as lessons for a wide range of age groups. Topics covered include creating and using spreadsheets, functions, graphing, formatting and creating formulas.
