LogoHyslop WordArt

Computer Training School

Serving Concord, Tilton, Laconia & the Lakes Region

 

HomeClass ScheduleCourse OutlinesCertificatesRegistrationDirections
Q&ABooks For SaleOur CustomersTestimonialsCancellationsAbout Us

Hands-On Computer Classes

Accounting Workshops
Database Workshops
Desktop Management Tools

Desktop Publishing, Presentation Programs & Digital Images & Web Design
Microsoft Office
Spreadsheet Programs
Windows & PC Maintenance
Word Processing

 

 Special Interest Workshops

Google Drive:  Documents, Spreadsheets & More

Google Drive is a *free* service that allows you to create, edit and share files in the cloud.  In this course you will be given a basic introduction to Google Documents, Spreadsheets, Calendars, Presentations and Google sharing. This course will be of interest to people who would like to know how Google Docs can help improve productivity. Google Docs has become one of the world’s most popular online tools. If you have never used Google Docs, here is your opportunity to learn how having a cloud account will simplify your routine tasks. 

Course Length: 3 hours
Cost: $100


Navigating Microsoft Windows 10

Windows 10 is Microsoft's latest operating system.  It is App, Touch Screen and Cloud (OneDrive) oriented. Created for cloud computing and mobility, Microsoft Windows has many new features and functions that make this system easy to navigate once you learn how. This workshop is designed for people who have recently purchased a new computer or are new to Windows 10. This class will teach you how to navigate the new windows environment, customize menus and the desktop, use Microsoft Edge, understand how Cortana can help you locate files on your computer and information on the web.   

Course Length: 3 hours
Cost: $100

 

Microsoft Office 365 -- Overview

Have you recently upgraded to the latest version of Microsoft Office? Thinking about whether you should make the change? During this workshop, the presenter will provide an overview of what's new and different in Microsoft Office 365. Specific topics will include the new start screen and backstage, making changes to the ribbon, customizing the quick access toolbar, becoming familiar with new tools such as the mini toolbar, live preview, building blocks, themes & pinning files in the recent documents list.  Special attention is given to the importance of saving files to compatibility mode or PDF when sending files to other users. The instructor will also show how to use, share and manage files in your Microsoft OneDrive cloud account. 

Course Length: 3 hours
Cost: $100

 

iPhone, iPad Tips & Tricks

Don't miss this class! HELP IS HERE for iPad, iPad Mini, iPod, iPhone - All in one class! 

This 3 hour iPad class will increase your capabilities tenfold!   You will first become familiar with the touch screen and how different functions occur when tapping, swiping or dragging with one finger to five!  You will become familiar with the settings menu, various Apps, keyboard and Siri.  We will show you how to group your apps, customize your home screen, e-mail, work with pictures and cut, copy & paste.  You will learn how to “FaceTime” and what all the symbols and icons mean.  This class is for beginners and those who are self-taught. You are invited to bring your device with you, however, keep in mind that these devices vary depending on the version so your capabilities for each may be different to what we are teaching in class. We currently teach the class with an iPhone and the iPad 3. 

Course Length: 3 hours
Cost: $100

 

Accounting Workshops

QuickBooks Professional I: Introduction to Automated Accounting

QuickBooks is the leading accounting program for small businesses. In this workshop, learn how to create and customize a new QuickBooks company. Start by gathering information and learn in easy steps how to track your company accounts. Participants will customize the chart of accounts by adding or deleting expense & income accounts; manage bank accounts; setup items, services, inventory & non-inventory parts; create users and set password protection. Backup and restoring a company file will also be discussed.

Course Length: 3 hours
Cost: $100

 

QuickBooks Professional II: Customers, Sales & Inventory

In this workshop, learn how to track and report customer activities. Topics include adding new customers and editing customer data; create estimates and invoices; apply payments to an invoice and create sales receipts; handle undeposited funds; track refunds and create credit memos; and print monthly statements. Participants will learn how to run customer activity reports including customer balance summaries, summary of open invoices, aging and collection reports.

