Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: excel courses london | advanced excel course london | excel courses in london | excel course london | advanced excel course | introduction to excel | excel vba course | excel introduction | microsoft access course objectives | microsoft office specialist distance learning
Homepage › IT, Computing, Telecommunications Courses › PC Applications Courses › Excel Courses

Microsoft Excel Macros

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£690 + VAT

Duration:

2 Days

Start:

07/12/2008 calendar
See course programme

Requirements:

This course assumes that you have a sound grasp of working with excel, including writing worksheet ... see more

Request free information

Course objectives:

This example-based, hands-on course introduces you to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time. You will write and edit macros for Excel, using Visual Basic for Applications and the Int...

PTR Associates Ltd

PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 2 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives This example-based, hands-on course introduces you to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time. You will write and edit macros for Excel, using Visual Basic for Applications and the Int...
Requirements
This course assumes that you have a sound grasp of working with excel, including writing worksheet formulas (such as SUM, MAX, MIN, AVERAGE etc) and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance. To effectively understand this course, we recommend that y...
Price £690 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel Macros And Vba
CTS - Computer Training Solutions
Berkshire - £375 + VAT
 
Microsoft Excel Vba Programming
WWP Training Limited
Berkshire - £650 + VAT
 
Excel 2007 Intermediate
2e2 Training
Berkshire - £495 + VAT
 
Microsoft Excel Advanced
Prolog Training
Distance - £300 + VAT
 
Introduction to Microsoft Excel
Ideal Training Solutions
Berkshire - £150 + VAT
Compare the selected courses
+ excel Courses + Excel Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Microsoft Excel Macros
Course objectives:
This example-based, hands-on course introduces you to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time.

You will write and edit macros for Excel, using Visual Basic for Applications and the Integrated Development Environment.

Upon successful completion of this course, students will be able to:
  • Create new macros and edit existing ones
  • Assign those macros to toolbar buttons and to get them to run automatically
  • Create sub procedures to interact with the user, asking for information and returning information
  • Format a worksheet, including text, cell borders and shading and use custom number formats through VBA
  • Enter data in cells and retrieve data from cells programmatically
  • Assign headers and footers programmatically and work with workbook properties
  • Create code loops to iterate through sheets in a workbook or cells in a range, in order to process each item in them in similar ways
  • Create programmatic tests and have the code respond in different ways depending on the outcomes of those tests

    Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

    Requirements:
    This course assumes that you have a sound grasp of working with excel, including writing worksheet formulas (such as SUM, MAX, MIN, AVERAGE etc) and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance.

    To effectively understand this course, we recommend that you take the Microsoft Excel Level 1, Level 2 and Level 3 courses, or have equivalent experience.

    Course content:
    Part 1: Basics of writing VBA

    Part 2: Selecting objects and setting values
  • Overview
  • Properties and methods
  • Named vs Positional arguments
  • Examples of Properties and Methods
  • Exercise – selecting cells and inserting data
  • Exercise – adding formatting to a worksheet Part 4: Using variables to store information
  • Data types for variables
    Part 5: Interacting with the user
  • Using an InputBox to get information
  • Some examples of using the InputBox function
  • Exercise 3 – Using InputBoxes to automate headers and footers Code for Exercise 3
  • Using a MsgBox
  • Using a MsgBox to give information to the user
  • Using a MsgBox to get information from the user
  • Exercise 4 – Using MsgBox functions
  • Exercise 5 – Using InputBoxes, MsgBoxes and functions Part 6: Branching and looping
  • The IF block
  • Exercise 6 – Using IF…ELSE…END IF
  • Select case
  • Using SELECT CASE to test a single conditional against multiple outcomes
  • Exercise 7 – Using Loops
  • Exercise 8 – Using DO…LOOP
    Part 7: Object Variables and FOR EACH… NEXT loops
  • Exercise 9 – Using object variables
  • Using the UNION function and multiple object variables
  • Exercise 10 – Putting it all together
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 07/12/2008 Finish: 08/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Excel

    Courses IT, Computing, Telecommunications | Courses PC Applications | Courses Excel | Courses Microsoft Excel | Courses Microsoft Office | Courses Spreadsheet

    Information related to Excel

    More related courses
    Microsoft Excel 2003 - Entry Level to Proficient User £24 + VAT Online
    Excel 2007 £30 + VAT Distance
    Excel 2007 Training £195 + VAT Distance
    Microsoft Excel 2003, 2007, XP Intermediate Price: On request
    Excel 2000 Mos £75 + VAT Online
    + excel Courses + Excel Courses in Berkshire + PTR Associates Ltd Courses
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: microsoft office microsoft excel microsoft office specialist
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights