Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Specifying Database Criteria

 -

Data > Form Dialog Box

 -

Data > Form Shortcut Keys

 -

Automatic Subtotals

Worksheet Functions

 -

DAVERAGE - Returns the average of the numbers in a database column satisfying a condition.

 -

DCOUNT - Returns the number of values in a database column satisfying a condition.

 -

DCOUNTA - Returns the number of values in a database column satisfying a condition.

 -

DGET - Returns the single value from a database column satisfying a condition.

 -

DMAX - Returns the largest number in a database column satisfying a condition.

 -

DMIN - Returns the smallest number in a database column satisfying a condition.

 -

DPRODUCT - Returns the product of all the values in a database column satisfying a condition.

 -

DSTDEV - Returns the standard deviation of numbers in a database column satisfying a condition.

 -

DSTDEVP - Returns the standard deviation of numbers in a database column satisfying a condition.

 -

DSUM - Returns the total of all the values in a database column satisfying a condition.

 -

DVAR - Returns the variance of numbers in a database column satisfying a condition.

 -

DVARP - Returns the variance of numbers in a database column satisfying a condition.

Advanced

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Related Topics

 -

Importing & Exporting

 -

Lists