Database Functions

The list of tutorials below cover using Excel database tutorials such as DSUM, DMAX, and DAVERAGE. Each tutorial includes a step by step example to show you how the function works.

Excel DSUM Function Tutorial
The DSUM function is used to add up or sum data that meets specific conditions that you set.

Excel DCOUNT Function Tutorial
The DCOUNT function is used to count the number of records in a database that meet specific conditions that you set.

Excel DAVERAGE Tutorial
The DAVERAGE function is used to find the average value for data that meets one or more specified criteria.

Excel DGET Function Tutorial
The DGET function is used to return a single field of data from an Excel database. A step by step example is included in this tutorial.

Excel DMAX Function Tutorial
The DMAX function can be used to find the largest or maximum number in a database or table of data.

Excel DMIN Function Tutorial
The DMIN function is used to find the fewest or minimum number in a database or table of data. A step by step example is included in the tutorial.

Excel Database Functions Tutorial Data
This document contains data for the Excel database functions step by step tutorials. Instruction are included to explain how to copy the data into a blank worksheet.

Discuss in my forum

Spreadsheets