Learning objectives: – Learn your way around the Excel 2010 environment. – Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions. – Learn how to modify rows, columns, and cells in Excel. – Learn all about formatting text in Excel. – Learn how to use the Save and Save As commands, save as a PDF, and save as an Excel 97-2003 compatible workbook. – Learn how to create a simple formula in Excel. – Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets and freeze rows and columns. – Learn how to preview your spreadsheet, modify margins, change page orientation, and print. – Learn how to create a complex formula in Excel. – Learn how to use functions to find values for a range of cells. – Learn how to sort data to better view and organize the data in your spreadsheet. – Learn how to outline your worksheet to summarize and control how your data is displayed. – Learn how to filter the data in your worksheet to display only the information you need. – Learn how to use styles to format tables in Excel. – Learn how to track changes, add comments, compare two versions of a worksheet, and share a worksheet. – Learn how to create a new workbook using an Excel template. – Learn how to insert and modify Excel charts to communicate information. – Learn how to insert sparklines and change their type and appearance. – Learn how to apply, modify, and delete conditional formatting rules in Excel. – Learn how to use PivotTables in Excel for stronger data analysis. – Learn how to use what-if analysis to answer different types of questions. – Learn how to merge copies of a shared workbook in Excel. – Learn all about using reference styles in Excel. – Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice. – Use these free resources to better work with and manipulate data in Excel. – Test your knowledge of Excel by taking our quiz.
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.
