CoursesWorkforce Training
Menu
    All Courses
  • Home
  • About Us
  • Workforce Training
  • Top Courses
  • Become a Partner
  • Affiliates
  • Education Providers
  • Contact Us
  • Careers
  • Terms of Use
  • Privacy Policy
  • Blog
  1. Home
  2. Business & Finance
  3. Excel
  4. Short
  5. Excel Macros and VBA Course, Private 1-1, Live Virtual Classroom
Enquire Now

Excel Macros and VBA Course, Private 1-1, Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime
Course Fees
£380
PCWorkshops Courses

Course overview

Recording and Running Macros in Excel

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

  • Setting Excel Macro Options
  • Record and run Simple Macros
  • Assign Macros to the Quick Access Toolbar

Introduction to the Excel VBA Editor

Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros

Creating Procedures and Functions

Create simple macro procedures in code that use variable to store data and communicate with the user

  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input From the User

Working With the Excel Object Model

The Excel course will explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks

  • Understanding Objects, Properties and Methods

Interacting With the Spreadsheet

  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
  • Updating Values in the Spreadsheet and Putting Values into the Spreadsheet

Functions

  • Using Standard Excel Functions in VBA
  • Creating new Custom Functions

Controlling Program Flow

Using Decision Making and Looping Structures to Control the way Your Program Works

  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Practical Project and Examples

Expand all and read more

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 1 Day

Course features

  • Excel Macros and VBA course certificate on completion (assessment based)
  • Excel Macros and VBA course notes
  • Practical Excel Macros and VBA course exercises, Excel Macros and VBA course homework/Excel Macros and VBA course revision work
  • To assist after the course, 1 free session for questions online Excel Macros and VBA course via Skype/Teamviewer

Payment options

Course fees – £380

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.

Reviews
Trustpilot

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Want to know more about this course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Want to know more about this course?

Get your free course guide now! Complete this easy form and you'll receive a course guide and consultation from PCWorkshops

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.
  • Popular Subjects
  • Qualification Levels
  • How to Become
  • Accounting
  • Administration
  • Bookkeeping
  • Computer
  • Counselling
  • Event Management
  • Hair and Beauty
  • Human Resources
  • IT
  • IT Support
  • Nail Technician
  • Networking
  • Payroll
  • Psychology
  • Software Testing
  • Supply Chain Management
  • Web Development
  • Xero
  • View More
  • Access to Higher Education
  • Advanced Certificate
  • Advanced Diploma
  • Bachelors
  • CertHE
  • Certificate
  • Diploma
  • ELCAS
  • Foundation
  • HNC
  • HND
  • Level 1
  • Level 2
  • Level 3
  • Level 4
  • Level 5
  • Level 6
  • Level 7
  • Level 8
  • LLM
  • Masters
  • MBA
  • MSC
  • MCSA
  • MCSD
  • MCSE
  • NVQ
  • Postgraduate
  • Short Courses
  • Undergraduate
  • View More
  • Begin a Career in IT
  • Bookkeeper
  • Career in Trading
  • Change Management Consultant
  • Cloud Architect
  • Construction Health Safety Officer
  • Cryptocurrency Expert
  • Forensic Scientist
  • Financial Modeller
  • Java Certified
  • Leadership Coach
  • Manager
  • Mentor
  • Microsoft Certified
  • Psychologist
  • Public Health Consultant
  • Software Developer
  • Software Tester
  • Start Your Careeer in Human Resources
  • Xero Certified
  • View More
Copyright © 2022 Coursesonline.co.uk Contact About Privacy Terms Become a Partner Affiliates Blog Sitemap
VAT No: 301 5420 62 Company No: 11182409

Coursesonline.co.uk uses cookies. By continuing you are agreeing to our use of cookies. Learn more.

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

Additional Cookies

This website uses additional cookies to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

Please enable Strictly Necessary Cookies first so that we can save your preferences!

Cookie Policy

More information about our Cookie Policy