28495 OV courses in Liverpool delivered Online

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

Teaching Assistant Level 3 Qualification Enhance your efficiency in the teaching profession and gear up your career opportunities in this noble sector with the most exclusive 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 aims to improve your knowledge of the education and training sector. Learners who complete this certification will have a good understanding of the skills and information that a qualified teacher or education professional must possess. You will also achieve a globally recognised certification to boost your confidence and establish a rewarding career in the teaching sector. Guess what's more!!! Along with this outstanding Level 3 Award in Education and Training (RQF) qualification, learners will get two Premium CPD accredited courses completely FREE!!! Courses are: Level 3 Diploma in Speech Therapy and SEN Teaching Phonics Teaching Diploma Level 3 These courses will help to boost the learning and enrich your speech therapy and phonics teaching proficiency. Enrol now and step forward for a glorious future!!! 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 Courses*** **Level 3 Diploma in Speech Therapy and SEN Teaching** Speech Therapy Module 01: An Overview of Speech Therapy Module 02: The Science of Speech Module 03: The Anatomy of Speech Module 04: Characteristic of Speech: Linguistic Discipline Module 05: Literacy and Language Development Module 06: Child Speech & Language Disorders Module 07: Adult Speech & Language Disorders SEN Teaching Assistant Module 01: Special Education Needs (SEN) An Overview Module 02: SEN Support Module 03: High Quality Teaching for Pupils with SEN Module 04: SEN Teaching Methodologies Module 05: Communication and Interaction Module 06: Cognition and Learning Module 07: Physical Development And Skills Module 08: Sensory or Physical Needs Module 09: Working in Partnership **Phonics Teaching Diploma Level 3** Module 01: Introduction to Phonics Education Module 02: Role of Early Phonics Teaching Module 03: Career as Phonics Teacher Module 04: Teaching Phonics Module 05: Jolly Phonics Module 06: Involving Parents and Carers Module 07: Speaking and Phonological Awareness Module 08: Systematic Assessment and Record-Keeping Module 09: Meeting Individual Needs Module 10: Cognitive Approaches in Dyslexia Module 11: Phonics for Deaf Children Module 12: Teaching Higher Level of Phonics Learning Outcomes What skills will I gain from this Level 3 Award in Education and Training (RQF) Qualification? Understand the underlying fundamentals of teaching and learning Make a practical approach to session planning Explore the various approaches to learning Determine the students' desires and long-term goals Implement strategies for assessing your students' potential You will become an expert in education and training You will gain knowledge in teacher expectations & attributions and much more 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 Speech Therapy & 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 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

Face to Face Training Customised and Bespoke.

Hysteria’s history, rooted in Greek myth, evolved into a Victorian belief of a “wandering uterus” leading to disturbing medical practices. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Hysteria- between Prof. Ernesto Spinelli and Bárbara Godoy “In this talk, I will compare the Histerical patient to the ancient Greek myth of Persephone, the goddess who traversed the boundaries between the world of the living and the underworld. Just as Persephone’s cyclical descent and return mirrored the changing seasons, hysteria was seen as a condition where emotions and experiences defied easy classification. This notion of transgressing boundaries became a cornerstone of early psychoanalysis. In Victorian times, hysteria took a decidedly bizarre turn. Here, the culprit was believed to be a mobile womb, an organ capable of throwing into disorder and confusion. This “wandering womb” was blamed for a variety of ailments and behaviours, particularly any expression of female desire out-of-wedlock. In a truly disturbing reflection of these beliefs, legal rulings based on this theory emerged. In some cases, women diagnosed with hysteria could be forced to undergo a hysterectomy.” Bárbara Godoy. Bárbara Godoy M.A., Adv. Dip. Exi. Psy, UKCP accredited Psychotherapist and Supervisor, MBACP and SEA – Director of Therapy Harley Street. Bárbara’s academic experience in London since 2008 includes lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent’s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. Bárbara has facilitated therapeutic Group Work internationally since 1997. The question about the meaning of Being-Woman was the topic of her thesis completed in 2005 and evolved into two main Women’s Groups: “Nine muses” and “Four Seasons” which she leads in addition to her individual private practice. Currently, as the clinical director of THS, Bárbara leads a team of over 20 professional practitioners in the area of Psychological services and Wellbeing consultancy. Bárbara is also the founder-director of THS’s Personal Development and CPD Programmes. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 13 December from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

Critical Thinking and Creative Problem Solving: On-Demand Two critical skillsets for the future of work are critical thinking and creative problem solving. These modes of working and thinking intersect and overlap; both are necessary and both can be taught. Having the ability to exercise creativity while at the same time applying structure and discipline to the thinking process is a key competency in the twenty-first century workplace. This course explores the interplay between critical and creative thinking, and the necessity of each to effective problem solving and decision making. Participants will learn a variety of techniques to apply critical thinking to real-life scenarios. They will experiment with different problem-solving approaches and will learn about cognitive influences on our decisions and choices. The course delves into the business value of creativity and involves participants in actively integrating criticality, creativity, and problem solving. What you will Learn At the end of this program, you will be able to: Explain basic concepts of problem solving Infer types of cognitive biases that impact decision making Utilize types of root cause analysis Differentiate among obstacles to sound decision making Apply a variety of problem-solving approaches / processes to existing challenges Evaluate alternative solution methods using various techniques Analyze real world problem scenarios to determine the lateral thinking type needed to address them Foundation Concepts Definitions Thinking modes and cognitive bias Basic problem-solving framework Problem Definition and Solution Generation Root cause analysis Basic problem-solving obstacles Generating alternative solutions Evaluating Alternatives Critical thinking guidelines Obstacles to sound decision making Tools for evaluating alternatives Exploring Lateral Thinking Problem-solving challenge Workplace application

