|
Course Descriptions
The following is a list of topics covered in all classes offered by Intellicom.
If there is a topic you can't find offered in one of our standard classes please contact our Training Department for individualized training options.
Basic Class Information
- Most classes are taught in a 4-hour, hands-on format.
- Students will receive take-home documentation of all topics covered in class.
- Most classes below are taught in a Windows 2000 environment using Microsoft Office 2000. There are
very few differences in the basic functionality of Office 2000 and Office 95 or 97. If you are using
either Office 95 or 97 these classes will benefit you just as much as if you were using Office 2000.
- For more information on any of the classes below please contact our training department.
Introduction To Windows 2000
Prerequisite: None
Platform: Windows 2000
Description: In this course, students will learn the basic functionality of the Windows 2000 environment. This is a great class for students that have not used the computer before or for those that are making the transition from a Macintosh to Windows environment.
Back To Top
Introduction To The Internet
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or XDescription: In this lesson, students will learn basic Internet browsing techniques with emphasis on efficiency, virus protection, and personal online security.
Back To Top
Microsoft Excel Level 1
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn basic worksheets skills and how to work with data in worksheets. Also, students will learn how to use an electronic spreadsheet to create basic data reports.
Topics:
- Start Microsoft Excel
- The Microsoft Excel 97 Window
- The Workbook Window
- Using the Keyboard
- Menus, Toolbars, and Commands
- Exit Excel
- Select Menu Items
- Options In A Dialog Box
- Set View Preferences
- The View Menu
- Change Window Displays
- Help Features
- The Office Assistant
- Contents and Index
- Exit Help
- Explore the Worksheet Using the Mouse and Keyboard
- Enter Labels
- Make Simple Corrections
- Save A Workbook
- Close A Workbook
- Numeric Labels and Values
- Label Alignment
- Check For Viruses
- Align Labels
- Indent Text in Cells
- Use Formulas
- Mathematical Operators
- Natural Language Formulas
- Open Files
- Save and Save As
- Create Backup Files
- Send Files
- Format Data
- Use Ranges
- Copy Data
- Print A Worksheet
- Copy Formulas (Absolute and Relative References)
- Format Data (Bold, Italics and Underline)
- Fractions and Mixed Numbers
- Spelling
- Use Functions
- Formula Bar and Formula Palette
- Paste Function
- AutoCalculate
- Edit
- Copy Part of a Cell's Contents
Back To Top
Microsoft Excel Level 2
Prerequisite: Microsoft Excel Level 1
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will increase their knowledge of formulas and functions by implementing advanced techniques into their worksheets. Student will also learn advanced techniques to enhance a worksheet or report’s readability.
Topics:
- Change column width
- Create a Series
- Comma Format
- AutoComplete
- Print Options
- Print Preview
- Cell Contents
- AutoSum
- Page Setup (Orientation, Scale, Margins, Header, Footer)
- Range Entry Using the Collapse Button
- Page Breaks
- Headers and Footers
- Print Titles
- Transpose Data
- AutoCorrect
- Freeze Titles
- Split Panes
- Copy and Paste Special (Extract Data)
- Create New Workbook
- Arrange Workbooks Window
- Save Workspace
- Named Ranges
- Data Validation
- Copy and Paste Special
- Format Negative Numbers
- Original Templates
- Link Workbooks
- 3-D Formulas
- Workbook Sheets
- New (or Duplicate) Workbook Window
- Solve What-If Problems
- Data Tables
- Goal Seek
- Insert an If Function
- Paste Function Feature
- IF Function
- Print Compressed Worksheet
- Conditional Sum Wizard
Back To Top
Microsoft Access Level 1
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, you will learn the basics skills necessary to begin using Access. You will design and create databases, tables, queries, forms, and reports.
Topics:
- Database Basics
- What Is A Database?
- What Are Database Objects?
- How Is an Access Database Organized?
- What Are Access Tables?
- How Are Access Tables Related?
- Plan A Database
- Create a New Database File
- Create a Table In Design View
- Save a Table Design
- Switch Views
- Close A Database
- Add New Tables
- Use Date/Time and Currency Data Types
- Primary Key
- Open A Table in Datasheet View
- Enter Records
- Input Mask
- Correct A Field Entry
- Security
- Enhance A Table (Datasheet)
- Change Datasheet Column Width
- Create A Form from and Existing Table
- Enter Records in Form View
- Yes/No Data Type
- Use Form Design View
- Adjust Controls
- Repeat Data Entry
- Add, Delete, and Move Fields in Design View
- Add a Lookup Value List Field
- Use Shortcut Menu
- Add, Delete, and Move Fields in Datasheet
- Lookup Value From Another Table
- Simple Print
- Find Records
- Find Records and Replace Data
- Search Using Wildcards
- Sort Records
- Quick Sort
- Multiple Sorts
- Filtering Records
- Shortcut Filters
- Advanced Filter/Sort
- Advanced Filter/Sort
- Relational Operators
- Create A Query
- Change A Query Design
- Save A Query
- Reports
- Create Reports With Report Wizard
- Edit Report Sections and Controls
- Move Design View Controls
- Save a New Report
Back To Top
Microsoft Access Level 2
Prerequisite: Microsoft Access Level 1
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, you will learn how to enhance your database designs by using the principles of normalization and table relationships. You'll also learn how to query multiple tables for data that is used in customized forms and reports. See how to take advantage of relational database efficiency to maintain data. You will also learn techniques to save time by controlling data entry and automating tasks. Benefit by becoming familiar with Access features that will enable you to customize forms and reports.
Topics:
- Relate Tables
- Enforce Referential Integrity
- Print Relationships
- Close Relationships Window
- Show/Hide Related Records
- Set Subdatasheets
- Use Database Wizard
- Use Switchboards
- Use All Fields of a Table For a Query
- Change A Query Design
- Delete and Move Fields
- Rename A Query
- Print a Query Datasheet
- Change Field Format in a Query Design
- Change Field Names In A Query Design
- Add Calculations to a Query
- Create a Query Using Data from Multiple Tables or Queries
- Indexes
- Index Properties
- Multi-Field Indexes
Back To Top
Microsoft PowerPoint Level 1
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn the basic skills necessary to begin effectively creating presentations in Microsoft PowerPoint. Students will learn how to create and edit bullet slides, use PowerPoint’s drawing tools, incorporate clip art and WordArt, create and enhance organization charts, and create and edit charts by using Microsoft Graph.
Topics:
- Opening A Presentation
- Running A Slide Show
- Exploring the PowerPoint Windows
- The Menu Bar
- Shortcut Menus
- The Toolbars
- Other Window Elements
- The Office Assistant
- Exploring the Different PowerPoint Views
- Closing a Presentation
- Creating Title and Bullet Slides
- Presentation Design Tips
- Entering Text on a Slide
- Create a Text Box for Entering Text
- Adding a Bullet Slide
- Adding AutoNumber Bullets
- Saving a Presentation
- Creating Slides in Outline View
- Outline Levels
- Updating A Saved File
- Modifying Text in a Bulleted List
- Moving Bullet Items in Outline View
- Using the Move Up and Move Down Buttons
- Dragging Paragraphs Up and Down
- Modifying the Slide Sequence in Outline View
- The Repeat Command
- Indents
- Line Spacing
- Using the Find Command
- Using the Replace Command
- Working with Drawing Tools
- Creating Objects and Assigning Attributes
- Moving Objects
- Sizing Objects
- Group Shapes Using the Drawing Toolbar
- Using the Clipboard
- Working With Text and Drawn Objects
- Create a Presentation from Existing Slides
- Adding Text To Objects
- Alignment
- Adjusting Text Within Drawn Objects
- Using AutoShapes
- Enhancing Drawn Objects
- Text Color, Fills, and Shadows
- Using Format Painter
- Additional Drawing Effects
- Using Clip Art
- Using the Clip Art Gallery
- Inserting A Table
- Moving and Resizing a Table
- Entering Text In A Table
- Using Word Art
- The Word Art Toolbar
- Formatting Word Art
- Creating An Organization Chart
- Adding Boxes to an Organization Chart
- Deleting and Moving Boxes
- Organization Chart Options
- Selecting Boxes and Levels
- Changing the Organization Chart Chart View
- Slide Show Options
- Deleting Slides
- Copying a Slide from One Presentation to Another
- Hiding Slides
- Adding Transitions and Animation To A Slide Show
- Animating Text and Objects
- Running A Manual and Automatic Slide Show
- Starting A Slide Show with Any Slide
- Slide Timings for Automatic Slide Shows
- Printing A Presentation
- Printing in Color and Black and White Print Options
- Printing Slides in a Variety of Formats
Back To Top
Microsoft PowerPoint Level 2
Prerequisite: Microsoft PowerPoint Level 1
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn advanced features of PowerPoint, including customizing templates and the PowerPoint environment and making a presentation interactive by using hyperlinks and action buttons. Students will learn how to enhance a presentation by using custom clip art, animation, and movies and work with embedded and imported objects by using Microsoft applications.
Topics:
- Work With Object slides
- Insert Clip Art
- Use Animated GIFs
- Inse5rt Scanned Pictures
- Import Pictures
- Use Undo
- Change A Presentation's Template
- Change A Slide's Layout
- Change A Slide's Color Scheme
- Change A Slide's Background
- Use Slide and Title Masters
- Slide Master View
- Insert Slides
- Numbers, Date and Time, and Other Footer Text
- Format Bullets
- Customize a Template
- Save and Apply A Custom Template
- Paste Object
- Link Object
- Embed Object
- Group, Ungroup and Regroup Objects
- Flip and Rotate Objects
- Layer Objects
Back To Top
Microsoft Outlook Level 1
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn the fundamentals of using Outlook to coordinate mail, appointments, events, meetings, tasks, and contacts. Students will learn how to send and receive mail, schedule appointments, insert events, schedule meetings, create and manage tasks, and organize contacts
Topics:
- The Outlook Bar
- Adding a Group to the Outlook Bar
- Remove a Group from the Outlook Bar
- Add A Shortcut to the Outlook Bar
- Delete A Shortcut or Folder From the Outlook Bar
- Create a Folder For Outlook Items
- Reading Mail
- Sending Mail
- Sending A Mail Attachment
- Sending Outlook Items Via a Mail Attachment
- Address Book
- Add A Personal Address Book
- Create A Personal Distribution List
- Add A Name to a Personal Distribution List
- Remove a Name from a Personal Distribution List
- Delete a Personal Distribution List
- Sign Message with AutoSignature
- Replying to Mail
- Forwarding Mail
- Deleting Mail
- Views
- Sorting by Single Fields
- Sorting by Multiple Fields
- Outlook Views in the Inbox
- Assigning A Category or Contact to an E-Mail
- Creating A New Contact
- Modifying a Contact
- Deleting a Contact
- Printing A Contact List
- Appointments
- Events
- Meetings
- Schedule an Appointment
- Schedule a Recurring Appointment
- Create and Event
- Create and Annual Event
- Printing A Calendar
- Retrieve a Deleted Item
- Empty Deleted Items
- The Mail Group Folders
- The Other Folders
Back To Top
Microsoft Outlook Level 2
Prerequisite: Microsoft Outlook Level 1
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this lesson, students will learn advanced features for using Outlook in conjunction with Microsoft Exchange.
Topics:
- Address Books
- Name Resolution and Your Address Books
- Separating Multiple Address In the To: Box
- Distribution Lists
- Public Distribution Lists
- Private Distribution Lists
- Outside Access to a Distribution Lists
- Planning A Meeting with Others
- Checking Your Coworker's Schedule
- Responding to a Meeting Request
- Canceling a Meeting
- Changing a Meeting
- Setting Permissions for Others
- Permissions
- Sharing Your Folders
- Out Of Office Assistant
- Discussion Forums
Back To Top
Microsoft Word Level 1
Prerequisite: General Knowledge of Windows
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn the basic skills necessary to begin using Word. Students will learn how to create and edit documents and use character and paragraph formatting. Even if you’ve worked with Word for years, this is an excellent course to speed up your everyday duties using new shortcuts and tricks.
Topics:
- About Microsoft Word
- Using the Mouse
- Starting Word
- The Word Window
- Use the Keyboard
- Close A Document Window/Exit Word
- Toolbars, Menus, and Commands
- Dialog Box Options
- Shortcut Menus
- The Zoom Options
- Window Display
- Default Settings
- Help Features (Office Assistant, Contents, Index, Find, Screen Tips)
- Exit Help
- Conventions
- If You Make An Error
- Document Views
- Create A New Document
- Save A Document
- Close A Document
- AutoCorrect
- Automatic Spell Checking
- Spelling & Grammar
- Properties
- Insertion Point Movements
- The Date and Time Feature
- Preview A Document
- Print
- Full Screen View
- Overtype Mode
- Comments
- Open A Document as Read-Only
- Save As
- Undo and Redo
- Select Text
- Delete Text
- Show/Hide Codes
- Delete Paragraph Marks
- Change Case
- Non-Breaking Spaces
- Track Changes
- Compare Documents
- Accept/Reject Revisions
- Set Margins
- Set Tabs
- View Margins
- Preview A File
- Print A File Without Opening It
- Select Multiple Files To Print
- File Details
- Sort Files
- Find Files
- Text Alignments
- Vertical Centering
- Fonts
- Font Faces
- Font Styles
- Font Size
- Font Color
- Emphasis Styles
- Remove Emphasis Styles
Back To Top
Microsoft Word Level 2
Prerequisite: Microsoft Word Level 1
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8 or X
Description: In this course, students will learn intermediate features of Word. Students will learn how to create and control section breaks, tables, merges, styles and templates.
Topics:
- Use Symbols
- Format Painter
- Bullets and Numbering
- End Bullets or Numbers
- Line Spacing
- Paragraph Spacing
- Hard vs. Soft Page Breaks
- Section Breaks
- Headers and Footers
- Line Spacing
- Paragraph Spacing
- Indent Text
- Hanging Indent
- Find Text
- Replace Text
- Hyphenate Text
- The Outline Feature
- Create an Outline
- Enter Outline Text
- Edit an Outline
- Styles
- Create/Edit A Word Style
- Print Specific Pages
- Bookmarks
- Page Numbers
- Page Number Placement
- Number Formats
- Footnotes
- Widow/Orphan Lines
- Record A Macro
- Mail Merge
- The Main Document
- The Data Source Document
- Merge Main and Data Source Documents
- Merge Selected Records
- Work With Clip Art
- Import A Picture
- Size A Picture
- Create A Table
- Default Borders, Gridlines and End marks
- Move Within A Table
- Enter Text In A Table
- Create A Parallel Column Table
Back To Top
Microsoft Outlook 2003 Level 1
Prerequisite: General Knowledge of Windows
Title: Outlook 2003 - Level 1
Delivery Method: Instructor-led Classroom Learning
Duration: 1.00 Day(s)
Overview:
This course will provide students with the skills needed to start sending and responding to email in Microsoft Office Outlook 2003, as well as maintaining the Calendar, scheduling meetings, and working with tasks and notes.
Who Should Attend:
This course is designed for people with a basic understanding of Microsoft Windows who need to learn how to use Microsoft Office Outlook 2003 to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes. This course is intended for persons interested in pursuing the Microsoft Office Specialist certification for Outlook.
At Course Completion:
You will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.
Outline:
Lesson 1: Getting Started with Outlook
Log On to Outlook
The Outlook Environment
Compose and Send a Simple Message
Open a Message
Reply to a Message
Print a Message
Delete a Message
Lesson 2: Composing Messages
Address a Message
Format a Message
Check Spelling and Grammar
Attach a File
Forward a Message
Lesson 3: Managing Mail
Open and Save an Attachment
Flag a Message
Create a Folder
Move Messages to a Folder
Copy Messages to Folders
Delete a Folder
Lesson 4: Scheduling Appointments
The Outlook Calendar
Schedule an Appointment
Assign a Category to an Appointment
Update Calendar Entries
Back To Top
Microsoft Outlook 2003 Level 2
Prerequisite: Outlook 2003 - Level 1
Title: Outlook 2003 - Level 2
Delivery Method: Instructor-led Classroom Learning
Duration: 1.00 Day(s)
Overview:
This course provides students with the necessary skills to customize their Outlook environment, calendar, and mail messages to meet their specific needs. Students will also learn how to track, share, assign, and quickly locate various Outlook items.
Who Should Attend:
This course is designed for experienced Outlook users who need to learn how to customize their environment, calendar, and mail messages to meet their specific needs and who wish to track, share, assign, and quickly locate various Outlook items.
At Course Completion:
You will customize your environment, calendar, and mail messages to meet your specific needs as well as track, share, assign, and quickly locate various Outlook items
Outline:
Lesson 1: Tracking Work Activities Using the Journal
Record a Journal Entry Automatically
Manually Record a Journal Entry
Modify a Journal Entry
Lesson 2: Setting Calendar Options
Set Work Days and Times
Display Other Time Zones
Set Free/Busy Options
Lesson 3: Setting Message Options
Modify Message Settings
Modify Delivery Options
Modify Message Formats
Notify Others that You will be Out of the Office
Create and Modify a Distribution List
Insert a Hyperlink
Lesson 4: Sharing Folder Information
Specify Folder Permissions
Access Another User's Folder
Delegate Access To Folders
Lesson 5: Managing Tasks
Assign a Task
Reply to a Task Request
Send a Task Update
Track Assigned Tasks
Lesson 6: Customizing Outlook
Customize the Toolbar
Create a New Toolbar
Customize the Menu
Create a Folder Home Page
Lesson 7: Locating Outlook Items
Sort Messages Using Multiple Criteria
Find Messages
Find Messages Using Multiple Criteria
Filter Messages
Organize Messages
Manage Junk Email
Back To Top
|
