Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per individual

£695 +VAT
Public course

Cost per course

£2,385 +VAT
Client site, max 10 individuals

Duration

3 Days

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

06/02/2019 Bradford
26/02/2019 Liverpool
01/05/2019 Bradford
17/06/2019 Liverpool

Book course

This course is intended for users who need to exploit Excel Visual Basic for Applications to automate tasks and use and create functionality not found in the standard Excel interface.

Objectives: At the end of the course users will be able to understand and create VBA code. You will be able to create procedures, user-defined functions and forms to help automate Excel spreadsheets for End Users.

Prerequisites: An advanced understanding of creating spreadsheets and manipulating data in Excel.

 Download Outline (PDF)

An Introduction to Macros
  • Recording & Running Macros
  • Adding Macros to the Excel Interface
  • Setting Macro Protection Levels
Getting Started with Visual Basic Editor
  • Exploring the Visual Basic Editor
  • Understanding VBA Procedures
  • Commenting & Editing VBA Code
Objects & Object-Oriented Programming
  • Understanding Objects & Dot Syntax
  • Referencing Cells with the Range Object
  • Organising Code using With...End With
Editing Features
  • Running Code in the Immediate Window
  • Completing Code with Auto Lists
Message Boxes
  • Creating & Customising Message Boxes
  • Receiving Information from Message Boxes
Variables
  • Understanding & Naming Variables
  • Methods of Declaring Variables
  • Defining Variable Data Types
  • Declaring & Using Constants
  • Assigning Values & Objects to Variables
Input Boxes
  • Creating Input Boxes to Receive User Data
  • Understanding & Customising Input Boxes
Writing Procedures
  • Calling Procedures from Different Locations
Function Procedures
  • Understanding and Using Intrinsic Functions
  • Writing User-Defined Functions
  • Using User-Defined Functions in VBA & the Excel Interface
Conditional Control Structures
  • Controlling Program Flow Using IF Structures
  • Using Select Case Structures
Looping Control Structures
  • Repeating Code Using Loops
  • Definite Loops
  • Indefinite Loops
Controls Dialog Boxes and Forms
  • Creating User Forms
  • Using Form Controls
  • Adding VBA Code to User Forms
Using Pivot Tables
  • Understanding Pivot Tables
  • Creating Pivot Tables with VBA
  • Manipulating Pivot Tables with VBA
Debugging & Error Trapping
  • Identifying Error Types
  • Reducing Errors in Code
  • Checking Code with Debugging Tools
  • Writing Code to Handle Errors

Book a course

Fill in your information to book this course. The information you provide on this booking form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here