Learn how to be productive with MS Word, MS Excel, MS PowerPoint, and MS Access in the latest version of Microsoft Office. Understand essential skills, from the fundamentals through to intermediate levels of Word and Excel. This instructor lead, 'hands-on' course makes use of lectures, exercises and labs in class, plus assignments outside of class hours. MS Office integration, linking and embedding data between applications is also covered. By the end of this course, successful participants will be able to create and work with documents, spreadsheets, presentations, and simple databases. With additional self-study, students will be prepared to move on to COMP 2361 MS Word Advanced and COMP 2362 MS Excel Advanced.
COMP 1002 or equivalent knowledge of MS Windows and File Management.
This is an intensive two week delivery of a twelve week course. Attendance is required every weekday morning. There is a significant amount of homework, reading and practice required every day after class. For some students this could mean 20+ hours of homework each week. Please do not attempt any other course at the same time as this two week (10 day) accelerated course.
Upon successful completion of this course, the student will be able to:
Identify and use features that are common to all applications in Microsoft Office 2013.
Create, edit, format, print, save, close and open files using MS Word, MS Excel, and MS PowerPoint.
Apply font, paragraph, page formatting, bullets and numbering to documents, workbooks and presentation.
Insert headers, footers, set tabs, format text into multiple columns or tables and apply formatting to cells, rows or columns.
Create formulas using addition, subtraction, division, multiplication, and common statistical functions: Sum, Average, Median, Min, Max, Count and the PMT financial function.
Create, modify, and format column and pie charts and insert sparklines.
Modify slide elements, apply animation schemes, themes, and transitions in MS PowerPoint presentations.
Insert and modify clipart or pictures; insert, create and modify SmartArt or WordArt in documents or presentations.
Define MS Access database components, tables, forms, queries and reports, edit, add and delete records.
Create filters and sort data in MS Access and MS Excel.
Embed, copy, paste or paste link and update data between Microsoft Office applications.
Perform a mail merge to create and personalize form letters, envelopes or labels using an Excel or Access data source.
COMP 2010 is offered as a part of the following programs:
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 2010 - Microsoft Office 2013?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.