Courses
Learning Management Systems
About us
Get in touch
Courses
Learning Platforms
About us
Get in touch
Microsoft Excel MACROS and VBA Introduction
This course is for people who want to expand their knowledge to record, edit and learn the Excel VBA programming language.
Get in touch
Suitable for:
Duration:
Learning style:
Virtual Classroom
Assured by:
Resources Included:
About this course

This course is aimed at people who want to expand their knowledge to record, edit and learn the Excel VBA programming language.

Learners will learn how to record macros and effectively use the Visual Basic Editor, use code to write sub procedures using common Excel objects, methods, and properties.

They will learn how to run the macros using different methods and debug the macro code.

Download Course Overview
Course dates
We are currently accepting admissions for the following upcoming cohorts:

Coming soon!

Make an enquiry
Self-led online courses include
Support for over 100 languages
Mobile-friendly design for playback on any device
Progress tracking and pass/fail tests
Automatic, remote updates to keep content fresh
Playback speed controls to speed up/slow down the video
Closed captions which can be turned on/off
This course covers
  • Recording a Macro using Absolute and Relative
  • Opening and saving Workbooks Containing  Macros
  • Get macros to run via shortcut keys, quick accesstoolbar, menus, and buttons
  • Launch the Visual Basic Editor
  • Writing Macros using Objects, Methods, and Properties
  • Testing and debugging macro code
  • Inserting, Copying, Printing, Renaming, and Deleting a Module
  • Copying Macro code between workbooks and personal folder
You may also like
View all courses
Power BI Intermediate
This Microsoft Power BI Desktop Intermediate training course is aimed at anyone looking to use this powerful, flexible, and highly accessible business intelligence tool to connect with and shape/transform data, build models, use DAX functions, and craft structured reports, which can then be shared through Microsoft Power BI Service with users.
1 Day
Virtual Classroom
Excel Advanced
This Excel Advanced course is aimed at people who want to expand their knowledge into some of the more advanced functions. The course also covers the creation, editing, and formatting of pivot tables and pivot charts, enabling dynamic data analysis and visualization. By the end, participants will possess a versatile skill set for efficient data management and analysis in Excel.
1 Day
Virtual Classroom
Train the Trainer
Who trains the Trainer? Training is not just about what you know; it is also about how you communicate that knowledge to an audience.
2 Days
Virtual Classroom
SharePoint (Super User)
This course covers SharePoint functionalities essential for effective site creation, security management, list and library organisation, document management, and other settings for streamlined collaboration and content management.
2 Days
Virtual Classroom
Get in touch
Teaching 4 Business provides online courses and learning management systems to businesses across a range of industries.
+44 3700 800 800
hello@teaching4business.com
155 Wellingborough Road
Rushden
Northamptonshire
NN10 9TB
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Popular Courses
Train the Trainer
Microsoft Project Introduction
Power BI Advanced
Food Hygiene Level 3
Managing HACCP Level 3
NEBOSH (National Examination Board in Occupational Safety and Health)
IOSH (Institution of Occupational Safety and Health) Managing Safely
Power BI Intermediate
Company
Courses
Learning Platforms
About
Contact
Teaching 4 Business is part of the We Teach You Group
© 2024 Teaching 4 Business
Privacy
Terms
Designed & developed by Finn Elliott.