Excel: Formulas & Functions (Intermediate Excel)
Thursday, October 28, 2021 4:00-6:00- Marcie Anszperger from the Center for Teaching Advancement & Assessment Research (CTAAR) Topics to be covered: Review of formula & function tools Quick review: Absolute vs. relative cell references Solving problems using different formula/function techniques Function auditing tools VLOOKUP & HLOOKUP Conditional statements Basic text functions Nested functions Understanding … Read More