Learning Outcomes

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 2010.
• 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 2010 applications.
• Use MS Outlook for email messages and attachments, create and manage contacts, schedule appointments and create tasks.