11571 Environment courses in Dunfermline delivered Online

Level 3 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored training courses: In, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data 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 Preferably, delegates would have attended the Excel Introduction 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

Level 4 | Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Health and Safety Executive including 10 additional premium courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Health and Safety Executive Complete Bundle: Course 01: Health and Safety Executive Course 02: LOLER Training Course 03: Asbestos Awareness Level 2 Course 04: RIDDOR Training Course 05: Fire Safety Awareness Level 2 Course 06: COSHH Awareness Level 3 Course 07: Manual Handling Level 2 Course 08: Mental Health First Aid Course 09: First Aid at Work Course 10: Biohacking Your Physical and Mental Health Course 11: Personal Hygiene If you want to gain a solid understanding of Health and Safety Executive and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Health and Safety Executive course designed by expert instructors. You'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Health and Safety Executive will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Health and Safety Executive has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Health and Safety Executive is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online course is perfect! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Course Curriculum: Module 01: Health and Safety at Work and the Laws Module 02: Managing for Health and Safety Module 03: Risk Assessment and Common Risks Module 04: Workplace Health, Safety and Welfare Module 05: Accidents and Ill Health at Work Module 06: Electrical, Fire and Gas Safety Module 07: Safety in Different Work Settings Module 08: Work Equipment Hazards and Risk Control Module 09: Other Health and Safety Hazards at Work Course 2: LOLER Training Module 01: Introduction to LOLER Module 02: Part 01 - Selecting Lifting Equipment and Accessories Module 03: Part 02 - Selecting Lifting Equipment and Accessories Module 04: Planning the Lifting Operation Module 05: Factors Affecting Safe Lifting Operation Module 06: Roles and Responsibilities Module 07: Risk Assessment Module 08: Examination and Inspection Module 09: Reports and Defects Course 3: Asbestos Awareness Level 2 Module 01: Asbestos Explained Module 02: Asbestos Identified Module 03: Asbestos and the Law Module 04: Risk Factors of Asbestos Module 05: Surveys and Risk Assessment Module 06: Asbestos Awareness Safety Module 07: Asbestos Containing Waste (ACW) Disposal Module 08: Accidental Disturbance of ACMs and Dealing with Emergencies Course 4: RIDDOR Training Module 1: Health and Safety at Work and the Laws Module 2: Managing for Health and Safety Module 3: Risk Assessment and Common Risks Module 4: RIDDOR Course 5: Fire Safety Awareness Level 2 Module 1: Introduction to Fire Safety Module 2: Fire Safety Law Module 3: Measures of Fire Safety Module 4: Evacuation Procedures Course 6: COSHH Awareness Level 3 Module 01: COSHH Explained Module 02: COSHH Regulations Module 03: Health Problems Related to Hazardous Substances Module 04: Identifying Hazardous Substances Module 05: COSHH Risk Assessments Module 06: Control Measures and Monitoring Module 07: Implementing Control Measures Course 7: Manual Handling Level 2 Module 01: Introduction, Legislation and Guidance Module 02: Manual Handling Hazards and Injuries Module 03: Manual Handling Risk Assessments Module 04: Controlling and Reducing the Risks Module 05: Safe Lifting Techniques Course 8: Mental Health First Aid Module 1: Introduction to Mental Health Module 2: Overview of Mental Health First Aid Module 3: Childhood and Adolescent Psychiatric Disorders Module 4: Stress and Anxiety Disorders Module 5: Schizophrenia Module 6: Personality Disorders Module 7: Mood Disorders Module 8: Eating & Sleeping Disorders Module 9: Self-Harm and Suicide Module 10: Medication and Therapy in the Treatment of Mental Illness Module 11: Social Attitudes to Mental Illness Module 12: Mental Health Legislation and Services Module 13: Mental Health in the Workplace Module 14: Approach and React To People in Mental Health Crisis Course 9: First Aid at Work Module 01: Introduction to Workplace First Aid Module 02: Legal Framework for Workplace First Aid Module 03: Incident Management at Work Module 04: Primary Survey Module 05: Secondary Survey Module 06: Basic First-Aid Techniques Module 07: Dealing with Minor Injuries at Workplace Module 08: Secondary Illness: Loss of Responsiveness and CPR Module 09: Secondary Illness: Breathing Problems Module 10: Secondary Illnesses and Injuries Module 11: Dealing With Fractures and Dislocations Module 12: Call for an Emergency Course 10: Biohacking Your Physical and Mental Health Module 01: Introduction Module 02: Sleep - So MUCH More Than Just Rest Module 03: Blue Light & Red Light Module 04: Mindfulness & Movement Module 05: What You Put In Your Mouth is KEY! Module 06: Hidden Secret - 'Cryotherapy' Module 07: Importance Of PURE Air Module 08: Final Thoughts & Recommendations Course 11: Personal Hygiene Module 01: Introduction to Personal Hygiene and a Brief History Module 02: Looking Clean, Smelling Clean Module 03: Improving and Maintaining Oral Health Module 04: Care of the Eyes Module 05: Ear Care Secrets Module 06: Foot & Nail Care in Personal Hygiene Module 07: Hair Care Hygienic Ways Module 08: Hygienic Approach to Skin Care Module 09: Maintain Good Toilet Hygiene Module 10: Potential Hygiene Guidelines Module 11: Personal Hygiene During Coronavirus Pandemic How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. CPD 110 CPD hours / points Accredited by CPD Quality Standards Requirements There is no time limit for completing this course, it can be studied in your own time at your own pace Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Health and Safety Executive) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Use Cases for Business Analysis: Virtual In-House Training The use case is a method for documenting the interactions between the user of a system and the system itself. Use cases have been in the software development lexicon for over twenty years, ever since it was introduced by Ivar Jacobson in the late 1980s. They were originally intended as aids to software design in object-oriented approaches. However, the method is now used throughout the Solution Development Life Cycle from elicitation through to specifying test cases, and is even applied to software development that is not object oriented. This course identifies how business analysts can apply use cases to the processes of defining the problem domain through elicitation, analyzing the problem, defining the solution, and confirming the validity and usability of the solution. What you will Learn You'll learn how to: Apply the use case method to define the problem domain and discover the conditions that need improvement in a business process Employ use cases in the analysis of requirements and information to create a solution to the business problem Translate use cases into requirements Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of use case modeling What is a use case model? The 'how and why' of use cases When to perform use case modeling Where use cases fit into the solution life cycle Use cases in the problem domain Use cases in the solution domain Use case strengths and weaknesses Use case variations Use case driven development Use case lexicon Use cases Actors and roles Associations Goals Boundaries Use cases though the life cycle Use cases in the life cycle Managing requirements with use cases The life cycle is use case driven Elicitation with Use Cases Overview of the basic mechanics and vocabulary of use cases Apply methods of use case elicitation to define the problem domain, or 'as is' process Use case diagrams Why diagram? Partitioning the domain Use case diagramming guidelines How to employ use case diagrams in elicitation Guidelines for use case elicitation sessions Eliciting the problem domain Use case descriptions Use case generic description template Alternative templates Elements Pre and post conditions Main Success Scenario The conversation Alternate paths Exception paths Writing good use case descriptions Eliciting the detailed workflow with use case descriptions Additional information about use cases Analyzing Requirements with Use Cases Use case analysis on existing requirements Confirming and validating requirements with use cases Confirming and validating information with use cases Defining the actors and use cases in a set of requirements Creating the scenarios Essential (requirements) use case Use case level of detail Use Case Analysis Techniques Generalization and Specialization When to use generalization or specialization Generalization and specialization of actors Generalization and specialization of use cases Examples Associating generalizations Subtleties and guidelines Use Case Extensions The <> association The <> association Applying the extensions Incorporating extension points into use case descriptions Why use these extensions? Extensions or separate use cases Guidelines for extensions Applying use case extensions Patterns and anomalies o Redundant actors Linking hierarchies Granularity issues Non-user interface use cases Quality considerations Use case modeling errors to avoid Evaluating use case descriptions Use case quality checklist Relationship between Use Cases and Business Requirements Creating a Requirements Specification from Use Cases Flowing the conversation into requirements Mapping to functional specifications Adding non-functional requirements Relating use cases to other artifacts Wire diagrams and user interface specifications Tying use cases to test cases and scenarios Project plans and project schedules Relationship between Use Cases and Functional Specifications System use cases Reviewing business use cases Balancing use cases Use case realizations Expanding and explaining complexity Activity diagrams State Machine diagrams Sequence diagrams Activity Diagrams Applying what we know Extension points Use case chaining Identifying decision points Use Case Good Practices The documentation trail for use cases Use case re-use Use case checklist Summary What did we learn, and how can we implement this in our work environment?

