54088 Courses delivered Online

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

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

CAVA is a combined of assessment of occupational competence in the work environment, and the assessment of vocational skills, knowledge and understanding. Level 3: Certificate in Assessing Vocational Achievement (RQF) course is suitable for people who assess vocational skills, knowledge and understanding other than in the work environment (e.g. a workshop, classroom or other training environment).

Every employee needs to have their performance managed and it is equally important to 'catch people doing something right

Face to Face Training Customised and Bespoke.

In today's dynamic business environment, Managers need to evaluate different courses of action and make decisive decisions.

Dive into the therapeutic world with our Therapy (Hydrotherapy, Physiotherapy, and Sports) Bundle! This comprehensive course bundle includes eight essential courses that offer a deep theoretical understanding of diverse therapy disciplines. Three of these courses are QLS-endorsed, specifically focusing on Physiotherapy, Hydrotherapy, and Sports Therapy. After completing these courses, you'll receive a hardcopy certificate, demonstrating your commitment and knowledge in these fields. The bundle also equips you with five CPD QS accredited courses, ranging from Massage Therapy Techniques and Deep Tissue Massage Therapy to Thai Massage Therapy for Pain Management, Acupressure for Pain Relief, and Thai Foot Reflexology. Dive into this theoretical journey across different therapeutic practices. Unleash the power of therapy knowledge with this all-encompassing bundle today! Key Features of the Therapy (Hydrotherapy, Physiotherapy and Sports) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Therapy (Hydrotherapy, Physiotherapy and Sports) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Physiotherapy QLS Course 02: Hydrotherapy QLS Course 03: Sports Therapy 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Massage Therapy Techniques Course 02: Deep Tissue Massage Therapy Course 03: Thai Massage Therapy for Pain Management - Online Diploma Course 04: Acupressure for Pain Relief Course 05: Thai Foot Reflexology Course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Therapy (Hydrotherapy, Physiotherapy and Sports) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Therapy (Hydrotherapy, Physiotherapy and Sports) Bundle: Gain a thorough theoretical understanding of Physiotherapy, Hydrotherapy, and Sports Therapy. Learn the concepts behind different Massage Therapy Techniques. Understand the principles of Deep Tissue Massage Therapy. Gain knowledge about Thai Massage Therapy for Pain Management. Understand Acupressure for Pain Relief and its theoretical underpinnings. Learn the concepts of Thai Foot Reflexology. Understand the role and application of these therapies in sports and recovery. The Therapy (Hydrotherapy, Physiotherapy and Sports) bundle is a comprehensive collection of courses that have been meticulously designed to provide you with a well-rounded education in Therapy (Hydrotherapy, Physiotherapy and Sports). With a combination of 3 QLS-endorsed courses and 5 CPD QS-accredited courses, this bundle offers you the perfect balance of essential knowledge and valuable skills. What's more, we are proud to offer free hardcopy certificates for each course within the Therapy (Hydrotherapy, Physiotherapy and Sports) bundle, giving you the recognition you deserve. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in gaining a theoretical understanding of different therapeutic practices. Those who want to deepen their knowledge about various massage techniques. Aspiring professionals in Physiotherapy, Hydrotherapy, and Sports Therapy. Anyone interested in the principles of pain management through therapy. Career path Physiotherapist: Salary Range - £23,000 - £48,000 Hydrotherapist: Salary Range - £18,000 - £32,000 Sports Therapist: Salary Range - £22,000 - £36,000 Massage Therapist: Salary Range - £18,000 - £30,000 Acupressure Practitioner: Salary Range - £20,000 - £35,000 Thai Foot Reflexologist: Salary Range - £18,000 - £30,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Step into the remarkable realm of education and child development with our specially curated bundle, "Pedagogy, Home Education and Educational Psychology - 3 QLS Course." Packed with a potent combination of expertise and theoretical exploration, this bundle is your ticket to deepening your understanding and setting your career on a path of continuous growth. The bundle is powered by three QLS-endorsed courses: Pedagogy, Home Education, and Educational Psychology. Immerse yourself in high-level, theoretical insights that pave the way for superior knowledge acquisition. And what's more? With each of these QLS courses, you'll receive a hardcopy certificate, an emblem of your commitment to elevating your professional potential. Complementing these, the bundle also offers five CPD QS accredited courses that delve into the nuances of School Administration, the role of Teaching Assistants, the essence of Montessori Education, the EYFS Teaching paradigm, and the fascinating world of Child Psychology & Development. Dive into a treasure trove of meticulously curated content that ensures you stay on top of the latest pedagogical theories and practices. Our Pedagogy, Home Education, and Educational Psychology bundle is the perfect conduit for you to shape futures, one lesson at a time. Join the ranks of those dedicated to the craft of education, set your horizons higher and empower your career with a new-age theoretical edge. Your journey towards educational excellence begins here. Key Features of the Pedagogy, Home Education and Educational Psychology - 3 QLS Course Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Pedagogy, Home Education and Educational Psychology - 3 QLS Course bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Pedagogy QLS Course 02: Home Education QLS Course 03: Educational Psychology 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: School Administrator Training Course 02: Teaching Assistant & Lesson Planning Course 03: EYFS Teaching Diploma Course 04: Montessori Education for Early Childhood Course 05: Child Psychology & Development In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Pedagogy, Home Education and Educational Psychology - 3 QLS courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of the theoretical underpinnings of pedagogy, home education, and educational psychology. Enhance your knowledge of school administration and the roles and responsibilities of teaching assistants. Delve into the tenets of Montessori Education and the Early Years Foundation Stage (EYFS) teaching paradigm. Develop a profound understanding of child psychology and the principles of child development. Gain the ability to critically assess, analyse, and apply modern educational theories and practices. Enhance your understanding of the intricacies of home education, providing optimal learning experiences outside traditional classroom settings. Acquire a holistic understanding of the diverse aspects of child development, from cognitive processes to social interactions. Introducing the "Pedagogy, Home Education and Educational Psychology - 3 QLS Course" bundle: your gateway to a profound understanding of modern pedagogical theories and practices. With a comprehensive array of eight courses, this bundle enables you to delve deeply into diverse aspects of education, from school administration to child psychology. Gain unparalleled theoretical insights, empowering you to make a lasting impact in the realm of education. CPD 250 CPD hours / points Accredited by Centre of CPD Excellence Who is this course for? Aspiring educators who wish to expand their theoretical knowledge and understanding. School administrators seeking to understand educational frameworks and pedagogical practices better. Parents or guardians interested in home education and eager to provide a comprehensive learning experience for their children. Individuals keenly interested in child psychology, development, and modern teaching methodologies. Career path Education Consultant (£40,000 - £60,000 annually) School Administrator (£20,000 - £35,000 annually) Home School Tutor (£25,000 - £35,000 annually) Teaching Assistant (£12,000 - £20,000 annually) Early Years Teacher (£20,000 - £30,000 annually) Child Development Specialist (£30,000 - £50,000 annually) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

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.

Business Relationship Management Fundamentals: On-Demand Business Relationship Management (BRM) Fundamentals introduces BRM as a capability, role, and discipline. Participants can expect an interactive and lively one-day session, with a high-level introduction to successfully navigate the complexity of BRM. What you will Learn During this course, we will show you how to: Define BRM as a capability, role, and discipline Describe what a BRM does and does not do Provide the language needed to change perceptions and perspectives Learn how the BRM discipline interacts with other disciplines (project management, architecture, Business Analysts, Business functions, strategy, etc..) inside an organization Explain the basic introduction to the different frameworks, processes, and models to bring structure and guidance to BRM Introductions and Expectations Business Relationship Management Institute Knowledge path to success Business Relationship Management (BRM) Defined BRM DNA = Develop, Nurture, and Advance BRM as a capability, role, and discipline Why BRM BRM is the answer to converging functions as strategic partners sharing ownership of strategy and results BRM evolves enterprise culture BRM capability builds strategic partnerships and drives business value BRM in Action Evolving enterprise culture Building strategic partnerships Driving business value BRM Results Relationships Business value BRM artifacts Communications Summary Reasons BRM fails Certificate of Experience: BRM Fundamentals What is next?