The College of Charleston Human Resources department will offer an exciting array of computer courses for faculty and staff during Fall 2007.

Some of the courses will be taught by Trident Tech Continuing Education staff but represent a significant savings.  Each Trident course will have a cost of $100 per day or $60 per half day; however, half of the total cost ($50.00 for full day and $30 for half day) will be refunded by Human Resources upon successful completion of the course. An IDT made out to Human Resources is required as soon as possible or 14 days in advance of the course start date.  The IDT must be made out to Human Resources for the entire amount ($100 per day or $60 for half a day) and any non-attendance will be charged the entire amount.  Please make out a separate IDT per person per course – I will put the HR account in and change the amount upon completion of the course. All courses come with a reference workbook.

There is limited space available so registration will be on a first come first serve basis based on receipt of the IDT or upon e-mail registration mcclenaghanl@cofc.edu for the “no cost” workshops.

Course Descriptions

• Excel Basics ($60)
  Date:  Sept. 11
  Time: 9-12:30
  Location: Bell Building Room 500

  This course is for those who have little or no experience using Excel. It introduces the essential tools necessary to create basic business worksheets that use simple calculations and print on a single piece of paper. Topics include the mechanics, essential commands and features, basic data entry, formatting basic spreadsheets, range names, split windows, and freeze panes.

• Excel Formatting ($60)
  Date:  Sept. 18
  Time: 9-12:00
  Location: Bell Building Room 500
  
  Construct a basic spreadsheet and learn how to create numeric, label and date formats; insert and delete rows and columns; change column or row width; sort larger workbooks; and filter. Other topics include copying pasting tips and tricks using clipboard and printing features.

• Excel Charts ($60)
  Date:  Sept. 25
  Time: 9-12:00
  Location: Bell Building Room 500

  Learn how to use the charting feature in Excel Learn how to create, modify, enhance and print charts.

• Excel Simple Formulas ($60)
  Date:  Oct. 2
  Time: 9-12:00
  Location: Bell Building Room 500

  Topics include creating basic formulas and using more advanced functions such as date, mathematical, financial, logical and IF; data list functions; and unusual uses for formulas and functions.  Look-up functions are demonstrated.  Emphasis is placed on designing formulas to be linked and copied, and linking cells to other workbook pages and files.

• Excel Pivot Tables ($50)
  Date:  Oct. 9
  Time:  9-12:00
  Location: Bell Building Room 500

  What are they? Why would I use them? They make life easier and more efficient! Creating neat, informative summaries out of huge lists of raw data is a common challenge. And while Excel gives you all the tools you need to create such summaries, the actual work of writing formulas, cutting and pasting information, and organizing your totals into a new table can be extremely tedious. Even worse, this approach isn’t very flexible. For example, once you’ve created the perfect summary that compares, say, sales in different regions, if you want to compare sales across different product lines or different customers, you’ll need to start from scratch and build a whole new report.

  Fortunately, Excel has a feature called pivot tables that can solve all these problems. Pivot tables quickly summarize long lists of data. By using a pivot table, you can calculate summary information without writing a single formula or copying a single cell. But the most notable feature of pivot tables is that you can arrange them dynamically.

• Dreamweaver Introduction
  Date: October 11 and 18 (2 day class – IDT for $200)
  Time: 9-4:30
  Location: Bell Building Room 500

  Learn to use one of the most popular Web design tools to build attractive, dynamic Web pages.  Apply special features of the software to enhance Web pages, and learn efficient file management for web sites and techniques of FTP and remote server interaction.

• Microsoft Outlook Calendaring (no cost)
  Dates: Sept. 20 – 9:30 a.m./ Oct.  22  – 3:00 p.m./Nov. 19  – 10:30 a.m.
  Location: Bell Building Room 500

  Outlook Calendaring is an amazing and powerful tool that can assist you in organizing your work and personal life.  This 75 minute workshop will start with the basics, but also give you tips and tricks that will save time and effort.  If you can get your whole department on calendaring…it becomes even more powerful.

• Microsoft Publisher (no cost)
  Dates: Sept. 14 – 9:30-11:30 /Oct.   12 – 2:30-4:30/Nov.   20 – 9:30 – 1130
  Location: Bell Building Room 500

  Make great looking documents that adhere to the high standards of the College of Charleston Style Guide.  You will learn all of the exciting feature of Publisher and practice with pictures, layouts, and text so that you will be ready to make your own personal or business documents.