Learning Path Includes: – Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) – Excel Cell Reference: Absolute, Relative or Mixed? – Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples – Excel Hack: Copy Formula Without Changing Cell References (or Without File References) – How to set Default Workbook Theme in Excel and how this could help you save time – Excel Filter Basics (for quick data analysis) – Advanced Excel Filter (And, Or, Between conditions for criteria range) – Create SMART Drop Down Lists in Excel (with Data Validation) – Excel Custom Data Validation (Use formulas to check for text, numbers & length) – 3 REALLY Useful Chart Tips You May Have Missed – Excel Header & Footer (& Quickly Copy to other Sheets) – Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort – 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa) – 3 Methods to Unhide All Sheets in Excel (& how to hide) – Excel’s Find and Replace (surprising features) – All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More – Calculate Percentages the Right Way in Excel (% Change & Amount after % increase) – Better Excel Presentations: Increase Font Size of Formula Bar – Change CASE of text in Excel (3 ways including NO Formulas) – Why you SHOULD be USING Custom Number Formatting in Excel – Lock Cells & Protect Excel Worksheet – EVEN by Cell Color! – ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) – The QUICKEST & EASIEST Way to Work with TEXT in Excel – 5 Excel INTERVIEW Questions You NEED to Get RIGHT – Do’s & Don’ts of Excel Spreadsheet Design (with Examples) – Excel Flash Fill For MAJOR Time Saving (7 Examples) – Your Excel Printing Problems, Solved! – Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers) – How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit) – Properly Use Excel IFS Function Course Length: 3:59:44 hours
FAQ
Most frequent questions and answers
Co-operative education is a three-way partnership between the university, students and employers. Students apply their classroom knowledge in a series of four-month work experiences. You, the employer, enhance a student’s education, while reaping the unique benefits of CO-OP employees.
- Year-round access to well-motivated, qualified employees.
- Access to potential full-time staff in a controlled environment, reducing your costs and risks.
- Access to a cost-effective source of temporary employees for peak periods or special projects.
- A say in what students learn by working with the university.
- Promotion of your organization as one that believes in developing the potential of young people.
- Access to a great pool of French-speaking, English-speaking and bilingual students.
Most work terms run at least 15 weeks, or four months. They can be no shorter than 13 weeks. Some master’s students, as well as some science and engineering students, are available for 8 or 12 months’ work terms.
All jobs are reviewed by a CO-OP Program Coordinator, and only those providing students with work experience related to their professional development are approved. Administrative activities involved in a job should be less than 10% of the entire workload.
When you first contact SSC, you are assigned one of our Program Coordinators, depending on your discipline of interest. This person is your main contact in our office. As you move through the recruitment process, you also work with a representative from CO-OP Administrative Services, who assists with job posting and interview scheduling.
Internships offer usually one discipline-specific, supervised, structured paid or unpaid, and for academic credit work experience or practice placement.
Work Experience intersperses one or two work terms (typically full-time) into an academic program, where work terms provide experience in a workplace setting related to the student’s field of study and/or career goals.
Community Service Learning (CSL) integrates meaningful community service with classroom instruction and critical reflection to enrich the learning experience and strengthen communities. In practice, students work in partnership with a community-based organization to apply their disciplinary knowledge to a challenge identified by the community.
Field Placement provides students with an intensive part-time/short term intensive hands-on practical experience in a setting relevant to their subject of study. Field placements may not require supervision of a registered or licensed professional and the completed work experience hours are not required for professional certification. Field placements account for work-integrated educational experiences not encompassed by other forms, such as co-op, clinic, practicum, and internship.
