BTS 155 Spreadsheets: Advanced Functions and Formulas • 1 Cr.
Develops worksheets using advanced functions and formulas such as IF, AND, OR, COUNTIF, SUMIF, LOOKUPS including nested functions and formulas, using spreadsheet software. The entire series of BTS 151, 152, 153, 154 and 155, with no omissions, is equivalent to BTS 165. Recommended: BTS 161 or equivalent experience.
After completing this class, students should be able to:
- The student will be able to develop a worksheet using nested ifs, and/or functions, countif function and sumif function using spreadsheet software.