37483 Courses delivered Online

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

Project Management Template Kit and Checklists

Exercise Pilates Yoga FREE Training

An accredited qualification to prepare supervisors and team leaders for a future management role. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. In order for a business to obtain maximum results, it is important that employees are motivated and supported in their job roles. It is the responsibility of the team leader or supervisor to lead their team effectively and present feedback to management. This 3-day programme will guarantee to boost your performance as a team leader and help you make the transition from working in a team to leading a team. We use a combination of theory and practical to help you develop yourself, and a toolkit of resources to use in the workplace. This is an internationally accredited course which not only carries kudos but it ensures you apply the learning back into the workplace for an immediate impact. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 2 Award in Leadership and Team Skills course is split into three main modules, covering the following: Module One Developing Yourself as a Team Leader Learning the various roles, functions and responsibilities of a team leader - depending on workplace Recognising limits of authority and accountability, and how these are defined Developing personal skills and abilities for effective team leading Using reflective learning skills to improve performance Identifying areas of strength and possible improvement Finding ways of obtaining feedback from others Receiving and responding positively to feedback Module Two Workplace Communications Learning stages in the communication process Consideration of the recipient's needs Spotting barriers to communication and how to overcome them Establishing a range of direct communication methods relevant to the team Collating a range of direct communication methods relevant to people outside own area of responsibility. This includes written, telephone, e-mail and face-to-face Recognising the aspects of face-to-face communication, including appearance, impact, body language Realising the importance of succinct and accurate records of one-to-one oral communication Reasons for maintaining records of one-to-one communication (e.g. potential disciplinary or legal issues) Module Three Managing Yourself Setting SMART objectives and using them to prioritise own actions Learning simple time management techniques Developing an awareness of own skills and abilities Giving yourself personal objectives in relation to team objectives Developing flexibility and responding to daily changing circumstances Diagnosing the causes and impacts of stress at work Identifying symptoms of stress in yourself Knowing the implications of stress for workplace and non-work activities/relationships Developing simple stress management techniques Available sources of support Action planning and review techniques Accreditation As with all ILM accredited programmes, participants will need to complete the post-programme activity in order to achieve their full ILM Level 2 Award in Team Leading. This element is designed to show to ILM that you are able to apply what you have learned in the workplace. Who Is It For? This programme is ideal for practising or aspiring team leaders, in any industry sector, who is looking to gain a solid foundation or develop their existing skills as a team leader. This internationally recognised course will give you a solid understanding of what is needed to be a successful team leader, how to delegate, motivate and how to implement these skills in to your work place. What Will I Learn? At the end of the course, successful candidates will: Have a good understanding of the team leader role Apply a range of effective communication skills to overcome barriers Know how to motivate, build confidence and gain the best from their teams Identify, build and encourage effective team behaviours Apply practical skills and knowledge to be transferred to the workplace Gain an internationally recognised qualification What Is Required? There are no formal entry requirements, but participants will normally be either practising or aspiring team leaders, with the opportunity to meet the assessment demands and have a background that will enable them to benefit from the programme. Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information about running this course in-house at your premises, please contact us for more information.

Learn how to effectively manage data breaches under GDPR regulations. Discover essential steps, from establishing a response plan to leveraging GDPR Data Protection Consultancy and gap analysis services. Ensure compliance and protect your organization.

Supporting people managers The flagship CAPE programme is different to other management development programmes. We offer people management training that supports managers to feel equipped, enabled and empowered to make an immediate and lasting impact. You will benefit from learning how conversation styles, self-belief and authenticity matter and practice your skills with one of our many charity partners towards the end of your training. 12 month multi-element programme Learn new coaching skills Work with charities to utilise your skills Limited spaces £1,795 plus VAT per person Our mission is to help you become a brilliant manager.

