inline-defaultCreated with Sketch.

This website uses cookies to ensure you get the best experience on our website.

Students
Tuition Fee
GBP 560
Per year
Start Date
Medium of studying
Duration
Program Facts
Program Details
Degree
Courses
Major
Computer Applications | Computer Programming | Software Development
Area of study
Information and Communication Technologies
Timing
Full time
Course Language
English
Tuition Fee
Average International Tuition Fee
GBP 560
About Program

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.

SHOW MORE
About University
PhD
Masters
Bachelors
Courses

University at Buffalo


Overview:

University at Buffalo (UB) is a public research university located in Buffalo, New York. It is consistently recognized as one of the world's most exceptional and affordable universities, making it a top choice for students and faculty globally. UB is New York State's flagship university and is known for its commitment to research, innovation, and community engagement.


Student Life and Campus Experience:

UB offers a vibrant campus life with over 400 student clubs and organizations. Students can enjoy Division I basketball games, kayaking on the on-campus lake, and a variety of other activities. The university encourages students to share their "True Blue" pride and wear blue on Fridays.


Key Reasons to Study There:

    Exceptional Academics:

    UB offers over 500 degree programs with world-renowned faculty.

    Research Opportunities:

    As a top 40 public research university, UB provides students with opportunities to collaborate with leading researchers and tackle complex challenges.

    Diverse and Inclusive Environment:

    UB fosters a welcoming and inclusive environment for students from all backgrounds.

    Affordable Education:

    UB is consistently ranked as one of the most affordable universities in the world.

    Vibrant Campus Life:

    UB offers a wide range of activities and opportunities for students to engage in both on and off campus.

Academic Programs:

UB has 13 schools and colleges, including:

  • Architecture and Planning
  • Arts and Sciences
  • Dental Medicine
  • Education
  • Engineering and Applied Sciences
  • Jacobs School of Medicine and Biomedical Sciences
  • Law
  • Management
  • Nursing
  • Pharmacy and Pharmaceutical Sciences
  • Public Health and Health Professions
  • Roswell Park Graduate Division
  • Social Work

Other:

UB is committed to sustainability and has been recognized for its climate action efforts. The university has a 12:1 student/faculty ratio, providing students with personalized attention and support.

Total programs
452
Average ranking globally
#143
Average ranking in the country
#67
Location
How can I help you today?