Excel L2 builds on L1 where students learned to navigate the various bars. In L2 students work with conditional formatting making worksheets more visually useful. Managing data by finding and removing duplicates. Exposure to data validation tools to make efficient input. In L2, students are introduced to filtering. Advanced data management techniques are explored. Advanced use of formulas and starting to build customized commands. Application of absolutes in formulas and usage of named cell ranges. Pre-requisite - some exposure to Excel. The course is offered virtually, and, with logistics permitting, in person. Courses are instructor led with students encouraged to bring practical workplace situations to class as learning examples.
