Bua Training
Suggested Uses
Training Course Outline
After the Course
You will be able to write complex macros that can read and write data from worksheets, process that data and write it to other locations.
  • Creating Macros
  • Correctin large amounts of data
  • Separating data into different worksheets
  • Collecting information through forms
  • Creating custom functions for Excel
  • 1   |  2   |  Next >>
     
  • Built-in Functions
  • Record and Running Macros
  • Introduction to VBA
  • Proper Selection Techniques
  • Procedures
  • Objects, Properties and Methods
  • Variable & Constants
  • Message & Input boxes
  • Performing Multiple Actions on an Object
  • Workbooks and Sheets
  • Reading and Writing from worksheets
  • Data Types
  • IF Statements
  • Loops
  • Controls
  • User Forms
  • Functions
  • Debugging and Error Trapping
  • Creating Add-Ins
  • How to Use What You’ve Learnt
  • Microsoft Excel VBA

    This course is for people who are Microsoft Excel power users or programmers who wish to utilise the VBA to develop more sophisticated applications.Microsoft Excel training courses are available at our state of the art training centre in Dublin City Centre or we are happy to travel to your company premises anywhere in Ireland.

    Fill out Microsoft Excel Pre-Course Questionnaire

    If you would like to have a course customised for your organisation, please contact us.
    Back to Software Training Course List
    2 Day Intensive
    Customisable
    Private Course
    Public Course
    Training Rooms
    Onsite
    Post-Course Support
    Consultancy Available
    © Bua Training 2018