VBA Training Courses - Visual Basic for Applications with CPD


Exclusive Offers: £132 pp per day for group of 5 | Buy 1 + colleague half price |
41% LESS than leading provider QA





Microsoft Office VBA Training Courses at Infero Training

MICROSOFT VBA TRAINING COURSES are fully CPD Accredited and designed for beginners who want to learn Automation secrets in Excel or Access VBA. It will help you to create macros to automatically generate customised charts, reports and other data processing functions.

Benefits of Studying with Infero Training:
  • CPD Accredited Classroom training in Small Groups for Max Focus
  • Only Microsoft Approved Courseware and Exercise Files are used
  • Free Assessment of Skills prior to booking
  • Certificate of Completion & Complementary 12 Months Post Course Support
  • Premier Locations, Latest Tech, Refreshments, OR We Come to You
  • 100% Money Back Guarantee & Price Match Guarantee
  • Bespoke Courses & Group Discounts from £132 per person

 


MICROSOFT VISUAL BASIC FOR APPLICATIONS (VBA) COURSE DATES

A PUBLIC SCHEDULED Training Option is very cost-effective for 1-3 delegates. To BOOK, please click on a course and BOOK a relevant date. If a DATE is not suitable, please CONTACT us to arrange another day. We are VAT EXEMPT !

Microsoft Excel VBA Introduction (1 Day) Download Course Content Download Course Content
Location Start Date Duration Price
Birmingham
30/04/2019 1 day £ 248.00 Book
11/06/2019 1 day £ 248.00 Book
23/07/2019 1 day £ 248.00 Book
Bristol
25/06/2019 1 day £ 248.00 Book
Coventry
30/04/2019 1 day £ 248.00 Book
11/06/2019 1 day £ 248.00 Book
23/07/2019 1 day £ 248.00 Book
Leeds
25/06/2019 1 day £ 248.00 Book
Leicester
30/04/2019 1 day £ 248.00 Book
11/06/2019 1 day £ 248.00 Book
23/07/2019 1 day £ 248.00 Book
Liverpool
14/05/2019 1 day £ 248.00 Book
06/08/2019 1 day £ 248.00 Book
London-St Pancras
18/06/2019 1 day £ 248.00 Book
Manchester
14/05/2019 1 day £ 248.00 Book
06/08/2019 1 day £ 248.00 Book
Milton Keynes
18/06/2019 1 day £ 248.00 Book
Nottingham
30/04/2019 1 day £ 248.00 Book
11/06/2019 1 day £ 248.00 Book
23/07/2019 1 day £ 248.00 Book
Sheffield
25/06/2019 1 day £ 248.00 Book
Microsoft Excel Programming with VBA (3 Days) Download Course Content Download Course Content
Location Start Date Duration Price
Birmingham
30/04/2019 3 days £ 658.00 Book
11/06/2019 3 days £ 658.00 Book
23/07/2019 3 days £ 658.00 Book
Bristol
25/06/2019 3 days £ 658.00 Book
Coventry
30/04/2019 3 days £ 658.00 Book
11/06/2019 3 days £ 658.00 Book
23/07/2019 3 days £ 658.00 Book
Leeds
25/06/2019 3 days £ 658.00 Book
Leicester
30/04/2019 3 days £ 658.00 Book
11/06/2019 3 days £ 658.00 Book
23/07/2019 3 days £ 658.00 Book
Liverpool
14/05/2019 3 days £ 658.00 Book
06/08/2019 3 days £ 658.00 Book
London-St Pancras
19/06/2019 3 days £ 658.00 Book
Manchester
14/05/2019 3 days £ 658.00 Book
06/08/2019 3 days £ 658.00 Book
Milton Keynes
19/06/2019 3 days £ 658.00 Book
Nottingham
30/04/2019 3 days £ 658.00 Book
11/06/2019 3 days £ 658.00 Book
23/07/2019 3 days £ 658.00 Book
Sheffield
25/06/2019 3 days £ 658.00 Book
Microsoft Access Programming with VBA Download Course Content Download Course Content
There is no public schedule for this course.

Please contact us for information

 

More Microsoft Office courses

 

***If you cannot find the date or location you want, please contact us***


MICROSOFT VISUAL BASIC COURSE OVERVIEW

Visual Basic for Applications (VBA) is a programming language that allows for the creation of user-defined functions and the automation of many time-consuming computer processes and calculations.

It is similar to Visual Basic, only it is embedded in an individual Microsoft application like Access, Excel and Word. This means users do not have to buy a copy of Visual Basic professional, because Visual Basic for Applications is a standard feature of Microsoft Office products.

