Advanced Excel Applications (Part-time)
- Program Code:
- Engineering & Information Technology
About the ProgramGraduates 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 InformationAll courses must be completed within 3 years of acceptance into the program.
- Ontario Secondary School Diploma (OSSD) or equivalent, OR 19 years of age or older.
Note re: Admission Requirements
- Students must be able to receive instruction, respond and research in the English language.
- Submit a completed Conestoga College Program Application Form.
- Attach proof of Admission Requirements.
- Final selection is made following an assessment of the admission requirements.
- Credit will be given for any qualifying course that was successfully completed up to two (2) years prior to admission into the program.
How to ApplyStudents 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:
299 Doon Valley Dr
Canada N2G 4M4
How to Register for CoursesGo 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 OpportunitiesFor more details on related occupations, job market information and career opportunities, see the Government of Canada website: https://www.jobbank.gc.ca/home
Program Related Resources
- Enter and edit text, numbers and functions into cells.
- Create Excel spreadsheets using advanced features such as multi-sheet models, linking and embedding and using macros.
- Perform advanced functions to manipulate dates, perform conditional operations and look up values in tables.
- Use advanced functions of Excel.
- Macro creation on an advanced level such as form validation, importing and exporting and menu creation.
- Create user-define functions for use in the worksheet.
- Use Debugging Tools.
- Create and control custom Toolbars.
- Create recorded Macros in Excel.
- Work with the main components of the VBA Editor window.
- Write code to manipulate Excel objects.
- Create procedures that start automatically.
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 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.
|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.
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.
|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.
|Course Code||Course Title||Spring||Fall||Winter|
|COMP1112||Excel 2013 – Advanced||X||X||X|
|COMP1245||Excel VBA & Macros – Advanced||X||X||X|
|COMP1340||Excel VBA & Macros – Introduction||X||X||X|
|Course Code||Course Title||Online Code||Online Course Title|
|COMP1112||Excel 2013 – Advanced||OLRN1303||Excel Expert|
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.
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.