If you’ve read the previous post, then you’re already aware that Facebook has officially released a web version of its Messenger app for mobile devices. The thing is you need to go to the official Messenger link just so you could ...
Windows 10 is the next installment to Microsoft’s OS series. You can try out technical previews of the software from this page. Microsoft are bringing back the Start Menu and adding a variety of new tools to the latest OS. W...
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 ...
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 ...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
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 do ...