Using VBA you can create macros or small programs that perform tasks within the application and allows users additional customisation beyond what is normally available in Microsoft Office products, such as Excel, Access, Word and PowerPoint.

It is user-intuitive, which allows those with little or no computer programming knowledge to learn VBA.

The program can be used to keep lists of customers’ names or other data, create invoices and forms, develop charts, analyse scientific data, and for budgeting and forecasting. It can also control several features of a host application such as Excel, including manipulating user interface features, such as toolbars and menus and working with dialog boxes or customised user forms.

Microsoft VBA Courses are fully CPD Accredited and designed to help advanced users to build custom solutions and create macros to automatically generate customised charts, reports and perform other data processing functions.

Everything learned in each VBA course can be applied and used in all 5 Microsoft Hosting Applications: Access, Excel, Outlook, PowerPoint, and Word.

Each hands-on, intensive course is delivered as a combination of trainer demonstration, exercises to consolidate learner's skills, an interactive support as required. All delegates are awarded with a certificate upon completion of the course at the end of the day.

Each course is suitable for anybody wanting to learn VBA for 2016, 2013, 2010 or 2007 version, as it covers all the aspects and differences between the versions.

We have 3 different Microsoft VBA courses for you to choose from to suit your requirements whether you are a beginner or a advanced Excel or Access user.

 



Microsoft Excel Training Courses at Infero Training


Microsoft Excel VBA Introduction (1 Day):
   • Getting Started with Visual Basic for Applications
   • Record and Run Macros in Excel
   • Understand and Edit a Macro in the Visual Basic Editor
   • Understand and Create Procedures and Functions
   • Work with Code Editors
   • Understand and Work with Objects

This day long Excel VBA programming course introduces advanced Excel (however beginners in VBA) users to the process of writing and editing Macros in Excel. No prior programming experience is required. You will learn how to Record a Macro, Run a Macro, create a Standard Module, create a Sub Procedure, create a Function Procedure, create an Event Procedure and much more.



Microsoft Excel Training Courses at Infero Training


Microsoft Excel Programming with VBA (3 Days):
   • Getting Started with Visual Basic for Applications
   • Working with Procedures and Functions
   • Understanding Objects
   • Using Expression, Variable, and Intristic Functions
   • Controlling Program Execution
   • Working with Forms and Controls
   • Working with the PivotTable Object
   • Debugging Code
   • Handling Errors

1 day VBA course is a great introduction to VBA programming. However if you wish to learn more, then choose this 3 days Excel VBA programming course, as it introduces advanced Excel users to the process of writing and editing Macros in Excel, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. The course takes you from the beginner level of VBA to an advanced.



Microsoft Excel Training Courses at Infero Training


Microsoft Access Programming with VBA (3 Days):
   • Getting Started with Visual Basic for Applications
   • Working with Procedures and Functions
   • Understand Objects
   • Using Expression, Variable, and Intristic Functions
   • Controlling Program Execution
   • Working with Forms and Controls
   • Working with the Recordsets
   • Debugging Code
   • Handling Errors

This 3 days Access VBA programming course introduces advanced Access users to the process of writing and editing Macros in Access, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. The course takes you from the beginner level of VBA to an advanced.

 

A day course includes:
  • Instructor Led course in a small group for maximum focus
  • Training on Microsoft Official Curriculum
  • Free 12 Months Post Course Support
  • Certificate of Completion
  • Comfortable Premises with latest technology & Refreshements
  • Training at Your Offices or Our
  • Bespoke courses, Weekend dates
  • Money Back Guarantee, Price Promise Guarantee, and Group Discounts

Microsoft Visual Basic Application (VBA) Courses at Infero Training




 

 Microsoft Office Specialist Certification with Infero Training


CERTIFICATION


Upon successful completion of a Visual Basic for Application (VBA) courses, you can receive CPD Certificate and points.

Microsoft does not have a Visual Basic for Application (VBA) Certification, however, if you wish to pursue a Microsoft Certification you can take an exam to earn a Microsoft Office Specialist (MOS) certification and become MOS Expert and/or MOS Master in Microsoft Excel.

The certification is a proof of your expertise and proficiency to work with Microsoft Excel.

 



SAVINGS


Our pricing structure is very flexible. You can enjoy one-off group and/or year discounts schemes.

Get a group Discount for 5 or more employees - the larger the groups the larger the discounts. And the more course bookings, the higher the discounts!

