In this course, learners build on intermediate level Microsoft Excel skills. They explore the purpose and function of three-dimensional (3D) and external references. Learners apply sorting, filtering, grouping, and subtotaling features to spreadsheet data and its validation. They examine more advanced logical functions used to test for the presence of and various combinations of data (if, and, or). Learners consider special formatting features that enhance tables and charts. Upon completion of the course, learners will be able to analyze, manipulate, organize, and visualize data.
Instructor Arlene Roche
Tuesdays, 9/7, 9/14, 9/21 & 9/28/21
8:00 am - 10:00 am
Instructor will contact you with the Zoom information