Course Description
In Microsoft® Office Essentials 2007, you will learn how to streamline repetitive tasks and display data in more visually effective ways. In this course, you will use Microsoft Word, Excel, Outlook and PowerPoint to streamline and enhance your documents with templates, charts, graphics, and formulas. Also, you will learn how to use the products together to create efficiencies.
This course will also cover over 100 Office shortcuts that will help save you time.
Target Student: The target students for this course are people who desire to gain the skills necessary to create templates, modify business documents, sort and filter data, import and export data, analyze data, customize your Office efficiency tools.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Performance-Based Objectives - Upon successful completion of this course, students will be able to better utilize the Office 2007 Suite.
Specific Lessons include:
-
calculate with advanced formulas
-
organize worksheet and table data using various techniques
-
analyze data using PivotTables and PivotCharts.
-
insert graphic objects.
-
create customized graphic elements.
-
modify pictures in a document.
-
use macros to automate common tasks.
-
control text flow.
-
use templates to automate document creation.
-
perform mail merges.
-
insert content using Quick Parts.
-
customize the Calendar by setting various Calendar options.
-
customize message options.
-
track work activities using the Journal.
-
assign and track tasks.
-
customize the Outlook environment.
-
manage lists.
-
customize tables and charts
-
create and modify charts
-
customize formatting with styles and themes.