Microsoft Office

Table of Contents:

Introduction to Windows

This course is designed to teach the students the basic skills necessary to work with computers and the fundamental features of Windows, including: start up and shut down, working with the desktop, and the taskbar & icons. Learn to move, minimize, maximize and restore windows, change a window's size and shape, cascade, tile, scroll within and switch between open windows, hide and display a window toolbar, and the status bar. Use the back and forward buttons, work with My Computer, using the Control Panel to view storage device properties and copy a diskette, create files and folders, rename, move and copy a folder or file, create and rename a shortcut, delete files, folders and shortcuts, retrieve a deleted object, empty and reconfigure the Recycle Bin, and using Windows Explorer.

Managing Windows

This course is designed to teach the students how to manage Windows and manipulate the Windows environment. Students will learn how to work with files and folders and how to customize Windows settings to suit their preferences.

Objectives:

  • Use the new features of Windows desktop
  • Learn Control Panel fundamentals
  • Manage files and folders
  • Work with documents and use disk copy
  • Customize Windows
  • Identify the new features of Internet Explorer
  • Identify new features of Outlook Express
  • Add network places
  • Search web pages
  • Use remote assistance

Word Basic

This course is designed to teach the students the basic skills necessary to use the Microsoft Word software. Topics covered by this course include exploring Word, using the Office Assistant, basic document skills, spell check and grammar check, working with document views, printing documents, envelopes and labels, and applying character, paragraph and document formatting. The use of styles is covered, as well as setting tabs, indenting paragraphs, and using numbers and bullets in organized lists. Students will work with headers and footers, create section breaks, and learn how to use online help.

Word Intermediate

In this course students will learn more advanced features of Word. Students will learn how to insert dates and symbols into documents, how to work with AutoFormat, and borders and shading. Students will learn how to insert tables, graphics, charts and diagrams, as well as how to edit them in Word documents. This course covers how to create newspaper columns, track revisions, use comments, and use AutoCorrect and AutoText. Students will also learn to use the thesaurus and spell check tools, how to use outline view, and customize Word preferences. Finally, this course teaches how to manage files and folders and use Word HTML (HyperText Markup Language) features.

Word Advanced

In this course students will learn advanced features of Word. Students will learn how to use mail merge and to merge mailing labels. Students will learn how to sort table data, use formulas in tables, and import data from Microsoft Excel into Word. This course covers working with lists, macros, and forms. Students will learn how to format long documents, create a table of contents and index, how to use bookmarks, use footnotes and endnotes, and how to create master documents. This course covers how to use Microsoft Graph and advanced layout features. Finally, students will learn how to review documents and work with web pages and XML (Extensible Markup Language).

Excel Basic

This course is designed to teach the students the basic skills necessary to use the Microsoft Excel software. Topics covered by this course include exploring Excel, using the Office Assistant, basic workbook skills, working with ranges, creating simple formulas, and copying and moving data. Page setup and printing workbooks are also covered. Formatting numbers and text, working with columns and rows, formatting cells, and using automatic formatting and styles are also covered in this course. Students will also learn how to use online help.

Excel Intermediate

This course is designed to teach the students basic and some more advanced skills necessary to use the Microsoft Excel software. Topics covered by this course include using large worksheets, working with multiple worksheets, and managing worksheets. Students will work with outlines and HTML files. Using 'Paste Special', range names, labels in formulas, and other functions will also be covered in this course. Students will create and edit charts, draw an object, use additional effects and objects, and use AutoShapes. This course also covers managing data and files and customizing Excel preferences.

Excel Advanced

This course is designed to teach the student the skills necessary for using the database capabilities and to effectively use the financial formulas in the Microsoft Excel software. Topics covered by this course include working with databases, working with the data form, using AutoFilter and advanced filters, importing and exporting data, creating and revising pivot tables, using multiple workbooks, using conditional and custom formats, using templates, working with comments, using worksheet protection, and sharing workbooks.

Outlook Basic

This course presents students with the basics of Microsoft Outlook. Students will learn how to open and reply to e-mail messages, insert attachments in messages, use the Outlook calendar to schedule appointments and meetings, and use Outlook contacts.

Outlook Advanced

This course teaches the advanced features of Outlook. Students will learn to manage tasks, work with the Outlook journal, and use notes. Customizing Outlook Today, creating rules, sharing and accessing other users' folders, creating forms, and working offline are also topics covered in this course.

PowerPoint Basic

This course is designed to teach students the basic skills necessary to use the Microsoft PowerPoint software. Topics covered by this course include exploring PowerPoint, using the Office Assistant, basic presentation skills, use of the outline pane, spell check, enhancing presentation text, printing, sending and publishing presentations, and formatting and editing text. Using graphic images and tables is covered as well as using the 'Slide Sorter' view, using the slide master, and working with drawing objects. Students will use slide show view and edit multiple presentations simultaneously.

PowerPoint Advanced

In this advanced course students are guided through the steps for enhancing slide elements in Microsoft PowerPoint. How to add design templates and how to customize notes and the handout master are covered. Students will learn about adding special effects, hyperlinks, importing objects, and working with charts and graphs. This course teaches how to transfer presentations, notes, and handouts to Microsoft Word and how to package to a CD. Students learn about publishing presentations as web pages and how to broadcast a presentation. Finally, students learn to save slides as graphics and export slides to various formats.

Software Version Compatibility

Students explore the differences between older versions and newer versions with hands on experience using Word, Excel, PowerPoint and Outlook.

NOTE: This information is for your planning purposes only. Due to all the legal disclosures mandated by the State of Washington Workforce Training and Education Board, it is necessary for Allied Training Systems to write all proposals to ensure student receives all the information necessary.