Resources for Spreadsheet Software

Producers of spreadsheet software, in and apart from office suite software.
Office Suite Software

Makers and distributors of desktop productivity applications. more »

Accounting Spreadsheets and Calculators

Sources of spreadsheets and calculators for accounting. more »

Call Accounting Software

Business directory to call accounting software. more »

Accounting Database Software

Offering industry database software. more »

Accounting Software

Business directory of software for accounting and accounting software system providers. Quickly find small business accounting software for your financial management and bookkeepin… more »

Get Your Business Listed

Get your business listed on this page

Reach active buyers and immediately increase your visibility

Get Started
Accounts Payable Software

Vendors of accounts payable software and bill management solutions. Research accounts payable system providers offering small business accounts payable programs. Find account payab… more »

Excel Templates, Calculators, and Calendars

Download Excel templates, calendars, mortgage and loan calculators, budget spreadsheets, and timesheets, for home and business.

http://www.vertex42.com

Spreadsheet Software Key Terms

A spreadsheet is made up of cells and you can enter data into each of them. This data is either numbers, letters or formulas. You can then format the data depending on how you want to see it. You can add or remove places after the decimal point, adding a dollar sign or a negative sign, and make letters all caps or small letters.

Sometimes you need to do the same task repeatedly; for these tasks, you can create macros. Finally, if you need to do the same thing each week or month you can make worksheets, which will make your job easier.

Although Microsoft Excel isn’t the only spreadsheet software, it dominates much of the spreadsheet information you'll find. This isn’t to say that you can’t use the information for other spreadsheets. However, most of the information in this guide is about Microsoft Excel.

Cells

A cell is a block that is designated by a row and column, such as A1 in a spreadsheet. A1 is the cell in the first row of the first column on a blank spreadsheet.

Toolbars

Toolbars are the buttons or icons you will commonly use when making or editing your spreadsheet. You can customize them to work for you.

Formulas

A formula is what you use when you want to do an arithmetic function with a cell such as addition, subtraction, multiplication or division.

Formatting

Formatting is what you do to a cell to customize it. You can put in a dollar or cents, center the data or put the data in all caps, to name a few options. In fact, there are many ways to format your cell.

Macros

An Excel macro is a set of commands that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet. Macros are used to remove the necessity of repeating the steps of common tasks over and over. You can create a macro and perform it when you want to complete a task quickly.

Data

Data is the information you enter in each cell. It can be a number, a label or a formula. Often, you can import and export data sets in and out of the program.
Using Technology in Education shows how to enter and manipulate data in a spreadsheet.