Course Length: 3 hours
Cost: $100

 

QuickBooks Professional III: Working with Vendors

Need to monitor your accounts payable? Learn how to create a vendor list, enter bills, pay bills and generate checks. Additional topics include creating purchase orders, tracking and receiving inventory items. Students will learn how to process reports including vendor balance summary, unpaid bills detail, accounts payable aging reports, and yearly 1099s for vendors.

Course Length: 3 hours
Cost: $100

 

QuickBooks Professional IV: Using Payroll

If you have employees, QuickBooks can help you process payroll quickly and accurately. In this workshop, students will learn how to setup payroll items and add new employees; create paychecks, print pay stubs and use direct deposit; process payroll liabilities and print payroll reports including quarterly unemployment forms, Federal 941s, annual 940s and W2s.

Course Length: 3 hours
Cost: $100

 

QuickBooks Professional V: Banking & Credit Cards

This workshop focuses on maintaining bank and credit card accounts. Learn how to reconcile the checkbook and other bank accounts; transfer funds between accounts; log entries directly in the check register; setup a credit card account, log charges and payments. Additional topics include making journal entries and handling loans.

Course Length: 3 hours
Cost: $100

 

QuickBooks Professional VI: Reports & Customizing

Now that you have mastered logging your daily entries, enroll in this workshop to learn how to create and customize reports, lists and summarize information. Specific topics will include profit/loss statements and balance sheets; working with memorized transactions and reports; exporting to Excel; creating mailing labels and letters to customers; changing company preferences; customizing company forms; modify reports and filtering data; and editing QuickBooks preferences.

Course Length: 3 hours
Cost: $100

 


Database Workshops

Microsoft Access I: Introduction to Databases

Access is the database application included with Microsoft Office Professional. This course will demonstrate how to create and maintain a simple database. Hands-on instructions will include an overview of opening and moving around database objects; previewing and printing tables and reports; working with table layouts; adding and changing information in a table; adding information with a form; defining a new table; using the clipboard to copy data; finding and replacing information in a table. An introduction to filtering and sorting information will be discussed.

Course Length: 6 hours
Cost: $200


Microsoft Access II: Basic Queries, Forms and Reports

This course is designed for people who have been working with Access and need more detailed information on working with forms, reports and queries. Topics will include filtering and sorting records; filter and query criteria; using the form wizard and query wizard; designing select queries; and using the report wizard to create reports.

Course Length: 6 hours
Cost: $200


Microsoft Access III: Designing Forms

This course introduces the features used to create and customize Access forms. Specific topics include establishing table relationships; adding and editing controls; enhancing a form using combo boxes, list boxes, group options and other special controls; and setting properties in a form.

Course Length: 6 hours
Corporate/Custom Class Only


Microsoft Access IV: Reports & Select Queries

Access Module IV discusses tools needed to create and customize database reports using formatting and grouping & summarizing. Other topics include importing objects; linking external tables; changing table field properties; enhancing select queries.

Course Length: 6 hours
Corporate/Custom Class Only



Desktop Management Tools

Microsoft Outlook I: Basic Desktop Management Tools

Microsoft Outlook is a complete desktop management application. This workshop will include an overview of the different desktop tools including using E-mail, tracking appointments in the Calendar, keeping a Task List for “to do” items, using the Contacts module to maintain addresses and phone numbers, and creating sticky Notes to record important information.

Course Length: 6 hours
Cost: $200

Microsoft Outlook II: Beyond the Basics

