Spreadsheets

How to Use Excel's CountIf Function

By eHow Computers Editor

0 comments

Excel's CountIf function counts the number of cells in a specified range that meet the specified criteria. The syntax is CountIf (range,criteria), where range is the cell range for which you wish to count cells and criteria is the criteria the ... more »

How to Use Excel's CUBEVALUE Function

By eHow Computers Editor

0 comments

Excel's CUBEVALUE function returns an aggregate value based on the specified member expressions and might typically be used to calculate a sales total from a given year. This function requires a data source. The following steps will show how to ... more »

How to Use Excel's MONTH Function

By eHow Computers Editor

0 comments

Excel's MONTH function calculates the month of a specified date and can accept dates in several different formats as input. It will return an integer ranging from 1 to 12 inclusive where 1 represents January and 12 represents December... more »

How to Use Excel's RTD Function

By eHow Computers Editor

0 comments

Microsoft Excel has many financial and mathematical functions that make calculations easy to accomplish with just a few clicks. Most only use Excel for simple tasks; however, Excel has a function called RTD the enables a user to update a ... more »

How to Use Excel's Solver

By eHow Computers Editor

0 comments

Microsoft Excel has long been a leading spreadsheet productivity software platform. Most everyone uses Excel for its basic spreadsheet functions. However, Microsoft Excel has add-in extensions that further increase its power and productivity. One ... more »

How to Use Excel's TIMEVALUE Function

By eHow Computers Editor

0 comments

With certain projects, you may need to determine a specific number value for data, such as time. Excel uses a specific formula to convert data displayed as time into the proper numerical value, eliminating error and saving you the hassle of ... more »

How to Use Excel's Today Function

By eHow Computers Editor

0 comments

Excel's Today function allows you to do a variety of calculations, from determining the serial value of today's date to figuring out how many days are between the current and future date. This Excel formula allows you to make these calculations ... more »

How to Use Excel's TREND Function

By eHow Computers Editor

0 comments

Excel's TREND function uses the method of least squares to fit a line to known points. It returns the corresponding y values (which may be an array) for the specified x values. The following steps demonstrate how to use Excel's TREND function... more »

How to Use Excel's TRIMMEAN Function

By eHow Computers Editor

0 comments

Excel's TRIMMEAN function calculates the mean from a data set where a percentage of the top and bottom data points are excluded and returns this value. It is used to exclude outlying data from the analysis... more »

How to Use Excel's VALUE Function

By eHow Computers Editor

0 comments

Excel's VALUE function converts a text representation of a number to that number and returns it as numeric data. It is primarily used for compatibility with other spreadsheet applications. VALUE generally should not be required in a formula ... more »

How to Use Excel's VARA Function

By eHow Computers Editor

0 comments

Excel's VARA function estimates the variance of a population based on a sample and returns the compound variance of that sample. This function is identical to VAR except that VARA accepts errors, logical values and text. The following steps will ... more »

How to Use Excel's VARP Function

By eHow Computers Editor

0 comments

The Excel function VARP stands for "variance population" and calculates the variance of an entire population. The accuracy of VARP was improved in Excel 2003 and later versions. Earlier versions used a computational formula that had more profound ... more »

How to Use Excel's WEEKDAY Function

By eHow Computers Editor

0 comments

Excel's WEEKDAY function calculates the day of the week for the specified date. It returns an integer ranging from 1 to 7 corresponding to the days of the week. Date conversion functions are needed by spreadsheets because dates are frequently an ... more »

How to Use Spreadsheet Software

By eHow Computers Editor

0 comments

One of the main programs you need to run your computer is spreadsheet software. You don't have to use Microsoft, any spreadsheet program will do. Read on to find multiple ways to use your spreadsheet software... more »

How to Add a Data Table to an Excel Chart

By eHow Computers Editor

0 comments

A data table can easily be added to a chart in Microsoft Excel 2007. This data table shows the raw data that was used to create the chart. Data tables are a great option to use if you want to show readers exactly what information went into making ... more »

How to Add a Legend to an Excel Chart

By eHow Computers Editor

0 comments

A legend can be easily added to an existing Microsoft Excel 2007 chart. This legend will help users understand the components of your chart, and the position of it can be set at the same time it is added. Follow the steps below to learn how to ... more »

How to Add a Shadow to a Chart in Excel

By eHow Computers Editor

0 comments

A shadow effect can be added to any chart in Microsoft Excel 2007. When a shadow is used subtly and applied to the whole chart, the look it creates can really add interest to your data. The steps below will tell you how you can add a shadow to a ... more »

How to Add a Title to an Excel Chart

By eHow Computers Editor

0 comments

If you have already created a chart in Microsoft Excel 2007 that doesn't have a title; you can easily go back and add one without having to recreate the chart. The "Chart Title" button makes it easy to add and format the new title... more »

How to Add an Axis Title to an Excel Chart

By eHow Computers Editor

0 comments

If you have already created a chart in Microsoft Excel 2007 and you didn't add an axis title during creation, you can go back and add that title later. You can customize the title by adding your own text and decide on the placement of the title... more »

How to Add and Delete Rows in Excel

By eHow Computers Editor

0 comments

Microsoft Excel is a spreadsheet program that is used to create and analyze data. Sometimes, in the process of arranging data in a spreadsheet, it becomes necessary to add more rows or delete some of them. The Insert menu contains commands that ... more »

How to Add Data Labels to an Excel Chart

By eHow Computers Editor

0 comments

Data labels can be displayed to a Microsoft Excel 2007 chart so users can easily see the exact measurements represented by the charts. You can use the "Data Labels" button to quickly add data labels to an Excel chart while choosing their location ... more »

How to Add Gridlines to an Excel Chart

By eHow Computers Editor

0 comments

Increase the readability of your Microsoft Excel 2007 chart by adding gridlines. Gridlines can be added horizontally and vertically and be displayed to represent major units, minor units or both. Keep reading the steps below to find out how you ... more »

How to Add Images to an Excel 2007 Document

By eHow Computers Editor

0 comments

Microsoft Excel is the top spreadsheet software on the market. Excel contains useful tools that make the lives of number crunchers everywhere more manageable. However, Excel does lag behind in the aesthetics department. Conversely, adding an ... more »

How to add the default numbers of worksheet in a Excel file.

By alexleeyy

0 comments

Default situation, inside an Excel file contains three worksheets were Sheet1, Seet2 and Sheet3, but some senior users or users with special needs, often have more higher requirements for more worksheets... more »

How to Add Two Cells Containing Sums of Other Formulas

By eHow Computers Editor

0 comments

Spreadsheets are computer programs that can help you track your expenses, balance your checkbook or create a budget. One popular aspect of spreadsheet software is the automatic math; the computer does the calculations for you. If your spreadsheet ... more »

Check Out All Categories

Articles in Spreadsheets