Category
ICT
Course Type
Microsoft
Price Per Delegate
£895 +VAT
Public Scheduled Course
Price Per Course
£2,945 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
3 Days
Full/Part Time
Part Time
Provider
Book courseThis 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.
- Recording & Running Macros
- Adding Macros to the Excel Interface
- Setting Macro Protection Levels
- Exploring the Visual Basic Editor
- Understanding VBA Procedures
- Commenting & Editing VBA Code
- Understanding Objects & Dot Syntax
- Referencing Cells with the Range Object
- Organising Code using With...End With
- Running Code in the Immediate Window
- Completing Code with Auto Lists
- Creating & Customising Message Boxes
- Receiving Information from Message Boxes
- Understanding & Naming Variables
- Methods of Declaring Variables
- Defining Variable Data Types
- Declaring & Using Constants
- Assigning Values & Objects to Variables
- Creating Input Boxes to Receive User Data
- Understanding & Customising Input Boxes
- Calling Procedures from Different Locations
- Understanding and Using Intrinsic Functions
- Writing User-Defined Functions
- Using User-Defined Functions in VBA & the Excel Interface
- Controlling Program Flow Using IF Structures
- Using Select Case Structures
- Repeating Code Using Loops
- Definite Loops
- Indefinite Loops
- Creating User Forms
- Using Form Controls
- Adding VBA Code to User Forms
- Understanding Pivot Tables
- Creating Pivot Tables with VBA
- Manipulating Pivot Tables with VBA
- Identifying Error Types
- Reducing Errors in Code
- Checking Code with Debugging Tools
- Writing Code to Handle Errors
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application 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.
