Excel VBA Level 2
Course
In Southwark
Description
-
Type
Course
-
Location
Southwark
-
Duration
1 Day
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Important information
Government funding available
Facilities
Location
Start date
Start date
About this course
Must least have had sufficient
exposure to the concepts covered in Level 1 to be able to move
onto new concepts.
Reviews
Course programme
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
PREREQUISITES
Must least have had sufficient exposure to the concepts covered in Level 1 to be able to move onto new concepts.
Revision of Level 1
-
VBE Components
-
If Statements
-
With...
-
Revisiting the scope of Variables
-
Dim
-
Public dim
-
Const
-
Public const
-
Dim
-
Understanding Events
-
User Input
-
A simple form
-
Inputbox and Msgbox
-
Using Worksheet Data
-
Providing a browse for a file box
-
Providing a GetSaveAsFileName box to save a file
-
A simple form
-
Using Select Case vs using If statement
-
Expanding on Conditional Formatting limitations
-
For Each cell in range... etc
-
Do While... Loop
-
Do Until... Loop
-
For a = 1 to 50 etc
-
Setting and going to Bookmarks
-
Catching Errors
-
On error goto....
-
On Error Resume Next
-
On Error goto 0
-
Using Built in VBA Functions
-
Working out differences in dates (Datediff, etc)
-
Extracting info from a long string (trim, left, right, mid, instr)
-
Working out what kind of value is residing in a cell (isnumeric, isstring, isdate... etc)
-
Working out differences in dates (Datediff, etc)
-
Creating your own Functions
-
A value with VAT added to it
-
Returning a country based on a provided city
-
Returning the last cell address in a range
-
Returning the last row in a range
-
Returning the last column in a range
-
A value with VAT added to it
Excel VBA Level 2