Skip to content

Automated Information Reporting with Microsoft Excel VBA - In-house training

Enquire for in-house and bespoke options

Pairview Training

Summary

Price
Enquire to get more info on pricing
Study method
Onsite
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Overview

The Advanced Microsoft Excel with Visual Basic (VBA) teaches delegates to write advanced macros to automate work and extend Excel features by programming add-ins and functions. VBA stands for Visual Basic for Applications, the programming language for Microsoft Office applications.

You will learn to…

Create and edit Macros

Use and understand VBA code

Link and combine spreadsheets and other Office applications

Set up advanced automation features

Description

Course Content

  1. Visual Basic Editor
  2. Objects, Methods, Properties
  3. Programming Tools
  4. The Menu Bar
  5. Running Code
  6. Run mode and Design mode
  7. Running Code from the development environment & the host application
  8. The Project Explorer
  9. Using the Project Explorer
  10. The Properties Window
  11. Changing a Property
  12. Using Constants
  13. Excel & Variable Constants
  14. Excel Objects
  15. Objects, Properties and Methods
  16. Getting & Setting Properties
  17. Calling Methods
  18. Passing Arguments
  19. Singular Objects & Collections of Objects
  20. Variables
  21. Dimensioning a variable
  22. Using variables in routines
  23. Object Variables
  24. Using Visual Basic Functions
  25. InputBox Function
  26. MsgBox Function
  27. Using a Set Statement
  28. Building Formula Control Structures
  29. If…Then Decision Structures
  30. Logical Operators
  31. Select Case Decision Structures
  32. Case Else
  33. Comparison Operators with Select Case Structure
  34. For… Loops & Do Loops
  35. While…Wend Statement
  36. UserForms
  37. Designing & Creating Forms
  38. Working with Controls
  39. Creating Custom Dialog Boxes
  40. Userform Properties Methods & Events
  41. Event Handling
  42. VBA Editing & Debugging
  43. Auto Macros
  44. Error Handling

4 Benefits of booking this course with us

Benefit 1

Development of the necessary skills to automate common tasks, apply advanced analysis and techniques to complex data sets as well as create and maintain an array of worksheets and datasheets to suit a range of objectives and outcomes.

Benefit 2

Hands-on, practical experience to solve the most popular problems.

Benefit 3

Intensive training on the most in-demand Big Data skills, with expert tuition by experienced senior Data Scientists practitioners.

Benefit 4

Fulfilling your potential and realising your career ambitions.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all