1569 Courses

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

This can be introduced in one day but is better offered over a series of twilight or half day workshops with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. Course Category Behaviour and Relationships Visioning and Problem Solving Team Building and Leadership Description ‘Insights and Solutions Circle’ a new expanded version of Solution Circle that uses some of the best of the Circle of Adults process. Its a 50 minute process and works really well with families and professionals! Contact us today for a live demo or training… Steps Problem presented Questions asked Theories Shared Strategies listed Dialogue regarding selected strategies Next steps Testimonials Excellent! It was great how we all cam up with ideas and theories including us parents I wish all meeting about my child’s behaviour were like this The whole world is going to be interested in this… The empowerment is great The buzz after the meeting says it all. Learning Objectives Deeper understanding of what is actually happening underneath the presenting behaviour Increased confidence in managing and building relationships with challenging pupils in mainstream schools Learn process for locating richer and wider range of practical strategies to impact on behaviour problems Deeper understanding of yourself and the psychodynamic processes happening between pupils, staff and pupils and families Opportunity to reflect on professional practice Mutual support established with other front line practitioners Who Is It For ? Team Around the Child agencies Parents and Professional working together Families Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in one day but is better offered over a series of twilight or half day workshops with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. The course answers the questions: Can we find an alternative to permanent exclusion or special unit or school placement? Cannot understand why a child is behaving as they do? Struggling with a child for whom praise is ineffective? Feeling isolated in your responses to a child’s needs? Worried about where your instinctive reactions are leading you? Cannot seem to get any consensus view of a young person’s behaviour/needs amongst all the family and professionals involved – is everyone pulling in different directions? We will cover: Setting the tone Background and detailed teaching of process Inclusion values underpinning this work Graphic and process facilitation skills Processes modelled and opportunities to try process out with coaching Practical setting up of insights and solutions circles Lessons learned If you liked this you may like: CIRCLES OF ADULTS…

This course is designed to: Give exam officers more confidence around access arrangement system and processes Develop best practice In four bite sized online modules, it can be done from the home or office. It also comes with an extensive range of materials. Once successfully completed an E-Certificate will be issued. Download our free leaflets to find out more. To enrol on the course, fill in the booking enquiry form below and an invoice/purchase order will be sent to you.