So you manage your Email every day.  Microsoft Outlook has so much more.  In this workshop explore and learn the full potential of Outlook, along with tips, tricks & shortcuts.  Topics include customizing the appearance of the Email window using Reading Pane options, Arrange in groups, Sorting and change columns with Field Chooser; Flag messages and add reminders; Change the subject of an existing message;  Drag & drop messages to Word documents, Calendar, Tasks or Notes; work with Conditional Formatting, Color code messages from specific people; Recall a message; Setup Quick Steps and use Rules to automate Outlook; Save time looking for information using Search and Filtering;  use Voting button; Create Distribution Lists (Groups); Use the mini calendar to display custom dates; color code Categories so they work across all folders/features; work with multiple calendars, group calendars, Shares, Permissions and Delegates; use Outlook to managing projects; organize the To-Do List, Tasks and To-Do Bar and use the Notes feature. 

Course Length: 6 hours
Cost: $200



Desktop Publishing, Presentation Programs, Digital Images & Web Design

Microsoft Publisher: Introduction to the Desktop Publishing

This course demonstrates how Publisher templates can be used to create impressive looking documents including brochures, newsletters, greeting cards, ads, signs, invitations, gift certificates and more. The user will learn how to control different types of objects including text boxes, WordArt, Clipart, basic and custom shapes. Grouping, layering, and rotating objects will also be discussed.

Course Length: 6 hours
Cost: $200

Microsoft PowerPoint I: Introduction to the Presentations

PowerPoint is used to create on-screen presentations, printed handouts for a meeting, or automated slideshows. The graphics capability in PowerPoint will enable you to create dazzling presentations in little time. Topics will include creating a presentation; saving, closing, and opening files; selecting, editing, and undoing; working with bullets; moving and copying using the clipboard; using drag and drop; PowerPoint view modes; print handouts and notes pages; format characters, paragraphs and bullets; format painter; insert pictures; grouping and ungrouping objects; using design templates; and controlling slide show effects.

Course Length: 6 hours
Cost: $200



Microsoft PowerPoint II: Working with Objects

This course is designed for people who have been using PowerPoint and would like to learn more about customizing presentations and including different types of objects in a presentation. Topics include drawing objects; changing object attributes; delete, or copy an object; managing multiple objects; rotate or flip an object; grouping and ungrouping; change stacking order; modifying the slide master; change the background and color scheme; insert tables; work with autoshapes; create templates; use the grid, guides, and ruler; create a graph; and setting presentation defaults.

Course Length: 6 hours
Corporate/Custom Class Only

Working with Digital Images

Learn how to manage your camera, iPhone, iPad and Samsung smart phone photos.  You have figured out how to take pictures  – but now what?  In this seminar, the presenter will show tips for taking great pictures, crop & touch up pictures, how to organize the photo gallery, select multiple photos, send them to family & friends, and how to transfer pictures to your computer.  The instructor will show how Google Photos can be used to backup pictures from all of your devices to one location – all for *free*.   You will also learn how to use Adobe Photoshop Elements to touch up photos and remove areas of a photo using the clone feature (yes, we can take people out!).  Join us for the fun and informative workshop.

Course Length:
6 hours
Cost:
$200


Microsoft Expression Web: Creating a Basic Web Site

Microsoft Expression Web is a website management tool. It can be used to create Intranets, websites, document research systems, and more. This class will provide students with the basic skills to create a website including creating pages, adding and formatting text, inserting photos, creating bookmarks & different types of links, controlling styles and page layout, working with forms & tables, and using special features such as interactive buttons or a Photo Gallery.

Course Length: 6 hours
Cost: $200


Spreadsheet Programs

Microsoft Excel I: Introduction to Spreadsheets

This course introduces the basics of Microsoft Excel and includes everything you need to build a basic workbook, create simple formulas and format a spreadsheet.  Instructions are reinforced by extensive hands-on exercises and offers useful shortcuts & tips. Participants will learn to control screen layout options; create, save, open, close, print and preview workbooks; edit data and use undo; select and move around the spreadsheet efficiently; move and copy text and formulas; use the fill handle to copy or create a series; insert and delete cells, columns and rows; format columns, text and numbers; control cell alignment; write basic formulas; and control basic page setup including margins, paper size, gridlines, headers and footers.

