Technology Enrichment

« Back

Email

Email Marketing

Email is consistently ranked the most profitable and effective marketing channel in today’s digital world. Email ROI (return-on-investment) outranks all other online marketing channels like social media and paid search as well as traditional offline channels such as print advertising and telemarketing. During this six-hour course, students will learn to set up and manage a free email marketing platform, gain subscribers, design effective emails, and create auto responder or sequential campaigns. Classes are hands-on using Mail Chimp, but the principles and strategies will work in any platform. Program topics will also include planning & strategy, list building, email design, automation, and copywriting. *This class will be held at the Warren Forest Higher Education Council, 589 Hospital Dr., Warren, PA 16365 Jamestown Campus

Word Processing

Microsoft Word - Part 1

Improve your word processing skills and take advantage of all the great features the newest version of Microsoft Word has to offer. You will create, revise, and save documents for future use and also learn the interface, creating and using autocorrect entries, spell and grammar check, thesaurus, and find and replace features. In addition, you will insert and remove page breaks, adjust margins, change line spacing, set, modify and remove tabs, cut, copy, and paste text, and create a mail merge for letters, labels or envelopes. Price includes textbook.

Microsoft Word - Part 2

Learn advanced word processing skills. You will work with tables creating, sorting, performing calculations, and adjusting properties, and also create and edit documents which include Word Art, clip art, drop caps, auto shapes, text boxes and other objects. Use your creative side as you format a newsletter trying out format changes using built-in and custom styles. Prerequisite: MS Word Part I. Price includes textbook.

Quick & Dirty Overview of Office Apps

Lets get quick and dirty with three hours of intense learning of Microsoft Office applications. Learn all the buttons of the ribbon bar, status bar, and quick access toolbar in Word, Excel, and PowerPoint. Work with creating, saving, and sharing documents. You will also learn how to insert pictures and graphs in all the applications and conduct basic functionality in Excel. 

Spreadsheets

Microsoft Excel -Part 1

Use Microsoft Excel to manage, display, and save numerical data. This course covers cell ranges, adjusting column width and row height, formatting cells, performing worksheet calculations, inserting and deleting rows, columns, and cells, hiding and unhiding rows and columns, managing multiple worksheets, inserting, deleting, and moving worksheets, editing multiple sheets, relative and absolute cell references, working with charts and tables, organizing large amounts of data, including the use of the IF function. Price includes textbook.

Microsoft Excel-Part II

Advance your Microsoft Excel skills even more! In level II, you will learn about formatting and customizing themes, working with date functions and conditional formatting, entering date and time calculations, using functions to modify text, troubleshooting formulas. You will also be introduced to LookUp functions, creating subtotals and using the quick analysis tool. Prerequisite: Working knowledge of Windows & MS Excel Part I. Price includes textbook.

Microsoft Excel-Part III

This class provides more complex skills than those presented in our Level I and II. Topics covered include working with PivotTables and PivotCharts, financial functions and What-If analysis, auditing and additional functions, advanced formatting and analysis tools, inspecting and protecting your workbook, and more. Prerequisite: Working knowledge of Windows & MS Excel Part I & II. Price includes textbook.

Constructing Microsoft Excel Formulas

Do you want to learn how to build more complicated formulas, use functions and combine them in powerful ways? Learn to troubleshoot formulas using the auditing tools, document the formulas that you create, and use named ranges and cells in your formulas to better understand the purpose of the formula. Prerequisite: Excel experience.

Using Microsoft Excel Charts

Do you know Excel supports a wide variety of standard types of charts and graphs? What are you waiting for?! Create effective charts today that clearly and accurately convey the meaning of your data. Prerequisite: Excel experience.

Accounting

Introduction to Quickbooks

QuickBooks is a computerized accounting system that can be used by everyone from novice to professional. Learn how to: create your own company; work with customers, vendors, physical inventory, balance sheets and budgets, payroll basics, and customize and integrate QuickBooks with other programs. Some topics not covered in the class are covered in the textbook, such as Banking, Bidding and Estimating, and much more. Price includes textbook. Please register one week prior to class start date to ensure book arrival.

Databases

Access I

Microsoft Access, one of the most powerful and valuable business tools you’re not using. Most individuals, businesses, and organizations are using Excel, Word or some other application to care for their important data needs, when Access, the perfect tool, is sitting right there on their desktop! In our introductory course, you will learn: Databases and Tables – Sorting Data, Importing Data Sources; Working with Forms – Layout & Design View; Querying a Database – Using Criteria, Sorting & Limiting Results, Calculated Fields; and Using Reports to Display Information on How to Organize, Structure and Modify Reports

Web Development

Let’s Build a Website in Wix Quickly and Easily

Start building a website with Wix’s easy to use website creation tools that will allow your creativity to stand out without the worry of all the technical hurdles when building a website. There is no coding or website knowledge required! Get your business or organization online today!

Website Development Series

Take the entire series of the five following courses and save $16.

Basic Website Design with WordPress

Create your own website in just four hours. Use WordPress software to build a customizable website for personal or business use. Bloggers, small business owners, and all types of companies use WordPress to manage and operate their website. WordPress makes it easy to customize and edit content quickly and easily without learning code.

Advanced Website Design with WordPress

Advance your creative skills with WordPress. Learn to set up plugins, configure widgets, set up custom menus, and customize your website template. You will also learn where to go for additional help. Must have taken Basic Website Design class or have experience with WordPress.

Cattaraugus County Campus - Olean

Sell Online With Your Ecommerce Website

Let’s start selling online! Learn about ecommerce options such as Shopify, Big Commerce, and how to use a WordPress website as an online storefront. For many small businesses, there's no need to build an expensive online shop from the ground up. Learn ways to get your shop up quickly and easily with minimal upfront costs.

Let’s Boost Traffic On Your Website With Search Engine Optimization (SEO)

Have your website stand out from others by learning the techniques that will allow your it to gain a top spot within a search engine. You will learn SEO techniques such as: title tags, meta descriptions, keywords, quality content guidelines, user experience guidelines and analysis methods. SEO is a critical tool for businesses in the competitive online environment.

What, When, and Who is Visiting Your Website

Explore how web analytics can help you gain a better understanding of your website and your visitors. Find out how many people visit your website, how they found it, pages they liked and didn't like. Web analytics can help you create a better user experience for your website's visitors and can help you track performance. Learn how to set up web analytics, use tracking codes, and analyze data.