Course Information Join our comprehensive course, meticulously designed to equip individuals implementing Good Clinical Laboratory Practice (GCLP) within laboratories handling samples from clinical trials. Delve into the current regulatory landscape governing laboratory work supporting clinical trials, referencing key guidelines such as the ICH Guideline for Good Clinical Practice, the Clinical EU Trials Directive, relevant regulations, and leveraging insights from the RQA guidance document on GCLP. Is this course for you? This course is tailored for laboratory managers, analysts, investigators, trial coordinators, monitors, and auditors operating in diverse settings such as pharmaceutical company laboratories, central laboratories, contract research organisations, hospital laboratories, clinics, and investigator sites. This course will give you: Guidance on effectively interpreting and applying GCLP within the broader framework of Good Clinical Practice (GCP) Insight into the seamless integration of GCLP within clinical programmes (GCP) Practical strategies for implementing GCLP in the nuanced environment of clinical research laboratories The chance to update your knowledge with the latest interpretations and guidance on clinical laboratories by the UK Medicines and Healthcare Products Regulatory Agency (MHRA) Access to a seasoned panel of speakers with extensive expertise A unique opportunity to deepen your understanding of GCLP's application across diverse scenarios. Engage in: Lively discussions to foster ideas Problem-solving sessions targeting specific challenges Detailed exploration of specific aspects within the realms of GCP and GCLP. Tutors Tutors will be comprised of (click the photos for biographies): Vanessa Grant -, - Louise Handy Director, Handy Consulting Ltd Tim Stiles Consultant, Qualogy Ltd Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introduction 09:20 Good Clinical Practice and the Requirements of Good Clinical Laboratory Practice A review of Good Clinical Practice and its requirements for the laboratory analysis of samples from a trial. The thought processes behind the development of Good Clinical Laboratory Practice, its objective, scope, interpretation and application are explained. 10:00 Safety and Ethical Consideration Informed consent, confidentiality, expedited reporting, blinding and unblinding and serious breaches of the GCP are discussed. 10:40 Break 10:55 Organisation and Personnel Responsibilities within GCP and the Laboratory The responsibilities of key functions that should exist within a clinical laboratory including personnel records of training and competence are discussed. 11:30 Staff Training and Training Records Personnel records of training and competency assessments are discussed. 11:45 Laboratory Facilities, Equipment and Materials Suitable facility design, organisation and operation will be discussed. The calibration, validation and maintenance of equipment used in the conduct of sample analysis are examined, as are the suitability of materials and the identification and labelling of reagents and solutions. 12:30 Lunch 13:15 Workshop 1 - Facilities, Equipment and Responsibilities Some practical problems with regard to the facilities, equipment and responsibilities are explored. 13:45 Workshop 1 - Feedback 14:15 Computer Systems Validation Systems, including computerised systems, used in the analysis, collection and reporting of results should be appropriately tested, operated and controlled. What this means in practice is discussed. 14:45 Trial Protocols, Analytical Plans During this session we examine the purpose, content, control and change of these important documents. 15:30 Break 15:45 Workshop 2 - SOPs, Clinical Protocols, Analytical Plans and Validation The practicalities of managing and documenting the planning phase of analytical work on a trial are explored along with computerised system validation. 16:30 Workshop 2 - Feedback 17:00 Close of Day Day 2 09:00 Conduct of the Work and Quality Control Many of the issues that surround the conduct of sample collection, shipment, storage, analysis and management of Analytical Methods are discussed. This includes the quality control of the assay that may be employed and Quality Control checks. 10:00 Deviation Management The expectations around deviations and CAPA are discussed. 10:15 Workshop 3 - Conduct of the Work and Quality Control Practical work conduct and quality control issues are explored. 10:45 Break 11:00 Workshop 3 - Feedback 11:30 Source Data, Data Integrity, Records and Reports The creation and subsequent management of source data and records, data integrity, are discussed, together with the process of reporting analytical results. 12:10 Workshop 4 - Data, Records and Reports Practical problems with data, records and reports are investigated. 12:45 Lunch 13:30 Workshop 4 - Feedback 14:00 Quality Audit The requirements for and purpose of quality audits are discussed. The difference between quality audit and quality control are explained along with the role of the quality audit staff and their interaction with the analytical project managers, laboratory management and study staff. 14:40 Risk Management How should we assess risk and how can we use the process to assist in evaluation of audit findings. 15:15 Break 15:30 Regulatory Inspection The conduct of regulatory inspections and current expectations of the inspectors. Preparation for inspections and conduct during them will be discussed. 16:00 Panel Session This panel session will address any outstanding issues raised by the delegates. 16:15 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 14 Points Development Level Develop

In this Workshop we will review: Disc Herniation Stenosis Spondylolisthesis Discover the "contra-indications" and what to avoid. How to review and programme safe Clinical Pilates practices. Cost: €395

