Computer Training

Whether you want to update your skills or acquire new ones, consider us your partner for computer training.

Computer workshops are offered on campus, or we can bring the training to your organization with our mobile laptop lab.

We also offer software application consultations. Whether it's assistance with an existing spreadsheet or the need to develop new ones, we can provide expertise you can rely on.

We offer workshops on the following computer software applications:

 

Access Part 1

Students will learn basic Access skills including:

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports

 

Access Part 2

Students will learn intermediate Access skills including:

  • Learn to normalize data
  • Work with Lookup fields and sub datasheets
  • Create join queries
  • Add objects to forms
  • Print reports and labels
  • Create charts
  • Use PivotTables and Pivot Charts
Access Part 3

Students will learn advanced Access skills including:

  • How to query with SQL
  • Create crosstab
  • Parameter and action queries
  • Create macros
  • Import, export, and link database objects
  • Work with XML documents
  • Work with Windows SharePoint Services
  • Optimize databases
  • Password protect and encrypt databases
  • Set Access options and properties
  • Create 2007 to update data
Excel Part 1

Students will be given an introduction to spreadsheet terminology and Excel’s window components. Students will learn basic Excel skills including:

  • Create a basic worksheet
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet
  • Manage Excel workbooks
  • Print the content of an Excel worksheet
Excel Part 2

Students will learn how to use multiple worksheets and workbooks efficiently. Skill learned will include:

  • Use advanced formulas
  • Organize worksheet and table data using various techniques
  • Create and modify charts
  • Insert and modify graphic objects in a worksheet
  • Customize and enhance workbooks and the Microsoft Office Excel environment
Excel Part 3

Students will learn advanced Excel skills including:

  • Learn how to work with Pivot Tables and Pivot Charts
  • Work with advanced formulas and functions
  • Import and export data
  • How to query external databases
  • Running and recording macros
  • Integrate Excel data with the web.
  • Learn analytical features such as Goal Seek and Solver
Microsoft Office New Features

This course covers new features of each Microsoft Office application.

PowerPoint Part 1

Students will create new presentations and learn the following skills:

  • Format text on slides
  • Add graphical objects to a presentation
  • Modify graphical objects in a presentation
  • Work with tables in a presentation
  • Add charts to a presentation
  • Prepare to deliver a presentation
  • Apply transition effects
PowerPoint Part 2

Students will customize PowerPoint by modifying the Quick Access Toolbar and creating macros. Other skills learned in this class include:

  • Customize a design template
  • Add SmartArt graphics to a presentation
  • Add special effects to a presentation
  • Add multimedia content and interactive elements to slides
  • Presentation distribution
  • Integrating PowerPoint with Word and Excel
QuickBooks Level 1

Performance-Based Objectives

  • Set up a company
  • Work with lists
  • Set up inventory
  • Prepare business forms
QuickBooks Level 2

Performance-Based Objectives

  • Write and print checks
  • Process payments
  • Work with bank accounts
  • Enter and pay bills
  • Create modify, memorize and print reports
  • Apply password protection
Word Part 1

Students will work with styles, sections, and columns. Skills learned in this workshop include:

  • • Identify and work with basic Word tools and features
  • Edit text in a Word document
  • Insert special characters and graphical objects
  • Organize data in tables
  • Proof a Word document
  • Control the appearance of pages in a Word document
  • Print a Word document

 

Word Part 2

Students will work with styles, sections and columns. Other skills learned will include:

  • Manage lists
  • Customize tables and charts
  • Customize the formatting of a document using styles and themes
  • Modify pictures in a document
  • Create customized graphic elements
  • Insert content using Quick Parts
  • Control text flow
  • Use templates to automate document creation
  • Use the mail merge function
  • Use macros to automate common tasks
Word Part 3

Students will perform mail merges, create and use forms and create master documents. Other skills learned will include:

  • Create macros
  • Customize Quick Access toolbar and Keyboard shortcuts
  • Manage document versions
  • Work with XML documents
  • Simplify the use of long documents
  • Secure a document