Project Management for Non-Project Managers (On-Demand) Individuals who are involved in projects (commissioning, supporting, sponsoring, etc.) may often be unfamiliar with project management. A basic understanding of project management is essential for non-project managers, who are critical stakeholders contributing to project success. This awareness course uses A Guide to the Project Management Body of Knowledge (PMBOK® Guide) and other sources to introduce you to project management vocabulary, concepts, and techniques. It also provides insights into the realities of being a project manager, and opportunities to explore how you can positively impact projects in your own role. What You Will Learn At the end of this program, you will be able to: Identify the benefits of project management Use standard project management terminology Describe characteristics of successful projects, project managers, and high-performing teams Explain various project stakeholder roles, their responsibilities, and the fundamental project management processes Recognize how agile / adaptive practices are useful for certain project life cycles Create a personal action plan for how to support real-world projects within a non-PM role Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Project management overview Strategic value of project management Defining project success Project life-cycle models and governance Project roles and responsibilities Project Initiating and Planning Initiating the project Defining project requirements and scope Developing the project schedule and budget Project Risk Management, Executing, Monitoring, and Closing Understanding, evaluating, and adjusting for risk Honoring the baseline and executing the project Monitoring and controlling the project Closing the project Project Interpersonal Processes Project communication Project team development Conflict management Summary and Next Steps

Getting Started The ILM Level 5 Certificate in Leadership and Management is designed for practising project managers, department heads, and middle managers, helping them to develop skills and experience, improve performance and prepare for senior management responsibilities. At the Certificate level, the mandatory unit focuses on understanding different leadership styles and adopting the most effective style to motivate staff and achieve organisational goals. Another unit covers using and evaluating action learning for leadership development, planning, and undertaking activities to develop the learner's leadership performance. The benefits of an ILM qualification are endless. The Level 5 management course focuses on the development of an individual's ability to lead, motivate and inspire a team, to provide strategic leadership as well as improve day-to-day operational management, benchmarking their managerial skills and raising their profile within the organisation-making ILM Level 5 one of the best management qualifications to have. The Institute of Leadership and Management (ILM) Level 5 Certificate will build upon and broaden senior managers' skills, giving them the practical techniques to excel as strong and effective leaders. The ILM Level 5 Certificate aims at those with considerable management experience and those looking to take their next career step to higher-ranking leadership positions within an organisation. Studying with ILM delivered by SBTL offers the learner real, practical and transferable skills that can immediately be implemented in the workplace. Key Benefits The Level 5 Certificate in Leadership and Management is designed for practising middle managers, helping them to develop their skills and experience, improve performance and prepare for senior management responsibilities. Benefits for individuals  Understand yourself as a leader  Use feedback and self-review to enhance your leadership skills  Learn solid techniques for planning and implementing complex pieces of work  Put these skills into practice in your workplace  Raise your profile, get results and get a nationally recognised qualification.  Benefits for employers  Short, concise qualification focused on workplace-based activity  Give managers the tools to manage their own professional development  Managers with the self-awareness to lead and the practical skills to deliver results in your organisation. About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. What is included? A dedicated tutor for individual students to help and provide suggestions throughout the course. Providing formative assessment with formative feedback will support the learner to improve their achievements. Our online learning platform will provide all of the assessment materials. Platform independent accessibility of Online learning portal, SBTL delivers the course straight to the student's smartphone, tablet, laptop or desktop, enabling them to study at their convenience. Entry Requirements Must be 19 years of age and over Substantial experience as a manager or supervisor Should possess provable academic ability to complete a level 5 qualification Progression These qualifications will provide progression opportunities to other qualifications including: ILM Level 5 Diploma in Principles of Leadership and Management Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Credit Value: Minimum 13 credits Maximum 36 credits Rules of Combination: Minimum 13 credits, maximum 36 credits Minimum of 7 credits from Group 1 Maximum of 6 credits from Group 2 Unit Code Unit Title Credit Group 1 8607-506 Managing Stress and Conflict in the Organisation 3 8607-511 Managing Projects in the Organisation 4 Group 2 8607-402 Managing Equality and Diversity in Own Area 4 8607-415 Motivating people in the workplace 2 Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Branding isn’t just about logos—it’s about strategy. Learn how to build, analyze, and manage a brand that drives business success. 📌 5 Modules | 28 Videos | 85 Minutes Total 📘 Includes Course Workbook for Hands-On Brand Analysis 🎓 Earn a Certificate of Completion Taught by branding expert Steven Silverman, Ph.D., this course breaks down the Brand Constellations Framework, helping you align your brand across product, pricing, marketing, customer experience, and company culture. 🔹 Who is this for? Founders, CMOs, marketing leaders, and anyone looking to build a powerful brand. 🔹 Why take this course? Gain a structured, research-backed approach to brand strategy with real-world case studies and actionable insights.

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.

Go from Beginner to Super Advance Level in Machine Learning Algorithms using Python and Mathematical Insights