An accredited qualification for current and prospective managers. 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. One of the main responsibilities of a manager is to make sure that employees are satisfied with their job and reaching their full potential. A manager who can energise his or her employees will have a team which has a much greater potential and capability of achieving company goals and objectives. It is therefore vital that a manager has the essential skills to fully support and lead their team to success. This 3-day programme brings together the key leadership skills that you will need to be an effective manager so that you can return to the workplace and deliver tangible results. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 3 Award in Leadership and Management course is split into three main modules, covering the following: Module OneSolving Problems and Making Decisions What is a problem? How to identify a problem, its nature, scope and impact Identifying the root cause Understanding how to interpret information to solve a problem What is involved in making an informed decision? Generate ideas/solutions- creative thinking techniques How to evaluate your options Finding the critical path Having confidence to commit to a decision Planning approach Communicating the decision Implementing the plan Module TwoUnderstanding Leadership What is leadership? Recognise the differences and similarities between leadership and management Qualities and skills of a leader Action Centered Leadership - Team, Task, Individual - John Adair Varying leadership styles Evaluating a range of leadership models and their significance for: Task, Performance, Culture, Relationships Reflect on your own leadership styles and behaviours Create an action plan to enhance your performance Module ThreeUnderstanding the Communication Process in the Workplace Identify what is effective communication Understand the importance of effective communication at work Recognise the different ways we communicate Recognise possible barriers to communication and how to overcome them Johari's window - communication flows How others will perceive and interpret the information you have provided Active listening Developing questioning skills Understanding the significance of non-verbal communication and body language Developing sensory acuity and how to use it effectively in the workplace In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. In-House Courses As well as being one of the most popular open courses, we can also arrange this course as an in-house programme for companies and organisations who wish to develop a number of their managers at the same time, and would find an in-house course at their own premises much more suitable. Scheduled Courses On-Demand Course - Self-paced The online course option includes a comprehensive course manual, book reviews, useful guides and personalised tutor support. You will also be able to upload assessments online and receive online feedback. Our online training option gives you 24/7 access to our learning platform for the duration of your course. The programme elements and assignments can be completed as quickly as you like, with the only time limit being that the final assignment has to be submitted to ILM within 12 months of your registration on the programme. Cost: £695 + vat Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.

TEACHERS TRAINING COURSES are designed for those of you who are looking to take your dancing skills to a higher level. As the art of belly dance becomes more popular, the demand for teachers is rising and it is an extremely rewarding gift to be able to transfer and share your skills with others. This course is also beneficial for those of you who wish to gain a deeper understanding of Belly Dance and dancing in general. If you’ve ever thought of doing what you enjoy for a living, this is definitely for you.

