Visual Basic for Applications (VBA) in Excel Part 1 draft

Program Overview

This Visual Basic for Applications (VBA) in Excel program empowers individuals with a strong Excel foundation to enhance their workflows through automation and custom functionality. Delivered online over 10 weeks, the course covers essential VBA concepts, including macros, variables, loops, functions, and object-oriented programming. Participants will receive an official City, University of London certificate upon attending over 70% of classes.

Program Outline

Visual Basic for Applications (VBA) in Excel Part 1: Extracted Information

Degree Overview:

• Focus: Extends the functionality of Excel leveraging the Visual Basic for Applications (VBA) programming language.
• Target Audience: Individuals with a strong working knowledge of MS Excel who want to add automation and custom functionality to their workflows.
• Learning Outcome: Students will be able to write macros, utilize the Visual Basic environment, use variables, loops, and if statements, understand and write their own functions, grasp object-oriented concepts, work with Excel VBA objects and properties, understand events in Excel, and debug errors.
• Additional Information:
• This is a short course with no starting dates available currently.
• The course duration is 10 weeks (unconfirmed) and the fee is £560 (unconfirmed).
• The course is delivered online.
• The course is ideal for those working with Excel and needing to manipulate and analyze data.

Outline:

• Content: The course covers recording and running macros, assigning macros to menus, toolbars and buttons, utilizing the Visual Basic editor, working with input boxes and message boxes, understanding object-oriented concepts, exploring Excel objects, variables and constants, writing if statements and loops, using conversion functions, creating user-defined functions, building user forms and dialog boxes, error handling and debugging, and responding to workbook and worksheet events.
• Structure: The course takes place one evening a week for 10 consecutive weeks.
• Modules: The specific modules are not listed in the context.
• Course Schedule: The course schedule is not provided in the context.

Assessment:

• Certificate: Awarded an official City, University of London certificate for attending over 70% of the classes.
• Assessment Method: Informal assessment through group discussion, classroom activities, and question-and-answer sessions guided by the tutor.

Teaching:

• Teaching Method: Delivered by an industry professional in small groups.
• Faculty: The specific faculty member is not mentioned in the context.
• Teaching Approach: The context does not mention a specific teaching approach.

Careers:

• Career Opportunities: The context does not mention specific career opportunities associated with the course.

Other:

• Testimonials: The context includes positive testimonials from past participants.
• Benefits: The course is delivered by an industry professional, conducted in small groups, and provides a City, University of London certificate upon completion.

Additional Notes:

• The context mentions that the course is ideal for those working with Excel and needing to manipulate and analyze data.
• The course is designed for individuals with a strong working knowledge of MS Excel.
• The course does not require any prior programming knowledge.
• Admission Requirements
• Application Process

Disclaimer:

The information extracted is based on the provided context and may not be exhaustive. It is recommended to visit the official course website for the most up-to-date information.