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