2116 Other courses in Bushey delivered Live Online

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Information Join us for a two-day immersive course crafted to equip participants with an in-depth understanding of remote audit methodologies. Delve into the nuances between remote and face-to-face audits, dissecting their respective strengths and limitations. Through practical scenarios tailored for remote audit conduct, this course stands as an essential counterpart to our on-site audits course The Auditing Course. Who Should Attend: Applicable across various domains of regulated research and development, this course proves invaluable in contexts requiring a quality system for audit. Participants with firsthand audit experience stand to gain the most benefit from this programme. Expanding on Previous Learning: This course extends its relevance to all forms of audits and further amplifies concepts explored in RQA's suite of research quality assurance courses, including: 'Research Quality Assurance for Good Laboratory Practice,' 'Good Clinical Practice Auditing – Principles and Practice,' and 'Good Manufacturing Practice for Investigational Medicinal Products.' Benefits include improved: Understand the processes of planning, conducting, reporting and follow-up of audits Recognising the importance of personal approach in developing positive audit outcomes Ability to analyse evidence and present logical audit findings Appreciate the importance of audit in continuing improvement. This course is structured to encourage delegates to: Discuss and develop ideas Solve problems Exchange information. Tutors Tutors will be comprised of (click the photos for biographies): Andrew Waddell Founder Director, Tower Mains Ltd Rosemary Ichaba Senior QA Associate, Tower Mains Ltd Cate Ovington Director, The Knowlogy Group Ltd Jean McWilliam Associate Director, Alexion Programme Please note timings may be subject to alteration. Day 1 09:00 Course Registration 09:15 Welcome and Introductions 09:35 Introduction to Audits Delegates explore the range of audits which they have experienced, define the purpose of each audit type and establish which of those audits are performed to meet regulatory requirements. 10:05 Introduction to Remote Audits Presentation to introduce the major differences between face-to-face audits and remote audits. The major elements of audits will be examined to determine where there may be differences. 10:30 Break 10:45 Workshop 1 - Remote Audits This workshop will examine participants experience or understanding of the differences between face-to-face and remote audits. 11:15 Workshop 1 - Feedback 11:35 Audit Preparation The essential steps in preparation for audits will be discussed with emphasis on remote audits. 12:05 Workshop 2 - Remote Audit Preparation Factors relating to the preparation for remote audits will be considered in discussion groups. 12:35 Workshop 2 - Feedback 12:50 Lunch 13:30 Audit Logistics Preparation for the audit includes many arrangements other than the audit content. 14:00 Workshop 3 - Audit Logistics Delegates will discuss some of the issues that may occur during the set up and conduct of remote audits and how to resolve them. 14:30 Workshop 3 - Feedback 14:45 Break 15:00 The Opening Meeting Presentation regarding the importance and content of the opening meeting. 15:20 Workshop 4 - Opening Meeting Delegates will consider the practicalities of arranging and conducting an opening meeting. 15:45 Workshop 4 - Feedback 16:10 Audit Conduct Tools Practical advice on preparation of some of the tools that will be valuable in the conduct of audits. 16:40 Questions and Answers An overview of the first day and a chance to ask questions 17:00 Close of Day Day 2 09:00 Reflections on Day 1 Recap on the topics covered and a chance for delegates to raise points. 09:15 Gathering Evidence Presentation on challenges of gathering evidence and conducting interviews during remote audits. 09:45 Workshop 5 - Remote Interviews Scenarios of different remote interviews will be played and delegates assess the strengths and weaknesses of each approach. 10:15 Break 10:30 Creating Audit Findings Ideas regarding how to create good audit findings will be discussed during this short presentation. 10:50 Workshop 6 - Creating Audit Findings Delegates will be provided with examples of evidence from an audit. They will discuss these and create their audit findings for presentation at the closing meeting. 11:35 The Closing Meeting The content and conduct of the closing meeting will be discussed. 11:55 Workshop 7(a) - Preparing for the Closing Meeting The findings from workshop 6 will be reviewed and a Lead Auditor selected to provide feedback in workshop 7(b) 12:15 Workshop 7(b) - The Closing Meeting The Lead Auditor from each group will hold a meeting to present the results (role play). 12:45 Lunch 13:30 The Audit Report This presentation will cover not only the essential contents of the audit report but also how to write the report in a manner that will generate the most positive reaction. 14:00 Workshop 8 - The Audit Report Delegates will be provided with an audit report from an audit conducted remotely and will conduct a peer review of the report in their breakout groups. 15:00 Workshop 8 - Feedback 15:20 Break 15:35 Audit Closure Presentation on how to conclude the audit with reference to post-audit activities. 15:55 Open Forum 16:30 Close of Course Extra Information 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.  

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Our OISC Level 2 preparation course is a two-day training course which offers a closer look at immigration advice and follows on from the training at Level 1. Throughout this course, we cover the syllabus at Level 2, as according to OISC standards. View our course dates below, delivered via Microsoft Teams Course Overview:   Take your expertise to the next level with our OISC Level 2 Accreditation Course. Designed as a two-day training program, this course builds upon the foundation established in Level 1 training. Delving deeper into immigration advice, we cover the Level 2 syllabus as prescribed by the OISC. Throughout this course, you’ll explore intermediate structures, frameworks, and concepts of UK immigration law. Gain insights into Humanitarian Protection and Asylum law, as well as the complexities of European Economic Area (EEA) free movement law. Additionally, our curriculum covers Business immigration law and Points-Based System (PBS) visas, along with the intricacies of detention and bail. We’ll also address major immigration offences to ensure a well-rounded understanding. Don’t forget to check out our Exam Technique Training (Level 2) which is designed to help prepare learners for their accreditation exam.   Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 2 Syllabus? The OISC Level 2 Training introduces new learning objectives for immigration adviser applicants. The course includes: Intermediate structures, frameworks and concepts of UK immigration law Humanitarian Protection and Asylum law European Economic Area (EEA) free movement law Business immigration law and PBS visas Detention and bail Major immigration offences   Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. Who can attend the OISC Training Level 2 classes? The immigration procedures and structures introduced by the OISC Level 2 Course follow directly on from the objectives covered in the Level 1 Training. For this reason, participants should attend an OISC Level 2 class only after completing the Level 1 assessment. This course is also useful for participants who aim to become acquainted with UK immigration law. On the other hand, those who hold an OISC accreditation and wish to learn more about the latest development in this field can also benefit from this training class.