Catch up with Dr John Graham Brown (University of Liverpool), Phillipa Page (NADIS) and Matt Colston (ELANCO) on their discussion around liver fluke control in sheep. Dr Graham Brown works with NADIS and SCOPS to calculate and predict the parasite and fluke forecast for the year ahead. He discusses the risks posed for this year and specific farm risks to consider for your farm. Matt and Phillipa discuss testing, management and treatment options for effective control on your farm. This event concluded with a Q&A session. This webinar was hosted by NADIS in association with Elanco. Dr John Graham-Brown, BVSc, MSc, PhD, MRCVS John graduated from the University of Liverpool in 2010. As part of his studies, he also completed a master’s degree in Veterinary Parasitology. Having spent some time in mixed practice in Wales, John returned to Liverpool in 2012 to complete a PhD investigating liver fluke infection in cattle under the supervision of Professor Diana Williams. Since 2016, John has been working as a researcher and lecturer at the university investigating a range of parasitic diseases of livestock and domestic animals in the UK and abroad. John is also currently collaborating with the national animal disease information service (NADIS) to develop and produce their monthly parasite forecasts. Phillipa Page, BVSc BSc MRCVS  Phillipa qualified from Liverpool Vet School in 2006 and started her first job in Neath, South Wales in a mixed practice. Following a short time as a locum dairy vet in Devon she then joined Wood Vet group in 2009 as a large animal vet. Her work was predominantly dairy but she had a special interest in sheep and developed the sheep side of the practice. In 2016 she then moved to specialize in sheep veterinary work with Flock Health Ltd. This involves a mixture of consultancy flock health work, farmer and vet CPD training and collaboration with retailers, processors and pharmaceutical companies and industry levy bodies. Phillipa was part of the co design groups for the DEFRA Animal Health and Welfare Pathway and Endemics disease program. Phillipa also works with NADIS (National Animal Disease Information Service) as the sheep lead on the Blowfly, parasite control, online health planning and disease alerts information. She has been a board member on the British Cattle Veterinary Association and the Sheep Veterinary Society and is the current conference organiser for the Sheep Veterinary Society and the current Junior Vice President. Phillipa co authored and published a book ‘Sheep Keeping’ as part of the professional small holders series by 5M Publishing and the chapter ‘Lameness’ in Differential Diagnosis in Sheep. 2022 Herriot Publications. She is involved with research and works on regular contributions to publications and is currently working towards a Diploma of the European College of Small Ruminant Health and Production. Outside of work she is a tenant farmer of 100 acres. Together with her husband and two boys she farms a flock of 300 commercial ewes and has a farm shop. Matt Colston, BM & S, CertSHP, MRCVS Matt graduated from the R(D)SVS in Edinburgh in 1986. He then spent five years working in a mixed practice in Fife and the Borders before taking up a two-year demonstrator’s position (shared between R(D)SVS and SAC (Edinburgh Genetics), concentrating on equine reproduction and artificial breeding in small ruminants. He later obtained the Cert.SHP qualification before returning to general practice in Penrith, where he has worked since 1997. In November 2013, Matt joined Novartis Animal Health as a Veterinary Technical Advisor for the Farm Animal Team. When Novartis was acquired by Elanco, he continued in this role with the company. Also, Matt currently serves as the Chairman of Moredun Foundation's North of England Regional Board.

Catch up with Dr Katie Lihou (University of Bristol), Phillipa Page (NADIS) and Matt Colston (ELANCO) for discussions around blowfly control. A review of the blowfly life cycle along with preventative management strategies and appropriate chemical use was discussed by Matt from ELANCO. Phillipa described effective treatments of clinically affected sheep to minimise compromised sheep welfare. Dr Lihou discussed the costs associated with prevention and treatment of clinical cases of blowfly using cost/benefit analysis modelling. The webinar was a useful refresher ahead of the blow fly season to ensure that knowledge is up to date for improved client and customer engagement. This event concluded with a Q&A session. This webinar, aimed at Vets, SQPS and farmers, was hosted by NADIS in association with Elanco. Dr Katie L Lihou, PhD, BSc Katie completed her PhD at the University of Bristol on the prevalence and distribution of livestock ectoparasites in the UK, in the department of Veterinary Parasitology and Ecology. Before her PhD, she studied 3 years of Veterinary Medicine, before moving into Biology. Katie is now a post-doctoral researcher working in the Bristol Vaccine Centre on infectious disease epidemiology and modelling. Phillipa Page, BVSc BSc MRCVS Phillipa qualified from Liverpool Vet School in 2006 and started her first job in Neath, South Wales in a mixed practice. Following a short time as a locum dairy vet in Devon she then joined Wood Vet group in 2009 as a large animal vet. Her work was predominantly dairy but she had a special interest in sheep and developed the sheep side of the practice. In 2016 she then moved to specialize in sheep veterinary work with Flock Health Ltd. This involves a mixture of consultancy flock health work, farmer and vet CPD training and collaboration with retailers, processors and pharmaceutical companies and industry levy bodies. Phillipa was part of the co design groups for the DEFRA Animal Health and Welfare Pathway and Endemics disease program. Phillipa also works with NADIS (National Animal Disease Information Service) as the sheep lead on the Blowfly, parasite control, online health planning and disease alerts information. She has been a board member on the British Cattle Veterinary Association and the Sheep Veterinary Society and is the current conference organiser for the Sheep Veterinary Society and the current Junior Vice President. Phillipa co authored and published a book ‘Sheep Keeping’ as part of the professional small holders series by 5M Publishing and the chapter ‘Lameness’ in Differential Diagnosis in Sheep. 2022 Herriot Publications. She is involved with research and works on regular contributions to publications and is currently working towards a Diploma of the European College of Small Ruminant Health and Production. Outside of work she is a tenant farmer of 100 acres. Together with her husband and two boys she farms a flock of 300 commercial ewes and has a farm shop. Matt Colston, BVM & S, CertSHP, MRCVS Matt graduated from the R(D)SVS in Edinburgh in 1986. He then spent five years working in a mixed practice in Fife and the Borders before taking up a two-year demonstrator’s position (shared between R(D)SVS and SAC (Edinburgh Genetics), concentrating on equine reproduction and artificial breeding in small ruminants. He later obtained the Cert.SHP qualification before returning to general practice in Penrith, where he has worked since 1997. In November 2013, Matt joined Novartis Animal Health as a Veterinary Technical Advisor for the Farm Animal Team. When Novartis was acquired by Elanco, he continued in this role with the company. Also, Matt currently serves as the Chairman of Moredun Foundation's North of England Regional Board.

embodiment course, somatic movement training, somatic awareness, free mini course to get embodied, find your centre, get grounded, embodiment training, somatic dance course, life coach with somatic intelligence, transformational dance, conscious dance, journey to freedom, mind body soul connection, mind body spirit, dance movement therapy, movementcoach, personaldevelopmentjourney, movementmeditation

4-Hour Discovery Day - NLP Training Near Me | Ely Wellbeing Neuro Linguistic Programming (NLP) is a collection of models and techniques that provide insights into human psychological processes. Through its various models, strategies and tools, NLP helps people to change their lives by taking control of their thoughts, feelings and behaviours. Our 4 Hour Discovery Day gives you an opportunity to learn the basics of Neuro Linguistic Programming; how it