CPTR 205 - Intermediate Excel (2)

This course provides students hands-on training using the spreadsheet application MS Excel. Students will gain an in-depth understanding of working with spreadsheet data in ranges, functions, and charts. This course includes the application of custom formatting, audit worksheets, the use of macros, templates, multiple workbooks, and importing/exporting data. Also included in this course are data base features to extract and filter data, use data analysis, pivot tables, data validation, and data protection.