Excel doesn’t have a word count, but the LEN function is something that counts text characters in cells. That counts all the text in a selected cell and returns the value. In addition, you can also combine the LEN formula wi...
If you enter numbers with lots of decimals into spreadsheets, you can round them off to integers (whole numbers) in a couple of ways. Firstly, Excel has cell formatting options that round numbers. In addition, Excel also includes ...
Excel is not the best software package to set up databases with. However, you can still set up effective flat-file (single table) databases with the application. Excel 2010/2013 includes database functions such as DAVERAGE and DSU...
The Windows Explorer Send to menu gives you a shortcut to move folders and documents. Windows 7 also has an Extended Send to menu that includes extra options and shortcuts. This is how you can open and customize the Extended Send ...
There are numerous plug-ins available for Windows Media Player that add more to the software package. Windows Media Player Plus is a plug-in that adds various enhancements to the program. For instance, with that plug-in you can ac...
The Windows Media Player supports a variety of video and audio formats. However, there are still a number of audio and video formats that it doesn’t support among which are FLAC and DivX. To play more media formats in WMP, c...
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...
Previous articles have covered how you can obtain color codes from images. However, it would be better if you could obtain color codes from any area of a website page. You can do exactly that with the Pick That Color add-on for Fi...