Description Call Centre Management diploma In the modern world of business, the critical part of any ambitious company that is fast growing is its call centre. In spite of there being available a variety of modern methods of interaction with customers, like social media, etc; the telephone still remains one of the efficient tools to ensure that you are heard by your clients and vice versa. That is one of the reasons why the role of a professional call centre manager remains very significant. Our Call Centre Management Diploma Course is designed in such a way that the managers in a call centre can acquire the skills and techniques required to manage this specific environment in an effective manner. Students attain certification in the ability to put into application the best and latest practices and also in setting high standards for updated call centre operations. The importance of having a qualified and well-managed team in order to achieve the best working environment and an increased level of efficiency on a daily basis is covered during the duration of the course. Insights into the optimum and most systematic approach for the achievement of excellence in call centre operations are covered by this course. Apart from the benefits listed above, students will study various other competencies required for the management of a modern professional call centre. What you will learn 1: Introduction to Call Centre 2: Call Centre Business Models and Drivers 3: Developing Organisational Structure and Roles 4: Building a Call Centre of Your Own 5: Choosing the Outsourcing Choice 6: Right People, Right Place, Right Time: Resource Management Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Elevate your understanding of relay protection in power systems with EnergyEdge's specialized classroom training course and gain valuable insights.

Sanctions Awareness Designed for non-sanctions experts Sanctions compliance is a high-profile area of risk management and regulatory scrutiny. This online course is designed for non-specialists and is a great starting point for those looking to gain knowledge and demystify this complex area. Sanctions fundamentals- get to grips with sanctions and their significance in today's international environment Application and impact- understand how sanctions are applied, their impact and the different categories of sanctions Challenges- identify what are they and how to apply the learnings in your workplace Red flags- know what to look out for when dealing with customers and clients. What are sanctions and who imposes them? Types of sanctions Who, what and where in the world? Other stakeholders involved Sanctions hazard perception

