### How to use LCM function in Excel spreadsheets [Tip]

LCM (Least Common Multiple) is an Excel function that returns the least common multiple of values. The least common multiple is the lowest integer (a number without fractional component) that is a multiple of all the selected numb...

### How to use EDATE and EOMONTH functions in Excel spreadsheets [Tip]

EDATE and EOMONTH are two date functions you can add to your Excel 2010/13 spreadsheets. These are functions that return that add or subtract months from a specified date. EMONTH returns the last day of the month and EDATE adds or...

### How to use GCD function in Excel spreadsheets [Tip]

GCD (Greatest Common Denominator) is another function you can add to Excel 2010/13 spreadsheets. The function finds the greatest divisor between two or more integers (numbers without fractional components). It returns the largest ...

### How to use FACTDOUBLE function in Excel spreadsheets [Tip]

This post covered the FACT Excel function that you can find factorials with. You can also find double factorials with Excel 2010/13. The double factorial is the product of all integers from one up to a non-negative integer n with ...

### How to use EFFECT function in Excel spreadsheets [Tip]

A nominal interest rate for a loan is one that does not factor in compound interest. However, as interest rates are compounded monthly, or quarterly, the effective rate of loan interest is slightly higher. To find the effective ra...

### How to use ODD and EVEN functions in Excel spreadsheets [Tip]

Excel has numerous functions that you can add to spreadsheets. Among them are ODD and EVEN. Those are functions that round numbers to the closest odd or even values. To add the ODD function to spreadsheets, click the fx button. Th...

### How to use ISPMT function in Excel spreadsheets [Tip]

Excel 2010/13 has a variety of financial functions. Among them is the ISPMT function, which returns the interest paid for a specific period of a loan. The ISPMT sysntax is ISPMT(interest_rate, period, number_payments,PV). For exam...

### How to use DMAX and DMIN functions in Excel spreadsheets [Tip]

Excel isn’t the best application for setting up databases. However, you can still set up smaller flat-file (single table) databases with the software. It includes a variety of database functions among which are DMAX and DMIN...

### How to use FV function in Excel spreadsheets [Tip]

FV (Future Value) is a financial function you can add to Excel spreadsheets. This is a function that returns the future value of an investment based on regular periodic payments and a fixed rate of interest. An investment such as ...

### How to use AVERAGEIF function in Excel spreadsheets [Tip]

AVERAGEIF is an Excel 2010/13 function that returns average values based on specified criteria. For example, if you have a data table you can add an AVERAGEIF function to a cell to find average values from one column that match cr...

### How to use MODE and MEDIAN functions in Excel spreadsheets [Tip]

MODE and MEDIAN are two functions you can add to Excel spreadsheets to find averages from a range of values.Mode is the most frequently occurring value from a data range. Median is the middle number in a given set of values. For e...

### How to freely move a picture in Word documents [Tip]

Handling images in Word can be quite tricky. For example, you’ll need a workaround for adjusting image transparency. It can also be difficult to move an image to any place or position that you like. As for the latter, there’s no n...

### How to use MOD and QUOTIENT functions in Excel spreadsheets [Tip]

MOD and QUOTIENT are two Excel 2010/13 functions you can add to spreadsheets to find the remainder and integer portion of a division between values. These are functions that require just two values. Enter a number and divisor to f...

### How to use RANK.AVG and RANK.EQ functions in Excel spreadsheets [Tip]

RANK.AVG and RANK.EQ are new Excel 2010 functions. They aren’t included in other versions except Excel 2013. These functions show you the statistical rank of a value within a list. So the rank tells you their order in a list of va...