Knowledge of Intermediate Microsoft Excel (CE9 138) recommended.
Topics cover the match and retrieve "Vlookup" function, name ranges to label and access data sets, macros to automate steps, and nested "IF" functions to leverage more complex function usage. Various examples and data sets will be used. ONE DAY WORKSHOP. Bring lunch.