Spreadsheets

View Schedule

All courses require an understanding of Windows file management, creating files, deleting files, moving files and copying files from a network drive to floppy and vice versa. All courses require purchase of a textbook and diskette at the bookstore.

Excel Level 1
MC4-464
Fee: $199
Prerequisite: Windows or equivalent.
Textbook and Diskette required.

Course Content

• Starting and navigating in Excel
• Modifying a worksheet
• Improving the appearance of a worksheet
• Entering formulas in a well-designed worksheet
• Working with functions
• Sorting, filtering, and editing lists 
• Working with Charts
• Developing a multiple-sheet workbook

Excel Level 2
MC4-465
Fee:  $199
Prerequisite: Excel XP Level 1 or equivalent.
Textbook and diskette required.

Course Content

• Creating special effects in a worksheet
• Working with custom formats, Autoformats, Styles and templates

• Documenting and protecting worksheets and workbooks

• Integrating applications
• Using functions to create data
• Guiding cell entry with data validation
• Creating PivotTable and PivotChart reports
• Creating hyperlinks and using collaborative tools