Please route to the appropriate persons ...

FALL 2007


Contact us at 800-780-8299 or 330-315-1335 or


Register for Upcoming Classes ...

Classes are held simultaneously in our Training Lab at 703 South Main Street #211, Akron OH and online at http://projectconnect.webex.com.

Cost is $60 per person per class.  Quickies are $35 per person per class.

Click here to register for Training Lab classes
Click here to register for Online classes
 

  • Microsoft Word 1: Document & Formatting Basics
    09/20/07 ... 10:00 AM - 2:00 PM  -ONLINE ONLY!

    • Learn how to set your options, use toolbars, format your text, change your page set-up, set tabs, use headers and footers, and more. After this course, you will be able to enter, format, and print letters, reports, proposals, etc., using tabs and page set-up. Prerequisite: Skills covered in Introduction to Computers 1 & 2.

  • Microsoft Word 2: Tables, Merges & Macros
    10/04/07 ... 9:00 AM - Noon

    • This course is designed for those who feel they aren't using Microsoft Word to its full potential. Learn how to insert, format, and manipulate tables, as well as complete a mail merge. We'll also cover recording and using macros. Prerequisite: Skills covered in Microsoft Word 1.

  • Microsoft Word 3: Forms & Advanced Tools
    10/11/07 ... 9:00 AM - Noon

    • Learn how to design forms which you can send to staff, clients, volunteers, etc., to complete and return to you for tabulation. We will also cover advanced finds/replaces, special characters, and headers/footers. Prerequisite: Skills covered in Microsoft Word 1 & 2.

  • Microsoft Word 4: Graphics & Brochures
    10/18/07 ... 9:00 AM - Noon

    • There's no need to buy an expensive desktop publishing package if you have Microsoft Word. Learn how to insert and manipulate graphics, use columns, and other cool tools. After this course, you will be able to develop professional-looking flyers and brochures. Prerequisite: Skills covered in Microsoft Word 1, 2, and 3.

  • Microsoft Word 5: Newsletters
    10/25/07 ... 9:00 AM - Noon

    • A nonprofit's communication strategy should always include ongoing communications with its clients, client families, volunteers, donors, funders, etc. The most professional way is through newsletters. This course will focus on what you need to know to develop newsletters that get read. Prerequisite: skills covered in Word 1, 2, 3, 4.

    Click here to register for Training Lab classes
    Click here to register for Online classes

     

  • Microsoft Excel 1: Spreadsheet & Chart Basics
    09/18/07 ... 9:00 AM - Noon

    • Learn how to set your options, use toolbars, navigate through a spreadsheet, fill down and across, AutoSum, and more. After this course, you will be able to create a basic spreadsheet from scratch, write basic sum and average formulas, and create simple charts from your data. Prerequisite: Skills covered in Introduction to Computers 1 & 2.

  • Microsoft Excel 2: Formulas
    09/25/07 ... 9:00 AM - Noon

    • Learn how to enter and edit formulas-such as right and left, date and time, lookup, and IF statements. Also covers essential spreadsheet tools: grouping, naming, freeze/unfreeze panes, and references to other worksheets. Prerequisite: Skills covered in Microsoft Excel 1.

  • Microsoft Excel 3: Advanced Tools
    10/02/07 ... 9:00 AM - Noon

    • Learn essential spreadsheet tools: grouping, naming, freeze/unfreeze panes, and references to other worksheets. Prerequisite: Skills covered in Microsoft Excel 2.

  • Microsoft Excel 4: Data Analysis Tools
    10/16/07 ... 9:00 AM - Noon

    • For those of you who are ready to go the next step: subtotals and pivot tables! These tools consolidate your data and point out critical relationships. Also, advanced chart techniques will be covered. Prerequisite: Skills covered in Microsoft Excel 1, 2, & 3.

    Click here to register for Training Lab classes
    Click here to register for Online classes

     

     

  • QuickBooks 1: Setting Up Your System
    11/13/07 ... 1:00 PM - 4:00 PM

    • According to our surveys, QuickBooks is used by more non-profits than any other accounting package. This class will cover setting up the QuickBooks system … including preferences, customers, accounts, etc. Even if you currently use QuickBooks, this class might be helpful in understanding your system.

  • QuickBooks 2: Statements & Reports
    11/20/07 ... 1:00 PM - 4:00 PM

    • This class will focus on entering and processing invoices, payments, deposits, etc. This will also cover printing simple financial reports which you can share with your board and funders.

  • QuickBooks 3: Donors & Grants
    11/27/07...
    1:00 PM -
    4:00 PM

    • After you've got the basics down, it's time to customize it for your organization's needs. This course is good for people who have been using QB for some time, or those who have completed courses 1 and 2 and are ready for more. We will also look at donor management and advanced grant tracking.

    Click here to register for Training Lab classes
    Click here to register for Online classes


     

  • Microsoft PowerPoint 1: Slideshow Basics
    09/25/07... 1:00 PM - 4:00 PM

    • Learn how to set your options, use toolbars, use the different view options, use templates, set up a master slide, individualize slides, insert graphics, and more! After this course, you will be able to create a basic yet professional presentation with graphics. Prerequisite: Skills covered in Introduction to Computers 1 & 2.

  • Microsoft PowerPoint 2: Animation & Graphics
    10/02/07... 1:00 PM - 4:00 PM

    • Learn the more complex tools of PowerPoint, including the impressive animation settings. Prerequisite: Skills covered in PowerPoint 1.

    Click here to register for Training Lab classes
    Click here to register for Online classes


     

  • Microsoft Publisher 1: The Basics
    10/16/07... 1:00 PM - 4:00 PM

    • Publisher is a terrific program for people who want to create professional-looking publications without having to know design: it has lots of templates which are easy to use. This course will cover the basics of Publisher so that you can do flyers and brochures. Prerequisite: Skills covered in Microsoft Word 1.

  • Microsoft Publisher 2: Newsletters
    10/23/07... 1:00 PM - 4:00 PM

    • The focus of this course will be developing professional-looking newsletters for your organization. The focus is on understanding how to use frames to control your text flow. Forms will also be discussed. Prerequisite: Skills covered in Publisher 1.

    Click here to register for Training Lab classes
    Click here to register for Online classes

     

  • Website Development & Management: A Hands-On Planning Course
    10/23/07 ... 9:00 AM - Noon

    • Great websites just don't happen: they take a lot of planning and knowledge of theory. We will explore the options of website development, paying special attention to the differences between designing for paper vs. designing for the web. When you complete this course, you will have a good plan for your new or updated website. Then you can create it yourself or give your plan to your computer specialist.
       

  • Adobe PhotoShop: Graphics for the Web
    10/30/07 ... 9:00 AM - Noon

    • Learn how to use PhotoShop's powerful tools to correct color balances in your scanned photos, crop and resize your images, and prepare them for the web. This includes special techniques for reducing the size of your images to reduce download time. Prerequisite: Skills covered in Introduction to Computers 1 & 2

  • Microsoft FrontPage 1: Themes & Shared Borders
    11/13/07 ... 9:00 AM - Noon

    • We will cover the basics of FrontPage, the most popular website authoring software in the world! The focus will be on understanding how FrontPage works, designing themes, and using shared borders. After this course, you will be able to develop a simple but useful format for your organization's website. Prerequisite: Skills covered in Introduction to Computers 1 & 2.

  • Microsoft FrontPage 2: Formatting Your Web Pages
    11/20/07 ... 9:00 AM - Noon

    • This is the nitty-gritty of developing a website: the pages themselves. We will cover importing and formatting text, using graphics, hyperlinks, bookmarks, and tables. With the skills in this course, you will be able to create different types of pages using the format developed in Microsoft FrontPage 1. Prerequisite: Skills covered in Microsoft FrontPage 1.

  • Microsoft FrontPage 3: Cool Tools
    11/27/07 ... 9:00 AM - Noon

    • Now we explore the cool tools of FrontPage: forms, marquees, hover buttons, searches, etc. We will also discuss ways to make each attendee's website better and easier to use. Prerequisite: Skills covered in Microsoft FrontPage 1 & 2.

    Click here to register for Training Lab classes
    Click here to register for Online classes


     

  • Introduction to Microsoft Access: Data Entry & Other Basics
    09/18/07... 1:00 PM - 4:00 PM

    • Reduce your frustration and increase your efficiency by learning the underlying logic behind this database program. This will also include data entry techniques and writing and using simple queries and reports. Prerequisite: Skills covered in Introduction to Computers 1 & 2.

    Click here to register for Training Lab classes
    Click here to register for Online classes

     

