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 & Web Design
Digital Images & Adobe PhotoShop Elements Workshops
Microsoft Office
Spreadsheet Programs
Windows & PC Maintenance
Word Processing

 

 New - Special Interest Workshops

“Understanding Ransomware and the Elevated Internet Threat to You and Your Family”

Are you concerned about current Internet threats?  Did you hear about “WannaCry” the Ransomware that attacked a Los Angeles hospital computer and held patient records hostage until they agreed to pay $17,000?  Are you at risk?  How can you protect your computer?

Local Information Technology Expert Nate Abbott will present key information to help you remain protected from hackers who are actively extorting a billion dollars in ransom from millions of computer users around the world.   In this presentation you will learn what actual screens look like when Ransomware strikes a computer, and what to do if it ever happens to you.  Various hacking schemes will be discussed and demonstrated to help you be wary and safe in your Internet browsing and email habits.  Great information for the whole family, so attend and take it back home, or better yet, bring them in to this two hour class. 

We know that this can be complex and confusing information so ample question and answer time is built into the presentation.  There is no such thing as a ‘stupid’ question.

$100 - CALL FOR DETAILS

 

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. You can use it with a mouse & keyboard or with a touch screen. 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 have installed Windows 10. This class will teach you how to navigate the new windows environment, use Microsoft Edge, understand how Cortana can help you locate files on your computer and information on the web.  Tips, tricks & shortcuts to customize your computer will also be provided.

Course Length: 3 hours
Cost: $100

 

Microsoft Office 365 -- "What's New"

Have you recently upgraded to 2013 or 2016? 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 2013/2016. Specific topics will include the new start screen and backstage, making changes to the ribbon, customizing the quick access toolbar, and saving files to your Microsoft cloud account.  The instructor will also show some of the new features in Excel including the Quick Analysis Tool, the new look to charts and changes made to Pivot Tables.

Course Length: 3 hours
Cost: $100

 

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.  We even show you an app that allows you to work remotely from your iPad to your desktop or laptop at home or at work! 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 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; 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, 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

This workshop is designed for people who use Microsoft Outlook on a regular basis and want to utilize some of the interactive tools of Outlook. Specific topics will include creating distribution lists, using voting buttons, working with signature files and Out of Office assistant, creating and using rules, integrate Outlook contacts with Microsoft Word to create envelopes and letters, use field chooser and customize views in Outlook, and set up and use the Journal feature to track activities you want recorded on a timeline.

Course Length: 6 hours
Corporate/Custom Class Only



Desktop Publishing, Presentation Programs & 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 frames, 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 overhead slides. 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 clipart; grouping and ungrouping objects; using design templates; controlling slide show effects; and using the Auto-Content wizard.

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; create a table; 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

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



Digital Images & Adobe PhotoShop Elements Workshops

Working with Digital Images

You've learned how to take pictures. What do you do next? This six hour workshop will help you understand the capabilities of your equipment, and how to effectively pass your digital photographs into the computer. This class will provide step-by-step instructions on how to use Adobe PhotoShop Elements to transfer and edit pictures, control the size and quality of images, crop, adjust brightness and contrast, and how to organize your hard drive so that you don't lose your pictures. The instructor will also demonstrate how to touch up photos and remove areas of a photo using the clone feature (yes, we can take people out!). Additional topics include options for printing your pictures or Emailing them to friends.

Course Length:
6 hours
Cost:
$200



Microsoft Office

Microsoft Office 365 -- "What's New"

Have you recently upgraded to Office 2010 or 2013? Thinking about whether you should make the change? During this 3-hour class, the instructor will provide an overview of what's new and different in Microsoft Office 2007, 2010 and 2013. Students will work with sample files in Word, Excel and PowerPoint to increase their confidence and comfort with the new look. Specific topics will include using the ribbon, tabs & 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 in compatibility mode when sharing files with other users and using the SkyDrive cloud in 2013. The instructor will also discuss features that have changed significantly -- Word tables, mail merge, Excel charts, pivot tables and autofilter.

Course Length: 3 hours
Cost: $100

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; 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

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, screen savers and 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 Word for Windows, offers tips and tricks, and includes in-depth instructions on formatting a document and using correction tools. Instructions are reinforced by extensive hands-on exercises. Participants will learn to create, save, open, close, print and preview documents; control screen options including view modes, toolbars, ruler, and scroll bars; select text and move quickly through a document; use multiple undo and redo; move or copy text using cut/paste and drag/drop; specify character size, style, color, attributes and special effects; use spell check and AutoCorrect; specify page setup for document margins, paper size, vertical page alignment, and page breaks in a document; and create individual envelopes and labels.

Course Length: 6 hours
Cost: $200


Microsoft Word II: Formatting Documents

Word Module II 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, shading, and drop caps; 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; and customizing toolbars.

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 from the Clipart Gallery; create WordArt objects; use the drawing toolbar 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