Course Outcomes As an MHFAider® you will be able to:  Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other supports Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the MHFAider® role in depth, including boundaries and confidentiality Practise self-care Know how to use the MHFAider Support App® Know how to access a dedicated text service provided by Shout and ongoing learning opportunities with MHFA England Format Learners will be trained over four live sessions with an MHFA England Instructor Member, covering 14 hours of content in total. Learning takes place through a mix of instructor led training, group discussions, individual and group activities. Each session builds on the previous, enabling the learner to gain confidence in supporting others with a Mental Health First Aid action plan. We limit numbers to 16 people per course so that instructors can keep people safe and supported while they learn. We strive for all of our learning content to be as accessible and inclusive as possible. Takeaways Everyone who completes this course gets:  A hard copy workbook to support their learning throughout the course A digital manual to refer to whenever they need it after completing the course A wallet-sized reference card with the Mental Health First Aid action plan A digital MHFAider® certificate Access to the MHFAider Support App® for three years Access to ongoing learning opportunities, resources and exclusive events The opportunity to be part of the largest MHFAider® community in England Becoming a qualified MHFAider® Once you complete the Mental Health First Aid course, you can test your knowledge and build your confidence in your role as an MHFAider® with the internationally recognised MHFAider® qualification, RSPH Level 3 Award in Mental Health First Aid. Course Structure Session 1: Mental Health First Aid and the action plan The MHFAider® role and self-care Helpful and unhelpful language Useful models to support the role Session 2: What influences mental health? What is anxiety? Crisis first aid Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? Session 3: Applying the Mental Health First Aid action plan What is depression? What is suicide? Crisis first aid continued What is psychosis? Session 4: Recovery and lived experience Boundaries in the MHFAider® role Moving forward in the MHFAider® role My MHFA action plan

•The Online NLP Practitioner Training is a comprehensive program that will provide you with the tools and techniques you need to overcome your chronic pain and mental health conditions. • The program includes a printable digital copy of the NLP Practitioner Manual, access to the video recording of the training, ‘live’ online demonstrations of the techniques in action on yourself, online support for one year by way of group calls, and assistance set up your business website. • This program is perfect for anyone who wants to achieve positive change in their lives! Whether you’re a self-starter who is interested in self-development or a professional who is seeking career development and job fulfilment.

