Excel Database Functions

Excel has some useful database functions so that you can extract information from a list or database. It allows you to set criteria such as to find a particular product and then sum up the values based on that criteria. For example, you might have a list of stock and how many you have in stock for particular items, by using DSUM you could add up the quantities to see the total amount in stock.

Here is a video tutorial to show you how it works using DSUM, DAVERAGE, DMAX and DMIN to find totals, average, highest and lowest values in a list.