Use our Exclusive Offer:
  • Buy 1 course, get 2nd half price for a collegue

We constantly monitor our prices and we take our pricing seriously. That is why you are covered with a Price Promise Guarantee. We promise to beat any legitimate quote on a like for like basis by at least 5% of the difference.



 

 



Microsoft Partner



QUALITY MANAGEMENT SYSTEM


We are a Microsoft Partner.

Our classes are taught using the Official Microsoft Curriculum and are led by Microsoft Certified Trainers to ensure the excellent quality of training.

Our first-class training specialists all have a minimum of 10 years training experience.

Our clients are invited to fill in our feedback forms at the end of the course. We evaluate the feedback daily to ensure a high quality of training. You can trust:
  • 1000s of happy customers
  • 99% of our clients recommending us
  • 97% would use their learning at job.

With our 100% Money Back Guarantee you simply have nothing to lose.

 


MICROSOFT VISUAL BASIC FOR APPLICATIONS (VBA) ONSITE TRAINING PRICES

An ONSITE Training option is a convenient and cost effective option for group(s) of more than 3 delegates. If you wish you can choose a specific version for training and customise course content.

Course
Name
1 person2 people3 people 4 people5 people6 people7 people8 people

Excel VBA Introduction
(1 day)
2016, 2013, 2010, 2007

 £544

 £599

 £654

 £709

 £764

 £819

 £874

 £929

Excel Programming with VBA
(3 days)
2016, 2013, 2010, 2007

 £1452

 £1577

 £1702

 £1827

 £1952

 £2077

 £2202

 £2327

Access Programming with VBA
(3 days)
2016, 2013, 2010, 2007

 £1452

 £1577

 £1702

 £1827

 £1952

 £2077

 £2202

 £2327

 


Benefits of Studying with Us:



Give us a call or let us call you or to find out more CLICK BELOW on the button.

  • Looking for Microsoft Office VBA Courses?
  • Need Different Versions?
  • Searching for a course at Your Premises or Public Schedule course?

If you answered 'Yes' to any of the above questions, then our Microsoft Office VBA training courses are for YOU!

So why not get in touch now and find out how we can help you build a better future?


Microsoft VBA Training Venue Locations:

 

We can deliver Microsoft VBA Training Courses to any of these locations:
Nottinghamshire: Nottingham, Beeston, Eastwood, Edwinstone, Mansfield, Newark on Trent, Worksop, Retford, Southwell
Leicestershire: Leicester, Loughborough, Market Harborough, Ashby-de-La-Zouch, Hinckley, Melton Mowbray, Coalville, Lutterworth
Lincolnshire: Lincoln, Gainsborough, Boston, Bourne, Sleaford, Market Rasen, Grantham, Grimsby, Holbeach, Louth,Scunthorpe, Cleethorpes, Skegness, Spalding, Stamford
Derbyshire: Derby, Chesterfield, Long Eaton, Ilkeston, Ashbourne, Bakewell, Buxton, Matlock, Glossop, Swadlincote
Northamptonshire: Northampton, Brackley, Brixworth, Daventry, Earls Barton, Peterborough, Rushden, Silverstone, Corby, Kettering, Wellingborough
Rutland: Oakham, Cottesmore, Ketton, Market Overton, Uppingham
Warwickshire: Warwick, Birmingham, Coventry, Alcester, Aston, Kenilworth, Nuneaton, Royal Leamington Spa, Rugby, Solihull, Redditch, Stratford-upon-Avon, Sutton Coldfield
Middlesex: London, Acton, Brentford, Camden Town, Chiswick, Edgware, Edmonton, Enfield, Fulham, Golders Green, Hackney, Hampstead, Hanworth, Harrow, Hendon, Highgate, Hounslow, Mill Hill, Millwall, Pinner, Potter’s Bar, Soho, Staines, Stanmore, Tottenham, Uxbridge, Westminster, Whitechapel
West Yorkshire: Leeds, Barnoldswick, Barnsley, Bradford, Doncaster, Harrogate, Halifax, Huddersfield, Rotherham, Saddleworth, Sedbergh, Sheffield, Skipton, Todmorden, Wakefield, Bingley, Pontefract, Castleford, Dewsbury, Keighley
East Yorkshire: Beverley, Bridlington, Filey, Kington-upon-Hull, Market Weighton
North Yorkshire: Guisborough, Hawes, Helmsley, Northallerton, Middlesbrough, Pickering, Redcar, Richmond, Thirsk, York, Harrogate, Wetherby, Whitby, Scarborough, Middlesbrough
Lancashire: Manchester, Preston, Barrow-in-Furness, Blackburn, Blackpool, Bury, Oldham, Bolton, Wigan, Liverpool, Lancaster, Salford, Southport, St Helens, Rochdale, Ulverston, Warrington, Widnes
Staffordshire: Stafford, Burslem, Burton upon Trent, Hanley, Leek, Lichfield, Stoke-on-Trent, Uttoxeter, Wolverhampton, Walsall, West Bromwich
Cheshire: Chester, Stockport, Crewe, Birkenhead, Wallasey, Altrincham, Halton, Macclesfield, Knutsford, Wilmslow
Bedfordshire: Bedford, Ampthill, Luton, Dunstable, Leighton Buzzard, Biggleswade, Sandy
Huntingdonshire: Huntingdon, Kilbolton, Godmanchester, St Ives, St Neots Cambridgeshire: Cambridge, Burwell, Chatteris, Ely, Gamingley, Melbourne, Sawston, Soham, Wisbech, Whittlesey.
Hertfordshire: Hereford, Ross-on-Wye, Leominster, Ledbury, Bromyard, Kington
East Midlands, West Midlands

Customer Satisfaction

Customer Satisfaction Rate at Infero Training
97% Recommend our Courses

        More on High Quality of Training
        More on Testimonials

Accreditation

  • Accredited CPD (Continual Professional
    Development) provider #776674
  • Accredited Training Organisation
    Affiliate for PRINCE2 #4832
  • SFA Registered Training Provider
  • Microsoft Partner

Our Clients

        More on Our Clients

Training Options

  • Public Scheduled Courses
  • One-to-One Training
  • On-site Training
  • Evening Training
  • Weekend Training
  • Closed Company Training

        More on Training Options

Infero Training Benefits

  • 100% Money Back Guarantee
  • Professional Industry Certified Trainers
  • Vendor Approved Course Materials
  • Practical, Real-world Skills
  • Optimum Class Size
  • Comfortable Premises   
  • Post Course Support
  • Refreshments

        More on Why Train With US

Want to know more?

Just fill in your details here and we'll be in touch.



Testimonials

I completed the Advanced Excel course and found it so good that I returned to complete the VBA course, By chance both courses happened to be on a 1-1 basis and my tutor Huseyn tailored the course to my needs.

The course was very hands on as most of the course involved using the info learned in class and applying it to data supplied by Infero.

The workbooks provided were clearly illustrated and had a step by step guide to complete each process.

     Gerard Cahill (Commercial Accountant) from Specsavers

 

The course was extremely informative and allowed me to gain an understanding of the functions, purpose and impact VBA can have to streamlining programs and processes.

The enthusiasm and genuine interest shown by the instructor contributed greatly to the engagement and overall success of the course - I would highly recommend this and any other Microsoft based courses via Infero to anyone at whichever stage of development you may be!

     Rob Carmichael (Senior Market Research Manager) from Vision Express

 

The VBA course I attended with Infero Training was very informative. It provided me with a very useful skillset that I am now using in my current role for many different things. I also now have a much better understanding of current systems that are using VBA. The enthusiasm of the instructor was great and definitely contributed to the overall experience of learning VBA. I would recommend this to anyone of any level of expertise as it highlights how VBA can help in many different ways throughout many different tasks.

     Jason (Programme Assistant) from Nottingham CityCare Partnership

 

The Microsoft Excel 2010 Programming with VBA course was great. The teacher (Samer) was patient and professional, and explained all the contents in a clear and understandable way. I noticed the effects of the course on my day to day tasks immediately, so am very happy with it.

     Sheila Bano-Hernandez (Evidence Analyst) from Valpak Ltd

 

I found the course very informative in a good atmosphere; Samer was very helpful and is a credit to your company. While I had some knowledge of VBA the course really opened the doors for me. I have already put what I learned into good use, automating processes that in the first instance saved us thousands of pounds as we no longer needed to hire an additional member of staff in that department thanks to the time saved.

     Graham Wright Management Accountant) from Mosaic Fulfilment Solutions

 

Thanks to everyone at Infero Training for making my VBA course not only an informative experience, but an interesting one too, for what could have easily turned into a Chalk and Talk course.

Samer\'s (the trainer) knowledge and enthusiasm for the content of the course shone through throughout the whole three days, taking what was a complete VBA novice to someone who not only understands how VBA works, but now has the ability to really impact not only my own work, but that of several different functions of the business.

     Neville Mellors (Project Consultant) from PMP Recruitment