Excel DMIN Function
Monday September 24, 2012
Excel's database functions are designed specifically to work with an Excel database file.
For the most part, these functions are variations of commonly used Excel functions such as SUM, AVERAGE, ... Read More
Round Down to the Nearest Integer in Excel
Monday September 17, 2012
Excel has a number of functions to help you round numbers, and each one does a slightly different job.
One of these, the INT function, will round data down ... Read More
Excel DCOUNT Function
Friday September 14, 2012
Excel DCOUNT Function© Ted French
DCOUNT is one of Excel's database functions.
This group of functions makes it easy to find specific information in an Excel database file.
DCOUNT's job ... Read More
Sort Data by Color in Excel
Wednesday September 12, 2012
Usually data in Excel is sorted by such things as names, titles, or values.
Another, lesser known, option is to sort data by color - either font color or the background ... Read More
Entering Data into a Database
Monday September 10, 2012
If you have ever kept a database file in Excel you'll know that the program does a great job. Whether you have a contact list for an organization, an ... Read More