1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Free Spreadsheet Tutorials

Free Tutorials on Free Spreadsheets

By

Listed here are tutorials on free spreadsheet programs such as Google Spreadsheets and OpenOffice Calc. The tutorials are also free. The tutorials cover a wide variety of topics related to creating and using a spreadsheet.

Basic OpenOffice Calc Spreadsheet Tutorial

Free Calc Spreadsheet Tutorial
Free Calc Spreadsheet Tutorial

OpenOffice Calc, is an electronic spreadsheet program offered free of charge by openoffice.org. The program is easy to use and contains most, if not all of the commonly used features found in spreadsheets such as Microsoft Excel.

This tutorial covers creating a basic spreadsheet in OpenOffice Calc. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

OpenOffice Calc Formulas Tutorial

Free Calc Spreadsheet Tutorial
Free Calc Spreadsheet Tutorial
Like other spreadsheets -free or otherwise, OpenOffice Calc allows you to create formulas to perform calculations. These formulas can be as basic as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, OpenOffice Calc does all the calculations for you.

Sharing Options for Google Spreadsheets

Free Google Spreadsheet Tutorial
Free Google Spreadsheet Tutorial
Google Spreadsheets, another free spreadsheet program, is one of the new “Web 2” applications that are now available on the Internet. One of the key features of Web 2 apps is that they let people collaborate and share information easily over the Internet. This article covers options for sharing free spreadsheets over the Internet.

Google Spreadsheet Formula Tutorial

Free Google Spreadsheet Tutorial
Free Google Spreadsheet Tutorial
This tutorial covers creating and using a simple Google Spreadsheet formula and is intended for those with little or no experience working with spreadsheets. The tutorial on this free spreadsheet program includes a step by step example of creating a Google Spreadsheet formula.

Google Spreadsheet IF Function

Free Google Spreadsheet Tutorial
Free Google Spreadsheet Tutorial
Google Spreadsheets' IF function allows you to use decision making in your worksheets. How it does this is by testing to see if a certain condition in a spreadsheet cell is true or false. If the condition is true, the function will carry out a specific operation. If the condition is false, the function will carry out a different operation. The tutorial on this free spreadsheet program includes a step by step example of using the IF function in a Google Spreadsheet.

Google Spreadsheet COUNT Function

Free Google Spreadsheet Tutorial
Free Google Spreadsheet Tutorial
The COUNT function is used in a Google Spreadsheet to count up the number of cells in a selected range that meet specified criteria. The tutorial on this free spreadsheet program includes a step by step example of using the COUNT function in a Google Spreadsheet.

Google Spreadsheet COUNTIF Function

Free Google Spreadsheet Tutorial
Free Google Spreadsheet Tutorial
The COUNTIF function in a Google Spreadsheet is used to count up the number of cells in a selected range that meet specified criteria. The tutorial on this free spreadsheet program includes a step by step example of using the COUNTIF function in a Google Spreadsheet.

©2014 About.com. All rights reserved.