ObjectivesGraduates of this part-time certificate program will have acquired the skills and knowledge to function in an environment that relies heavily on the use of electronic spreadsheets for financial, databasing, multi-sheet models and macros. Students completing the requirements for this certificate in spreadsheet applications should be thoroughly familiar with all the major functions and formulas.
Course descriptionCOMP1245 Excel Macros Level I
Description: Recommended: COMP1310 Excel Advanced or equivalent knowledge.
This course will teach you how to create macros, user defined functions, understand the VBA environment and use a range of programming techniques to develop automated solutions in Excel.
Hours: 36
Credits: 3
COMP1310 Excel - Advanced
Description: Recommended: COMP1100 Excel or equivalent knowledge. This course builds on the knowledge gained in the Excel course. Emphasis will be placed on organizing and consolidating data with efficient multi-sheet models; applying arrays and formulas to new and powerful uses; working in an OLE (Object-Linking and Embedding) environment; recording and editing macros; advanced charting; utilizing scenarios; pivot tables; and finding the best solution using Solver.
Hours: 36
Credits: 3
COMP1340 Excel - Business Applications
Description: Recommended: COMP1310 Excel - Advanced or equivalent knowledge.
This course is intended to advance a student's knowledge of how to approach and develop spreadsheet applications. Topics include: understanding and developing macros; transaction processing; user-specific forms; importing and exporting across operating system platforms; templates; and application development using Visual Basic for Applications (VBA). Course assignments will be based on business applications.
Hours: 36
Credits: 3
COMP1475 Excel 2007
Description: Recommended: COMP1150 Computer Literacy for Windows or equivalent knowledge.
This course takes you beyond the basics to cover intermediate spreadsheeting concepts and techniques using Excel 2007. Students will learn how to produce professional workbooks. Emphasis will be placed on: planning and creating spreadsheets using formulas and functions; data analysis; generating graphs; and, linking summarizing and consolidating worksheets.
Hours: 36
Credits: 3