| |
Microsoft
Office Courses
Courses are two-day classes and version 2007.
All courses are still available in version 2003 if requested.
|
Course
Name
|
Course
Number
|
Description
|
|
Outlook Module I
(one day)
|
MDTOUT107 |
This course covers how to send and reply to email in Microsoft Office 2007, set email options, use attachments and folders, organize messages, customize the Inbox, use
stationery, signatures and address book. |
Outlook
Module II
(one day) |
MDTOUT207 |
This course covers the use of the calendar, tasks, notes, contacts, sharing calendars and other
folders, archiving and deleting objects. |
| Word
Module I
|
MDTWO107 |
Word
2007 is the word processing application in Microsoft Office 2007.
This training covers basic document creation tasks in Word such as
creating, saving, opening and closing documents; formatting text,
using Help, Spell Check and Grammar Check. It also covers printing
documents, formatting paragraphs, setting margins and adding page
numbers.
|
| Word
Module II
|
MDTWO207 |
This
training builds upon the skills learned in the Module I course and
covers graphics, styles, tabs, tables, headers and footers, basic
mail merge, and creating templates.
|
| Word
Module III |
MDTWO307 |
This
course continues to build upon the skills learned in Module II and
covers linking, SmartArt, fields, advanced mail merge, advanced
styles, symbols, footnotes, tracking revisions, and macros.
|
| Word
Module IV
|
MDTWO407 |
This
course continues to build upon the skills learned in Module II and
covers outlining, formatting long documents (master documents),
table of contents, indexes, captions, table of figures and
bookmarks, and creating a brochure, calendar, and forms in Word.
|
| Excel
Module I
|
MDTEX107 |
Excel
2007 is the spreadsheet program in Microsoft Office 2007. This
beginner’s course covers basic tasks such as creating and saving
workbooks, entering data and simple formulas and functions, AutoSum,
formatting cells, working with columns and rows, using page setup
and printing a worksheet.
|
| Excel
Module II
|
MDTEX207 |
This
course build upon the skills learned in Module I and covers charts,
named ranges, outlining, absolute references, more functions
including date and statistical functions, graphics, linking
worksheets and linking between Word and Excel.
|
| Excel
Module III |
MDTEX307 |
This
course continues to build upon the skills learned in Module II and
covers IF and PMT functions, Goal Seek, Data Table, protecting a
worksheet, customizing the toolbars, macros, custom formats,
conditional formatting, database forms and filters, subtotals, data
validation, Vlookup function, Pivot Tables and Pivot Charts.
|
| Access
Module I
|
MDTACC107 |
Access
2007 is the database program in Microsoft Office 2007. This
beginner’s course covers basic tasks such as creating tables,
queries, basic forms and reports, filtering and calculating with a
query, parameter queries, importing and linking data, creating
relationships.
|
| Access
Module II
|
MDTACC207 |
This
course builds upon the skills learned in Module I and covers the
Expression Builder, multi-source queries, forms and reports in
Design view, action queries, option groups/subforms/combo boxes,
creating a calculated control in a report.
|
| Access
Module III
|
MDTACC307 |
This
course continues to build upon the skills learned in Module II and
covers macros, event properties, creating a main menu, database
security tools, splitting a database, exporting data, linking,
replicating, creating a web page.
|
PowerPoint
Module I
|
MDTPPT107 |
PowerPoint
2007 is the graphics/slide show application in Microsoft Office
2007. This beginner’s course covers creating slides, views,
applying designs and customizing the background, adding transitions,
notes pages, handouts, tab settings, tables, and manipulating
graphic objects.
|
PowerPoint
Module II
|
MDTPPT207 |
This
course builds upon the skills learned in Module I and covers charts,
organization charts, SmartArt, Master Views, custom templates,
hyperlinks, creating a web-based presentation, slide animation,
movies, and sounds.
|
| Project
Level I |
MDTPRO107 |
Covers how to create a project plan with a task list, enter task duration estimates, link tasks, enter resources and assign them to tasks, create a baseline plan, view the critical path, and create reports. |
| Project
Level II |
MDTPRO207 |
Covers importing a task list, exporting data into Excel, saving a project as a web page, working with task progress, filtering tasks, saving an interim project plan, using hyperlinks, creating a custom report, creating a template, sharing resources, creating
a master project plan. |
Visio
2007 Professional
Level I
(one day) |
MDTVIS107 |
This
course covers basic skills in Visio. Students create a directional
map, a flowchart, a process map, and an organization chart.
Time-saving skills such as duplication, auto-numbering, manipulating
shapes, grouping, aligning, and stacking are learned. |
Visio
2007 Professional
Level II
(one day) |
MDTVIS207 |
This
course builds upon skills learned in the Level I course. Topics
covered are customizing Visio's toolbars and windows, using the
drawing tools, creating custom shapes, using advanced stencil
techniques, creating and using templates, styles and layers.
Students will exchange information with other programs and print a
drawing. |
Back
to Customized Computer Training |