Course Length: 6 hours
Cost: $200



Microsoft Excel II: Multiple Sheets, Formulas & Formatting

This course is designed for the person who wants to use advanced formatting to enhance the appearance of spreadsheets, work with multiple sheets in a file and gain more practice in formula writing. Specific topics include advanced numeric formatting; horizontal and vertical alignment; borders, patterns and color. The student will learn to work with multiple sheets by renaming, moving, copying, deleting, grouping and linking formulas between sheets. In addition, linking formulas between multiple files; viewing multiple sheets/files and freezing titles will be discussed. Formula features include using Paste Function and AutoSum to write formulas; and working with relative vs. absolute addressing.

Course Length: 6 hours
Cost: $200


Microsoft Excel III: Creating and Customizing Charts

During this workshop participants will learn to create different types of charts including column, stacked, line and pie charts. The student will learn to work with embedded charts and chart sheets, understand chart components, use chart formats, move or resize an embedded chart, add new information to a chart, change the chart type and format, customize the chart axes, legend, titles, data markers, gridlines, plot area and add notes to a chart. An overview of drawing objects will be discussed including adding arrows, text boxes and callouts.

Course Length: 6 hours
Cost: $200


Microsoft Excel IV: Formulas, Templates, Tips and Timesavers

This course includes extensive hands-on practice in writing and copying formulas; working with absolute and mixed addressing; understanding formula arguments; and use Trace Precedents / Trace Dependents to find errors. Participants will learn to customize the Excel environment by creating custom lists that can be recalled using the fill handle; define and apply formats using cell styles, conditional formatting and AutoFormats; create and modify worksheet templates; protect a workbook from changes and use the track changes feature.

Course Length: 6 hours
Cost: $200



Microsoft Excel V: Databases & Logical Functions

This course is designed for people who have mastered the basics and want to begin using the power of Excel. Students will learn in a hands-on environment how to use Excel database features including sorting information; use a list as a database; create database function formulas; create and use range names in formulas; use criteria to find records; filter data to show specific records; calculate automatic database subtotals and totals; and define a criterion range. In addition, conditional IF statements; vertical and horizontal lookups and pivot tables will be covered.  

Course Length: 6 hours
Cost: $200

 

Microsoft Excel:  Using Macros

This course is designed for people who want to learn how macros can automate the things you do in a spreadsheet on a regular basis.  The presenter will show how to create macros, edit and manage macros, add a macro to the Quick Access toolbar, ribbon or assign it to a shortcut key.  Students will learn to build a control panel to execute macros, launch a website and create links to files on a server.  

Course Length: 3 hours
Cost: $100

 



Windows & PC Maintenance Workshops

Microsoft Windows I: Introduction to PCs

Are you self-taught and feel you need a better understanding of how the computer works?  This workshop will help you fill in the missing pieces.  The workshop begins with an introduction to terminology (using non-technical terms) and computer hardware including the microprocessor; importance of RAM (memory); organization of a hard drive; different types of drives; overview of local area networks; using a hotspot; and a general discussion on the Internet.  The participant will learn in a hands-on environment to control icons on the desktop; open/close Windows applications; control the window size and placement using minimize, maximize, and restore; open and switch between multiple applications; use the Windows Clipboard to cut, copy and paste and manage the Recycle bin.  

Although this class was designed for new users, people who are self-taught find this class very informative.  Particular emphasis is on comparing different types of drives, how to use them and when to use them.  Discussion will include using a hard drive, flash drives, memory card, network drives, CD-ROM, CD-RW (burner), DVD, and USB devices (known as thumb drive, jump drive or flash drive).

Course Length: 6 hours
Cost: $200


Microsoft Windows II: File Management

This workshop is designed for users who have been working with Windows.  Topics include how to copy information and use paste link; manage files by moving, copying, renaming and deleting files; work with removable disks and flash drives; copy files between drives or folders; create new folders; display folder contents; expand and collapse folders.   Participants will learn to customize the Windows environment by installing/uninstalling software; customizing the Start menu and Taskbar options; change the appearance of the desktop using wallpaper, desktop pictures, change screen colors; and create shortcut folders and application icons on the desktop. 

