Advanced Excel

Objectives

This is an extension of the Intermediate Excel Class and will cover advanced features and student requests. Course content includes various functions, math features, and macros.

Six hours Total. Two 3-hour sessions.

Course Objectives:

The participant will 1) Create macros 2) link and group worksheets to create a workspace 3) work with pivot tables and charts and, 4), work with Goal Seeking.

Content Outline

• Using both relative and absolute macros
• Changing macros with Visual Basic (brief intro)
• How to manipulate and create Pivot Tables and Charts
• The difference between linking and importing worksheets
• Other advanced topics

 

 

 

Who Should Attend

NOTE: ONLY THOSE WHO HAVE PREVIOUSLY TAKEN INTERMEDIATE EXCEL SHOULD REGISTER FOR THIS CLASS

 

 

Register for this course.

Links to Class Categories:
• Computer Training
• Health and Safety Training
• Management and Supervisory Training
• Quality Assurance Training
• Team and Employee Development Training

All Contents Copyright
© Western Kentucky University 2006