Today's Data Hack takes you back to basics to make the most out of Excel. You don't need to be a scientist in order to sort and analyze data in a basic way. Check out this short overview of database functions that will help you parse information from lists:
DCOUNT - Count the number of cells with values
DMAX - Finds the largest value in a list
DMIN - Finds the smallest value in a list
DSUM - Calculate the sum of values matching criteria
These functions as use a three-argument syntax. Here is an example:
=DAVERAGE(database,field,criteria)
