Spreadsheets

How to Use Excel's Char Function

By eHow Computers Editor

0 comments

Excel's Char function determines the character specified by the number of a character set. This will be the Macintosh character set for Macintosh computers and the ANSI character set for Windows computers. Char is frequently used to translate ... more »

How to Use Excel's Clean Function

By eHow Computers Editor

0 comments

Excel's Clean function removes all of the non-printable characters from a string. It is often used when importing text from other applications that may not be compatible with your operating system. The following steps will show how to use Excel's ... more »

How to Use Excel's Column Function

By eHow Computers Editor

0 comments

Excel's Column function determines the column number for the specified reference. Columns in Excel are normally designated with letters of the alphabet beginning with A as the first column. Column will return 1 for cells in column A, 2 for cells ... more »

How to Use Excel's Combin Function

By eHow Computers Editor

0 comments

Excel's Combin function returns the number of ways that the specified number of items can be combined. It may be used to determine the maximum number of groups for a given number of items. The following steps will show how to use Excel's Combin ... more »

How to Use Excel's COMPLEX Function

By eHow Computers Editor

0 comments

Excel's COMPLEX function converts the specified real and imaginary coefficients into a complex number. A complex number has the form x+yi where x is the real component, y is the imaginary component and i is the square root of -1... more »

How to Use Excel's Concatenate Function

By eHow Computers Editor

0 comments

Excel's Concatenate function joins text strings into a single text string. You may select a range of cells to create multiple strings if the cell that will hold the results is a row that includes the selected cells. The following steps will show ... more »

How to Use Excel's CONVERT Function

By eHow Computers Editor

0 comments

Excel's CONVERT function converts units for a variety of measures including those for distance, energy, force, liquids, magnetism, power, pressure, temperature, time and weight. The new and original units must be for the same type of measure... more »

How to Use Excel's Count A Function

By eHow Computers Editor

0 comments

Excel's Count A function counts the number of non-empty cells and values in a list of arguments. It can also count the cells that contain data in an array or range. The following steps will show how to use Excel's Count A function... more »

How to Use Excel's CountBlank Function

By eHow Computers Editor

0 comments

Excel's CountBlank function counts the number of empty cells in the specified range. The CountBlank function syntax is CountBlank(range), where range is a range of cells of the form cell_1:cell_2 from which the blank cells will be counted. The ... more »

How to Use Excel's COUPDAYBS Function

By eHow Computers Editor

0 comments

Excel's COUPDAYBS function calculates the number of days between the beginning of the coupon period and the settlement date. It can be remembered by the mnemonic "COUPon DAY Beginning Settlement" and is a member of Excel's financial library... more »

How to Use Excel's COUPDAYS Function

By eHow Computers Editor

0 comments

Excel's COUPDAYS function calculates the number of days in the period containing the settlement date. It can be remembered by the mnemonic "COUPon DAY Settlement" and is a member of Excel's financial library... more »

How to Use Excel's COUPDAYSNC Function

By eHow Computers Editor

0 comments

Excel's COUPDAYSNC function calculates the number of days between a security's settlement date and the next coupon date. It can be remembered by the mnemonic "COUPon DAY Settlement Next Coupon" and is a member of Excel's financial library... more »

How to Use Excel's COUPNCD Function

By eHow Computers Editor

0 comments

Excel's COUPNCD function calculates the first coupon date after a security's settlement date. It can be remembered by the mnemonic "COUPon Next Coupon Date" and is a member of Excel's financial library... more »

How to Use Excel's Covar Function

By eHow Computers Editor

0 comments

Excel's Covar function calculates the covariance between two data sets. Covariance is the average of the products of deviations for a pair of data points. For example, Covar can determine the correlation between grades and study time. The ... more »

How to Use Excel's CUBEKPIMEMBER Function

By eHow Computers Editor

0 comments

Excel's CUBEKPIMEMBER function returns a property for a Key Performance Indicator and displays its name in a cell. This function is only available when the spreadsheet has a connection to a Microsoft SQL Server 2005 or later. The following steps ... more »

How to Use Excel's CUBEMEMBER Function

By eHow Computers Editor

0 comments

Excel's CUBEMEMBER function returns a unique member from a cube that matches the specified expression. It is used primarily to determine the existence of that member within the cube. This function requires a connection to a data source... more »

How to Use Excel's CUBEMEMBERPROPERTY Function

By eHow Computers Editor

0 comments

Excel's CUBEMEMBERPROPERTY function returns the property of a member within the cube and is also used to verify the existence of that member. This function requires a connection with a data source... more »

How to Use Excel's CUBERANKEDMEMBER Function

By eHow Computers Editor

0 comments

Excel's CUBERANKEDMEMBER function returns the member in a set with the specified rank such as the top 10 students in a class. It requires a connection to a data source such as Microsoft SQL Server 2005 or later... more »

How to Use Excel's CUBESET Function

By eHow Computers Editor

0 comments

Excel's CUBESET function returns a set of members from a cube that matches the specified expression and is used to retrieve all of the members in the desired hierarchy. This function requires a connection to SQL Server 2005 or later... more »

How to Use Excel's CUBESETCOUNT Function

By eHow Computers Editor

0 comments

Excel's CUBESETCOUNT function returns the number of members in a set. It typically uses a CUBESET function or reference to a CUBESET function and requires a connection to a SQL Server 2005 or later data source. The following steps will show how ... more »

How to Use Excel's DateValue Function

By eHow Computers Editor

0 comments

Excel's DATEVALUE function returns the serial number for a specified date. Excel uses this serial number internally to store dates and it is also used by the programmer to perform date calculations. The following steps will show how to use ... more »

How to Use Excel's DAVERAGE Function

By eHow Computers Editor

0 comments

Excel's DAVERAGE function is short for "database average." It selects a set of values from a column of a database that matches the specified criteria. DAVERAGE then calculates the arithmetic mean of the selected values in the same manner as ... more »

How to Use Excel's Days360 Function

By eHow Computers Editor

0 comments

Excel's DAYS360 function calculates the number of days of difference between two specified dates based on a year of twelve 30-day months. This method is used in accounting for some payment schedules. The following steps will show how to use ... more »

How to Use Excel's DB Function

By eHow Computers Editor

0 comments

Excel's DB (short for declining balance) function calculates an asset's depreciation over a period of time by using the fixed-declining balance method. This method assumes that the asset depreciates at a fixed rate... more »

How to Use Excel's DCount Function

By eHow Computers Editor

0 comments

Excel's DCOUNT function is short for "database count." It considers all of the cells in a column of a database that match the specified criteria. DCOUNT then returns a count of all cells that contain a numeric value in the same manner as COUNT, ... more »

Check Out All Categories

Articles in Spreadsheets