Do you ever worry about how safe your students are in their relationships? Do you think that they might be vulnerable to abuse? You may work with students who indiscriminately sit on people’s laps or hug a stranger; or alternatively an adult with learning difficulties who is capable of having close intimate connections, but you worry about the speed of which they enter these relationships. These are common concerns and situations for any parent or care giver. It is well acknowledged that this need; to educate children and young people about relationships and social safety, is not being met at the moment. The SoSAFE! Programme is a visual teaching tool which enables learners to develop their abilities in managing; and communicating about their relationships. The program covers all degrees of interaction; from a student’s expectations of strangers, to the intricacies of an intimate relationship. SoSAFE! moves away from making feelings based decisions so we can enable and empower our learners to make their own judgments about what is okay to do with specific people. SoSAFE! provides a format which is portable and easy to understand, meaning that any student can discuss their relationships at any time. By giving students a set of ‘rules’ for different relationships they are better placed to realise when a relationship may not be acceptable and then have the tools to report potential abuse. If you want your students to have more success in safer relationships; but there is a gap in your knowledge that prevents you from doing this, then SoSAFE! is the framework for you. Teach them to be SoSAFE! Read a blog about one school's experience of implementing the programme. WHAT YOU WILL LEARN Discuss the history of and reasons for teaching social safety Identify characteristics of students and how best to support them Explore how to practically implement the SoSAFE! tool kit Learn how to teach explicit consent to any user Discover how to apply SoSAFE! to real life scenarios You can find further information on the SoSAFE Programme at sosafeprogram.com WORKSHOP DETAILS Agenda: 9:00 AM - 4:00 PM Registration Time: 8:30 AM - 9:00 AM Tuition Includes: A SoSAFE! Manual, all programme materials and SoSAFE! Tool Kit on a USB stick, handout with space for note taking and Certificate of Attendance.

  Being ISO 27701 Certified proves your Information Privacy Systems Audit experience, skills and knowledge, and demonstrates you are capable in the assessment of vulnerabilities, Compliance with GDPR and institutional controls within the enterprise.   Gain an in-depth understanding of GDPR solutions and how they map to compliance requirements Learn how to perform and lead Privacy Information Management System (PIMS) certification audits to ISO 19011 standards Enhance your existing or learn with new skills in the field of Data Protection Candidates deliver Assurance services to organisations by advising on conformance with PIMS requirements Become a Technical expert on the preparation required for ISO 27701 Certification Understand a Privacy Information Management System (PIMS) and its processes based on ISO/IEC 27701 Identify the relationship between ISO/IEC 27701, ISO/IEC 27001, ISO/IEC 27002, and other standards and regulatory frameworks Acquire the competences of the auditor's role in planning, leading, and following up on a management system audit in accordance with ISO 19011. Learn how to interpret the requirements of ISO/IEC 27701 in the context of a PIMS audit About This Course   ISO 27701 Internal Auditor Certification;    Confirms your knowledge and experience Quantifies and markets your expertise Demonstrates that you have gained and maintained the level of knowledge required to meet the dynamic challenges of a modern enterprise Is globally recognized as the mark of excellence for the Information Privacy Audit professional Increases your value to your organization Gives you a competitive advantage over peers when seeking a new role Is administered by the International Examination & Certification Board (IECB), based in Estonia, and fully aligned to the ISO/IEC 17024:2012 standard (Conformity assessment - General requirements for bodies operating certification of persons)   Certified Individuals:    Are highly qualified, experienced professionals in the field of Data Protection Systems Audit Provide the enterprise with a Certification route for Information Privacy Assurance that is recognized by multinational clients, lending credibility to the enterprise Are excellent indicators of proficiency in control requirements creation and monitoring Demonstrate competence in five domains, including standards and practices; organization and management; processes; integrity, confidentiality and availability; and software development, acquisition and maintenance Demonstrate a commitment to providing the enterprise with trust in and value from your Privacy Compliance Framework Maintain ongoing professional development for successful on -the -job performance   The below job practice is organized by domains. Each domain is covered in the course.   Domain 1-The Process of Auditing Information Privacy Systems and Solutions   Provide audit services in accordance with ISO 19011 audit standards to assist the organization in protecting and controlling information privacy systems.    Domain 2 - Governance and Management of Information Privacy Technology   Provide assurance that the necessary leadership and organizational structures and processes are in place to achieve objectives and to support the organization's strategy.    Domain 3-Information Systems Acquisition, Development and Implementation   Provide assurance that the practices for the acquisition, development, testing and implementation of information systems meet the organization's strategies and objectives.    Domain 4-Information Systems Operations, Maintenance and Service Management Provide assurance that the processes for information systems operations, maintenance and service management meet the organization's strategies and objectives.   Domain 5-Protection of Personally Identifiable Information (PII) Assets   Provide assurance that the organization's policies, standards, procedures and controls ensure the confidentiality, integrity and availability of PII.   Prerequisites   A thorough understanding of current Data Protection legislation, Information Security & Risk Management knowledge as well as ISO 19011 Auditing Standards is required to successfully pass the examination. What's Included?   Teas, Coffees, refreshments and a full Lunch* Course Slides Study Guide Exam Fees * For Classroom based Courses only Accreditation   Who Should Attend?   Auditors seeking to perform and lead Privacy Information Management System (PIMS) certification audits Managers or consultants seeking to master a PIMS audit process Individuals responsible for maintaining conformance with PIMS requirements Technical experts seeking to prepare for a PIMS audit Expert advisors in the protection of Personally Identifiable Information (PII)   Assessment     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 3 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success. Our Guarantee   We are an approved IECB Training Partner. You can learn wherever and whenever you want with our robust classroom and interactive online training courses. Our courses are taught by qualified practitioners with commercial experience. We strive to give our delegates the hands-on experience. Our courses are all-inclusive with no hidden extras. The one-off cost covers the training, all course materials, and exam voucher. Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. Our Promise: Pass first time or 'train' again for FREE.   *FREE training offered for retakes - come back within a year and train for free. Provided by   This course is Accredited by NACS and Administered by the IECB

