Course Title: Advanced Microsoft Excel

Course Length: 6 hours typically offered in (2) 3-hour sessions.

Prerequisites: Intermediate Excel (201.500) or equivalent knowledge of Excel.

Objective: To build on existing Excel skills.

Recording a Macro Naming Assigning a shortcut key
Relative and absolute references in Macro
Running your Macro
Button or active X control
Tool bar button
Graphic Object
Menu bar
Lotus converted file
Managing Macros
Copy/delete
Rename
Edit

 

• Session 2

Creating a PivotTable
Modifying
Adding/removing fields
Displaying and Grouping

Beneficial to: Those interested in expanding their knowledge and skills of Excel.

Equipment Needed: Microsoft Office software, Lap Top Computers