Excel VBA Level 2
Course Outline

DURATION	1 Day
PREREQUISITES	Must least have had sufficient exposure to the concepts covered in Level 1 to be able to move onto new concepts.
DESCRIPTION	Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
COURSE DATES	Special: Four Days of MS Office training for the price of Three! Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekend Sat, 4-Feb-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 23-Feb-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 5-Mar-12 and Tue, 6-Mar-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 23-Mar-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 7-Apr-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 24-Apr-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 5-May-12 10:00 - 16:30 £200.00 +VAT Weekday Wed, 23-May-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 4-Jun-12 and Tue, 5-Jun-12 18:30 - 21:30 £200.00 +VAT Weekday Mon, 25-Jun-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 7-Jul-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 24-Jul-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 4-Aug-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 23-Aug-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 3-Sep-12 and Tue, 4-Sep-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 4-Sep-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 6-Oct-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 23-Oct-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 5-Nov-12 and Tue, 6-Nov-12 18:30 - 21:30 £200.00 +VAT Weekday Fri, 23-Nov-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 5-Dec-12 and Thu, 6-Dec-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 25-Dec-12 09:30 - 16:30 £200.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

Revision of Level 1

• VBE Components

• If Statements
  

• With…
  

Continuing Sub Procedures

• Revisiting the scope of Variables
  

  • Dim

  • Public dim

  • Const

  • Public const

   

• 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

   

• Using Select Case vs using If statement
  

• Expanding on Conditional Formatting limitations
  

Looping

• For Each cell in range… etc
  

• Do While… Loop
  

• Do Until… Loop

• For a = 1 to 50 etc

Error Handling

• Setting and going to Bookmarks

• Catching Errors
  

• On error goto….
  

• On Error Resume Next
  

• On Error goto 0
  

Functions

• 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)

   

• 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