Spreadsheets

How to Calculate a Present Value Using Microsoft Excel

By eHow Computers Editor

0 comments

Using Microsoft Excel to calculate the present value of a potential investment is a simple task once you learn the syntax of the required formula. Follow these easy steps and you can calculate present value using Microsoft Excel easily and quickly... more »

How to Calculate a Principal Payment Using Microsoft Excel

By eHow Computers Editor

0 comments

The PPMT function in Excel calculates the amount of a loan payment that is applied to the principal based on the interest rate, period of the payment, number of payments and the value of the loan. The resulting value is also referred to as the ... more »

How to Calculate Sum-of-Years' Digits Depreciation With Excel

By eHow Computers Editor

0 comments

The SYD function in Excel calculates an asset's sum-of-years' depreciation over a specified period. This calculation is based on the original cost of the asset, the salvage value of the asset, the number of periods that the asset will be ... more »

How to Combine Columns of Data in MS Excel

By Melody

0 comments

There are occasions when you need to combine or join columns of data into a single column. Here’s how to do it using MS Excel's concatenate function... more »

How to Define Cell Ranges in Excel

By eHow Computers Editor

0 comments

In Excel 2000, you can define names for cell ranges to make it easier to create and understand your formulas. For example, if the cells from J20 to J33 are all sources of income, you could name this cell range "IncomeSources" and then use that ... more »

How to find the "one" number that appears most frequently in a column in Excel

By dougharris

1 comments

I'm a lottery player and I wanted to do some simple statistics to help me choose my numbers. The logical thing for me was to build a spreadsheet. I play a 5 number lottery in my state. Every day when I check the drawing, I enter that days drawing ... more »

How to Keep Track of Changes in an Excel Document

By eHow Computers Editor

0 comments

When you're creating a spreadsheet with a group, it can be difficult to remember who made changes and why these changes were made. Use the Track Changes option in Excel to simplify this process. These steps work with Microsoft Excel 97... more »

How to Learn Lotus 1-2-3

By eHow Computers Editor

0 comments

Lotus 1-2-3 was one of the first spreadsheet programs. It was extremely popular before Microsoft Excel arrived on the market. It stills holds a place for a lot of people and businesses. Although its features are similar to Excel, there are some ... more »

How to Make Footers Appear Automatically in Word and Excel Documents

By noiddog

1 comments

This article is to show you how to make your headers, margins, and footers automatically appear in Word or Excel 2003... more »

How to Monitor Stock Prices in Microsoft Excel

By eHow Personal Finance Editor

0 comments

Whether you have a large stock portfolio or own a few shares of stock, monitoring the performance of your investments can be done with Microsoft Excel, a product in the Microsoft Office software suite. After setting up your stock information in ... more »

How to Transpose a Data Array in Microsoft Excel

By eHow Computers Editor

0 comments

Transposing data in Microsoft Excel instructs the program to return a vertical range of cells as a horizontal range or vice versa. “Transpose” must be entered as an array formula, which is a formula that calculates multiple values and returns a ... more »

How to Use "Range Name" in a Spreadsheet

By eHow Computers Editor

0 comments

When you name cells or groups of cells in a spreadsheet, it is called a range name. Using this can make your work easier to read and modify, plus it will make it easier for you to navigate your spreadsheet. The following steps will teach you the ... more »

How to Use Autofit in Excel

By eHow Computers Editor

0 comments

When you open Microsoft Excel and begin to enter data, you will notice that if an entry is long, the end of the entry will be cut off by the column border. You can apply autofit to this column so the column will expand to the size that will fit ... more »

How to Use Conditional Formatting in Microsoft Excel 2007

By Anthony Delgado

0 comments

Microsoft Excel 2007 has a number of new and impressive features, one of which is enhancement to the conditional formatting function. There are many graphic interfaces as well as text formatting and cell formatting options available... more »

How to Use Excel's TRUE Function

By eHow Computers Editor

0 comments

Excel's TRUE function returns the logical value of TRUE. The value TRUE may be entered into cells and formulas directly so the primary purpose of this function is to provide compatibility with other spread sheet applications. The following steps ... more »

How to Use keyboard shortcuts in Microsoft Excel

By Ambyr Lix

2 comments

Keyboard shortcuts can be a very valuable tool for any Microsoft Office user. Some people prefer the ease and time efficiency of shortcuts; others use the keyboard rather than a mouse because of physical reasons. For whatever your reason, there ... more »

How to Use the Paste Special Command in Excel

By eHow Computers Editor

0 comments

Instead of copying entire cells, you can copy specified cell contents - such as the cell format or the result of a formula, but not the formula itself - with the Paste Special command in Microsoft Excel 2000. You can also switch data from columns ... more »

How to write a PHP script that dynamically builds Excel spreadsheets

By marcain

0 comments

How to build a PHP script that can be used to dynamically build an Excel spreadsheet... more »

How to Add Two Cells in Excel

By eHow Computers Editor

0 comments

One of the best things about a spreadsheet is using formulas to calculate values automatically. When you tell Microsoft Excel to add two cells (perhaps the cells that represent the number of men and women in a class that you are teaching), the ... more »

How to Calculate the Term of an Investment Using Microsoft Excel

By eHow Computers Editor

0 comments

The NPER function in Excel calculates the number of payment periods required to pay off a loan based on the overall value of the loan, the payments and the interest rate. The resulting value may also be referred to as the term of an investment. ... more »

How to Choose a Spreadsheet Program

By eHow Computers Editor

1 comments

Spreadsheets are sophisticated number-crunching programs. They calculate and recalculate figures, generate charts, graphs and reports and provide tools and templates to automate much of the process for the user... more »

How to Create a For Next Loop in Excel VBA

By Keith Johnson

0 comments

The For Next loop is one of the most useful loops in Excel VBA. It allows you to run the same code a specific number of times--and it's easy to learn... more »

How to Create a Spreadsheet Template in Excel

By eHow Computers Editor

0 comments

If you create similar spreadsheets all the time, use Excel 2000 to create your own custom template with all your common settings in it... more »

How to Create a Statistical Process Control Chart

By eHow Computers Editor

0 comments

A statistical process control chart is used in manufacturing to evaluate the output or activity of a particular process or work flow and determine if the process is in control or not. In control means current data is an accurate source of future ... more »

How to Define Cell Names in Excel

By eHow Computers Editor

0 comments

Name a cell to refer to it by name (perhaps "Taxes" or "Widget Sales"), not by cell reference (such as C3 or F8). Naming cells can make it easier to set up formulas. You can also name a cell range. These steps work with Microsoft Excel 97... more »

Check Out All Categories

Articles in Spreadsheets