WTF Toshiba?
Look at the photo to the right. That notice was used as a seal on the plastic bag (which was inside a box) that my recently purchased Toshiba laptop came in. Essentially, the notice says Toshiba has the right to (spy on me) and I ...
Tag Archives: Windows Tips and Tricks
How to find the motherboard number in Windows [Tip]
You might need your motherboard number to check hardware compatibility or update drivers. There’s a few ways to check that number. You can do that with the Command Prompt or freeware software such as Speccy. Checking Model N...
A brief guide to the Contacts folder in Windows [Tip]
The Contacts folder is one of the more unique folders in Windows. It’s a folder that doesn’t have an exact path, so applications can find it. This folder is a full-fledged contact manager that you can keep your contact...
How to use Facebook Messenger as a standalone desktop app [Tip]
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 ...
How to add Windows 10 icons to Windows 7/8 [Tip]
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...
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...