12685 GRE courses

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Learn Angelic Reiki with multi-award winning Master Teacher, Jayn Lee-Miller, who was one of the first to work professionally with angels and is now approaching her 18th year of teaching Angelic Reiki. Please email info@healingangels.co.uk for full details of this healing module which has been channelled through the Archangel Metatron especially for this time as the consciousness of humanity is collectively ascending to fifth dimension. The Angelic Kingdom of Light is assisting in helping us hold a place of unconditional love to help us remember the divine beings we truly are. In Angelic Reiki you are attuned by Angels to The Angelic Kingdom of Light and during healing exchanges you actually become the Angel you are channelling.

You are about to unleash your inner sculptor on a new level! Our workshop is designed for beginners looking to learn the basics, including harvesting materials, shaping and joining wood, and completing a variety of structures. The wood we use is sourced from sustainably managed forests in Europe and Asia. We believe that knowing where your materials come from is important—that's why we make sure our wood comes from responsibly managed forests (the best kind). We know you'll love getting creative and making something beautiful out of nature's gifts!

A comprehensive and practical guide to the art and science of company valuation. Learn value investing’s most important skill.

Level 3 Award in Education & Training (RQF) and Educational Psychology & Development Education is one of the most influential and noble sectors globally. Be a part of this extremely rewarding profession and build a better tomorrow with this Level 3 Award in Education and Training (RQF)qualification. The Level 3 Award in Education and Training (RQF)qualification is a level 3 Award in Education & Training AET(former PTLLS) which has been regulated by the UK's Govt. and awarded by Focus, the UK's fastest-growing awarding organisation. Focus is a well-established awarding organisation governed by Ofqual, ensuring professionalism and appreciation of the qualifications. This Level 3 Award in Education and Training (RQF) qualification will provide you with the opportunity to walk through every aspect of education and training, its history, and much more. You will get a professional insight into the education and training sector, know more about the opportunities and choices you will have after completing this course. You will also get a widely accepted renowned professional certificate which will change your career curve. With this intensive Level 3 Award in Education and Training (RQF) qualification, learners will get a Premium CPD accredited Educational Psychology and Development course completely FREE!!! These courses will boost the Level 3 Award in Education and Training (RQF) qualification and grow to understand children's psychology, its role and development, and so on. With this Level 3 Award in Education and Training (RQF) qualification, learners will get 20 Premium CPD accredited courses completely FREE!!! With this Level 3 Award in Education & Training AET (former PTLLS) Course, learners will get the 20 Premium courses absolutely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: Work Area Organisation for Increased Office Productivity Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma Educational Psychology & Development This course will help you enrich your learning and grow your understanding of educational psychology, development and so on. Enrol today and step forward to achieve greater things in your career! Qualification Summary Qualification type: Focus Level 3 Award Qualification title: Focus Level 3 Award in Education and Training (RQF) Accreditation status: Accredited Level: 3 Guided Learning Hours (GLH): 48 Total Qualification Time (TQT): 120 Qualification number (QN): 601/6099/8 ****Qualification Curriculum**** **Level 3 Award in Education and Training (RQF)** Unit 1: Understanding Roles, Responsibilities and Relationships in Education and Training Unit 2: Understanding and Using Inclusive Teaching and Learning Approaches in Education and Training Unit 5: Understanding Assessment in Education and Training ***Curriculum of The FREE Course*** **Educational Psychology and Development** Module 1: Educational Psychology: An Overview Module 2: Educational Psychology and its History Module 3: Behavioural Views of Learning Module 4: Cognitive Development Module 5: Social, Moral and Emotional Development Module 6: Constructivism and Motivation Module 7: Dyslexia and Learning Difficulties Module 8: Applying Educational Psychology to Teaching Module 9: Effective Instruction and Technology in Education Module 10: Opportunities and Careers in Educational Psychology Learning Outcomes What skills will I gain from this Level 3 Award in Education & Training (RQF) and Educational Psychology and Development Course? Inclusive Teaching and Learning Teaching, Learning and Assessment Approaches Providing opportunities for English, Maths, ICT and Wider Skills Theories of Learning Communication Induction, Icebreakers and Ground Rules Creating a Scheme of Work Devising an Inclusive Teaching and Learning Plan (Session Plan) Self-Evaluation and Continuing Professional Development Course Duration Total Qualification Time This is an estimate of the total length of time it is expected that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification i.e. to achieve all learning outcomes. Total Qualification Time is GLH and an estimate of the number of hours a learner is likely to spend in preparation, study, or any other learning including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor, or tutor. The credit value, where given, for qualification, is determined by TQT, as one credit corresponds to 10 hours of learning. Total Qualification Time for this qualification is 120 hours. Guided Learning Hours These hours are made up of all contact time, guidance, or supervision of a learner by a lecturer, supervisor, tutor, trainer, or other appropriate provider of education or training. Guided Learning Hours for this qualification is 48. Assessment Unit 1: Understanding roles, responsibilities and relationships in education and training: You will be required to submit a written assignment demonstrating your knowledge of legal responsibilities, equality and diversity, individual learner needs, maintaining a safe and supportive learning environment, and your role as a teacher and your superiors. Unit 2: Understanding and using inclusive teaching and learning approaches in education You will be required to complete a written assignment demonstrating your knowledge and understanding of inclusive teaching and learning, as well as your understanding of your own role's strengths and limitations, how to motivate learners, ground rules, and teaching and learning resources.You must perform a micro-teach (15 minutes - 1 hour long) to a group of at least three people of your choosing. Unit 5 - Understanding assessment in education and training You will be required to complete a written assignment that reflects your knowledge of the purpose of assessment, different assessment types, how to conduct assessments, understanding learner involvement in assessment, reasons for constructive feedback, and effective assessment record keeping. Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work product evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal. Certification Successful candidates will be awarded a Level 3 Award in Education and Training (RQF) Qualification Certificate from Focus Awards Limited. Learners will also get CPD accredited Phonics Teaching Diploma and Special Education Needs (SEN) Training certificate from Apex Learning. Progression Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Level 3 Award in Understanding the Principles and Practices of Assessment Level 3 Award in Assessing Competence in the Work Environment Level 3 Award in Assessing Vocational Related Achievement Level 3 Certificate in Assessing Vocational Achievement Level 4 Award in Understanding the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in Learning and Development Level 4 Diploma in Learning and Development. Who is this course for? Those who have already worked in the teaching profession The aspiring professionals who want to add new skills to their CV Individuals who want to start their career as a teacher or teaching assistant ** 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. ** Requirements Level 3 Award in Education & Training (RQF) qualification does not have any specific entry requirements for students. However, you must be at least 19 years old or above to register. Career path Level 3 Award in Education & Training (RQF) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer

