course descriptions

Computer basic: Word and Excel

"What's the difference between Microsoft Word and Microsoft Windows?" "How much do I need to erase off my hard disk so I have more memory?" If you don't know the difference between an application and an operating system, or that erasing files off the hard disk has nothing to do with memory, then you should take this course. After learning Windows basics, students work with word processing (Word) and spreadsheets (Excel), including operations such as "cut and paste."

Windows 10 upgrade

Is this really the last version of Windows we'll have to learn? Microsoft says so--with forever updates. Windows 10 is chock-full of new features, both useful and distracting, from built-in Facebook apps to the "Notifications" bar. Learn how to customize your Start and your taskbar, access the control panel, and use the Windows Shop (more useful than it sounds). (90-minute session, 9:30 to 11:00)

microsoft outlook (email)

Outlook is Microsoft's solution for integrated e-mail, calendars, address book, and task lists. Includes basic features such as email options (receipts, signatures, stationary, virtual business cards). Also teaches how to set up your own Outlook folders, work with multiple calendars (calendar sharing), customize your address book, set recurring appointments and reminders, and leave yourself notes! (half-day, afternoons)

Word, Levels 1 and 2

Word Level 1 (Intermediate). Learn how to use the ruler and change margins and page numbers with "sections." Learn quick shortcuts such as autocorrect and autotext. Why are "paragraphs" so important"? When should you use columns, tabs, or tables? How do you work with multiple documents? What are the tricks to envelopes and labels? (Note: This is not a basic-level course; people who are new to word processing on a computer should take "Introduction for new users" above.)

Word Level 2 (Advanced). Reviews some of the more advanced key features, such as tabs (left, right, decimal align), tables (including sort and sum), margins and columns (sections), autotext, and autocorrect. Emphasis on creating and using templates, styles, and macros. Also covers mail merge, paste links, forms, and objects (as time permits).

Excel, Levels 1 and 2

Excel Level 1 (Basic to Intermediate). Basic spreadsheet operations (simple math, sum, average, db, other functions, percent distributions, absolute cell references). covers working with multiple tables and basic data sorting. Chart wizard is introduced (as time permits). Students learn how to format a table for impressive printouts, including fonts, lines, borders, shades, headers and footers, and sizing to fit. Finally students learn how to link tables to other tables for automatic updates.

Excel Level 2 (Intermediate to Advanced). Assumes you know everything mentioned above. Focuses on more advanced math ("if" statements; count, counta, countif; math with date/time; calculating interest; depreciation). Includes links across multiple tables and to other files and programs. Graphing is covered in detail. Finally database functions such as text-to-columns, concatenate, proper, filters, and grouping/subtotals are used. Class concludes with tools such as validate (including drop-down menus), consolidate, goal seek, scenarios (storing multiple numbers within one cell), pivot tables / pivot charts, and vlookups.

PowerPoint, Levels 1 and 2

PowerPoint Level 1 (Basic to Intermediate). "Presentation software" used to create slide shows and on-screen computer shows, and to print overheads, transparencies, or graphs. Easy-to-use graphing capabilities make creating bar, pie, and line graphs a breeze. Comes with extensive clipart library that can be edited. Learn 3-d settings, autoshapes, grouping, grids, and more.

PowerPoint Level 2 (Advanced).If you know the basics but want the bells-and-whistles, learn how to create speaker notes, sort slides, create animated transitions that play sound, export to other formats, use Pack-and-Go, create your own templates, design masters, and create comments and "meeting minder." Emphasis is on masters, color schemes, custom design templates, and other shortcuts for efficiency.

Access

Access (Basic, 2 Days). Relational database management that allows you to access information based on your structure. Class begins with an overview of database concepts and the construction of tables. Then you will learn how to field properties, analyze data using find, sort, and query (using action, parameter, calculated field, and other types), and then construct forms for data entry and reports for printing.

Adobe Dreamweaver

The best program for web design. Learn basics of formatting with HTML, how to use CSS (style sheets), control layouts with tables and DIVs, insert graphics, and then FTP files to your web site.

Adobe Photoshop

Learn how to edit scanned photographs and add special effects, correct colors, and create your own drawings. Professional-quality features for image editing and printing, including color separations, duotones, special effects (such as lighting pointillism, blurs and sharpens), and pixel editing. Course focuses on importance of layers, masks, paths, and adjustments.

Adobe InDesign

Desktop publishing of newsletters, posters, three-fold leaflets. Hands-on instruction with emphasis on layout and design, including control palettes and style sheets. Replaces Adobe PageMaker.

Adobe Illustrator

Introduction to Illustrator. Learn how to use layers, create and edit paths, blend colors. Be creative with the pencil tool and draw smooth magnetic curves. Then import or export graphics to other programs.

Roving Help Desk

"Roving Help Desk" is a special service we offer to clients who don't need a class, but would like one-on-one, on-site support. You raise the questions, we provide the answers, spending time with each staff person as needed. Topics can be arranged in advanced, and we will work with you to estimate the amount of time needed to deal with each issue. Very efficient way to boost productivity!

selling on ebay

Learn the tricks and guidelines for being a successful seller in one 3-hour session. Learn the secrets to succeeding, from getting free boxes for shipping to avoiding unnecessary fees. The instruction is an eBay "PowerSeller" and a "Recommended Seller," with over 6,000 completed sales and 100% positive feedback.

Intro to social media

Trying to decide whether or not to jump into Facebook or Twitter? Take this half-day course to learn the fundamentals of Facebook, Twitter, and Pinterest, three of the leading social media websites. Also learn tips for safe use and security.