Spreadsheets

How to Use Excel's DCOUNTA Function

By eHow Computers Editor

0 comments

Excel's DCOUNTA function is short for "database count all." It considers all of the cells in a column of a database that match the specified criteria. DCOUNTA then returns a count of all nonblank cells in the same manner as COUNTA, the equivalent ... more »

How to Use Excel's DDB Function

By eHow Computers Editor

0 comments

Excel's DDB function determines an asset's depreciation over a specified period of time. The acronym "DDB" stands for double-declining balance because this is the most common method used by this function, although it may use any specified method ... more »

How to Use Excel's Degrees Function

By eHow Computers Editor

0 comments

Excel's DEGREES function converts radians into degrees and is the inverse function of RADIANS. Both radians and degrees are units of circular measure and converting between the two is a frequent requirement in trigonometry. The following steps ... more »

How to Use Excel's DGET Function

By eHow Computers Editor

0 comments

Excel's DGET function (short for database get) retrieves a single value from a column in a database according to the specified criteria. Unlike other database functions, DGET does not have a non-database equivalent. The following steps will show ... more »

How to Use Excel's Dmax Function

By eHow Computers Editor

0 comments

Excel's DMAX function is short for "database maximum." It selects a set of values from a column of a database that matches the specified criteria. DMAX then returns the largest number in this set just as MAX, the equivalent non-database function, ... more »

How to Use Excel's DMIN Function

By eHow Computers Editor

0 comments

Excel's DMIN function is short for "database minimum." It selects a set of values from a column of a database that matches the specified criteria. When it has obtained a set of values, DMIN returns the smallest number just as MIN, the equivalent ... more »

How to Use Excel's Dollar Function

By eHow Computers Editor

0 comments

Excel's DOLLAR function converts a numeric value to a text value and applies a currency symbol. This function's name and the currency it applies are dependent upon the language settings in Excel... more »

How to Use Excel's DPRODUCT Function

By eHow Computers Editor

0 comments

Excel's DPRODUCT function is short for "database product." It selects the values in a column of a database that match the specified criteria. DPRODUCT then returns the product of those values just as PRODUCT does. The following steps will show ... more »

How to Use Excel's DSTDEV Function

By eHow Computers Editor

0 comments

Excel's DSTDEV function is short for "database standard deviation." It calculates a population's standard deviation based on a sample for values in the column of a database that match the specified criteria. When the values have been selected, ... more »

How to Use Excel's DSTDEVP Function

By eHow Computers Editor

0 comments

Excel's DSTDEVP function is short for "database standard deviation for a population." It calculates a population's standard deviation for values in the column of a database that match the specified criteria. When the values have been selected, ... more »

How to Use Excel's DSUM Function

By eHow Computers Editor

0 comments

Excel's DSUM function is short for "database sum." It adds the values in a column of a database that match the specified criteria. DSUM then calculates its return value in the same manner as SUM, which simply takes its values directly from the ... more »

How to Use Excel's DVAR Function

By eHow Computers Editor

0 comments

Excel's DVAR function is short for "database variance." It estimates the variance of a population based on values determined by a specified database, field and criteria rather than values taken directly from the arguments. The following steps ... more »

How to Use Excel's DVARP Function

By eHow Computers Editor

0 comments

Excel's DVARP function is short for "database variance population." It calculates a population's variance based on the entire population using values specified by a database, field and criteria rather than taking values directly from the arguments... more »

How to Use Excel's EDATE Function

By eHow Computers Editor

0 comments

Excel's EDATE function calculates a date that is a specified number of months before or after a specified date. It is frequently used to determine due dates that occur on the same day of the month as the start date... more »

How to Use Excel's EOMONTH Function

By eHow Computers Editor

0 comments

Excel's EOMONTH function calculates the last day of the month that is a specified number of months before or after a specified date. It is frequently used to determine due dates that occur on the last day of each month... more »

How to Use Excel's HOUR Function

By eHow Computers Editor

0 comments

Excel's HOUR function determines the hour in a time value. It will return the hour as an integer ranging from 0 to 23 inclusive where 0 is midnight and 23 is 11 p.m. The following steps will show how to use Excel's HOUR function... more »

How to Use Excel's MINUTE Function

By eHow Computers Editor

0 comments

Excel's MINUTE function determines the minute of a time value and will return the minute as an integer ranging from 0 to 59 inclusive. Any fractional value of the minute value (representing the seconds) will be truncated. The following steps will ... more »

How to Use Excel's NETWORKDAYS Function

By eHow Computers Editor

0 comments

Excel's NETWORKDAYS function calculates the number of work days between two dates. It will not count weekends or any other dates designated as holidays and is frequently used in calculations involving accrued employee benefits. NETWORKDAYS is ... more »

How to Use Excel's NOW Function

By eHow Computers Editor

0 comments

Excel's NOW function returns the current date and time and is commonly used in date and time calculations. The cell containing this result will be formatted as a date if its format previously was General. The following steps will show how to use ... more »

How to Use Excel's SECOND Function

By eHow Computers Editor

0 comments

Excel's SECOND function determines the number of seconds in a time value and will return an integer ranging from 0 to 59 inclusive. Any fractional value of the second value will be truncated... more »

How to Use Excel's SIGN Function

By eHow Computers Editor

0 comments

The SIGN function can be used in Microsoft Excel to find the mathematical sign of any cell reference. If a cell contains a positive number, the return will be "1" while if the cell contains a negative number, the return will be -1. A cell ... more »

How to Use Excel's SINH Function

By eHow Computers Editor

0 comments

Most people primarily use Microsoft Excel for business computations and basic mathematical functions. Excel however is a much more diverse application in that a user can compile complex trigonometry calculations. One such trigonometry function is ... more »

How to Use Excel's SKEW Function

By eHow Computers Editor

0 comments

Microsoft Excel uses functions contained within the application to assist user with complex mathematical and financial calculations. The functions provide a relatively simple means of obtaining complex calculation with just a few clicks. One such ... more »

How to Use Excel's SLN Function

By eHow Computers Editor

0 comments

The SLN function in Microsoft Excel is used to find the straight-line depreciation of any asset. In order to calculate this information, you will need to have cells that contain the cost, salvage and useful life of a particular asset. Follow the ... more »

How to Use Excel's SMALL Function

By eHow Computers Editor

0 comments

The SMALL function in Microsoft Excel returns the smallest value from a range of values. You can also use it to return other values in relation to the smallest value. This function can be quite useful when you are looking to quickly find a low ... more »

Check Out All Categories

Articles in Spreadsheets