Microsoft Excel 2007 Macros course

Excel Macros course: This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items. Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros.

Entry Requirements

Students should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek another course.

Duration

This course will take apprimately 25 hours to complete. There are no restrictions or limits on completion.

Materials Supplied

Your course will be issued in paper format, printed in full colour and  contained in a college A4 ring binder. Your course will come complete with self testing exercises and assignments to test the knowledge gained as you progress.

Course syllabus



Click here for syllabus details

Assessment

Students are required to forward their completed asignments to student support via email once they complete the course. Once received we will arrange for them to be assessed and certification issued as below.

Certification

Excel Macros Award

Once completed successfully each student will receive their award from the college proving their skills and knowledge in this rewarding field. Add this to your completed folder of coursework and impress any potential employer. Your award will give you the self belief and confidence to progress further with your studies or help make inroads to getting that job you have always wanted.