ITM 340 Excelling with Excel

This hands-on course provides students with an intermediate to advanced-level understanding of Excel, preparing them to organize and evaluate quantitative data for personal and managerial decision-making. The course covers the Excel skills necessary for the Microsoft Office Specialist (MOS) Excel Associate Certification and many needed for the MOS Excel Expert Certification. Specifically, the course covers creating formulas that use functions and work with cells, ranges, arrays, and tables, referencing data on worksheets and other workbooks, manipulating data, validating data, creating pivot tables, creating graphs, and creating simple macros. Techniques to improve workbook maintainability and reuse are also explored.

Credits

4

Prerequisite

Prerequisite: ITM 220

Offered

summer semester.