Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Solid grounding
Best-practice essentials
Powerful formulas and clear reporting
Masterful manipulation and PivotTables

  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Foundation courses - Excel next step 4

Automation and robustness

     Duration: 1 day  
     Format: Hands-on, computer provided  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  
  YOUR POWER-PACKED AGENDA

Learn macros for automating tasks

  • Record a macro for a simple task.
  • Create a button to run a macro.
  • Build a macro that imports a text file, fills in missing data and inserts formulas.
  • Structure a long macro into shorter, more understandable procedures.
  • Discover the technique for selecting the imported range whatever its length.
  • Record relative movements.
  • Debug a macro by running one instruction at a time.
  • Program the flow with If..Then..Else statements.
  • Prompt the user for input and display messages.
  • Create a loop to delete certain rows of a range.

Apply protection

  • Stop users from making unwanted changes.

Recap range names

  • Understand why range names are essential for macros, file-links and much more.
  • Create, modify and delete range names, and learn the benefits of AbleOwl naming conventions.

Create reliable, easy-to-follow formula links to other Excel files

  • Build your formula-links to other files so that changes to the source file don’t affect the destination.
  • Structure your links to make them easy to follow and change.

Ensure valid entries with Data Validation

  • Discover how to allow only number or date entries.
  • Provide an in-cell drop-down of valid entries.

Follow best-practice rules for reliability

  • Following on from previous courses, pick up more conventions for reliable, better-structured workbooks.

Break, change and locate file-links (optional topics)

  • Discover how to remove or repoint links to a different file.
  • Know how to locate where the links are.

Prerequisites

Excel users who are already competent with formulas and formatting, and who use Excel constantly. Those who have tasks that could be automated or who want to make spreadsheets easy and robust for others to use. Please note that the macros topic takes up over half of the course. Prior attendance at the Best practice essentials course is not mandatory, though an understanding of the range names topic it covers would be particularly useful.


  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.