Sanity is privileged over insanity, which is stigmatized. A therapoet views differences without hierarchy, valuing each unique expression. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Difference - between Prof. Ernesto Spinelli and Dr. Todd DuBose "Sanity and insanity have been situated in relation to each other on a hierarchical scale that privileges sanity over, beyond, above, and more than its “less than” subjugated copy, insanity. Framed in this way, insanity can only be stigmatized, devalued and pathologized, while sanity is that to which we are to strive, uphold, and genuflect. The therapoet as a phenomenological hermeneutic horizontalizes a spectrum of “sayings of suffering souls”, or “befallings”, which is the originally meaning of “symptom”, not as a pathogen to be excised. Countering supremacist hierarchies of sanity/insanity, or health/illness, the therapoet sees difference, not as deficient, but just different, anew, and not in relation to any centric norm, but just to other differences. The relation to other differences is a relative gradation, whose incomparability resists any kind of nothing-but-ism any more than a fish can be said to be nothing but a squirrel with fins, or dirt as nothing but dry water. The therapoet, therefore, attends to each showing or saying of the suffering soul, sufficient in itself, as it is, in its own way of presencing, by being with it, letting it be, without why.” Dr. Todd DuBose. Dr. Todd DuBose is a world-renowned, Distinguished Full Professor at The Chicago School’s College of Professional Psychology. He teaches philosophical foundations of practices of care, ethics, loss and mourning, psychology and spirituality, psychopathology, among other courses, all from a human science perspective, and with a particular focus on therapoetic care. He is a licensed psychologist, supervisor, consultant, and former chaplain, with over thirty-five years of experience. He holds degrees in continental and comparative philosophy of religion and existential-hermeneutical-phenomenological human science clinical psychology and integrates these approaches as a way of caring for such experiences as the impossible (no way out, boundary or limited situations), extreme experiences (such as psychosis, nihilism, suicidal and homicidal ideation), and the taboo (the places no one wants to go: the unwanted and unacceptable, unsayable, unforgiveable, forbidden, and irreverent). He regularly presents workshops in several international venues such as the Circulo de Estudios en Psicoterapia Existential, in Mexico City, Mexico, the Zhi Mian International Institute of Existential-Humanistic Psychology in Dali, China, and the Centre for Existential Practice in Melbourne, Australia. He is widely published and has written on caring for others in very difficult situations including traumatic loss, surviving the COVID-19 pandemic, and meaninglessness. He has also written a short dialogue with Miles Groth, edited by Loray Daws, called, Dialogues on The Soul of Existential Therapy, published by The Society for Existential Analysis. Most of all, he considers himself simply a fellow human being. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 22 March from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

Revit face to face training customised and bespoke. Online or Face to Face

I’ll share a case of visual hallucinations, showing how an existential-phenomenological approach helps understand their meaning and purpose. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Hallucination- between Prof. Ernesto Spinelli and Prof. Simon du Ploc “The phenomenon of hallucination has been a subject of debate for centuries. It has been suggested that its function was one of revelation or prophesy, and those who hallucinated were often considered to have a ‘sacred’ affliction. In recent times, their function, at least in the West since the Age of Reason, has been often been reduced to primary indicators of schizophrenia and other forms of psychosis. Lumped into the ‘core phenomena’ of schizophrenia, the concern is not so much what they are, or what they mean to the client, or even their content, but their treatment and control. I will present an excerpt from my own clinical practice with a client who presented with distressing visual hallucinations. This piece of work illustrates how approaching such irregular perceptions of reality from an existential-phenomenological perspective can provide a way of understanding their meaning and purpose within a client’s lived experience. I will suggest that such an approach also enables us to take a creative position regarding wider notions of sanity and madness, a position which enables us to navigate a path between, on the one hand, the medical model which typically focusses on reduction and management of hallucinations, and on the other hand, a Laingian view of hallucination as a route to ‘hyper-sanity’. Adopting such a path may enable us to work more confidently with clients when they present with unusual or disturbing perceptions.” Prof. Simon du Ploc. Prof. Simon du Plock is Senior Research Fellow at the Metanoia Institute, London. He was Head of the Faculty of Post-Qualification and Professional Doctorates at the Institute from 2007 to 2020, in which role he directed counselling psychology and psychotherapy research doctorates jointly with Middlesex University. He is a Fellow of the Royal Society for Medicine, a Foundation Member with Senior Practitioner Status of the BPS Register of Psychologists Specialising in Psychotherapy, and a Member of the BPS Register of Applied Psychology Practice Supervisors. He has been a BPS Chartered Counselling Psychologist and UKCP Registered Psychotherapist since 1994. He has authored nearly one hundred journal papers and book chapters on existential therapy, and he has co-edited Existential Analysis, the Journal of the British Society for Existential Analysis, since 1993. He was an editor of the 2019 Wiley World Handbook of Existential Therapy. He has lectured and trained internationally, and in 2006 he was made an Honorary Member of the East European Association for Existential Therapy in recognition of his contribution to cooperation between West and East Europe in the development of existential psychotherapy. His clinical and research interests include phenomenological research methodology, clinical and research supervision, existential pedagogy, and working with issues of addiction and dependency. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 15 November from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by: