Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Macros introduction
Macros next step
Macros advanced


  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Macro-writing courses

Speed up with macros - introduction 1-day

     Duration: 1 day  
     Format: Fully hands-on  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  

Complete tasks faster by automating them.
Make it easier for others to use your spreadsheets.
Make it easier on yourself too by automating your work.
Save time by not having to remember a long sequence of steps.
Reduce errors by having a Visual Basic macro faithfully repeat the same steps each time.
Build your own functions to simplify long formulas and give others access to specialised calculations.
Stop wishing for features Excel doesn’t have: create them yourself.

  YOUR POWER-PACKED AGENDA

Create a simple macro

  • Create a simple macro to speed up a repetitive task
  • Edit the macro
  • Add a macro button to the Quick Access Toolbar

Automate an import application

  • Recap range names, which are essential for macros
  • Structure your macros into separate simple procedures
  • Step through macros
  • Create a procedure to run others
  • Create an on-sheet button to run a macro
  • Use If statements
  • Prompt for the input of a month number
  • Allow the user to cancel a prompt
  • Check whether an input is valid
  • Prompt the user to select a file
  • Display messages

Loop to delete records

  • Use a For¡­Next loop to process through rows
  • Learn the different ways of looping

Discover objects, properties, and methods

  • Understand the logic of objects, property and methods
  • Discover the Object Browser
  • Know how to work with the Range object to create reliable macros
  • Work with collection objects

Create user-defined functions

  • Build your own functions to simplify long formulas
  • Create an add-in to make your user-defined functions available to all

Prerequisites

Excel users new to writing Visual Basic macros and those who have only limited experience of Visual Basic macros.


  LEARN IN A POSITIVE ENVIRONMENT
 
  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  COURSE CANCELLATION POLICY
 
A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.