THE Ultimate  Excel Portal         LINKS:  [ Popular | New | Editor's Picks | Top Rated ]
Home >> Excel Tutorials >> Excel Database

Excel Database

:: 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!




Links in This Category: 1
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]
Rating: (11 votes) - Details - Added: 06-02-2004 - Hits: 8867 - Error?

Similar Categories
Pivot Tables
 
Main Categories
Excel Add-ins
Excel Help
Excel Password Recovery
Excel Templates
Excel Tips & Tricks
Excel Tutorials
Excel VBA
Free Excel Add Ins
Spreadsheet Research
Create Excel Dashboard Reports with Plug-N-Play Reports
Newest Links
Ultimate Gradebook Template
Waterfall Chart Utility
Dot Plot Utility
Marimekko Chart Utility
Cluster Stack Chart Utility
Box and Whisker Plot Utility
Workbook Comparison Tool
Arixcel Accounts - Personal Finance Tool
Arixcel
ActiveData For Excel



Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.