Learn The Art of Smudging Learn everything you need to know to confidently begin incorporating this powerful Smudging Ceremony into your life today! Smudging is a practice of connecting with the Spirit of specific plants and herbs to help cleanse, uplift, protect, and unite the physical and spiritual planes. Ancient traditions all around the world have incorporated the practice of smudging into their ceremonies. Now is your time to connect with “that which is greater than us”.

Speech Writing for Public Speaking- one day interactive course. Please register interest to be updated of new dates. Email us at air(@gold.ac.uk). There can be no quality public speaking without masterful use of words. What participants of this course say “It was a very wonderful course ... The Teacher was awesome! Thank you.” “It was excellent. A lot of lessons learned. Would consider a longer course. Thanks for a great day!” Not-for-profit 100% of AIR income, beyond operational expense, is used towards education and research - enabling us to provide our training at exceptional value. Tutoring This course is directed by Fatos Selita, a multidisciplinary trained communication expert. Booking Information Group bookings To book this 'Public Speaking and Presenting' course for a group, please email us air@gold.ac.uk. The price for group bookings starts from £1,925, covering a maximum of 8 people. VAT-Free except when provided in Clients' Offices: as a University, we are able to offer our courses at minimum prices, and free of VAT - to make knowledge available to as wide audience as possible. Refund policy: For this training course, where the number of participants is capped at 8, we offer you the following flexibility: If you cannot attend on the date booked, we will be happy to move your booking to a new date or provide you with a refund of our fee - if you notify us more than 7 days ahead of the start date. If you need to cancel the course within 7 days ahead of the start date - we will be happy to offer you one change to a future date. 10% discount when a participant enrols for more than one of our courses at the same time. 20% discount for UK students. 20% for members of the Society for Personality and Social Psychology (SPSP) (spsp.org). 25% discount for Members of the UK Law and Society Association (UKLSA) (uklsa.co.uk). Goldsmiths students, staff, or alumni, please email us for current discounts. Sponsored places: We are currently offering a number of sponsored places on all AIR Courses for those in extremely difficult financial circumstances. Please email us for details: air(@gold.ac.uk). Bespoke training Public Speaking for Diplomacy Interview Skills Public Speaking for Academics / Researchers Public Speaking for Business Professionals (Bankers, Lawyers, Media Professionals) Enquiries For all enquiries, and to be regularly updated on upcoming AIR courses, please email: air (@gold.ac.uk). For anything urgent, or if emailing is not a good option for you, you can also call us via WhatsApp or phone on +44 (0)7908 566 949.

