If you need to find the maximum and minimum values from a range of Excel spreadsheet cells, the MAX and MIN functions will come in handy. The MAX function returns the highest value from a range of cells. You can add the MIN functi...
If you use Excel spreadsheets to enter chemical equations in, you should add subscript formatting to the formula’s molecules. Subscript formatting is a number, figure or symbol that is smaller than the standard font type. Ch...
Windows Media Player has a variety of plug-ins that you can add to it. Among them is the Lyrics Plugin that adds lyrics to Windows Media Player. So when you play the song in Windows Media Player, the lyrics are shown in the Now Pl...
Most word processors have options to change the font color with. MS Word 2010 also includes a variety of gradient options. With those options you can add color gradients to text in MS Word documents. Open MS Word 2010/13, and then...
CELL is an Excel 2010 function that you can add to spreadsheet cells. The function does not calculate anything, but instead gives you further details for spreadsheet cells. With the function you can find out cell color, width, add...
CONCATENATE is an Excel function that you can add to spreadsheets to merge cells together. The function merges both text and numbers in alternative cells into one. As such, with CONCATENATE you can quickly merge columns and rows i...
A pictograph is a graph with pictures. The number of pictures in the graph shows you a specific value. Excel 2010 does not include any direct options to set up pictographs, but with a little customization you can convert bar graph...
The basic SUM function in Excel is sufficient for adding a variety of numbers across a range of cells. However, what if you only need to add a few numbers that match a specific criteria from a range of cells? If that is so, add th...
Windows Sticky Notes are a handy accessory that you can stick notes to the desktop with. Although it might seem that they have little in the way in formatting options, there are, in fact, many ways that you can format them. For ex...
Aero is the glass effect in Windows Vista and 7 that you can select to turn on/off from system properties. However, you can set up an Aero On/Off shortcut in Windows. With this registry tweak you can add Aero On/Off options to the...
Keeping backups will ensure that you don’t lose files. As such, there are a multitude of utilities you can set up backups with. Not many of those utility packages include options to schedule backups with. Cyoteck CopyTools i...
As Microsoft starts pulling Windows and Windows Phone (WP) together, we already have seen so many features from WP that made their way to Windows 10. With that being said, the latest one in Windows 10 TP build 9926 is Offline Maps...
The Windows Start Menu includes a user account picture at the top. Windows doesn’t include any option to remove the user account picture, but you can still do that with Classic Shell. That’s a software package which in...
Let’s just say that you took a screenshot or photo. You want to share your photo on a website with public access but you do not wish to reveal any of the sensitive data included in your photo (ex. name, address, bank account numbe...
Excel includes a Move or Copy option that enables users to move or copy a worksheet with all its formatting and data intact. So if you ever need to set up a new Excel worksheet based on a spreadsheet in another workbook, you can q...
