Conestoga College Logo - Home Page

Advanced Excel Applications (Part-time)

Credential:
Certificate
Program Code:
1190
School:
Engineering & Information Technology

About the Program

Graduates of this 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.

Program Information

All courses must be completed within 3 years of acceptance into the program.

Admission Requirements

Note re: Admission Requirements

Admission Procedures

Program Requirements

How to Apply

Students may obtain a Conestoga College Program Application Form from any Conestoga College campus, OR by writing directly to the Registrar's Office, OR by using the college website at www.conestogac.on.ca/admissions/forms

Send completed applications to:
Conestoga College
Admissions Office
299 Doon Valley Dr
Kitchener, Ontario
Canada N2G 4M4

How to Register for Courses

Go to How to Register for detailed registration information.

Prior Learning Assessment and Recognition (PLAR)

Conestoga recognizes prior learning of skills, knowledge or competencies that have been acquired through employment, formal and informal education, non-formal learning or other life experiences. Prior learning must be measurable at the required academic level and meet Conestoga standards of achievement for current courses. Challenge exams and portfolio development are the primary methods of assessment. Other methods of assessment may be available depending upon the nature of the course objectives. Successful completion of the assessment results in an official course credit that will be recorded on the student's Conestoga transcript. PLAR cannot be used by registered Conestoga students for the clearance of academic deficiencies, to improve grades or to obtain admission into a program.

Learn more about PLAR.

Graduate Opportunities

For more details on related occupations, job market information and career opportunities, see the Government of Canada website: http://www.workingincanada.gc.ca

Program Related Resources

Program Outcomes

Program Courses

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the status column will open a new browser tab or window in the Student Portal.

Course Information
Course Code Course Title Status
COMP1245 Excel VBA and Macros - Advanced
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
Pre-Requisites:
CoRequisites:
Details
COMP1340 Excel VBA and Macros - Introduction
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
Pre-Requisites:
CoRequisites:
Details
COMP1911 Excel
Description: This course takes you beyond the basics to cover intermediate spreadsheeting concepts and techniques using Excel. 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
Pre-Requisites:
CoRequisites:
Details
COMP1912 Excel - Advanced
Description: 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
Pre-Requisites:
CoRequisites:
Details
Annual Delivery Schedule
Course Code Course Title Spring Fall Winter
COMP1106 Excel 2013 X X X
COMP1112 Excel 2013 – Advanced X X X
COMP1245 Excel VBA & Macros – Advanced X X X
COMP1340 Excel VBA & Macros – Introduction X X X
Online Equivalencies
Course Code Course Title Online Code Online Course Title
COMP1106 Excel 2013 OLRN1293 Excel
COMP1112 Excel 2013 – Advanced OLRN1303 Excel Expert

Note:
All efforts will be made to adhere to this schedule, however the college reserves the right to make adjustments when necessary.
* To learn more about online course offerings, visit Distance Learning - OntarioLearn.

Disclaimer

The College reserves the right to alter information including requirements and fees and to cancel at any time a program, course, or program major or option; to change the location and/or term in which a program or course is offered; to change the program curriculum as necessary to meet current competencies in the job market or for budgetary reasons; or to withdraw an offer of admission both prior to and after its acceptance by an applicant or student because of insufficient applications or registrations, over-acceptance of offers of admission, budgetary constraints, or for other such reasons. In the event the College exercises such a right, the College’s sole liability will be the return of monies paid by the applicant or student to the College.

Students actively registered in cohort delivered programs who take longer than the designed program length of time to complete their studies are accountable for completing any new or additional courses that may result due to changes in the program of study. Unless otherwise stated, students registered in non-cohort delivered programs must complete the program of study within seven years of being admitted to the program.

SEARCH PART-TIME (PT)

Program Contact

Carol Schlievert, cschlievert@conestogac.on.ca 519-748-5220 ext. 2390

Videos

Part-time Studies video
More videos

Success Stories

Back To Top