Boost Your Career By Enrolling In This QLean Six Sigma Green Belt for Service Industry Bundle To Overcome Your Challenges! Receive 10 CPD Accredited additional bundle courses related to Six Sigma Green Belt for free when you purchase this Lean Six Sigma Green Belt for Service Industry Bundle. Supercharge your service industry career with our game-changing Lean Six Sigma Green Belt course. Gain the skills and certification needed to drive continuous improvement in Lean Six Sigma Green Belt, boost productivity, and propel your professional success to new heights in Six Sigma Green Belt. This Lean Six Sigma Green Belt for Service Industry Bundle Package includes: Course 01: Diploma in Lean Six Sigma Green Belt for Service Industry at QLS Level 5 10 Additional CPDQS Accredited Premium Courses related to Six Sigma green belt- Course 01: Lean Six Sigma White Belt course Course 02: Lean Six Sigma Black Belt Course Course 03: Lean Six Sigma green belt Toolkit Course 04: Professional Lean Management: Service Industry Course 05: Project Management Course 06: Leadership & Management Diploma Course 07: Supply Chain Management Course 08: Quality Management Course 09: RCA: Root Cause Analysis Course 10: Online Time Management Training Enrol today in our Six Sigma Green Belt course to unlock a world of opportunities and become a valued asset in streamlining processes and delivering exceptional service. Learning Outcomes of Six Sigma Green Belt: By completing the Lean Six Sigma Green Belt for Service Industry course, you will: Understand the principles and methodologies of Lean Six Sigma green belt. Learn how to define, measure, analyze, improve, and control processes for optimal Six Sigma green belt efficiency. Acquire the tools and techniques to identify and eliminate waste in service operations. Gain practical knowledge in applying Lean Six Sigma green belt methodologies through real-life case studies. Develop skills to enhance customer satisfaction and drive continuous improvement in the service industry. Why Prefer This Six Sigma Green Belt Bundle? Get a Free CPD Accredited Certificate upon completion of the course Get a free student ID card with this training program The course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the course materials The training program comes with 24/7 tutor support Start your learning journey straightaway with our Six Sigma Green Belt Training! *** Course Curriculum of the title course of the Six Sigma green belt Bundle*** Here is the curriculum breakdown of the Lean Six Sigma Green Belt for Service Industry at QLS Level 5 course: Section 01: Course Overview Section 02: Introduction Section 03: Define Section 04: Measure Section 05: Analyze Section 06: Improve Section 07: Control Section 08: Case Study Section 09: Conclusion Assessment Process of Lean Six Sigma Green Belt course: You have to complete the assignment questions given at the end of the Six Sigma green belt course and score a minimum of 60% to pass each exam. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Lean Six Sigma Green Belt for Service Industry at QLS Level 5 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for individuals who aspire to become Lean Six Sigma green belt professionals. Requirements No prior background or expertise is required for this Lean Six Sigma Green Belt course. Anyone who is interested in Six Sigma green belt can enrol in this Lean Six Sigma Green Belt course. Career path Completing the Lean Six Sigma Green Belt for Service Industry course opens up a world of exciting career opportunities. Lean Six Sigma Green Belt Lean Six Sigma Black Belt Operations Manager Quality Manager Process Improvement Consultant Project Manager Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Lean Six Sigma Green Belt for Service Industry at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Lean Six Sigma Green Belt for Service Industry at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

The Learning College Group offers this HLTA Level 4 Higher Level Teaching Assistant qualification that is fully Regulated and accepted in all schools across the UK. This HLTA qualification enables you to work with children between the ages of 5-18 years. Our TQUK Level 4 HLTA Teaching Assistant (RQF) Qualification is a fully recognised qualification regulated by Ofqual, of which is accepted within schools throughout the UK in the teaching sector.

First Degree Usui Reiki Course This is the first level of Reiki. It is suitable for therapists and laypeople alike – everyone is welcome to come and share the gentle energy. ​It will enable you to connect with the universal energy that exists all around us to help yourself, friends and family, or animals and plant life. If you are interested in using Reiki as a therapy in your practice – then this is the starting point. Individuals wanting to add Reiki to their daily life will benefit highly from this course. This course is comprehensive and detailed.