You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates
Excel Database
Links in This Category: 1
:: Examples and tutorials for using an Excel database. Excel database functions include DCOUNT, DSUM, DGET, and DAVERAGE to name just a few.
:: An Excel List can be used as a database, and you can get really fancy by using external data. Pivot tables can be used to summarize data in a database. All these advanced techniques are just begging for tutorials!
:: An Excel List can be used as a database, and you can get really fancy by using external data. Pivot tables can be used to summarize data in a database. All these advanced techniques are just begging for tutorials!
| Using DSUM for Conditional Summation www.grbps.com | |
| This article explains how to use the DSUM database function in Excel instead of complicated nested SUM and IF formulas. [PDF Format] | |
|
Added: 06-02-2004 - Updated: 06-03-2004 - Hits total: 10391
| |
Similar Categories
Pivot Tables