Microsoft Courses:
|
21a Peach Street, Wokingham, Berkshire, UK Tel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk Web: www.ptr.co.uk |
Microsoft Excel Macros CourseCourse Description This example-based, hands-on course introduces you to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time.
You will write and edit macros for Excel, using Visual Basic for Applications and the Integrated Development Environment. Upon successful completion of this course, students will be able to:
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Course pre-requisites: This course assumes that you have a sound grasp of working with excel, including writing worksheet formulas (such as SUM, MAX, MIN, AVERAGE etc) and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance.
To effectively understand this course, we recommend that you take the Microsoft Excel Level 1, Level 2 and Level 3 courses, or have equivalent experience. This course is rated as an Advanced Course, suitable for accomplished computer users.
Topics covered on the 2 day Microsoft Excel Macros coursePart 1: Basics of writing VBAPart 2: Selecting objects and setting values
Part 4: Using variables to store information
Part 5: Interacting with the userCode for Exercise 3Part 6: Branching and looping
Part 7: Object Variables and FOR EACH… NEXT loops
Course Classification: Applications Training Course Course Fee = £690 (excl.VAT)
Scheduled course dates
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Excel Training and bespoke Microsoft Excel courses
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The Microsoft Excel Macros course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates. View SAVE IT Scheme Details PTR Associates Limited21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United KingdomTel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk |