Spreadsheets

By eHow Computers Editor

0 comments

Creating labels for your rows and columns makes your spreadsheet easier to read. These steps work with Microsoft Excel 97... more »

How to Record an Excel Macro

By eHow Computers Editor

0 comments

A macro automates a complex task. Excel macros can perform complicated series of actions or simply record commonly used commands. These instructions apply to Excel 97... more »

How to Save an Excel Worksheet as HTML

By eHow Computers Editor

0 comments

You can convert your Excel 2000 worksheets and charts to HTML with just one command... more »

How to Sum a Column or Row of Excel Cells

By eHow Computers Editor

0 comments

With AutoSum, you can add a range of cells in a flash! Plus, best of all, Excel will recalculate the sum whenever the cells you selected change. These steps are intended for Microsoft's Excel 97... more »

How to Use the AutoFill Function in Excel

By eHow Computers Editor

0 comments

Use the AutoFill feature in Microsoft Excel 2000 to automatically fill in cells with common series (numbers, months, days of the week) or with custom lists, such as your company's departments or the sections of your budget... more »

How to Create a Form for the Web in Excel

By eHow Computers Editor

0 comments

With Excel 97, you can post a Web page that asks users to submit data to be incorporated into a spreadsheet (perhaps you need budget numbers for several departments, for example). You set up the spreadsheet first; then, when users enter the data ... more »

How to Interpret Descriptive Statistics

By Paul McDaniel

0 comments

These steps will lead you through each of the basic descriptive statistics calculated by standard statistical analysis software such as SAS, SPSS, STATA, Excel, etc., and how to interpret them. Descriptive statistics (mean, median, mode, range, ... more »

How to Make a Circle Graph With Excel

By eHow Computers Editor

0 comments

You may not ever get around to all of the capabilities a powerful program such as Excel offers. An example of one such feature is graphing. You can make many graphs, but a favorite of many people is the circle graph (often called a pie chart). ... more »

How to Make a Pivot Table in Excel 2007

By eHow Computers Editor

0 comments

Microsoft Excel makes computations and data organization easier. Ease of use and efficiency are hallmarks of this software. One utility that exemplifies this are pivot tables. Pivot tables make the use and the display of copious amounts of data a ... more »

How to Merge Workbooks in Excel

By eHow Computers Editor

1 comments

In Excel 2000, you can distribute copies of a spreadsheet, have reviewers provide input, and then "merge" the review copies back into one workbook. To do this, you first set up the basic workbook to be "shared," then merge the shared copies back ... more »

How to Use Cell Ranges in Excel Formulas

By eHow Computers Editor

2 comments

When creating formulas in Microsoft Excel 2000, you can indicate a range instead of specifying each individual cell to use... more »

How to Use Excel's TTEST Function

By eHow Computers Editor

0 comments

Excel's TTEST function calculates the probability that two samples are from the same population, assuming the populations have the same mean. TTEST returns the probability of a Student's t-Test, a method of testing a hypothesis made about the ... more »

How to Calculate a Net Present Value Using Excel

By eHow Computers Editor

0 comments

Net present value is a tool you can use to evaluate the profitability of an investment or project. It compares the present value of the cash inflow from the investment to its cash outflow, telling you the value of the investment. You can use ... more »

How to Link Data to Another Spreadsheet in Excel

By eHow Computers Editor

0 comments

If you need to use several spreadsheet files to keep your data current, try linking cells of one spreadsheet to another. This way you will not have to key the data into several spreadsheets every time you make changes to one item. You can even ... more »

How to Sum a column in an Excel spread Sheet

By pamam

0 comments

My sister and brother-in-law had difficulty with adding a column in excel so I thought maybe others have similar problems. This article gives two ways to accomplish this task. I am assuming that you know how to enter data into a spread sheet by ... more »

How to Add Borders to Cells in Microsoft Excel

By eHow Computers Editor

0 comments

Microsoft's Excel spreadsheet program has been around for several years. It is used in homes to keep the family budget while stock brokers use it to track up to the minute changes in the New York Stock Exchange. This program can help organize and ... more »

How to Add Cells in Excel

By eHow Computers Editor

0 comments

Microsoft Excel is the most popular spreadsheet program available and it is sold bundled with other programs in the Microsoft Office Suite. In the process of formatting data, it is often necessary to calculate the sum of certain figures as well ... more »

How to Audit Formulas in Excel 2007

By eHow Computers Editor

0 comments

Microsoft Excel 2007 offers many functions that make complicated computations and formulas easy to calculate. While these formulas are easy to compute especially when compared with the pen and paper alternative, they are not without their own ... more »

How to Calculate a Loan Payment Using Microsoft Excel

By eHow Computers Editor

0 comments

Microsoft Excel is a lovely program that can help you manage your personal or business finances. If you are applying for a loan that will have constant payments and a constant interest rate, it can easily calculate your loan payment for you. You ... more »

How to Calculate an Interest Rate Using Excel

By eHow Computers Editor

0 comments

Microsoft Excel is a good program to use when making financial decisions. Among the many functions it can perform, Excel can help you calculate the interest rate of a loan or an investment. By simply entering the information you already know, you ... more »

How to Choose Timesheet Software

By clf99

2 comments

Client Billings in Chaos? Project Costs Unknown? Nine Critical Characteristics To Demand From Your Timesheet Vendor... Can They Do This? If you’ve outgrown your current paper-based or homegrown timesheet system, or if you have multiple ... more »

How to Convert a Microsoft Word Table Into an Excel Workbook

By eHow Computers Editor

0 comments

You can use Microsoft Excel for storing large amounts of data. If your data currently exists in a Microsoft Word table document and you want to use an Excel spreadsheet to manage it, you don't have to resort to manual typing. The data can be ... more »

How to Convert a Spreadsheet Document to HTML With FrontPage

By eHow Computers Editor

0 comments

On a Web page, you may want to display your company's fourth-quarter sales earnings or your chocolate consumption tally spreadsheet. Do this using the FrontPage Editor. This tutorial uses FrontPage 97... more »

How to Copy and Paste in Excel

By eHow Computers Editor

0 comments

Creating and editing spreadsheets in Excel is commonplace in most businesses. To easily edit information within a spreadsheet, you can copy and paste information from one cell to another. Follow these steps and you will save time by copying and ... more »

How to Copy Formulas in Excel

By eHow Computers Editor

0 comments

When setting up a spreadsheet it is useful to be able to copy formulas from one place in the sheet to another. With newer spreadsheets like Excel, the formula may need to be copied to a different page of the workbook. Sometimes the formula needs ... more »

Check Out All Categories

Articles in Spreadsheets