Skip to content Skip to footer site map

COMP 45

This course covers Excel from basics to advanced topics. It is designed to introduce students to electronic spreadsheets and then introduces more advanced features of Microsoft Excel. During the course students will create simple spreadsheets using the four building blocks of cell content: labels, values, formulas and functions. Students will also gain skills in visually formatting the spreadsheet and creating simple charts. Students will create spreadsheets using more complex functions including arithmetic on date values; managing multi-sheet workbooks; incorporating protection within the workbooks and use filtering of data in tables. Advanced topics in Excel includes: creating automated worksheet tasks, What-If analysis, Pivot Tables, exchanging data with other programs and programming in VBA.