Select Calendar(s) Jump to Today Select Date

year
year view

month
month view

2week
2week view

week
week view

day
day view

.

List
list format

hide
hide details

.

options
options

print
print

search
search

help
help

login
login

Client Service Center

 < Previous

Week of February 27, 2011

Next >  


Sun


Mon


Tue


Wed


Thu


Fri


Sat

27

28

9 a.m. - 11 a.m.
Excel 2007 - III: Advance

1

2

3

4

5

Monday, February 28, 2011

9 a.m. -
11 a.m.

Excel 2007 - III: Advance

Topics:
In this course we will cover the following major tabs/menus

• Formulas & Functions
  o How to enter formulas and/or functions
  o Anatomy of a function
  o Using different functions 
• Names
  o Creating Names
  o Using the name manager
• Data
  o Data validation rules
  o What-if analysis
• Grouping Data
PREREQUISITES:
* Basic understanding of Excel 2003 or Excel 2003
* Understand the difference between absolute vs. relative refernce
* Understand basic file management concepts (files, folders, hard drive, saving, etc)
* Familiarity with formatting commands such as Bold, Italics, Underline, etc.


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

“Excel 2007 - III: Advance (Monday, Feb-28-2011)”

Posted by: Faisal Sheikh

 

Top of page

Powered by WebEvent (tm).