Computer Training School Conven

Recorded Video Lessons
Hands-On, Step-by-Step
(Please allow 24 hours to receive an Email link to the video.)

Our recorded classes enable you to gain the same knowledge as you would in person. You can do your lesson anytime of day (or night). When you purchase our class videos you will receive an Email with a link to the shared file. The share will be available for 30 days – so let us know when you are ready. The videos allow you to stop, rewind or replay as needed. We will also send you sample files to use for the lessons. If you need to verify participation to an employer, or to us for certification, we ask that you Email your class exercise files when you complete the video.

To purchase a video, choose one of the following options:

Click Add to Cart next to the class title.
Call (603) 286-3300 with your credit card information.
Email admin@hyslops.com with the class details and payment method.

Click on a link below to jump to a section.

Free Videos

Accounting Workshops - QuickBooks
Adobe Acrobat Pro DC
Cloud Programs - OneDrive & Google Drive
Database Workshops - Microsoft Access
Desktop Management Tools - Microsoft Outlook
Desktop Publishing - Microsoft Publisher
Digital Images
Microsoft Office 365
PC Maintenance
Presentation Programs - Microsoft PowerPoint
Spreadsheet Programs - Microsoft Excel
Web Design - Microsoft Expression Web
Windows 10 & File Management
Word Processing - Microsoft Word

FREE VIDEOS

Overview - How Our Videos Work

This free video will explain how our recorded lessons work and what you can expect when you place an order. We strongly recommend that you take a few minutes to listen to this recording.

Class Resources

Course Length: 5 Minutes
Class Fee: Free

Sample Video - Formatting Excel Columns

This is a short video to show how our step-by-step lessons work.

Class Resources

Course Length: 5 Minutes
Class Fee: Free

Using Multiple Monitors

Want to purchase one of our video classes? We recommend the use of multiple monitors. You can watch our video on one screen and do the steps with the presenter on the second monitor. This video will explain how to setup and use dual screens.

Class Resources

Step-by-Step Guide

Course Length: 4 Minutes
Class Fee: Free

Working with Side-By-Side Windows

Are you using a large flat screen monitor or have you connected your computer to a TV? This video will show you how to split your screen to work in multiple windows. This is helpful for our recorded videos where you can watch the presenter in one window and do the step-by-step lessons in the second window.

Class Resources

Step-by-Step Guide

Course Length: 4 Minutes
Class Fee: Free

Join a Zoom Meeting

COVID has changed the way many of us are doing business. Need to join a Zoom meeting for the first time? This video will teach you how.

Class Resources

Step-by-Step Guide

Course Length: 4 Minutes
Class Fee: Free

Adobe Acrobat Pro DC

In this workshop you will learn how to create PDFs, convert documents, images or photos into PDF files, turn PDFs into editable Microsoft Word, Excel, PowerPoint, or RTF files. You will work with PDF files and use Acrobat with Microsoft Office, combine files, work with tables & interactive forms, add signatures and incorporate text, notes, graphics, and links to the Internet. We will organize PDF files and learn to rotate, reorder, delete and combine multiple files into a single PDF file. Topics will also include manage your Adobe Document Cloud storage, sending documents for signatures, fill-in and e-sign forms, sharing PDFs and track delivery of documents electronically.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: 200

Or call us with your credit card information.

MICROSOFT EXCEL (SPREADSHEETS)

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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Recorded with Excel 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

ACCOUNTING - QUICKBOOKS

QuickBooks Professional I: Introduction to QuickBooks

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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $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.

Recorded with QuickBooks Desktop 2020. Also appropriate for any version 2015 or later. Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

MICROSOFT WORD

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Recorded with Word 2019. Also appropriate for any version 2007 or later.
Minor differences will be discussed during the lesson.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

MICROSOFT POWERPOINT (PRESENTATION PROGRAMS)

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

MICROSOFT PUBLISHER (DESKTOP PUBLISHING)

Microsoft Publisher: Introduction to the Desktop Publishing

This course demonstrates how Publisher templates can be used to create impressive looking publications 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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

MICROSOFT OUTLOOK (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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Or call us with your credit card information.

CLOUD BASED PROGRAMS - GOOGLE DRIVE & ONE DRIVE

Google Drive: Documents

Google Drive is a free service that allows you to create, edit and share files in the cloud. In this course you will learn how to setup your Google Drive, upload / download documents between Microsoft Word and Google Docs. Attendees will learn how to create, edit, format and share Google Documents. Specific topics include using bullets & numbering, indenting paragraphs, line spacing & alignment, working with tabs, controlling page breaks and using headers & footers. The presenter will also show how to insert different objects like tables and pictures.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

Google Drive: Spreadsheets

This course includes everything you need to build a basic workbook, create simple formulas and format a spreadsheet. In this course you will learn how to manage files in your Google Drive, upload / download spreadsheets between Microsoft Excel and Google Sheets. Participants will learn to enter & edit data; use undo; select and move around the spreadsheet efficiently; move/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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

Microsoft Office 365 -- OneDrive Overview

Have you recently upgraded to the latest version of Microsoft Office? Do you want to learn how to use the OneDrive Cloud. During this workshop, the presenter will provide an overview of what's new and different in Microsoft Office 365. Specific topics will include the 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. The presenter will discuss how and why to save files to compatibility mode or PDF. You will also learn how to use, share and manage files in your Microsoft OneDrive cloud account.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

Microsoft OneNote

Microsoft Windows Sticky Notes, Outlook Notes & OneNote – oh my! Learn when and how to use each of these “notes” features and how they work together. Create quick “Sticky Notes” on your desktop, setup miscellaneous Notes in Outlook and keep track of important information with OneNote. This course covers how to set up and organize your OneNote notebooks, sections and pages. Learn how to store different types of content including text, pictures, hyperlinks, screen clippings, and use tables to organize your information. Additional topics include how to format typed notes, record audio or video, include handwritten notes, add a reminder to your Outlook tasks, and import content from other applications, such as Word, Excel and Outlook. Downloading the OneNote app on your smart phone or tablet allows you to access your Notebook by syncing all of your devices using your Microsoft Account.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

Or call us with your credit card information.

DIGITAL IMAGES

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 your devices to one location. 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 this fun and informative workshop.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

MICROSOFT ACCESS (DATABASE)

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

MICROSOFT WINDOWS

Navigating Microsoft Windows

Windows 11 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. 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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

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).

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

PC MAINTENANCE

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 3 Hours
Class Fee: $100

WEB DESIGN (EXPRESION WEB)

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.

Class Resources

Upon enrollment, you will receive:

A link to the video, available for 30 days
Valid for “One” user
Quick Reference Guide
Class Exercise Files

Course Length: 6 Hours
Class Fee: $200

Updated 1/24/24

Free Videos

Accounting Workshops - QuickBooks
Cloud Programs - OneDrive & Google Drive
Database Workshops - Microsoft Access
Desktop Management Tools - Microsoft Outlook
Desktop Publishing - Microsoft Publisher
Digital Images
Microsoft Office 365
PC Maintenance
Presentation Programs - Microsoft PowerPoint
Spreadsheet Programs - Microsoft Excel
Web Design - Microsoft Expression Web
Windows 10 & File Management
Word Processing - Microsoft Word

Back to the Top