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

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 Like 0 Dislike

Follow 0

Other Lessons for You

HTML (Hypertext Markup Language)

HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

ITech Analytic Solutions

1 0

Learning Pivot Table Part-1

You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...

Kaustubh Chavan

1 0

INITIAL STEP FOR EXCEL

IT BECOME ITSELF LOOK LIKE A TABLE, THERE HAVE MANY CELL IN ROWWISE OR COLUMNWISE. FIRST YOU THOUGHT THAT WHAT TYPE OF DATA IS AND HOW YOU DESIGN.

Deepak Kumar Jha

0 0

What is a VBA Module?

VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

ITech Analytic Solutions

0 0

How to Create Dynamic List in MS Excel?

In Dynamic list 1 contains a drop down which contains "Butcher", "Baker" and "Handyman".

Ally T.

2 0

Find Microsoft Excel Training classes near you

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

Microsoft Excel Training Questions

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

Should beginners learn excel VBA training online?

19 Answers

How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.....

60 Answers

What is the difference between an MS word, an MS Excel, and an MS PowerPoint?

5 Answers

How to write macros in excel?

11 Answers

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

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.