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: 9287 - 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
ExcelArt
MiniCharts
Production Planning and Scheduling
Interactive Spreadsheet Guide
QueryCell
Kinematics
OpenSystems21
Docstoc.com
Google Docs
TodoExcel



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