When it comes to using computer-based resources, our customers have told us they need specific knowledge in a wide-range of programs, productivity in day-to-day tasks, or even just the skills to finish a critical step in a project.

No time for formal training? Let us offer several alternatives:

· Customized targeted learning for one learner or for small groups

· Application / Network consulting and troubleshooting on an hourly basis

· Frequently-asked questions (FAQs) are our specialty

· Skills of using programs together (Word, Excel, Access, Outlook, ODBC…)

We are knowledgeable in a wide variety of software, operating systems and business practices. We can be available to be your technical consultant on a weekly, monthly or as-needed basis (for a certain projects) to help you meet your goals using your current technology.

---

Partial Course Listing and Descriptions

Not all classes are listed,  please call for more information.

• A+ Certification Training
  Operating Systems/Hardware
  
  This 5-day hands-on class is jam-packed with valuable information on computer architecture, microprocessors, storage, video, modems, printers, local area networks, electrical theory, portable computers, MS DOS startup process, device drivers, batch files, hard disk setup, MS-DOS setup, MS-DOS optimization, MS Windows Family, Windows 3.1 setup, Windows 95, Windows 2000 and Windows XP. This class helps prepare students for the A+ Certification Exam.
  

• Access, Level I  (8 hours)
  
  This course covers essential database creation guidelines including relational (multi-table) queries, reports and forms. A great course for new and experienced users alike!

• Access, Level II (12 hours)
  
  This module covers techniques when working with multiple tables in a relationship.  Including advanced multi-table queries, reports and main-form, sub-form scenarios.  We also include a working explanation of all query types and an excellent example of transaction processing.

• Access, Level III (12 hours)
  
  This course covers all advanced topics available in this premiere product except programming.  In this session we complete advanced action & cross tab queries.  We also cover the creation of command buttons with embedded macrocode and we streamline the process of database replication for network-distributed applications.  The bonus topic is using Access to collect information from the Internet!

• Access, Level IV (16 hours)
  
  This course combines knowledge from all previous Access sessions.  We design and build an application from the ground up.  During this session you will discuss the design process, create command buttons, automate a dialog box, create a macro group and a switchboard, build custom menus and toolbars, create visual basic for access applets and design and add security to your finished application.  Course prerequisites must be met prior to attending this session.

• ACT! , Level I (8hours)
  
  This course teaches the fundamentals of contact management using ACT! 2000.  Students will learn how to find and manage client information, schedule and keep track of activities with clients, and create word processing documents.

• ACT! , Level II (8hours)
  
  This class is a must for the serious ACT! User!  Students will learn the advanced features of contact management.  Topics include how to modify templates and reports, perform complex lookups, customize a database, automate procedures, exchange data, perform database maintenance, and link to the Internet.

• Adobe Acrobat 4.0:  Basic Skills(8hours)
  
  Acrobat represents the newest revolution in the war between paper and electronic documents.  Learn how to create, edit, and manage your library of electronic PDF files.  This course provides the basic knowledge needed to understand how Adobe Acrobat documents are created from standard desktop applications.  Students will convert actual Word documents, PowerPoint presentation, and Excel spreadsheets to create electronic documents.  

• Adobe Illustrator, Level I (8 hours)
  
  Want to create artwork like the pros?  Learn the capabilities of this program as you create your own artwork.  Topics include using tools and menus and creating special typographical effects.  Learn how to scale, stretch, and rotate type and objects.  Other topics include grouping, locking, layering, creating bezier paths, and using the transformation tools. 

• Adobe Premiere, Level I (12 hours)
  
  Want to be a Movie Director? This course covers many features, including how to import and capture audio and video from your digital devices.  Then we will teach you how to create several digital movies using numerous advanced editing techniques, i.e., adding transitions and professional looking special effects that will enhance your project.  The final production will be to export your project to a QuickTime format that can be used in PowerPoint presentations or your web page.

• Capture Your Audience -- Add Multimedia To Your PowerPoint Presentation (4 hours)
  Aug 17 from 1p to 5p
  Students will learn to add transition effects and set a slide show to run continuously, create animation by assembling an object, transform one image into another, creating a “morphing” effect, record narration to add to a slide show, and create a Custom Soundtrack to accompany a presentation, (Really Good class!!!)

