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	Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Evening Wed, 15-Sep-10 and Thu, 16-Sep-10 18:30 - 21:30 £200 Weekday Mon, 20-Sep-10 09:30 - 16:30 £150 Evening Mon, 4-Oct-10 and Tue, 5-Oct-10 18:30 - 21:30 £200 Weekday Mon, 11-Oct-10 09:30 - 16:30 £150 Weekday Mon, 1-Nov-10 09:30 - 16:30 £200 Weekend Sat, 6-Nov-10 10:00 - 16:30 £200 Weekday Wed, 1-Dec-10 09:30 - 16:30 £200 Weekend Sat, 11-Dec-10 10:00 - 16:30 £200 Weekday Tue, 4-Jan-11 09:30 - 16:30 £200 Weekend Sat, 8-Jan-11 10:00 - 16:30 £200 Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400 Levels 1-4 Specials: Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 11-Oct-10 - Thu, 14-Oct-10 09:30 - 16:30 £540

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)