Intermediate Level Spreadsheeting Skills: Assessing and Organizing Data

This intermediate spreadsheeting course uses Microsoft® Excel to assess and organize data in an electronic format. The class is designed for learners who have experience using Excel and who want to increase their spreadsheeting knowledge and skills.

Key concepts covered in this course include:
     • Relative, absolute, and mixed cell referencing
     • Text, date, and time-based functions and formulas
     • How to nest functions
     • Management of delimited data
     • VLOOKUP and XLOOKUP
     • Dynamic arrays

This course is only available to ICAC task force member and affiliate agencies.