• Cisco CCNA Training
  (Cisco Certified Networking Associate)
  
  This 5-day hands-on class is jam-packed with valuable information and hands-on training designed to help network professionals achieve Cisco CCNA certification.  Upon successful completion of this course, students will be able to:  Interconnect Cisco Switches and routers according to a given network design; Use Cisco software to identify addresses, protocols, and connectivity status in a network with multiple, interconnected Cisco devices; Configure Cisco switches and routers; Configure lists to control access to network devices; and, Verify that Cisco switches and routers operate as intended within their given network specification.
  For more information about this course, please call 398-9000 or email trainme@williscomputing.com.  We would be happy to fax or email you the detailed course outline.

• CorelDRAW, Level I ( 8 hours)
  
  CorelDRAW is an illustration program that allows you to create graphics, use text, and combine with images in a vast array of colors.  This application is a one-stop graphics package!  Popular uses of CorelDRAW include:  signs, business letterhead, cover designs, and logo and product illustrations.  In this course we will cover viewing and moving around drawings, selecting and manipulating objects, special effects.

• Create Brochures, Flyers, And More, Using Word (4 hours)
  
  The focus of this course will be to identify some fundamentals of desktop publishing and create a simple newsletter. Create a coupon flyer, incorporating graphics, a page border, and text boxes. Print address information on the back of a single-page flyer by creating a template and using the Mail Merge feature. Design a tri-fold brochure using a three-column, two-page, landscape layout.

•  Crystal Reports 8.0, Advanced (16 hours)
  
  Students will learn how to create advanced formulas, format reports based on calculation results, use multiple sections, insert sub reports, access data from sources other than PC databases, and create user libraries.

• Crystal Reports 8.0, Introduction (16 hours)
  
  Students will learn the basics of report creation including sorting, grouping, linking, basic formula creation, working with reports experts, and how to distribute reports to other users.

• DreamWeaver, Level I (8 hours)
  Designing Web Pages Using DreamWeaver
  
  Learn to use DreamWeaver to create Web pages that incorporate text, images , background art, and tables.  Topics covered in class include formatting text for size, color, and alignment; creating ordered and unordered lists; and linking pages together with hyperlinks.  After completing this course, students will understand how to create a Web site on a local disk, clean up the HTML code, and perform a final site check that searches for broken links and tests browser compatibility. 

•  DreamWeaver, Level II (8 hours)
  Designing Web Pages Using DreamWeaver
  Add visual interest to your Web pages using the interactive and design features of DreamWeaver.  Use Cascading Style Sheets and HTML styles to standardize formatting throughout your Web site.  Topics include designing attractive and effective pages using frames, and creating precise layouts suing rulers and the grid.  Learn to include animation and rollovers to enhance your pages, and to use image maps to create splash screens and navigation bars.

• Excel Functions (4 hour)
  Dec 21 from 1p to 5p
  Students will use a variety of functions and timesaving techniques with sample files consisting of a business’ personnel files, timesheets, exam scores, and project scheduling reports. Activities covered; Track elapsed time Simplify statistical analysis with functions, Apply error-handling and auditing techniques.

• Excel, Level I (8 hours)
  
  This course is a must for spreadsheet users.  Important spreadsheet creation guidelines are taught including correct formula creation techniques and 3D sheets including formatting and printing.

•  Excel, Level II (8 hours)
  
  Database features including AutoFilter plus a complete overview of spreadsheet graphics are the main focus of this level.  In addition, advanced functions dealing with spreadsheet manipulation and creation techniques will be covered.  

• Excel, Level III (8 hours)
  
  This course meets the Microsoft Proficiency Guidelines for Excel at the Expert level.  Students will learn the skills and concepts necessary to work with advanced features of Excel.  Students will learn how to customize toolbars, create pivot tables, link files, consolidate data, and record macros.  Students enrolling in this course should understand the basic concepts involved in using Excel.  For example, students should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

• FrontPage 2000, Level I (8 hours)
  
  Learn how to create and maintain a Web Page.  Every company needs a presence on the Internet without learning HTML. Students will learn how to create and edit a set of web pages, apply paragraph and character formatting, create links between and within web pages, create links to the World Wide Web, insert images and create links from images, insert and format tables, and create framed pages from images, and insert and format.

• FrontPage 2000, Level II (8 hours)
  This course covers advanced features available in FrontPage.  Learn to create forms that include data validation and run-time form Bots.  Other topics include using cascading style sheets and other DHTML features, such as page transitions and animations.  Learn to insert FrontPage components, including an automatic table of contents, search form, hit counter, and scheduled image.  Additional topics include designing consistent and attractive Web sites using sample pages and templates.

