START
 

Excel - VBA

SquareOne Training
Course summary
Length: 2 days
Price: 440 GBP excl. VAT
Language: English
Location: Liverpool
Next available date: Contact us for more information - Liverpool
Course type: Open / Scheduled

Course Description

This course is aimed at improving the skills of experienced / advanced users of Excel - and especially highly skilled developers that are wishing to add high-end automation to Spreadsheets. The programme covers Macros, User-Defined Functions, Variables, Programming and Custom Menu's as well as other details.

Suitability - Who should attend?

This course is suitable for experienced Excel Users, and especially highly skilled developers who wish to add high-end automation to Spreadsheets.

Course Pre-Requisites

Participants are expected to be an Advanced User of Spreadsheets and preferably have attended an Advanced Excel course.

For more information on suitability, please send an enquiry here

Training Course Content

Recording Macros

  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Recording
  • Running a Relative Recording, Viewing the Module
  • Modifying a Recorded Macro
  • Recorder Workshop
  • Creating a Recorded Application
  • Examining The Data

User-Defined Functions

  • Creating a User Defined Function
  • Using a User Defined Function
  • Creating another Function
  • Passing Multiple Arguments
  • Modifying a Function
  • Creating a Function Library

Using the VBA Editor

  • Opening & Closing The Editor
  • Working With The Project Explorer
  • Working With The Properties Window
  • Using The Work Area
  • Working With a Code Module
  • Running Procedures From The Editor
  • Setting Break Points In The Editor
  • Stepping Through a Procedure

Understanding VBA

  • Using the Immediate Window
  • Working With Object Collections
  • Setting Property Values
  • Working With Worksheets
  • Using the Object Browser
  • Programming With the Object Browser

Procedures

  • Creating a Command Procedure
  • Making Sense of IntelliSense
  • Using the Edit Toolbar
  • Commenting Statements
  • Indenting Text
  • Bookmarking In Procedures

Using Excel Objects

  • The Excel Object Model
  • Splitting the Screen
  • Using Workbook Objects
  • Using Worksheet Objects
  • Using Range Objects
  • Using Objects in a Procedure

Using Variables

  • Creating & Using Variables
  • Implicit & Explicit Declarations
  • The Scope Of Variables
  • Procedure Level Scoping
  • Module Level Scoping
  • Public Scoping Of Variables
  • Passing Variables By Reference
  • Passing Variables By Value
  • Avoiding Variant Data Types
  • Using Arrays

Programming Techniques

  • Programming Conventions
  • Communicating With The User
  • Prompting For User Input, Using The Input Method
  • Using IF To Make Decisions, Testing For Multiple Conditions
  • Looping a Fixed Number Of Times
  • Looping a Specified Number Of Times
  • Looping An Unknown Number Of Times

Creating Custom Forms

  • Creating a Custom Form
  • Changing The Form Properties
  • Adding Text Boxes To The Form
  • Moving Controls
  • Adding Label Controls To The Form
  • Changing Text Box Control Properties
  • Changing Label Control Properties
  • Adding a Combo Box
  • Adding Option Buttons
  • Adding Command Buttons
  • Running a Form

Programming Custom Forms

  • Initialising the Form
  • Closing The Form
  • Updating The List
  • Creating Error Checking Procedures 
  • Running a Form From a Procedure

Custom Menus

  • Creating a New Menu
  • Creating a Cascade Menu
  • Adding Menu Commands
  • Assigning Macros To Menu Commands
  • Removing a Menu
  • Automatic Startup
  • Consolidating Worksheets by Category or by Position

Sharing Workbooks

  • Programming Automatic Events
  • Running Automatic Procedures
  • Automatically Starting The Workbook

Expenses

For information on pricing for this open/scheduled course, please send an enquiry here

This course can also be delivered in-house and tailored to meet the particular requirements of your organisation. 

Provider: SquareOne Training

SquareOne Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Excel - VBA.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for SquareOne Training

SquareOne Training


2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Contact SquareOne Training
Enter & win £50 voucher

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

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

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
 
Find more courses here