Delegates will acquire the necessary skills to become productive in Excel.

All our training courses can be designed to suit your specific needs.

Objectives: This course provides an Advanced level of training.

Who should Attend:

Delegates who have attended the intermediate course.

Course Outline

• Point and click macros and script editing
• Introducing VBA programming
• Creating andusing pivot tables
• Logical Functions
• Text Functions
• Creating custom number and date formats
• Protecting cells, ranges and worksheets
• Using add-ins
• Goal Seeking and Solver
• The analysis tool pack
• Data transfer to/from other workbooks/programs