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

How to add bullets Point in MS-EXCEL

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal

0 0

PowerPivot For Excel

PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

ITech Analytic Solutions

0 0

Sparklines

Sometimes you may want to analyse and view trends in your data without creating an entire chart. Sparklines are miniature charts that fit into a single cell. A Sparkline is a tiny chart in a worksheet...

Saburudeen MA

0 0

What is Big Data and Why Do Organizations Need It?

Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s...

ITech Analytic Solutions

0 0

Functions in Advanced MS Excel

Introduction to Advanced Excel: Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References,...

Sla Consultants India

0 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

Are there any excel and VBA coaching centres at As Rao Nagar?

15 Answers

How can I learn MS Excel from the beginning to the advanced level, online?

5 Answers

How to write macros in excel?

11 Answers

How many columns can be created in MS Excel?

5 Answers

How to use the h look up in excel worksheet ???

24 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.