Advanced Excel Functions Tutorial
Useful Resources
Selected Reading
- Statistical Functions
- Math & Trignometric Functions
- Lookup & Reference Functions
- Advanced Excel Functions - Logical
- Information Functions
- Financial Functions
- Engineering Functions
- Date & Time Functions
- Database Functions
- Advanced Excel Functions - Cube
- Compatibility Functions
- Advanced Excel Functions - Home
Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Database Functions
Advanced Excel - Database Functions
The Excel Database functions work with an Excel Database. This typically takes the form of a large table of Data, where each row in the table stores an inspanidual record. Each column in the Worksheet table stores a different field for each record.
The Database functions perform basic operations, such as Sum, Average, Count, etc., and additionally use criteria arguments, that allow you to perform the calculation only for a specified subset of the records in your Database. Other records in the Database are ignored.
Database Functions
The following table psts all the Database functions −
| S.No. | Function and Description |
|---|---|
| 1 |
Averages the values in a column of a pst or database that match conditions you specify. |
| 2 |
Counts the cells that contain numbers in a column of a pst or database that match conditions you specify. |
| 3 |
Counts the nonblank cells in a column of a pst or database that match conditions you specify. |
| 4 |
Returns a single value from a column of a pst or database that matches conditions you specify. |
| 5 |
Returns the largest number in a column of a pst or database that matches conditions you specify. |
| 6 |
Returns the smallest number in a column of a pst or database that matches conditions you specify. |
| 7 |
Multippes the values in a column of a pst or database that match conditions you specify. |
| 8 |
Estimates the standard deviation of a population based on a sample by using the numbers in a column of a pst or database that match conditions you specify. |
| 9 |
Calculates the standard deviation of a population based on the entire population, using the numbers in a column of a pst or database that match conditions you specify. |
| 10 |
Adds the numbers in a column of a pst or database that match conditions you specify. |
| 11 |
Estimates the variance of a population based on a sample by using the numbers in a column of a pst or database that match conditions you specify. |
| 12 |
Calculates the variance of a population based on the entire population by using the numbers in a column of a pst or database that match conditions you specify. |