merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Microsoft Excel VBA Introduction

Activia Training
Course summary
1 day
249 GBP excl. VAT
English
Open / Scheduled
Next available date: 25/11/2019 09:15 - Birmingham
Course Dates
Birmingham
25/11/2019 09:15  (English)
249 GBP
22/01/2020 09:15  (English)
249 GBP
London
27/11/2019 09:15  (English)
249 GBP
18/12/2019 09:15  (English)
249 GBP
Manchester
09/12/2019 09:15  (English)
249 GBP
05/02/2020 09:15  (English)
249 GBP

Course description

Our Microsoft Excel VBA Introduction course will push your Microsoft Excel skills to a new level.

This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

Training Course Content

Recording and Running Macros in Excel
  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar
Introduction to the Excel VBA Editor
  • 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
  • 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
  • Understanding Objects, Properties and Methods
  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using the Resize Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
Controlling Program Flow
  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Get Inspired! Watch the Video

   

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel VBA Introduction.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number
www.activia.co.uk


Reviews

Average rating 4.5

Based on 28 reviews

Radika
(4)
Training was well managed and done well
Oliver
(4)
Our trainer, Steve was brilliant and brought extra helpful material.
Lydia
(5)
Lee could not be a better trainer!! He is so informative! I was so pleased to have him again after my first course
Request Information

Find out more about this Microsoft Excel VBA Introduction course - simply fill out your details:

Reviews
Course rating
(4.5)
Based on 28 reviews
U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Be Inspired - watch the videos