• Lotus Notes, Level I (8 hours)
  
  Students will learn how to work with Notes databases, create and edit documents, use Notes mail features including calendaring and scheduling, addressing memos, delivery options, folders, sections, links, and mobile computing.

• Macromedia Flash (8 hours)
  
  Learn to use Flash to design dynamic Web pages that combine seamless animation and special effects.  Build a Web movie by inserting layers, creating and importing artwork, then arranging all the elements on the Timeline.  Create interactive pages by assigning actions to buttons and adding rollover effects.  Additional topics include managing the library elements, using symbols, and optimizing text.

• Microsoft Office 2000 to Office XP:  New Features  (4 hours)
  July 25 from 1p to 5p
  Students will explore new and improved interface features common to all Office XP applications.  They will also become familiar with feature enhancements across the suite.  Topics covered will include the new features of Word 2002, Excel 2002, PowerPoint 2002, Access 2002, and Outlook 2002.

• Microsoft Office 97 to Office XP:  New Features  (4 hours)
  
  Students will explore new and improved interface features common to all Office XP applications.  They will also become familiar with feature enhancements across the suite.  Topics covered will include:  Using the new and improved features including the Office Clipboard, the Media Gallery, and the Office Template Gallery; Explore and use new document management features; and Performing basic Web authoring tasks in Office XP.

• New User Seminar (2 hours)
  
  This seminar is designed to explain and demonstrate to a new user some of the common software that is distributed with a new computer. Topics covered include a brief hands-on overview of basic Windows, Word Processing, Spreadsheets, Quicken, introduction to the Internet, Free E-mail set up, and discussion about buying Products on-line.  It is our goal to have seminar participants eventually sign up and register for training with us, as well as utilize this experience to ask questions from the expert on which software to use and how to buy products on-line.

• Novell System Administration (8 hours)
  Selected Topics
  
  This session is geared to the professional who needs a basic familiarity of Network Administration and the interface between Windows 95/98.  Novell 3.12, Novell 4.1 and 4.11 will be available for this session.

• Open Lab / Internet Lab (4 hours)
  8a to 5p on selected days See attached calendar.
  These sessions are geared towards previous students who need additional practice.  We encourage each attendee to bring their training manual(s) to these labs.  A monitor will be available to assist if requested.

• Outlook, Level I (8 hours)
  
  Learn to manage data with Outlook.  Topics include using Outlook to send, receive, and organize your email.  Use the contact feature of Outlook to keep track of people, phone numbers, and addresses.  Schedule meetings and appointments using Outlook’s calendar feature.  We also cover how to mail merge contacts with Word.

• Outlook, Level II (8 hours)
  
  Students will learn how to manage, prioritize, and arrange email messages; how to schedule and manage meetings with other users; and how to use contacts to access the Internet and automatically record activities in the Journal. Students will also learn how to use templates and forms and how to customize the Outlook Bar.

