Excel VBA Training – Level 1

    This introductory Excel VBA Training Course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its key principles, rather than simply memorising syntax.

    Basics

    Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros

    Objects, properties and methods

    About Excel objects, Using the Object Browser , Range object, The Selection property

    The Range property

    Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a cell, Retrieving a formula from a cell, Setting the value of cells

    Charts and drawing

    About programming charts, Assigning a range to a chart, Positioning a chart, Drawing shapes, Setting shape attributes

    Using Visual Basic

    Language structure, Using variables, Declaring variables, Scoping variables, Data types, Using constants, Using the VBA debugger

    Making decisions

    If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays

    Interactivity

    Assigning a macro to a menu, Assigning a macro to a toolbar, Assigning macros to other objects, Built-in dialogue boxes, Creating custom forms, Using the Form Editor , Using form controls


    Excel VBA Training On-site UK-Wide

    The fee for running in-house Excel VBA courses in Colchester is £795, per day.
    The cost for running customized Excel VBA courses in Luton is £795, per day.
    Our fee for delivering customized Excel VBA training in Tyneside is £795, per day.
    The charge for running customized Excel VBA training in Liverpool is £795, per day.
    Our price for delivering on-site Excel VBA courses in Medway Towns is £795, per day.
    The fee for running customized Excel VBA training in Doncaster is £795, per day.
    The fee for running customized Excel VBA training in Exeter is £795, per day.
    Our charge for delivering on-site Excel VBA courses in Farnborough/Aldershot is £795, per day.
    The charge for running customized Excel VBA training in Greater Manchester is £795, per day.
    Our charge for delivering Excel VBA courses in Chesterfield is £795, per day.
    Our price for supplying on-site Excel VBA courses in Reading is £795, per day.
    Our price for delivering on-site Excel VBA courses in Blackpool is £795, per day.
    Our fee for delivering in-house Excel VBA courses in High Wycombe is £795, per day.
    The charge for running Excel VBA courses in Chelmsford is £795, per day.
    The fee for running on-site Excel VBA training in Edinburgh is £895, per day.
    Our price for delivering in-house Excel VBA courses in Oxford is £795, per day.
    Our price for running on-site Excel VBA training in The West Midlands is £695, per day.
    The fee for running on-site Excel VBA training in Telford is £695, per day.
    The cost of supplying on-site Excel VBA courses in Accrington/Rossendale is £795, per day.
    Our charge for supplying Excel VBA courses in Sunderland is £795, per day.
    Our price for supplying in-house Excel VBA courses in Derby is £695, per day.
    Our price for delivering customized Excel VBA courses in Basingstoke is £795, per day.
    Our price for delivering customized Excel VBA courses in Eastbourne is £795, per day.
    Our fee for delivering on-site Excel VBA training in Northampton is £795, per day.
    The fee for running customized Excel VBA training in Ireland is £895, per day.
    The charge for running in-house Excel VBA courses in Preston is £795, per day.
    Our price for running Excel VBA courses in Sheffield is £795, per day.
    Our price for running customized Excel VBA training in Plymouth is £795, per day.
    Our price for supplying in-house Excel VBA courses in Slough is £795, per day.
    Our charge for supplying on-site Excel VBA training in Newport is £795, per day.
    The fee for running customized Excel VBA courses in Torquay is £795, per day.
    Our price for delivering customized Excel VBA courses in Burnley is £795, per day.
    Our fee for delivering customized Excel VBA courses in Ipswich is £795, per day.
    The fee for running on-site Excel VBA training in West Yorkshire is £695, per day.
    Our price for supplying Excel VBA courses in Dundee is £895, per day.
    Our fee for delivering customized Excel VBA courses in Cardiff is £795, per day.
    Our fee for delivering Excel VBA courses in Bristol is £795, per day.
    The fee for running customized Excel VBA training in Norwich is £695, per day.
    Our charge for supplying on-site Excel VBA courses in Birkenhead is £795, per day.
    Our charge for delivering customized Excel VBA courses in Coventry is £695, per day.
    Our fee for delivering on-site Excel VBA courses in Warrington is £795, per day.
    Our price for delivering in-house Excel VBA courses in Mansfield is £795, per day.
    The fee for running on-site Excel VBA courses in Greater Glasgow is £895, per day.
    The charge for running customized Excel VBA courses in Lincoln is £695, per day.
    Our charge for delivering customized Excel VBA training in Wigan is £795, per day.
    The cost for running in-house Excel VBA courses in Poole is £795, per day.
    The fee for running on-site Excel VBA courses in Worcester is £795, per day.
    The charge for running customized Excel VBA courses in Stoke-on-Trent is £695, per day.
    Our charge for supplying on-site Excel VBA courses in Maidstone is £795, per day.
    Our price for running customized Excel VBA training in Nottingham is £695, per day.
    Our price for supplying Excel VBA courses in Basildon is £795, per day.
    The cost for running customized Excel VBA courses in Hastings is £795, per day.
    Our charge for delivering customized Excel VBA courses in Swindon is £795, per day.
    Our price for delivering customized Excel VBA training in Brighton and Hove is £795, per day.
    The cost of supplying Excel VBA courses in Cheltenham is £795, per day.
    Our price for running on-site Excel VBA courses in Teesside is £795, per day.
    Our price for supplying customized Excel VBA training in Cambridge is £695, per day.
    The charge for running customized Excel VBA courses in Thanet is £795, per day.
    The charge for running customized Excel VBA courses in Birmingham is £695, per day.
    The cost of supplying on-site Excel VBA courses in Grimsby is £795, per day.
    The cost of supplying on-site Excel VBA courses in Burton-upon-Trent is £795, per day.
    Our price for supplying on-site Excel VBA courses in Greater London is £795, per day.
    The cost of supplying customized Excel VBA courses in Crawley is £795, per day.
    The fee for running in-house Excel VBA courses in York is £795, per day.
    Our charge for supplying customized Excel VBA training in Leicester is £695, per day.
    Our fee for delivering customized Excel VBA training in Southend-on-Sea is £795, per day.
    The cost of supplying in-house Excel VBA courses in South Hampshire is £795, per day.
    The cost for running customized Excel VBA training in Bedford is £795, per day.
    Our fee for delivering Excel VBA courses in Barnsley is £795, per day.
    Our price for delivering in-house Excel VBA courses in Blackburn is £795, per day.
    Our price for running Excel VBA courses in Gloucester is £795, per day.
    Our charge for supplying customized Excel VBA training in Bournemouth is £795, per day.
    Our price for supplying customized Excel VBA training in Aberdeen is £895, per day.
    The fee for running on-site Excel VBA courses in Peterborough is £695, per day.
    Our price for running customized Excel VBA courses in Milton Keynes is £695, per day.
    The cost for running customized Excel VBA courses in Kingston upon Hull is £795, per day.
    Our price for running Excel VBA courses in Swansea is £795, per day.
    Our charge for supplying on-site Excel VBA training in Belfast is £895, per day.