Overview This comprehensive course on 'Educational Psychology and Development' will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 'Educational Psychology and Development' comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. ** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. ** How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 'Educational Psychology and Development'. It is available to all students, of all academic backgrounds. Requirements Our 'Educational Psychology and Development' is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. 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 qualifications 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. Course Curriculum 10 sections • 10 lectures • 04:01:00 total length •Introduction to the Educational Psychology: 00:17:00 •Educational Psychology and its History: 00:29:00 •Behavioural Views of Learning: 00:21:00 •Cognitive Development: 00:29:00 •Social, Moral and Emotional Development: 00:24:00 •Constructivism and Motivation: 00:23:00 •Dyslexia and Learning Difficulties: 00:34:00 •Applying Educational Psychology to Teaching: 00:27:00 •Effective Instruction and Technology in Education: 00:23:00 •Opportunities and Careers in Educational Psychology: 00:14:00
Overview This comprehensive course on English for Healthcare will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This English for Healthcare comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this English for Healthcare. It is available to all students, of all academic backgrounds. Requirements Our English for Healthcare is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications 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. Course Curriculum 4 sections • 13 lectures • 04:40:00 total length •Module 01: Human Body Vocabulary with Pictures: 00:47:00 •Module 02: Equipment, Instruments and Lab Tests: 00:19:00 •Module 03: Acronyms and Abbreviation: 00:36:00 •Module 04: Digestive System: 00:25:00 •Module 05: Cardiovascular System: 00:20:00 •Module 06: Blood and Immunity System: 00:15:00 •Module 07: Respiratory System: 00:17:00 •Module 08: Musculoskeletal System: 00:17:00 •Module 09: Central Nervous System: 00:14:00 •Module 10: Professional Communication and Behaviour: 00:19:00 •Module 11: Interviewing Techniques: 00:32:00 •Module 12: Adapting Communication to a Patient's Ability to Understand: 00:19:00 •Assignment - English for Healthcare: 00:00:00
Overview Develop essential professional skills with the Domestic Plumbing and Heating Installer Complete Diploma course. This Domestic Plumbing and Heating Installer Complete Diploma course includes easy to digest, in-depth modules providing learners with thorough, proficient knowledge. It delivers essential domestic heating and plumbing training which will benefit you personally and professionally. Upon completing the course, you can save money by carrying out plumbing and heater installation by yourself, and will have the necessary skills to kickstart your career. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Domestic Plumbing and Heating Installer Complete Diploma. It is available to all students, of all academic backgrounds. Requirements Our Domestic Plumbing and Heating Installer Complete Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. 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 qualifications 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. Course Curriculum 12 sections • 12 lectures • 03:00:00 total length •Module 01: Basic Components of Plumbing: 00:15:00 •Module 02: Principles of Effective Plumbing Systems: 00:15:00 •Module 03: The Plumbing Tools: 00:15:00 •Module 04: The Plumbing Process: 00:15:00 •Module 05: Central Heating Systems: 00:15:00 •Module 06: Domestic Cold Water System: 00:15:00 •Module 07: Domestic Hot Water System - Part 1: 00:15:00 •Module 08: Domestic Hot Water System - Part 2: 00:15:00 •Module 09: The Sanitation System and Repairs: 00:15:00 •Module 10: Domestic Rainwater System Installation: 00:15:00 •Module 11: Plumbing Projects: Case Study: 00:15:00 •Module 12: UK Standards for Plumbing: 00:15:00
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 Certificates Certificates Certificate of completion Digital certificate - Included
Learn to manage family conflicts through a legal lens with our course, designed to provide a comprehensive understanding of Family Law. From marriage and divorce to child custody and adoption, this theoretical course covers it all. Learning outcomes: Gain a foundational understanding of Family Law Understand the legal framework for marriage and civil partnership Analyse the concept of nullity in marriage and divorce Gain knowledge of child custody and support laws Understand property and finance regulations in divorce Examine domestic violence and gender equality in Family Law Our course, "A Legal Approach to Managing Family Conflicts," provides a theoretical understanding of Family Law. This course is designed to provide a comprehensive understanding of Family Law by delving into various aspects of it, from marriage and divorce to adoption and domestic violence. The course includes 13 modules that cover different legal aspects related to family conflicts. The course begins with an introduction to Family Law and moves on to discuss various concepts such as marriage, civil partnerships, nullity, divorce, child custody, child support, adoption, domestic violence, and gender equality. Throughout the course, you will learn about the legal framework for each of these concepts and gain an in-depth understanding of how they relate to managing family conflicts. Whether you are a law student or someone interested in understanding Family Law, this course is for you. With no prerequisites, this course is open to anyone interested in understanding the legal aspects of managing family conflicts. By the end of the course, you will be equipped with theoretical knowledge to understand and analyse legal issues related to family conflicts. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Law students Legal professionals Social workers Family counsellors Career path Family Law Solicitor: £24,000 - £85,000 per annum Family Law Barrister: £25,000 - £400,000 per annum Mediator: £22,000 - £70,000 per annum Legal Advisor: £20,000 - £55,000 per annum Family Support Worker: £18,000 - £30,000 per annum Child Advocate: £25,000 - £40,000 per annum
Level 2 & 4 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access
Overview This comprehensive course on The Formula to Talk with Strangers will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Formula to Talk with Strangers comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this The Formula to Talk with Strangers. It is available to all students, of all academic backgrounds. Requirements Our The Formula to Talk with Strangers is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications 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. Course Curriculum 4 sections • 12 lectures • 00:34:00 total length •Welcome: 00:01:00 •Disclaimer: 00:02:00 •How to Deal with Rejection: 00:03:00 •Who are the Right People for You (The LA Rule, Step 1): 00:01:00 •Where to Meet the Right People: 00:04:00 •What to Talk About (The LA Rule, Step 2): 00:02:00 •What to Talk About with COMPLETE STRANGERS: 00:06:00 •Have a Joke to Spare: 00:05:00 •Unspoken Words: 00:07:00 •How to Maintain the Relationship: 00:01:00 •The Most Important Things from the Course: 00:01:00 •Thank You: 00:01:00
Overview This comprehensive course on Brow Lift & Lamination Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Brow Lift & Lamination Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Brow Lift & Lamination Training. It is available to all students, of all academic backgrounds. Requirements Our Brow Lift & Lamination Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications 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. Course Curriculum 5 sections • 12 lectures • 00:47:00 total length •Introduction: 00:01:00 •1. Clean the eyebrows: 00:03:00 •2. Apply The product nr1: 00:02:00 •3. Removing The product nr1: 00:02:00 •4. Apply The product nr2: 00:03:00 •5. Removing The product nr2: 00:02:00 •6. Tint the eyebrows: 00:10:00 •7. Tweeze, wax, trim them: 00:14:00 •8. Strengthening lotion and concealing: 00:08:00 •Tint preparation: 00:02:00 •Resources - Brow Lift & Lamination Training: 00:00:00 •Assignment - Brow Lift & Lamination Training: 00:00:00
Overview This comprehensive course on Drugs and Alcohol Awareness Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Drugs and Alcohol Awareness Training comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Drugs and Alcohol Awareness Training. It is available to all students, of all academic backgrounds. Requirements Our Drugs and Alcohol Awareness Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications 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. Course Curriculum 11 sections • 10 lectures • 04:02:00 total length •Introduction to Drugs and Alcohol Addiction: 00:20:00 •Overview of Drugs: 00:27:00 •Overview of Alcohol: 00:25:00 •Prevention and Awareness: 00:19:00 •Drugs and Alcohol Abuse at Workplace: 00:16:00 •Drugs and Alcohol Policy at Workplace: 00:21:00 •Treatment of Drugs and Alcohol Addiction: 00:26:00 •Recovery and Post-Treatment Care: 00:39:00 •Laws and Acts on Drugs: 00:33:00 •Moving Beyond Addiction: 00:16:00
Overview This comprehensive course on Landscape Paintings with Acrylic will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Landscape Paintings with Acrylic comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Landscape Paintings with Acrylic. It is available to all students, of all academic backgrounds. Requirements Our Landscape Paintings with Acrylic is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. 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 qualifications 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. Course Curriculum 2 sections • 14 lectures • 02:03:00 total length •My Introduction: 00:02:00 •Switzerland Painting Overview: 00:01:00 •What is the Acrylic and Course Overview: 00:02:00 •Material for Painting: 00:02:00 •Learn Layout with Drawing: 00:06:00 •Color and Background Texture: 00:06:00 •How to Paint Grass, Stone and Tree: 00:18:00 •Overall Texture Process: 00:08:00 •Overall Texture with Shadow Process: 00:13:00 •Detailing of Tree Light and Shadow: 00:06:00 •How to Paint Water and Mountain Texture: 00:09:00 •Overall Shadow Process: 00:13:00 •Overall Color Balance Process: 00:18:00 •Finishing Big Canvas: 00:19:00