Spreadsheet Design & Production

This 14-week course is designed to equip students with the fundamental skills needed to proficiently navigate and design spreadsheets using industry-standard software. Through a combination of independent study and collaborative group work, participants will develop a comprehensive understanding of spreadsheet design principles and practical applications. Specifically, students will learn to design, build, and navigate basic spreadsheets for a variety of uses; apply and update formatting tools such as themes and cell styles; create and edit formulas depending on a variety of mathematical operations; master basic and intermediate functions such as SUM, AVERAGE, COUNT, COUNTA, IF; sort and filter data; and determine which charts are appropriate to create, edit, and format based on data selection. Students will also learn the basics of cell addressing; inserting and editing graphic elements to enhance their spreadsheets; as well as how to use LOOKUP functions and the basic What-If analysis features.