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, Oct-14-2011)”

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 (Thursday, Oct-20-2011)”

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, Oct-21-2011)”

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