### 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 copy the content of a text or image file without clicking on it in Windows [Tip]

Let’s just say that you’re editing multiple images using Paint. By default, you can open or bring images to Paint via drag and drop or via the “Open file” command. Now, what if you want an easier and faster option? If you aren’t f...

### 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 Reading List in Project Spartan in Windows 10 [Tip]

If you’re using Windows 8.1, there’s a good chance you’ve heard about an app called Reading List. It’s a Store app that helps you store and organize contents (mostly webpages) from many apps. In Project Spartan, Reading List has b...

### 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 use Reading View in Project Spartan in Windows 10 [Tip]

Continue the series of articles about Project Spartan, today I’ll show you how to use Reading View. It’s one of many new features available in Project Spartan in Windows 10 build 10049. As its name suggests, Reading Vi...

### How to add “Select all” to Windows context menu [Tip]

By default, you can use “Ctrl + A” to select all items in a folder. Alternatively, you can just click the “Organize” folder in the Windows Explorer toolbar. On the menu that appears, just click “Select all” and you’re ready to &he...

### How to disable Flash Player in Project Spartan in Windows 10 [Tip]

As you already know, Project Spartan is the new web browser Microsoft’s building to replace Internet Explorer. It went to public testing last week with a new build of Windows 10. As expected, there are many new features for...

### What’s new in LibreOffice 4.4? [Guide]

LibreOffice is a freeware office suite that includes word processor, presentation, vector drawing, database and spreadsheet applications. It’s based on the same code OpenOffice. LibreOffice has now been updated with a redesi...