483 CLO courses in London

Enhance your knowledge in catheter care with our comprehensive course designed for healthcare professionals, caregivers, and individuals seeking to provide effective care for patients.

Gain comprehensive knowledge and practical skills for fine-bore nasogastric tube care and feeding with our healthcare professional course. Learn techniques, considerations, and patient care for enteral nutrition, medication administration, and gastric decompression.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients 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. Our competitive rates start from £550.00 per day of training Tailored 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. 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 Certificates Certificates Certificate of completion Digital certificate - Included

#healing #soundhealing #healwithsound #wellbeingworkshop #mysticsisters

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. 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

Managing Project Scope Although scope is just one part of a project's competing constraints, it has a direct bearing on your project's cost and schedule outcomes. In this course, you will explore and practice straightforward, specific tools and techniques required to effectively manage scope at each phase of the project life cycle. You will also discover common pitfalls and best practices that can significantly hinder or foster the probability of project success. Although scope is just one part of a project's competing constraints, it has a direct bearing on your project's cost and schedule outcomes. So effectively managing project scope is critical, requiring constant vigilance and discipline throughout the entire project life cycle. This especially includes the avoidance of scope creep, a major challenge to deliver successful projects. In this course, you will explore and practice straightforward, specific tools and techniques required to effectively manage scope at each phase of the project life cycle. You will also discover common pitfalls and best practices that can significantly hinder or foster the probability of project success. What you Will Learn At the end of this program, you will be able to: Recognize the relationships among project management deliverables, scope management, stakeholders, and project success Explain the spectrum of interactive processes and documentation impacting scope during the project life cycle Generate an inventory of common pitfalls and best practices during scope management phases Create and develop realistic deliverables reflecting critical phases of scope management, based on a real-world case study Foundation Concepts What is project scope? Project scope management Progressive elaboration and project life cycle Stakeholder management and communication Progressive Elaboration of Scope Progressive elaboration and SDLC example Elaboration process before project initiation Elaboration process after project initiation Developing the WBS, requirements document, & PSOW Monitoring and Controlling Scope Why project control? Project control process & the PM role Control scope Validate scope Project Closeout Project closure overview Close project or phase & scope management Evaluation and lessons learned

Introducing Private Occupational Therapy London Package: Personalized Support for Your Unique Needs Are you looking for private occupational therapy services in London that prioritize your individual needs and goals? Miss Date Doctor’s Private Occupational Therapy London Package offers you dedicated one-on-one support and personalized interventions to help you overcome challenges and improve your quality of life. Private occupational therapy provides a focused and tailored approach, ensuring that you receive the highest level of care and attention. Our experienced occupational therapists in London are committed to understanding your specific needs and providing effective solutions to enhance your daily functioning and well-being. Here’s how the Private Occupational Therapy London Package can support you: Personalized Assessment: Our private occupational therapists will conduct a thorough and individualized assessment to gain a comprehensive understanding of your unique challenges, strengths, and goals. Tailored Treatment Plan: Based on the assessment, we’ll develop a customized treatment plan designed to address your specific needs and aspirations. This plan will focus on enhancing your functional abilities and promoting independence. Focused Attention: Private occupational therapy sessions offer you dedicated one-on-one attention, ensuring that you receive the most effective and personalized interventions. Individual Progress: Our therapists will closely monitor your progress throughout the therapy process, making adjustments to the treatment plan as needed to maximize your outcomes. Convenient Scheduling: Private occupational therapy allows for flexible scheduling options to accommodate your busy lifestyle and ensure that you have access to the support you need when it’s most convenient for you. Personal Empowerment: We believe in empowering you to take an active role in your therapy journey. Our therapists will collaborate with you, providing guidance and support as you work towards your goals. Confidentiality and Privacy: Private occupational therapy sessions offer a confidential and private environment where you can freely discuss your challenges and experiences. The Private Occupational Therapy London Package at Miss Date Doctor is committed to providing you with the highest level of personalized care and support. Our expert occupational therapists will work closely with you to help you overcome obstacles, regain independence, and enhance your daily living skills. Invest in your well-being and experience the benefits of private occupational therapy. Take the first step towards a more fulfilling and empowered life with the Private Occupational Therapy London Package. Let our skilled therapists guide you towards greater independence, improved functionality, and a more enriched quality of life. 3 x1 hour https://relationshipsmdd.com/product/private-occupational-therapy-london-package/

Learn how to design and create your own river table.

