Excel VBA Level 1
Course Outline

DURATION	1 Day
PREREQUISITES	This is a generic VBA course and is suitable for users of any version of Microsoft Excel VBA.  You need to have a good working knowledge of Excel.
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. Weekday Wed, 22-Feb-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 3-Mar-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 22-Mar-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 2-Apr-12 and Tue, 3-Apr-12 18:30 - 21:30 £200.00 +VAT Weekday Mon, 23-Apr-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 2-May-12 and Thu, 3-May-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 22-May-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 2-Jun-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 22-Jun-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 2-Jul-12 and Tue, 3-Jul-12 18:30 - 21:30 £200.00 +VAT Weekday Mon, 23-Jul-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 1-Aug-12 and Thu, 2-Aug-12 18:30 - 21:30 £200.00 +VAT Weekday Wed, 22-Aug-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 1-Sep-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 3-Sep-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 1-Oct-12 and Tue, 2-Oct-12 18:30 - 21:30 £200.00 +VAT Weekday Mon, 22-Oct-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 3-Nov-12 10:00 - 16:30 £200.00 +VAT Weekday Thu, 22-Nov-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 1-Dec-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 24-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.

MACROS

• Running Macros

• Where macros are stored

• Assigning macros to buttons or a custom toolbar

• Recording Macros

• Entering a list of people's names

• Formatting a cell

• Adding a Header and Footer

• Naming the three sheets

• Inserting three more sheets and naming them

• Running an Advanced Filter

• Inserting a Logo

• Exporting a Sheet to text

• Create a Pivot Table

• Protect a sheet with a password

• Copy a range and paste the values into a new workbook

• Open, Close, Save a workbook

TTHE VBA ENVIRONMENT

• The Screen Components
  

  • Project Explorer

  • Project Properties

  • The Code Window

  • The Immediate Window

  • Finding Macros

   

• Export and Import VBA Modules

• Add and Remove a module

ANALYSING VBA

• Understanding the macro results

• Understanding Code Formatting (Indents, etc)

• Reading from and writing to a cell

• Absolute vs Relative Referencing

• Playing back VBA
  

•  Stepping through code

• Stopping Code

 

• Excel Objects and their hierarchy
  

  • Workbook

  • Range

  • Cell

  • Worksheet

  • Columns

  • Rows

   

• Using the Offset property

• Using the object browser

WRITING CODE

• What is a sub procedure

• What is a function

• Formatting Objects

• Cut / Copy / Paste

• Deleting rows / columns / ranges / cells

• Using Msgbox

• Using Variables

• Variable Types

• Understanding Variable Scope

 

• If… elseif… end if

• Using With…

• Using Do… Loop

• Creating a simple function

• Understanding VBA’s Operators (*, /, + etc)