true

Learn Microsoft Excel Training from the Best Tutors

• Affordable fees
• 1-1 or Group class
• Flexible Timings
• Verified Tutors

Search in

# Excel Database Functions List

U
Uma Sahu
16/01/2017 0 0

## Excel Database Functions List

 Database Functions DAVERAGE Calculates the average of values in a field of a list or database, that satisfy specified conditions DCOUNT Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions DCOUNTA Returns the number of non-blank cells in a field of a list or database, that satisfy specified conditions DGET Returns a single value from a field of a list or database, that satisfy specified conditions DMAX Returns the maximum value from a field of a list or database, that satisfy specified conditions DMIN Returns the minimum value from a field of a list or database, that satisfy specified conditions
 Database Functions DPRODUCT Calculates the product of values in a field of a list or database, that satisfy specified conditions DSTDEV Calculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions DSTDEVP Calculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditions DSUM Calculates the sum of values in a field of a list or database, that satisfy specified conditions DVAR Calculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions DVARP Calculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditions

0 Dislike

## Other Lessons for You

VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Create A Time Sheet In Ms Excel
The following tutorial is about creating a Time-Sheet using MS Excel. Steps: Arranging data, Formulas to analyze data points.
P

Pranav T.

Learning Tip
1. The foundation: a productivity systemLet’s face it, without a solid foundation there is no way you can expect to build new skills and form new habits. My first tip therefore is to adopt a productivity...

Dynamic HyerText Markup Language (DHTML)
Dynamic HyerText Markup Language (DHTML) is a combination of Web development technologies used to create dynamically changing websites. Web pages may include animation, dynamic menus and text effects....

VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

### Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

X

### Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

• Select the best Tutor
• Book & Attend a Free Demo
• Pay and start Learning

### Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro