Call us on 01452 221 777
Email us at info@glosenterprise.co.uk
My Cart
Login | Register

Excel - VBA

Who should attend?

If you want to take your understanding of spreadsheets to the very highest levels and make the software do what you want it to do, then this is the course for you.  You should be confident with the advanced functions of Excel.

Why should you attend?

Macros offer amazing opportunities to save time by automating repetitive tasks. This course is designed for those who have been introduced to macros on the Excel Advanced course and want to go further.

Course outline

After the course, delegates will be able to:

  • Understand where to store macros and the implication for Excel files
  • Run a macro from a key press, button or Quick Access Toolbar icon
  • Record a macro
  • Edit an existing macro using Excel VBA
  • Create different types of loop using Excel VBA
  • Work with variables and Message Boxes
  • Use the input box
  • Incorporate decision making into code
  • Debug code to identify where problems lie
  • Resolve problems in VBA code
  • Introduce CASE statements into code
  • Change cell formatting based in conditions
  • Find text strings in worksheets with code
  • Manipulate text strings with code

Cost

Course: £252.00 +VAT

Time & Location

9:30AM until 4:30PM @ Twigworth Business Centre

There are currently no dates available for this course

Related Courses

insert-alt

Understanding Organisational Finance

Please email us at info@glosenterprise.co.uk if you are interested in attending this course and we will let you know the next date. This course delivered over 2 half-day sessions can be attended either in-person at Twigworth or online to suit your preference. As your position in the organisation rises, so too must your appreciation of the finances. You will need to be able to read financial documents and statements, draw conclusions from them and recommend actions. Through sound knowledge and understanding of finances, you'll be fully confident using financial performance indicators as the basis of decision making. This course will show you how!

 insert-alt

Project

This course is delivered over 1 full-day at our training centre in Twigworth. Project is a powerful management tool for controlling resources, time, personnel or skill against a set project deadline. The capabilities to accept milestones, task information and of course task deadlines, means modern companies can allow project management to be processed electronically. The generation of critical paths, task lists, resource charts and many other reports makes Project an essential business software.

 insert-alt

Project Management Skills

This course delivered over 1 full day in-person at Twigworth. This course will introduce you to the discipline required to manage projects to successful completion.  It will develop your planning and organising abilities and help you develop effective control measures. You will learn how to set up projects, initiate them, monitor them and keep them (and your staff) on track.