How to Use Database Functions in Excel for Tables and Lists

Database Functions are easy to use. Whether you use DSUM, DCOUNT, DAVERAGE, etc. you use the same three required arguments: Database, Filed, Criteria.

If you use Data Tables or Lists, you probably use Filters to query your list. Now, use a Database Function to capture the total or the average for the results that match your criteria.

Database functions take a few minutes to set-up. You want to create a Criteria Range and to create an area to hold the results of your Database Formulas. Once that is done you have an Excel Dashboard - you can get quick answers about the information in your data table.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to see all of my video lessons and to explore the resources that I offer.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Excel
• Database Functions
• Filters
• Queries
• Criteria Range
• DSUM Function
• tutorials
• Software Tutorial
• Microsoft Excel
• Technology
• Office
• Management
• Training
• Business

[DannyRocksExcels]

@gswslt

My pleasure. I am glad that you enjoyed my tutorial.

Danny Rocks

The Company Rocks

[gswslt]

Excellent work. Thanks for sharing!

[DannyRocksExcels]

@fabiocl123

Thanks for writing! I am pleased that you enjoyed my video and that it helped you!

Danny Rocks

The Company Rocks

[fabiocl123]

Thanksfor sharing your knowledge, the video is really useful!

[DannyRocksExcels]

@myunlu1

Yes, These Functions have been around for a long time. They will work in Excel 2003.

Danny Rocks

The Company Rocks

[myunlu1]

Hi ,

I was wondering if those functions are also available in excel 2003?