The Database Developers Series  ONLINE ONLY

Non-profits thrive on databases ... funding and services depend on the staff'' ability to obtain information about clients, donors, volunteers, etc. Microsoft Access is relatively easy to learn compared to other database applications, but it does take a lot of time and commitment.

After this set of courses, you will be able to set up and use practical databases for your organization.

Because each course is based upon the information presented in the previous session, we ask that you take all five in the series. Cost is $300 for the entire series.

  • Microsoft Access 1: Database Planning & Set-Up
    10/03/07 ... 9:00 AM - Noon

    • This first session will focus on identifying what needs to be included in a nonprofit-related database and how to structure it so that the database will be easy to use and easy to retrieve useful information. Attendees will plan the database they need for their own organization. Prerequisite: Skills covered in Microsoft Excel 2.  

  • Microsoft Access 2: Database Tables & Relationships
    10/10/07 ... 9:00 AM - Noon

    • In the second session, we will actually set up the database planned in the previous session. Tables will be closely examined, especially field properties. We will also do quick searches, filters, and sorts. Relationships between tables will be a major focus. Prerequisite: Skills covered in Microsoft Access 1 and completion of homework.

  • Microsoft Access 3: Database Queries & Basic Forms
    10/17/07 ... 9:00 AM - Noon

    • Queries are used to analyze data, combine data from different tables, and retrieve data from one or more tables using criteria you specify. Forms can be created to "pretty up" your data, make data entry easier, and combine data from different tables and queries. We will also integrate the data into Microsoft Word and Excel for file exchange and publication. Prerequisite: Skills covered in Microsoft Access 2 and completion of homework.

  • Microsoft Access 4: Database Forms & Reports
    10/24/07 ... 9:00 AM - Noon

    • More extensive work on the forms will be covered. We will also cover creating and editing reports, which present your data in meaningful ways. Sub-forms and sub-reports will be discussed. Skills covered in Microsoft Access 3 and completion of homework.

  • Microsoft Access 5: Troubleshooting the Database
    10/31/07 ... 9:00 AM - Noon

    • This class will focus on troubleshooting the database and other useful tools. Also covers the important compact-and-repair tool. Prerequisite: Skills covered in Microsoft Access 4 and completion of homework.

    Click here to register for Online classes

     

 

Quickies Series

We're bringing back an old favorite: Quickies!! Unlike the regular half-day sessions, these one-to two-hour Quickies are down-and-dirty, learn-the-ropes-then-get-out-of-here-and-do-it-yourself courses.

  • Collecting Data the Easy Way: Taming the Survey Monkey! 
    10/30/07 ... 1:00 PM - 3:00 PM

    • Get important feedback from your clients, funders, community members, etc. Survey Monkey helps you gather and evaluate information about your programs, services, website, whatever!

  • Top Ten Tools to Improve Productivity
    11/18/07 ... 1:00 PM -
    3:00 PM

    • Shortcuts, shortcuts, shortcuts!!! Two hours of your time will save you days of tedious labor!

  • Advanced Techniques for Managing Yourself & Your Staff Using Outlook
    11/11/07 ... 1:00 PM - 3:00 PM

    • This session focuses on keeping all those e-mail messages organized, staying on top of meetings and appointments with Calendar, and advanced Task management.

Click here to register for Training Lab classes
Click here to register for Online classes
 

PROJECT CONNECT ... TECHNOLOGY SOLUTIONS FOR OHIO NONPROFITS

   

 330-315-1335
800-780-8299

www.PCLiveHelp.org