Advanced Spreadsheet Techniques
CIS-2228
|
|
Advanced Spreadsheet Techniques CIS-2228 |
Course Description: Provides a study of spreadsheets. Topics include: advanced spreadsheet concepts; development of macros; data integration concepts; and troubleshooting spreadsheets.
| Class hours per week: | 4 |
| Lab hours per week: | 4 |
| Course credit hours: | 6 |
| Course prerequisites: | SCT-100 |
|
Current Textbook |
|
|
|
Microsoft Excel 2003, comprehensive
edition Parsons, Oja, Ageloff, Carey , Authors ISBN: 0-619-26815-8 Thomson Publishers Reference material for this textbook may be found at www.course.com |
Things to expect in this class: This course is dedicated completely to spreadsheets. After a quick review of the basics, we will explore advanced techniques such as VBA (Visual Basic for Applications), integrating HTML with spreadsheets and look-up tables as well. We will explore macros, autofilters and list management techniques. We will explore the most powerful features of Excel, pivot tables, Solver, and goal seeking. We will play with OLE techniques and do some Internet web queries. This course will round out your spreadsheets skills. Expect several projects and written tests about every other chapter.
Click here to view the current course syllabus.
last updated on 03/22/2005