Introducing Therapy for Relationship Issues Package: Strengthening Bonds and Nurturing Healthy Connections Are you and your partner facing challenges in your relationship and seeking professional support to improve communication, resolve conflicts, and strengthen your bond? Miss Date Doctor’s Therapy for Relationship Issues Package offers you expert guidance to navigate difficulties, foster intimacy, and build a healthier, more fulfilling partnership. Relationships can encounter various obstacles that impact communication, trust, and emotional connection. Our experienced therapists specialize in working with couples and are dedicated to helping you and your partner overcome challenges and cultivate a more loving and harmonious relationship. Here’s how the Therapy for Relationship Issues Package can support you: Effective Communication: Our therapists will help you and your partner improve communication skills, fostering a deeper understanding of each other’s needs and emotions. Conflict Resolution: Relationship therapy addresses conflict resolution strategies, assisting you in navigating disagreements constructively and preventing recurring conflicts. Rebuilding Trust: If trust has been compromised, our therapists will guide you in rebuilding trust and creating a more secure emotional bond. Emotional Intimacy: We’ll explore ways to enhance emotional intimacy and create a more fulfilling emotional connection between you and your partner. Addressing Past Issues: Relationship therapy can address unresolved issues from the past that may be affecting your present relationship dynamics. Identifying Patterns: Our therapists will help you and your partner identify negative patterns of behaviour or communication, fostering healthier interactions. Shared Goals: We’ll assist you in exploring and aligning your shared goals and aspirations, ensuring that you are on the same page about your future together. Renewing Affection: Therapy for relationship issues can help rekindle affection and emotional closeness between you and your partner. The Therapy for Relationship Issues Package at Miss Date Doctor is designed to empower you and your partner to build a stronger foundation for your relationship. Our skilled therapists provide a safe and supportive space for open and honest dialogue, allowing you to work towards a more fulfilling and harmonious partnership. Invest in the well-being of your relationship and take the first step towards a healthier and more loving connection with the Therapy for Relationship Issues Package. Embrace the opportunity to strengthen your bond, improve communication, and create a lasting and satisfying relationship. Let our experienced therapists guide you and your partner towards a brighter future filled with love, understanding, and mutual support. 3 x 1 hour sessions https://relationshipsmdd.com/product/therapy-for-relationship-issues-package/

Overview This one day course covers the basics of brainstorming and then goes on to look at a number of different yet highly effective techniques that can be employed. Description Brainstorming is probably the most well known and most widely used method for bringing groups of people together to generate ideas about an issue or problem. This is because it’s a good way to gather a lot of ideas very quickly. It is also a great way of bringing people together and helping to build them as a team. Just imagine the effect on the team and its morale if ideas that they generate are actually used. There is no doubt that people are more likely to buy into the ideas that they came up with themselves. Although brainstorming is widely used for decision-making, it is not always handled very well. If that is the case, it can have the opposite effect to the one that is intended. Rather than creating ideas it can stifle them and rather than motivating people it demotivates them. This highly interactive course will help learners to make the most of brainstorming sessions and also provides alternative techniques to enliven any session that is beginning to flag. Topics covered: What is Brainstorming? – A discussion to help participants understand what brainstorming is, and what it involves. Brainstorming rules – A quick look at the very limited rules suggested by Alex Osborn who is generally credited with being the inventor of brainstorming. Preparation – Although many brainstorming sessions take place on the spur of the moment they all require some preparation. We look at the importance of defining the purpose of the session, selecting the right participants, and then briefing them properly. Storm and Floods – This is an activity that we re-visit on several occasions to take participants through the whole brainstorming process and to give them plenty of practice. The Three R’s of Facilitation – The three R’s take you through the essential elements of facilitating an effective brainstorming session. Closing the Session – Effective closing of the brainstorm may be just as important as the session itself. We look at the essential elements that the facilitator needs to cover. Clarify and Nurture – Learners discover the importance of ensuring that all ideas that are unclear are clarified and that ideas are nurtured. They also learn what this involves practically. Alternative Techniques – There are many ways to enliven a flagging brainstorming session, provide a fresh approach or simply build on initial ideas. The learners are introduced to some of the most important of these. Brainstorming Scenarios – Learners work through up to 6 scenarios so that they can practice the alternative techniques covered during the programme. Who should attend Anyone who facilitates or takes part in brainstorming sessions, or wants to work with organisational teams to develop their problem-solving abilities. Requirements for Attendees None.