• PageMaker Basics, Level I (8 hours
  
  This course introduces the basics of PageMaker.  Develop the skills you need to design and produce camera-ready copy for simple publications.  Topics include entering, selecting, and changing text, as well as placing word-processing files into your documents.  Additional topics include moving text, creating and manipulating art using the toolbox, changing page views, creating multiple columns, and defining master pages.

• PageMaker Production I (8 hours)
  
  This course covers features such as creating and using templates.  It also introduces working with graphics and color and defining colors.  Features such as graphic formats, contrast and halftones, and printing are also learned.

• PageMaker Type Design, Level II (8 hours
  
  This course covers the more complex layout techniques used in desktop publishing.  Learn to control multiple-column formats and create and manipulate text blocks.  Students will also learn to use the ruler guides and zero point to set up a page and align its elements.  Other topics include placing and manipulating clip art, importing artwork into frames, defining colors, and paragraphs formatting.

• PhotoShop, Level I (8 hours)
  
  This course covers the basics of graphic manipulation by using the various built in tools & techniques.  Some of the highlights are transforming selections, feathering edges, layering and using each tool on the toolbox.

• PowerPoint, Level I (8 hours)
  
  Learn how to make absolutely amazing presentations with animation, sound, and video clips!  Students will create and edit bullet slides and use PowerPoint’s drawing tools to create a slide.  Also covered in this course will be how to incorporate clip art and WordArt objects in a slide, create and enhance organization charts, and creating and editing charts by using Microsoft Graph.  Rounding out the course will be running a slide show, becoming familiar with slide show options, and adding notes to a slide.

• PowerPoint, Level I (8 hours)
  
  Learn to create effective graphic presentations using PowerPoint.  Topics include outlining and organizing your ideas into a presentation that can be rearranged and manipulated.  Use the word processing feature to create and edit text, add multiple-level bulleted entries, and set tabs and indents.  Use the drawing tools to make attractive art or logos, and import clip art to add impact to your slides.  Other topics include the spell checker, find and change, page sorter, and applying different templates.

• PowerPoint, Level II (8 Hours)
  
  This course meets the Microsoft Proficiency Guidelines at the Expert level. This course concentrates on charting data using PowerPoint.  Learn how to create effective charts and graphs using the built-in datasheet capability.  Topics include a discussion of chart types and which to use for particular data, charting with AutoFormat, and importing files.  Learn how to add impact to your charts using color and three-dimensional formats, and to alter charts to serve your specific needs.  Other topics include using and changing the color schemes and creating customized templates.

• Project , Level I (12 hours)
  
  This course meets the Microsoft Proficiency Guidelines for Microsoft Project at the Expert level.  Students will be able to; Identify the steps involved in project planning, build a project Work Breakdown Structure by entering project tasks, creating an outline, and entering task durations, create and modify task relationships by linking tasks and attaching task constraints, staff a project by creating a company calendar, entering the resource pool into the Resource Sheet, assigning resources to tasks, and entering resource costs using the cost table, work with different views and tables by customizing the Calendar View, formatting the Gantt Chart, and modifying standard, default tables, resolve time and resource conflicts by shortening the length of a project’s critical path and using the Level Now command and  sort and filter project data effectively by sorting data in a sheet using the Sort dialog box and by viewing the data that meets specific criteria using filters.

• Project, Level II (12 hours)
  
  This course meets the Microsoft Proficiency Guidelines for Microsoft Project 2000 at the Expert Level.  Students enrolling in this course should have completed the Microsoft Project Level I  course and be familiar with management terminology such as the Gantt Chart, task, critical path, and resource project.   Students will learn how to track and modify a project that is in progress.  Students will create a baseline plan, track an active project, manage tasks that will occur in the future, work with resource needs, and customize a Microsoft Project.  This class is a must for the serious Project user!

• Publisher, Level I (8 hours)
  
  Develop the skills you need to design and produce publications ready for printing.  Topics include entering, importing, and formatting text in single and multiple-column pages.  Additional topics include using the Page Wizards and Design Gallery to simplify document creation, adding special type effects with WordArt, and inserting clip art into your document pages.

• Publisher, Level I (8 hours)
  
  Learn the basics including, Page Setup, Layout Guides, Frames, Multi-Page Documents, Backgrounds, Formatting, Tabs, How to use Graphics, Borders and Copying Elements between documents. 

• Quark Express, Level I (8 hours)
  
  This course introduces the basics of QuarkXpress.  Develop the skills you need to design and produce camera-ready copy for simple publications.  Topics include inputting, selecting, and editing text.  Additional topics include importing from word processing documents, stacking layers, and using menus and the tool palette.  Learn the word processing capabilities such as spell checking and find and change.  Saving and printing publications will also be covered, as well as an introduction to linking/unlinking text boxes. 

• QuickBooks, Level I (8 hours)
  
  This course covers features that are in both QuickBooks and QuickBooks Pro.  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

• QuickBooks, Level II (8 hours)
  
  QuickBooks Level I or equivalent knowledge is required in order to attend this session.  This course covers features that are in both QuickBooks and QuickBooks Pro. Students will 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.

• SQL (Using Microsoft SQL Server) (8 hours)
  
  This course introduces SQL using Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems.  Learn how to do ad hoc queries on a database to select the information you need.  Topics include SQL syntax, data definition language, and data manipulation language.  Learn how to create and update tables, as well as order data, group data, and generate totals.

• Take Advantage of Templates in Office 2000
  (4 hours)
  
  
  

• Visio Professional, Level I (8 hours)
  
  Students will learn the basic concepts for creating flowcharts and basic network diagrams.  This includes learning the basics for using and creating shapes, printing drawings, creating custom stencils, and many timesaving shortcuts and techniques designed to increase user productivity.  Students will learn how to fully utilize Visio’s drawing features to create professional-looking drawings with increased efficiency.  Each project gives a challenging business problem to solve while learning how to create diagrams. 

• Visual Basic 5, Level I (24 hours)
  
  This introductory programming course will cover, the Code Editor, programmatic logic, functions & procedures, variables, form applications, custom controls, menus, and error handling.  Upon completion of the course the attendee will be able to build and run a small application while isolating, identifying, and correctly compiling, logic and run-time errors

• Windows 2000 2151 A
  Network & Operating System Essentials
  
  Curriculum covered in this official Microsoft course will include:  The principal features of Windows 2000 and the basics of networking with Windows 2000; The types of user accounts and the principal security features of a Windows 2000 network; Identification of the tools used to perform various administrative tasks; The features of the common protocols used in a Windows 2000 network; The fundamentals of TCP/IP, including name resolution, routing, and IP addressing-Classful versus Classless Inter-Domain Routing (CIDR); The network communication models used in a Windows 2000 network; Differentiate between the various types of network architectures; The common physical components used for network communication; The concepts and protocols for emote access communication; and the client and server technologies used in a accessing Web services.  

• Windows 2000 Additional Topics (8 hours)
  
  Upon successful completion of this course, students will be able to properly log on, shut down restart and work with desktop objects and windows, Navigate and Manage information with the Windows Explorer.  Customize the desktop to best suit your needs use Active Directory to browse and search shared folders; activate the Offline Files feature, make changes to a file, and then synchronize the copies on the domain and their computers.  Manage and administer the workstation by using the Microsoft Management Console, the Control Panel, and the NTFS used in Windows 2000.

• Windows 2000 Professional, Level I (8 hours)
  
  Upon successful completion of this course, students will be able to:  Log on to Windows 2000, shut down and restart the operating system, and work with desktop objects and windows.  Navigate to information stored on the computer.  Use Windows Explorer to manage files and folders.  Customize the Windows 2000 desktop to best suit your needs.  Use My Network Places to browse the network and view connections; use the Active Directory to browse and search shared folders; activate the Offline Files feature, make changes to a file, and then synchronize the copies on the domain and their computers.  Manage and administer the workstation by using the Microsoft Management Console, the Control Panel, and the NTFS used in Windows 2000.

• Windows 98 Transition (4 hours)
  
  This half day hands-on seminar is a must for previous Windows users who want to learn the new features and advanced topics in a short session.

• Windows 98, Level I (8 hours)
  
  This basic course is designed to teach you how to navigate around the Operating System, modify minor system settings and prepare you for the Intermediate/ Advanced Windows courses.  This is also the prerequisite to all Windows courses on this schedule.

• Windows 98, Level II (8 hours)
  
  This long awaited course covers Outlook Express, Changing file attributes and properties, Associating files with applications, using the RUN command and using the command prompt, enabling user profiles and setting user passwords, sharing folders, working with all system tools, Maintaining your system performance and using FrontPage Express for web page creation.

• Windows NT Workstation 4.0 Introduction
  (8 hours)
  Aug 6 & 8 from 1p to 5p
  Aug 13 & 15 from 1p to 5p
  Students will learn how to use the Windows NT Workstation environment to create and manage documents.  Topics include introduction to the Windows NT Workstation and working with the Windows NT desktop.  Also covered in this course are basic application techniques, NT Explorer, and using Network resources.  This course is a must for the new Windows NT user!  

• WindowsNT Workstation 4, Level I (8 hours)
  
  This operating system contains desktop level security that will allow the multiple users to share one computer but not access each of the locally stored files.  Between Windows98 and WindowsNT the choice is clearly WindowsNT.

• Word, Level I (8 hours)
  
  This course covers document navigation, editing techniques, character and paragraph formatting and alignment.  It also introduces students to tabs & tables and several important document management tools.

• Word, Level II  (8 hours)
  
  If you work with large documents then this class is for you!  Learn how to create and use styles, templates, and mail merge (with Access), basic macros and WEB pages

•  Word, Level III  (8 hours)
  
  This class is for students who want to use the more advanced features of the Word program.  Create multi-column formats.  Discover how to import graphics and art and integrate graphics and columns.  Learn how to define style sheets and templates for document formats.  Create and run simple macros for automating simple, repetitive tasks.  Use the features that make sharing documents with others easier:  comments, tracking changes, and saving different versions.

•   WordPerfect, Level I (8 hours)
  
  Students will learn the basic WordPerfect skills such as how to open, close, and save documents; how to enhance page appearance by applying text attributes such as bold, italics, and underlining; how to change fonts and font sizes; how to affect the appearance of a document by changing tabs, margins, and line spacing; how to create tables; and how to spell check documents to ensure minimal spelling errors.