MICROSOFT® OFFICE – LEVEL 2 (Word, Excel, Outlook, PowerPoint & Access)
Length
8 weeks
1 session per week
4 hours per session
32 total class hours
Audience
Individuals interested in increasing their proficiency with the major tools in the MS Office suite. Knowledge workers who need to learn new ways of working with and using these essential business applications.
Recommended Prerequisites
Prospective students should be familiar with basic computer terminology, comfortable with the use of the mouse and keyboard, have file management experience, and at least 3 months using Microsoft Office. Participants should have basic typing skills. Familiarity with Windows 7 or 8 is essential.
Topic
Word (3 weeks)
- Creating a Document
- Editing a Document
- Formatting Text
- Formatting Paragraphs
- Adding Tables
- Inserting Graphic Objects
- Controlling Page Appearance
- Proofing a Document
Outlook (1 week)
- Composing Messages
- Organizing Messages
- Managing Contacts
- Scheduling Appointments
- Scheduling Meetings
- Managing Tasks and Notes
Access ( 1 week)
- What is a Database
- Creating A Database
- Using a Table
- Importing and Exporting data.
- Queries
- Forms
Excel (2 weeks)
- Calculating Data with Advanced Formulas
- Organizing Worksheet and Table Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing Workbooks and the Excel Environment
- Create and Use Templates
PowerPoint (1week)
- Working with Objects,
- Changing Colors & Background
- Using Hyperlinks & Special Buttons
- Animated Text, Objects & Charts
- Adding Sound & Video
- Working with Slide Shows
- Creating Content
- Formatting Content
- Collaborating
- Managing & Delivering Presentations