Developing and using our innate resources well is as integral to mental health as meeting our emotional needs – join HG co-founder Ivan Tyrrell and Diploma tutor Carol Harper to explore them further Accredited CPD Certificate: 5 hours Suitable for: All health and welfare professionals – and anyone interested in what makes us who we are A perfectly coordinated seminar, a ‘dance’ between psychotherapy geniuses Ivan Tyrrell and Carol Harper - I wouldn't have missed it for the worldIAKOVOS FLASKIS Why take this course Nature provided us with a wealth of inbuilt resources to help us get our innate physical and emotional needs met. They are a fundamental part of being human, what we call human ‘givens’, and can be usefully thought of as internal guidance systems that not only enable us to survive but to achieve remarkable things. They have been continuously refined over thousands of years and are still evolving. A lot of attention is given to the importance of ensuring that people’s innate emotional and physical needs are met well – but our resources are an integral part of this: if they are not fully developed, or are misused or even damaged, we can suffer greatly. A clear understanding of these guidance systems, how they work and what they do for us, is essential if you wish to help others, improve our society, or understand yourself and those around you better. This is especially true if you are an involved parent, teacher, manager, or any kind of therapist. If you work with, or for, others you need this knowledge – understanding what makes us all ‘tick’ should be at the heart of everything we do. Amazing! Incredibly fascinating subject delivered with a deep respect for the profound human resources with which we are endowed...DAMIAN FEARNS, TRAINER, FACILITATOR, COACH What you will gain A deeper understanding of yourself and others More insight into the holistic nature of the rich but incomplete patterns that we inherit from our genes How and why these patterns must seek their completion in the environment An increased understanding of how memory is involved in learning – from birth to old age Guidance about how malleable memory is and why forgetting is as important as remembering The unexpected science behind emotional arousal – how emotions are created moment by moment A deeper understanding of the APET model – and why metaphorical pattern matching is central to all human interactions and endeavours Greater insight into why emotions create trance states in us – and the role this plays in many disorders Why being able to go into trance is essential for learning A richer understanding of the important role imagination plays A better understanding of how dreaming preserves the integrity of our genetic inheritance The confidence and skills to build on the instinct for rapport and what happens when that instinct is only crudely met in infancy An understanding of how rapport plays an important part in language acquisition How to counter the blight of loneliness Why reasoning is important and so difficult for some people What it means to ‘know’ something How we can check out our own emotional responses and biases We also consider whether intuition is an innate resource and the role accessing the Observing Self has in spiritual development And much more… No prior knowledge of the human givens approach is needed to benefit from this course. What's included? 14 Videos 10 Multiple choice quizzes PDF Course Notes & downloads Life-long access CPD Certificate Course programme The ‘A closer look at our innate resources’ online course is split into 10 sections and covers the following: Resources: guidance systems for life and learning Emotions, dreaming, trance states, imagination The ability to build rapport Reason, how we know and the Observing Self This course has been independently accredited by the internationally recognised CPD Standards Office for 5 hours of CPD training. Meet your tutors Ivan Tyrrell Ivan Tyrrell worked for many years as a psychotherapist and now spends most of his time lecturing and writing. Read more Carol Harper Carol has 30 years’ experience in private practice, her holistic outlook and curiosity has influenced her professional development… Read more Good to know This new online course is based on live online training given during the pandemic. It gives you a unique opportunity to learn from Ivan Tyrrell, co-founder of the human givens approach, and co-author with Joe Griffin of best-selling books about our innate needs and resources. He is joined by senior tutor Carol Harper – and together they draw on their extensive knowledge and lifetimes’ experience to share key insights that will deepen your psychological understanding and increase your ability to help people.