College of Staten Island
 The City University of New York

Office of Information Technology Services
 Faculty & Staff Training Schedule

Spring 2017 Training

For a listing of available Training for the Spring 2017 semester, please go to CSI Technology Training Program for Spring 2017

Topics Offered

MS Access I

  • how to create, open & save a database
  • import/export text files
  • create tables

MS Access II

  • create basic queries

MS Access III

  • create basic forms
  • create basic reports

Adobe Acrobat

  • convert MS Office documents to a PDF
  • how to create a form
  • create a writable PDF document

MS Excel I

  • difference between a workbook and a worksheet
  • set up a document
  • change default settings

MS Excel II

  • create a template
  • apply conditional formatting to cells
  • group data
  • link cells within a document
  • import/export data
  • filter

MS Excel III

  • create a pivot table
  • create macros
  • perform functions

MS Excel Charts

  • create a chart
  • create a graph

General Computer Skills

  • different parts of the computer
  • add icons to the start bar (task bar)
  • create/delete shortcuts on the desktop
  • folder management structure
  • and more...

Online File Storage System (CSI MyFiles)

  • accessing the system
  • navigation
  • uploading files
  • sharing files

MS Outlook/Instant Messaging

  • create a distribution list/contact/group/address book
  • create a task
  • create a calendar
  • create an appointment
  • add attachments to appointments
  • scheduling assistant
  • message colleagues using IM

MS PowerPoint

  • create a presentation
  • how to import graphics to slides
  • create hyperlinks
  • custom animation
  • transitions

Reduced Sign On

  • accessing the system
  • setting up the password wallet

Windows Movie Maker/NJVID 

  • how to create videos using Windows Movie Maker
  • upload videos to NJVID digital media repository
  • information on using NJVID for Blackboard

MS Word I 

  • how to set up a document
  • create tables
  • create/customize ribbons/default settings
  • create hyperlinks

MS Word Mail Merge 

  • create a template
  • create mail merge