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 |