687 Environment courses in Market Warsop

EPFA and EFAW combined course

(non-accredited) Course 90 Minutes Cost:  £20.00 + vat per person This course will teach individuals lifesaving skills and is ideal for Community Groups and Charities. SYLLABUS Everyone attending this course will learn: How to perform a Primary Survey of a casualty using the acronym DRABC How to administer good quality CPR How to use a defibrillator Unconscious casualties Recovery position This is a non-accredited course; however, a Digital Certificate of Attendance will be sent on completion.  First Aid • Life-Saving Skills First Aid Training is not just a Course; it’s a life-saving skill everyone should possess. It’s about being prepared for the unexpected knowing how to respond when seconds count. As Health & Safety Law mandates, employers must create a secure and healthy environment for their employees. This responsibility extends to providing immediate and effective First-Aid Care when necessary. We understand that learning is best achieved through practical application. That’s why we offer In-Person Workshops on First Aid. These workshops provide hands-on experience under the guidance of our highly qualified trainers. You’ll have the opportunity to practice what you’ve learned in a controlled environment before you need to apply it in real life. Upon completion of a First-Aid Qualification, employers can be assured that they have highly-trained personnel capable of responding swiftly and effectively to any First-Aid needs. This fulfils legal obligations and contributes to a safer, more caring work environment for all. In essence, the First Aid Certification is more than just a qualification; it’s an investment in the health and safety of your workforce.

Did you know that 30.7 million working days were lost due to work-related illnesses and workplace injury in 2017/18?  It is an employer’s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training to employees to allow them to work in a way that does not put themselves or others at risk.  The QA Level 2 Award in Health and Safety in the Workplace (RQF) is ideal for all employees, as it helps candidates develop a greater understanding of health and safety issues and the role that everyone plays in maintaining a safe working environment. What’s more, with subjects covered in just 1 day, this regulated and nationally recognised qualification is the ideal way for organisations to improve health and safety awareness, whilst minimising disruption to everyday business operations!

QA Level 2 Award In Cardiopulmonary Resuscitation And Automated External Defibrillation (RQF) Full day course Gives learners the knowledge and skills to give CPR and use an AED safely Covers maintenance of AEDs (Automated External Defibrillators) Course Contents: The principles underlining basic life support The principles underlining resuscitation Different types of cardiac arrest Recovery Position CPR Choking Safe Use of an AED (Automated External Defibrillator) AED maintenance Benefits of this course: In the UK there are over 30,000 cardiac arrests a year outside of hospital But only less than one in ten survive to be discharged from hospital When someone has had a cardiac arrest, every minute makes a huge difference You can help save people's life by starting CPR as soon as possible, and use an AED (Automated External Defibrillator) to restart their heart This course helps to give you the skills and confidence to save people's lives, and make a huge difference not just to them, but also to their families and loved ones Accredited, Ofqual regulated qualification: Our Cardiopulmonary Resuscitation and Automated External Defibrillation course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your CPD & AED Certificate is a very good way to make sure you and your employees are trained in First Aid. And of course, all of our training courses are run in a fun and engaging, interactive and varied way, ensuring your employees have the skills and knowledge they need! The Ofqual Register number for this course is 603/2654/2 This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here.

Effective report writing, the exchange of information, ideas, opinions and decisions between people at all levels, internally and externally, makes a vital contribution to organisational success.

See how plastic bottle tops are remelted into beautiful objects!

Employee Assistance Programme Training

Recent changes to Forestry Commission policy recommend those who work in the Forestry industry attend training which includes additional topics relevant to the risks and nature or their work. The Forestry Commission recommend topics including: Crush Injuries Catastrophic bleeding including chainsaw including chainsaw injuries and gun shot wounds Hypothermia / Exposure Suspension injuries Lyme's Disease Lightning & High Voltage injuries Casualty evacuation planning These are in addition to the normal Emergency First Aid criteria. Who Should Attend? This course is ideal for those who work or intend to work in a forestry, agricultural or remote environment, such as tree surgeons and farmers. Emergency First Aid Course Content Health & Safety First Aid Kit Resuscitation/CPR AED Familiarisation Recovery Position Choking - Adult, Child, Baby Burns & Scalds Poisoning including Anaphylaxis Epilepsy Shock Bleeding including Catastrophic bleeding Asthma Head Injuries Breaks, Sprains & Strains Specific Conditions (Heart Attack) Assessment / Certification Independent qualified assessors carry out the assessments. Each delegate that passes will receive a Certificate valid for Three years. Please note those holding a valid Certificate, training can take place up to 3 months in advance of the expiry date & the new Certificate will be dated from the expiry date of the old Certificate.

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

Introducing the Psychotherapy London Package: Expert Guidance for Personal Growth and Emotional Well-being Are you searching for professional psychotherapy services in London to support your personal growth and emotional well-being? Miss Date Doctor’s Psychotherapy London Package offers you access to highly trained therapists who are dedicated to helping you navigate life’s challenges and achieve greater self-awareness and fulfillment. Psychotherapy is a collaborative and evidence-based therapeutic approach that addresses various mental health concerns, relationship issues, and emotional difficulties. Our experienced therapists in London provide a safe and confidential space for you to explore your thoughts, emotions, and experiences, facilitating positive change and growth. Here’s how the Psychotherapy London Package can support you: Comprehensive Assessment: Our therapists will conduct a thorough assessment to understand your unique needs, challenges, and goals. This assessment will serve as the foundation for designing a tailored treatment plan that suits your specific requirements. Evidence-Based Techniques: The Psychotherapy London Package draws from a range of evidence-based techniques and modalities, ensuring that you receive the most effective and appropriate therapeutic interventions. Individualized Approach: Your therapy sessions will be personalized to address your specific concerns and aspirations. Our therapists recognize that each individual’s journey is unique, and they will tailor the treatment to support your personal growth. Emotional Support: Our therapists provide a supportive and empathetic environment where you can freely express your thoughts and feelings. This emotional support is crucial for fostering a strong therapeutic alliance and promoting healing. Stress Reduction: Psychotherapy can be an effective tool for managing stress and anxiety. Through guided discussions and coping strategies, you’ll develop skills to navigate life’s challenges with greater resilience. Relationship Enhancement: If you are seeking to improve your relationships, our therapists will provide guidance and techniques to enhance communication, foster emotional intimacy, and resolve conflicts effectively. Self-Exploration and Awareness: Psychotherapy encourages self-exploration and self-awareness. By gaining insight into your thoughts and behaviours, you’ll be empowered to make positive changes in your life. Positive Change: With the support of our skilled therapists, you’ll work towards achieving meaningful and lasting positive changes in various aspects of your life. The Psychotherapy London Package at Miss Date Doctor offers you the opportunity to embark on a transformative journey of personal growth and emotional well-being. Our therapists are committed to helping you navigate life’s challenges and empowering you to lead a more fulfilling and balanced life. Take the first step towards greater self-awareness and well-being with the Psychotherapy London Package. Invest in your mental and emotional health, and unlock your potential for positive change. Discover the benefits of psychotherapy and experience the guidance and support you deserve on your journey to a happier and healthier life. 3 x 1 hour sessions https://relationshipsmdd.com/product/psychotherapy-london-package/