Microsoft Excel 2007 - I

This workshop provides an overview of Microsoft Excel 2007.  The workshop covers some of the major changes that have been made in Office 2007.  The following topics would be covered:

1. The Ribbon
2. Office Button
3. Adding or Deleting Worksheets
4. Auto Fill
5. Using Formulas and Functions
6. References (Absolute vs. Relative)

Location: LWH-4066

Prerequisites: None
1- Understanding basic computer usage (using mouse, keyboard, selecting text) is required. 
2- Understanding of basic math (Addition, Subtraction, Division, etc) 3- Working knowledge of any Office 2007 or Office 2003 product is preferred. 
4- Previous knowledge of Excel is preferred.

REGISTRATION:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Excel 2007 - I (Friday, Jan-13-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Excel 2007 - II

The workshop covers some intermediate topics in Excel. Some of the topics that will be covered in this workshop are:

A. Charts
o Purpose of a chart
o Different types of charts
o How to create a chart
B. Tables
o Purpose of a table
o How to add a table
o How to remove a table
C. Pivot Tables
o Purpose of a Pivot Table
o How to create a Pivot Table
o How to delete a Pivot Table
o How to manipulate a Pivot Table

PREREQUISITES:
1. Introduction to Excel.
2. Basic understanding of Excel 2003 or Excel 2007.
3. Understand the difference between absolute vs. relative reference.
4. Understand basic file management concepts (files, folders, hard drive, saving, etc).
5. Familiarity with formatting commands such as Bold, Italics, Underline, etc.
6. How to navigate the explorer window to locate files.
7. How to open / save / close files.
8. Basic usage of a mouse (click, double-click, right-click, etc).


REGISTRATION:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Excel 2007 - II (Friday, Jan-20-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Excel 2007 - III

This workshop covers the following topics

A. Name Manager
B. Data Validation Rules
C. What-if Analysis
D. Grouping & Data Consolidation

PREREQUISITES:
1. Introduction to Excel – I workshop.
2. Basic understanding of Excel 2003 or Excel 2007.
3. Understand the difference between absolute vs. relative reference.
4. Understand basic file management concepts (files, folders, hard drive, saving, etc).
5. Familiarity with formatting commands such as Bold, Italics, Underline, etc.
6. How to navigate the explorer window to locate files.
7. How to open / save / close files.
8. Basic usage of a mouse (click, double-click, right-click, etc).

REGISTRATION:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Excel 2007 - III (Friday, Jan-27-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.
 

Posted by: Faisal Kalota

Microsoft Access 2007 - I (Tables)

This workshop provides an Introduction to Databases using Microsoft Office Access 2007.  The following topics will be covered:
A. General database concepts such as records (rows), fields (columns), primary keys, attributes of the fields, relational database.
B. Overview of the Microsoft Access 2007 Interface
C. How to create Tables in Microsoft Access 2007 using Design View.

Location: LWH-4066

Prerequisites: 
1- Experience using of Microsoft Excel 2003 or 2007.  Ideally it is recommended that you have a minimum of approximately six months of experience with Excel. 

Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Microsoft Access I (Friday, Feb-10-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Access 2007 - II (Queries)

This workshop covers queries in Microsoft Access 2007. Some of the topics that will be covered in this workshop are:
* Query
- What is a query
- How to create a simple query
* Query Operators
- AND, OR, NOT
- Wild Card Characters
- Relational Operators
* Query Types
* Understanding different type of Queries (Select, Append, Delete, Update, etc)

PREREQUISITES:
* Microsoft Access 2007 - I (Introduction).
* General understanding of relational operators such as >, <, >=, <=, !=, etc.
* Be able to demonstrate the basic database principles by designing and creating a new database with at least 4 tables.
* Be able to create tables in a database and set various attributes of the fields in the table.
* Be able to establish relationship among the different tables.
* Be able to create tables by importing data from Excel and then updating the table properties.
* Be able to create a table and then import data from Excel.

Location: LWH-4066

Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Microsoft Access II (Friday, Feb-17-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Access 2007 - III (Forms & Reports)

The workshop provides an overview of Forms and Reports in Access 2007.  The following topics will be covered:

1 Reports
- Purpose of a report.
- Creating a simple report using the wizard.

2 Forms
- Purpose of a form.
- Creating a simple form using the wizard.

PREREQUISITES:  

• Microsoft Access 2007 - I  (Introduction)
• Be able to demonstrate the basic database principles by designing and creating a new database with at least 4 tables. 
• Be able to create tables in a database and set various attributes of the fields in the table.
• Be able to establish relationship among the different tables.
• Be able to create tables by importing data from Excel and then updating the table properties.
• Be able to create a table and then import data from Excel.
• Be able to create queries in Access using the Wizard.


Location: LWH-4066

Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: Microsoft Access III (Friday, Nov-24-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Word - II (Intermediate)

TOPICS:
1. Updating page margins.
2. Using built-in heading styles.
3. Updating heading styles.
4. Using heading styles to create an automatic table of content.

PERQUISITES:
1. Experience with any word processing software.
2. Participant should be comfortable with font formatting (Bold, Italics, Underline, etc) and Paragraph formatting (left, center, and right justification).
3. Use of mouse and keyboard.

Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 

“UTS Training: Word II (Friday, Mar-09-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft PowerPoint 2007 - I (Introduction)

This workshop provides an overview of Microsoft PowerPoint 2007.  The workshop covers some of the major changes that have been made in PowerPoint.  This workshop is intended for people who have not used PowerPoint or who would like to brush up their basic PowerPoint skills.  The following topics would be covered in the workshop:

1. The Ribbon
2. Office Button
3. The Home Tab (Font Formatting, Adding Slides)
4. Insert Tab (Adding Images, SmartArt, Header & Footers)
5. Applying themes to the presentation. 
6. Adding slide transition

Prerequisites: 
1- Knowledge of any Microsoft Office 2007 or 2003 Product.
2- Introduction of Office 2007 Workshop (or consent of instructor)
Registration:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 
“UTS Training: PowerPoint I (Thursday, Mar-15-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes: 
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

Microsoft Publisher 2007 - I

TOPICS: 
This workshop provides an introduction to Microsoft Publisher 2007. Some of the topics that will be covered in this workshop are:
* Creating a new publication.
* Adding various objects to the publications such as text boxes, images, etc.
* Formatting various options in the publication.

PREREQUISITES:
1. Formatting (Bold, Italics, Underline, etc) in a document.
2. How to open / save / close files.
3. Basic usage of a mouse (click, double-click, right-click, etc) and keyboard.
4. How to navigate the explorer window to locate files.
5. Experience with any word processor such as Microsoft Word, Corel Word Perfect, etc.
6. Preferred: Previous experience with Microsoft Publisher.

REGISTRATION:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 

“UTS Training: Publisher I (Friday, Mar-16-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota

HTML Basics

HTML Basics

TOPICS:
This workshop covers the basics of HTML and different elements of HTML. The following topics will be covered:

• Basic HTML Document
Create a blank HTML document.
Insert text holders for parts of the HTML document
Use paragraph, alignment, and table tags to structure HTML document.

• Making Changes
Add graphics and text effects to enhance HTML document.
Populate HTML document with data.

PREREQUISITES:
1. Formatting (Bold, Italics, Underline, etc) in a document.
2. How to open / save / close files.
3. Basic usage of a mouse (click, double-click, right-click, etc) and keyboard.
4. How to navigate the explorer window to locate files.
5. Experience with any word processor such as Microsoft Word, Corel Word Perfect, etc.


REGISTRATION:
To register please send an email to trainme@neiu.edu with the following phrase in the subject line 

“UTS Training: HTML Basics (Friday, Mar-23-2012)”

Please also include the following information in the email body
Full Name:
Department:
Title:
Email:
Phone:

Important Notes:
1. Pre-registration via email is required because seats are limited.
2. Please ensure that you send the email with the proper subject line and other information in the body, otherwise you may not be able to register.
3. The workshop may be canceled if there are not enough participants.  Please check the calendar periodically to check the workshop's availability.

Posted by: Faisal Kalota