43366 Courses delivered Online

We run regular First Aid at Work public courses or we can bring our training to you. Includes complimentary annual refresher video training.

We run regular Paediatric First Aid public courses or we can bring our training to your workplace. Fully meets Ofsted and EYFS requirements.

We run regular First Aid at Work public courses or we can bring our training to you. Includes complimentary annual refresher video training.

We run regular First Aid at Work public courses or we can bring our training to you. Includes complimentary annual refresher video training.

Attend this Combined Course and you will be awarded a Paediatric First Aid L3 (12 hours) and a First Aid at Work L3 (18 hours) certificate.

We run regular Paediatric First Aid public courses or we can bring our training to your workplace. Fully meets Ofsted and EYFS requirements.

We run regular Emergency First Aid at Work public courses or we can bring our training to you. Includes free annual refresher video training.

Supervising First Aid for Mental Health FAA Level 3 Award in supervising First Aid for Mental Health (RQF). Award in Leading First Aid for Mental Health at SCQF Level 6. This course builds on the Level 2/5 Award in First Aid for Mental Health and covers a wider range of mental health conditions. Goes into detail on the range of therapy and professional support that a person may be given by professional bodies during treatment for a mental health condition.

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

The MindGYM is a brain training App that works scientifically to develop the neuroplasticity of your mind, so you can become a creative and innovative genius, thinking quicker in super-states of creativity and creative people-solving, whilst in gamma and theta brain waves of flow state and hemispheric synchronisation. You will be able to tap into boundless energy, and develop your physical and mental capabilities. In effect, the app gives you the mind and the body, to manifest into your life of your greatest desire.