After completing this chapter, you will be able to:
| SLO 6.1 | Use database functions such as DSUM, DAVERAGE, and DCOUNT. |
| SLO 6.2 | Build AND, OR, and other logical functions and use nested functions. |
| SLO 6.3 | Use Lookup & Reference functions such as INDEX and MATCH. |
| SLO 6.4 | Build statistical calculations such as MAD, MSE, and STDEV.S. |
| SLO 6.5 | Use financial functions such as PV, FV, and NPV. |
| SLO 6.6 | Use text functions such as CONCATENATE, EXACT, and REPLACE. |
| SLO 6.7 | Use multiple criteria in functions such as SUMIFS, AVERAGEIFS, and COUNTIFS. |
| SLO 6.8 | Use the Watch Window and Find and Replace. |