Microsoft Excel 2007 Tutorial





Español Français 中文 Deutsch Portuguese Japanese nederlands
   
 
Learn MS Excel
css tutorials Introduction
Database Functions Database Functions
Date & Time Functions Date & Time Functions
Engineering Functions Engineering Functions
Financial Functions Financial Functions
Information Functions Information Functions
Logical Functions Logical Functions
Lookup Functions Lookup Functions
Math Functions Math & Trigonometry Functions
Statistical Functions Statistical Functions
String Functions Text Functions
Forums Ask Your Doubts
Feedback Feedback
 

Database Functions

Description

Below listed are the various database functions of Microsoft Excel.

Daverage():

DAVERAGE function is used to calculate the average of items from a database range.

Dcount():

DCOUNT function is used to calculate the count of items from a database range.

Dcounta():

DCOUNTA function is used to find the count of items from a database range.

Dget():

DGET function returns a single result from a database range.

Dmax():

DMAX function is used to find the maximum value from a list of items from a database range.

Dmin():

DMIN function is used to find the minimum value from a list of items from a database range.

Dproduct():

DPRODUCT function returns the product of the items in the table/database.

Dstdev():

DSTDEV function is used to calculate the Standard Deviation based on a sample.

Dstdevp():

DSTDEVP function is used to calculate the Standard Deviation based on the entire population.

Dsum():

DSUM function is used to find the sum of a list of items from a database range.

Dvar():

DVAR function is used to find the variance of a list of items from a table/database range.

Dvarp():

DVARP function is used to find the variance of a list of items from a table/database range.









A Note

Simple online tutorial to learn Microsoft (MS) Excel 2007 functions and formulas with video tutorials. Hope you enjoy learning this tutorial. We welcome your valuable feedbacks or suggestions about this Excel tutorial. This is a copyright content.


Other Links

web hosting