THE Ultimate  Excel Portal     [ 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: 9762 - 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
Vertex42 Money Manager
Kaizen Excel Templates
Learn Excel VBA Easily
Employee Payroll Spreadsheet
Viral Growth Forecaster
Excel Training Guides
The Formulator
Financial Modeling Training Program
Customer Invoicing Template
Personal Debt Analyser



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