Vertex42 - Niche Excel SolutionsThe Excel Nexus
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: (7 votes) - Details - Added: 06-02-2004 - Hits: 6073 - 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
EasyFitXL - Distribution Fitting
Ayuda Excel
SimpleShortcuts Excel Add-In
Trim Spaces for Excel
Merge Tables Wizard for Excel
Duplicate Remover for Excel
RedRover Audit
Project2Excel
Investment Calc Pro
Sobolsoft Add-Ins



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