A must for everyone! This course provides a wonderful introduction to the PC. Basic computer skills are essential to everyone who uses a PC. No prior experience is needed.
Topics:
- Uses of Personal Computers
- Types of Personal Computers
- Common Components of a PC
- How Personal Computers Work
- Start Your Computer
- Set Up Your Computer
- Log in to Your Computer
- Display My Computer
- Saving Files to a Floppy Disk and the Hard Drive
- Finding Files
- Navigate in Word Processing Document
- Identify Types of Networks
- Access the Internet
- & More!
This Course Includes:
- 3 hours of classroom instruction
- Certificate upon completion
Learn basic computer concepts & skills related to IBM-compatible PCs. Receive a thorough introduction to the domain environment. In addition, learn Windows 2000 techniques and become acquainted with applications.
Topics:
- The Environment
- Logging On
- The Desktop
- Input Devices
- Taskbar/ Start Menu
- Open Windows
- Hierarchy
- My Computer
- Search Feature
- Windows Explorer
- Creating Folders
- Copy/Move Objects
- Recycle Bin
- Programs
- Cut/Copy/Paste
- Customize Desktop
- Shortcuts
- Web Style View
- Control Panel Settings
- Network Places
- Working Remotely
- Control Panel
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
- Placement Counseling Session
Join the excitement of the Internet and World Wide Web. We’ll teach you how to set it up, get on– line using Explorer, and take advantage of the Web for work, pleasure, and profit. Our Windows, PC Basics, or equivalent knowledge required.
Topics:
- Open Web Pages
- Follow Links
- Bookmark Pages
- Print Pages
- Find a URL
- Find People
- Get Driving Directions
- Find Information
- Send and Receive Instant Messages
- Subscribe to a News-
- group
- View Newsgroup Messages
- Download a File
- Open a Zipped File
- Copying from a Web Site
- Block Cookies
- Delete Unnecessary Files
- Organize Your Favorites
- ...and More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Join the excitement of the Internet and World Wide Web. We’ll teach you how to set it up, get on– line using Explorer, and take advantage of the Web for work, pleasure, and profit. Our Windows, PC Basics, or equivalent knowledge required.
Topics:
- Open Web Pages
- Follow Links
- Bookmark Pages
- Print Pages
- Find a URL
- Find People
- Get Driving Directions
- Find Information
- Send and Receive Instant Messages
- Download a File
- Copying from a Web Site
- Organize Your Favorites
- ...and More!
This Course Includes:
- 3 hours of classroom instruction
- A complete instruction manual
- Certificate upon completion
A Personalized Course A program is created to match your individual goals & experience, enabling you to master the keyboard. A unique mix of lessons, drills, practice, games, and progress reports are used to enhance the speed and accuracy of beginners, two–finger typists and touch typists.
The First Session:
During your first session, you’ll establish your goals and objectives for the course and current skill level. This information is used to create custom lessons.
The Key is Practicing:
To quickly increase speed and accuracy, most time is spent with lessons, which consists of a series of computer-based drills. At the end of each lesson, you’ll get feedback on your performance, speed, accuracy, best keys, and keys to work on.
This Course Includes:
- Instructors always available
- Certificate upon completion
Learn the most popular word processing system! Participants will understand the basic concepts of Word 2000. You will be introduced to Word features and the steps required to use the features correctly. Our MS Windows, PC Basics, or equivalent knowledge required.
Topics:
- Entering Text
- File Save As
- Using Toolbars and Menus
- Opening and Viewing Documents
- Creating Documents
- Saving Documents
- Finding Documents
- Using Repeat, Undo and Redo
- Using AutoText and AutoComplete
- Using AutoCorrect
- Using the Format Painter
- Setting Margins
- Changing Line and Paragraph
- Spacing
- Controlling Text Flow
- Aligning Text on a Page
- Finding Text
- Replacing Text
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
For the word processing pro, learn more features and functions to improve your efficiency and productivity using Word. Learn how to use templates; create letters, envelopes, and labels; use styles; use outlines; use headers and footers; create and use tables; format tables; work with columns; and use graphic elements in documents. Our MS Word Introduction class or equivalent knowledge required.
Topics:
- Using Existing Templates
- Creating Templates, Letters and Envelopes
- Creating Mailing Labels
- Applying and Modifying Styles
- Creating Outlines
- Creating Headers and Footers
- Creating First Page Headers and Footers
- Alternating Headers and Footers
- Working with Page Numbering
- Entering Text into Table Cells
- Creating Tables
- Changing Column Widths and Row Heights
- Using Borders and Shading with Tables
- Using Table AutoFormat
- Formatting Sections as Multiple Columns
- Formatting Columns
- Using Clip Art Pictures in Documents
- Creating Watermarks
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Learn how to insert form fields and modify forms, create help messages, use online forms, sort information, create mail merge data sources and main documents, create form letters and mailing labels, and use macros. Our MS Word Intermediate class or equivalent knowledge required.
Topics:
- Creating Basic Forms
- Saving Forms as Templates
- Inserting Form Fields
- Inserting Check Box Form Fields
- Inserting Text Form Fields
- Enhancing Tables in Forms
- Protecting Forms
- Creating Status Bar Help Messages
- Entering Data into Online Forms
- Sorting Paragraphs
- Sorting Information in Columns
- Viewing Merged Data Records in a Main Document
- Sorting and Merging Records to Create Form Letters
- Creating Mailing Labels
- Using Alternate Data Sources
- Creating, Running and Editing macros
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Learn the most popular spreadsheet program. The skills we teach help you how to create modify and format worksheets, format and print worksheets, and work with formulas, functions, and charts. Our Windows class, PC Basics or equivalent knowledge required.
Topics:
- Exploring Spreadsheet Uses
- Moving Around Worksheets
- Creating New Workbooks
- Using the AutoComplete Feature
- Saving and Closing New Workbooks
- Copying and Moving Worksheet Data
- Cutting and Pasting Data
- Inserting and Deleting Rows/Columns
- Changing Column Widths/Row Heights
- Using Numeric Formats
- Using Conditional Formatting
- Creating Headers and Footers
- Creating, Using and Editing Formulas
- Using Relative and Absolute Cell References
- Using Functions
- Working with Multiple Worksheets
- Grouping Worksheets
- Creating 3-Dimensional Formulas
- Creating and Using Styles
- Creating, Modifying and Formatting Charts
- Printing & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
For the spreadsheet pro, learn how to name cells, use advanced functions, find and replace data, use print options, protect worksheets, and link workbooks. You will also learn how to create and use templates, and macros. Our Excel Intermediate class or equivalent knowledge required.
Topics:
- Naming Formulas
- Working with Advanced Functions
- Creating Custom Number Formats
- Creating and Applying Outlines
- Locating and Updating Data
- Using Special Format and Print Options
- Using Comments
- Protecting Worksheet Data
- Working with Multiple Workbooks
- Freezing Rows and Columns Simultaneously
- Exporting Data to Other Applications
- Linking Workbooks
- Automating Your Work
- Working with Existing Templates
- Customizing Templates
- Creating Workbooks Based on
- Templates
- Creating Templates
- Working with macros
- Recording macros
- Creating Custom Lists
- Queries & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
With our Advanced Level class, learn how to create and sort databases; use database functions, filters, and queries; create and modify PivotTables; audit worksheets; and create scenarios and custom reports. Our Excel Expert class or equivalent knowledge required.
Topics:
- Working with Databases
- Sorting Database Data
- Using Database Functions
- Using the VLOOKUP Function
- Using the Advanced Filter Feature
- Working with Extracted Data
- Querying an External Database
- Using Automated Features
- Creating and Editing PivotTables
- Using PivotTable AutoFormat
- Using Advanced Data
- Analysis to Audit Worksheets
- Creating, Displaying and Editing Scenarios
- Creating Custom Reports
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Microsoft database manager has everything you need to store, sort, & keep track of your files and records. Learn this powerful tool to create custom–made database programs. This course teaches you how to create and modify tables, create queries, use filters, create and modify forms, create and modify reports, and enhance reports. Our Windows, PC Basics, or equivalent knowledge required.
Topics:
- Identifying Database Components
- Designing Relational Databases
- Creating New Databases
- Creating Tables
- Assigning a Primary Key
- Working with Records
- Working with Table Structure
- Finding Records
- Understanding Comparison Operators
- Using Select Queries
- Creating and Using Forms
- Creating and Using Reports
- Enhancing Forms and Reports
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
For the database pro, learn how to create relational databases, work with related tables,
use subforms, maintain data integrity, use advanced form features, use advanced report features, use advanced query features, use advanced queries, and work with charts. Our Access Introduction class or equivalent knowledge required.
Topics:
- Examining Table Relationships
- Enforcing Referential Integrity
- Using the Lookup Wizard
- Adding Data to Related Tables
- Using Subdatasheets
- Creating Subforms
- Displaying Information with Subforms
- Using Input Masks
- Using Validation Rules
- Using Calculated Controls
- Improving Accuracy in Forms
- Creating a Report Using the Report Wizard
- Customizing Headers and Footers
- Concatenating Text Fields
- Adding Calculated Values
- Working with Subreports
- Performing Calculations in a Query
- Using Crosstab Queries
- Using Parameter Queries
- Using Action Queries
- Creating Charts
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Learn how to design Access applications; use tools and controls; create dialog boxes; use macros; control data entry; use dialog boxes to get report criteria; create custom switchboards; create keyboard shortcut macros, control tips, and status bar messages; use database utilities; and protect and replicate databases. Intermediate class or equivalent knowledge required.
Topics:
- Designing Applications
- Deciding Where to Automate Your Application
- Using Advanced Tools and Controls
- Using a Combo box to Find Records
- Creating Dialog Boxes
- Creating macros
- Creating macro Groups
- Restricting User Access to Fields
- Closing Forms Automatically
- Specifying Default Values for Fields
- Using Dialog Boxes to Get
- Report Criteria
- Creating Custom
- Switchboards
- Creating Keyboard Shortcut macros Messages
- Creating Control Tips and Status Bar
- Setting Startup Properties
- Using Database Utilities
- Protecting and Replicating Databases
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Everything you need to quickly turn your ideas into powerful presentations. We’ll show you how create, modify, format, build and run PowerPoint slide shows, as well as use WordArt, ClipArt, and graphic objects. Our Windows class, PC Basics or equivalent knowledge required.
Topics:
- Create, modify, format, build and run PowerPoint slide shows
- Starting PowerPoint and Opening Presentations
- Working with Slides in Different Views
- Manually Running a Slide Show
- Creating New Presentations
- Adding Text to Slides
- Changing Slide Layouts
- Saving Presentations
- Adding New Slides to an Existing Presentation
- Rearranging, Copying & Deleting Slides
- Modifying Bullets & Bullet Characters
- Replacing Fonts Throughout a Presentation
- Changing Text Alignment
- Previewing Slides
- Printing Handouts
- Applying Line Colors and Style
- Applying Fills
- Inserting AutoShapes
- Rotating & Flipping Objects
- Layering & Grouping Objects
- Using WordArt
- Expanding Slides
- Adding Transition Effects
- Adding Animation Effects
- Using Preset Animation Effects
- Using Custom Animation Effects
- Controlling Slide Shows
- Using On-Screen Navigation Tools
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Advance your skills in presentation management with our intermediate level class. You will be introduced to the advanced features of PowerPoint 2000 by working with slide outlines, templates, and multimedia elements. You will also create charts, tables, and organizational charts; customize PowerPoint; link slides; prepare presentations; and save presentations in other formats. Our PowerPoint Introduction class or equivalent knowledge required.
Topics:
- Working with Slide Outlines
- Creating Charts
- Customizing Charts
- Animating Chart Elements
- Creating Tables
- Adding Organization Charts
- Customizing Organization Charts
- Adding Multimedia Elements
- Working with Templates
- Modifying Slide Masters
- Creating Custom Toolbars
- Creating and Modifying Color Schemes
- Creating Custom Slide Shows
- Inserting Hyperlinks
- Inserting Action Buttons
- Preparing Speaker Notes
- Using the Meeting Minder
- Saving Presentations in Other Formats
- Saving Presentations for the World Wide Web
- Saving Presentations for Automatic
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Students will learn the fundamentals of using Outlook 2000 to coordinate mail, appointments, events, meetings, tasks, and contacts. Our MS Windows or PC Basics classes or equivalent knowledge required.
Topics:
- Overview of Outlook 2000
- Customizing Outlook Today
- Working with the Address Book
- Creating and Managing Distribution Lists
- Managing the Contacts Folder
- Importing Contact Data
- Viewing Incoming Messages
- Creating and Sending Messages
- Organizing Messages
- Managing Appointments
- Creating Recurring Tasks
- Creating Tasks
- Creating Notes
- Changing the Color of Notes
- Printing E-mail Messages
- Printing Your Calendar
- Printing Contact Information
- & More!
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Students will learn how to organize, find, and archive Outlook data; format e-mail messages; use your Calendar to schedule meetings; access your contacts to which you can assign speed dial numbers and tasks; send and receive faxes; use e-mail security features; create and use custom forms; integrate Outlook with other Office applications; and use Outlook with the Internet. Our Outlook Introduction class or equivalent knowledge required.
Topics:
- Organizing Outlook Data
- Archiving Outlook Data
- Delegating Folder Access
- Formatting Messages
- Configuring the Rules Wizard
- Working with Offline Folders
- Organizing Messages
- Using the Call Contact Feature
- Sending vCards
- Assigning Tasks to Contacts
- Adding a Fax Service to Your Profile
- Adding Your Digital ID to E-mail
- Messages
- Viewing Outlook Forms
- Creating Custom Forms
- Using Custom Forms
- Attaching Files to Outlook Items
- Embedding Objects in Data Forms
- Opening Web Pages in Outlook
- Sharing Outlook Folders on the Web
- & More!
This Course Includes:
- Full–day or 2 afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Learn to create and edit macros, and gain an understanding of VBA code. Examine sample code, learn how to create macros from scratch, and add to previously created macros. Our Windows 2000, Excel Advanced & Word Advanced courses or equivalent knowledge required.
Topics:
- Visual Basic intro
- Run/Record macro
- Examine module design
- Assigning macros
- Specifying location
- Decision-making code
- If…Then structure
- If…Then…Else structure
- Select Case structure
- Loop structures
- For…Next statement
- Do…Loop statement
- For Each…Next statement
- Macro management
- Personal Workbook
- Auto Sub Procedures
- Recording in Word
- Interactive macros
- Custom message box
- Custom input box
- Extracting from Excel
- & More
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Student learn the basic concepts of FrontPage 2000. You will be introduced to FrontPage features and the steps required to use the features correctly. Learn to how to create, modify and format Webs, create hyperlinks in Webs, insert and manipulate images in Webs, design tables in Webs, and publish and maintain Webs. General knowledge of Windows required.
Topics:
- Viewing a Web Site
- Touring the FrontPage Interface
- Starting FrontPage and Opening Web Pages
- Working with the Views Bar and Folder List
- Viewing Web Pages in Different Views
- Designing and Developing Webs
- Creating Webs
- Adding Web Pages to a Web
- Managing the Task List
- Adding Text to Web Pages
- Copying and Moving Text
- Formatting Text
- Creating Lists
- Renaming Pages
- Modifying and Applying Styles
- Working with Themes
- … & More
This Course Includes:
- Full–day or 2 Afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Students will learn how to set up a QuickBooks company; enter account opening balances; create and customize company lists; set up inventory; sell products; invoice for services; process customer payments; work with bank accounts, enter and pay bills; set up an internet connection; and use online services. Students will also learn how to customize forms; work with credit card transactions, work with Asset, Liability and Equity accounts; create and customize reports and graphs; track and pay sales tax; manage payroll, complete job estimates, time tracking and costing; and create customized letters and forms During this course, including computer lab time, students will be provided with the information necessary to complete the following objectives:
- Getting Started
- Setting Up a Company
- Working with Lists
- Setting Up Inventory
- Selling Your Product
- Invoicing for Services
- Processing Payments
- Working with Bank Accounts
- Entering and Paying Bills
- Using the EasyStep Interview
- Using Online Banking
- Customizing Forms
- Using Other QuickBooks Accounts
- Creating Reports
- Creating Graphs
- Tracking and Paying Sales Tax
- Doing Payroll with QuickBooks
- Estimating, Time Tracking, Job Costing
- Writing Letters
- Synchronizing with Contact Management Software
- ...and More!
Prerequisites: Windows or equivalent knowledge required. You can successfully complete this course without any knowledge of finances or accounting.
Course length: 3 days (18 hours)
Students will learn how to create a letterhead, a flyer, and a newsletter using Publisher. Also included is working with shapes, setting up a table, and creating a Web site. Our MS Windows or PC Basics classes or equivalent knowledge required.
Topics:
- Entering Personal Information
- Creating a Letterhead
- Saving a Publication
- Printing a Publication
- Creating a Flyer
- Adding a Border
- Inserting Clip Art
- Combining and Grouping Frames
- Creating a Newsletter
- Working With Shapes
- Drawing Custom Shapes
- Creating a Table
- Formatting a Table
- Creating an Artistic Text Block
- Creating a Web Site
- Creating a Hyperlink
- Previewing and Publishing a Web Site
- Additional Publisher Features
- & More!
This Course Includes:
- Full–day or 2 afternoon or eves (6 hrs) in class
- A complete instruction manual
- Certificate upon completion
Includes:
- PC Basics
- Introduction to the Internet
Includes:
- Excel Introduction
- Excel Intermediate
- Excel Advanced
- QuickBooks
Includes:
- Keyboarding Level I
- MS Word Introduction
- MS Word Intermediate
- MS Word Advanced
Includes:
- PC Basics
- Introduction to the Internet
- MS Word Introduction
- Excel Introduction
- Outlook Introduction
Includes:
- PC Basics
- MS Windows 2000 Introduction
- MS Word Introduction
- Excel Introduction
Includes:
- Access Introduction
- Access Intermediate
- Access Advanced
Includes:
- Excel Introduction
- Excel Intermediate
- Excel Advanced
Includes:
- MS Word Introduction
- MS Word Intermediate
- MS Word Advanced
Includes:
- MS Windows 2000 Introduction
- MS Word Introduction
- Excel Introduction
- Access Introduction
- PowerPoint Introduction
Includes:
- MS Word Introduction
- MS Word Intermediate
- Excel Introduction
- Excel Intermediate
- Access Introduction
- Access Intermediate
- PowerPoint Introduction
- PowerPoint Intermediate
Includes:
- MS Word Introduction
- MS Word Intermediate
- MS Word Advanced
- Excel Introduction
- Excel Intermediate
- Excel Advanced
- Access Introduction
- Access Intermediate
- Access Advanced
- PowerPoint Introduction
- PowerPoint Intermediate
- VBA Macro Programming
- Outlook Introduction