Introduction to Menopause (via Zoom)Course Focus:This comprehensive two-day course serves as an invaluable introduction to menopause care within the primary care setting. Understanding menopause, its effective management, and the ensuing implications for women's well-being are pivotal aspects for healthcare practitioners, particularly practice nurses who frequently engage with women facing menopausal transitions during their consultations.Course Highlights:Understanding Menopause:Dive into the core concepts of menopause, grasping its multifaceted aspects, and gaining a deep understanding of its physical, emotional, and psychological dimensions.Effective Menopause Management:Explore optimal strategies for managing menopause, equipping practitioners to provide well-informed guidance to women traversing this life phase.Short and Long-Term Implications:Delve into the implications of menopause for women's well-being, both in the short and long term, enabling practitioners to offer holistic care that addresses immediate concerns and promotes long-term health.Tailored Approach for Practice Nurses and AHP's:Recognize the pivotal role of practice nurses and AHP's in menopause care, understanding the specific challenges they encounter during consultations with menopausal patients.Competency Framework for Progression:Access a comprehensive competency framework that empowers nurses to work towards mastery in menopause care. This framework can be validated by experienced team members, fostering ongoing skill development.Dynamic Learning Environment:Through interactive sessions, case studies, and discussions, participants will engage in a dynamic learning environment that facilitates the absorption of knowledge and practical insights. The course encourages networking and collaboration, enabling practitioners to learn from both expert facilitators and fellow participants.Learning Outcomes:Upon completion of this two-day course, participants will be equipped to approach menopause care with heightened confidence and competence. Whether they occasionally encounter menopausal patients or engage with them more regularly, practitioners will leave with the tools and strategies to provide informed and supportive care, positively impacting women's well-being during this transitional phase.Target Audience:This course is tailored for a diverse range of primary care practitioners, including practice nurses, cervical sample takers, and those who regularly engage with menopausal patients without specialized training. All practitioners seeking to enhance their expertise in menopause care are welcome to attend.Day One09.15Coffee and registration09.30Introduction and course objectives09.40Physiology and definitions10.00Menopause symptoms10.45Coffee11.00What do we need to ask?13.00Lunch14.00Management Strategies: Hormonal and non-hormonal treatment of menopause symptoms14.30Diet, Lifestyle and Exercise14.30Complementary therapies15.00Case Studies 15.30Action plan, evaluation, and resources15.45CloseDAY 209.15Coffee and registration09.30Review of Day 1 and tasks09.45Women with special needs10.00Contraceptive options for peri-menopausal women10.45Coffee11.00What do we need to ask?13.00Lunch14.00Which HRT when and how14.30The older woman15.00Case Studies 15.30Action plan, evaluation, and resources15.45Close

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Environmental Health And Conservation bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Environmental Health And Conservation related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Environmental Health And Conservation bundle will help you build a solid foundation to become a proficient worker in the sector. This Environmental Health And Conservation Bundle consists of the following 30 CPD Accredited Premium courses - Course 01:Sustainable Energy, Development and Environmental Impacts Course 02:Online Course in Conservation Course 03:Environment Management Course 04:Environmental Health Course 05:Environmental Law 2021 Course 06:Meteorology Course 07:Mushroom Growing Course Course 08:Carbon Literacy Knowledge Course 09:Animal Science Course 10:Genetics Course 11:Ornithology Course 12:Biotechnology Course 13:Floristry Academy Diploma Course 14:Arboriculture Course 15:Marine Biology Course - Online Diploma Course 16:Garden Design Course 17:Reproduction in Flowering Plants Course 18:Kitchen Gardening Course 19:Architectural Studies Course 20:Cleaning: Disinfection, Waste Management and Chemical Safety Course 21:COSHH (Control of Substances Hazardous to Health) - Awareness Course 22:Spill Management Training Course 23:Horticulture & Organic Gardening Course 24:Homesteading Diploma Course 25:Land Management Course 26:Diploma in Water Treatment Course 27:Forestry Course 28:Agricultural Science Course 29:Botany Course 30:Wildlife Rescue and Rehabilitation 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Learning Outcome This tailor-made Environmental Health And Conservation bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Environmental Health And Conservation Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Environmental Health And Conservation bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Environmental Health And Conservation Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.