Course Length: 6 hours
Cost: $200

Routine PC Maintenance

Does your computer seem to be getting slower every day? Are you haunted by pop-ups? This seminar will demonstrate how to perform general maintenance on your computer that may correct some of the current problems and prevent new problems. The presenter will discuss defragmenting a hard drive, scanning a drive for errors, running disk cleanup, removing cookies, spyware, and malware, how to prevent viruses, run software updates, and remove Windows / Internet temp files. 

Intended Audience: People who want to learn more about today's Internet threats and how to keep their computer running efficiently.

Course Length: 3 hours
Cost: $
100



Word Processing Workshops

Microsoft Word I: Introduction to Word Processing

This course introduces the basics of Microsoft Word, offers tips and tricks, and includes in-depth instructions on formatting a document and using correction tools.  Participants will learn to create, save, open, close, print and preview documents; control screen options including toolbars, ruler, and scroll bars; select text and move efficiently in a document; use undo/redo; move or copy text using cut/paste and drag/drop; specify character size, style, color, and special effects; use spell check and AutoCorrect; specify page setup for margins, paper size, vertical page alignment, control page breaks; and create individual envelopes and labels. 

Course Length: 6 hours
Cost: $200


Microsoft Word II: Formatting Documents

This workshop teaches the user how to enhance the appearance of documents using paragraph and section formatting. Specific topics include using Format Painter and the highlight feature; indent paragraphs, change line spacing and alignment options; set custom tabs, change tab alignment and use leaders; add borders and shading; control bullets and automatic numbering for paragraphs; use special symbols; and control page and section breaks.

Course Length: 6 hours
Cost: $200


Microsoft Word III: Working with Long Documents

This workshop is intended for people who work with large documents. Topics include using search tools; page numbering and field codes; headers and footers; document styles; automatically generating a Table of Contents; cross references; comparing documents and marking revisions; adding non-printing document comments; and managing footnotes.

Course Length: 6 hours
Cost: $200


Microsoft Word IV: Tables, Forms and Templates

This module is designed for people who want to create templates for repetitive type documents and use the table feature to create lists or forms. The user will learn in a hands-on environment how to create and manage tables by inserting/deleting columns or rows; adjust column width and spacing; change the text direction; control borders, shading and color; split and merge cells; draw and erase cell borders; perform table calculations; sort text or numbers; and use Table AutoFormat to create complex tables. Additional topics will include creating fill-in form documents with tables or form letters; creating and using templates.

Course Length: 6 hours
Cost: $200



Microsoft Word V: Creating Newsletters and Working with Graphics

Now that you have mastered the basics, you may want to use Word to create newsletters, certificates, invitations or announcements. This class demonstrates in a hands-on environment how to format a document into newspaper columns; add a Drop Cap or page border; insert pictures; create WordArt objects; use  drawing tools to create objects and work with Autoshapes; rotate or align objects; create text boxes; enhance object appearance by changing colors; add a shadow or 3-D effect; create different types of arrow objects; group/ungroup objects and control the layering of objects in a document.

Course Length: 6 hours
Cost: $200



Microsoft Word VI: Macros and Mail Merge

The Mail Merge feature is used to create customized form letters or maintain a mailing list to create labels and envelopes. Specific topics will include creating a form letter with merge codes; maintaining a database of names, addresses, etc.; merge to labels or envelopes; create a catalog or list; use Queries to select data; sort data files alphabetically or numerically; and merge a Word document with data from Microsoft Access or Excel. Additional topics include creating AutoText entries to recall repetitive blocks of text; and creating Macros to play repetitive keystrokes.

Course Length: 6 hours
Cost: $200


If you would like to be added to our mailing list

 Email Us: admin@hyslops.com