53706 Courses in Epsom delivered Online

Expand your Excel knowledge and learn how to structure and analyse large data sets.

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

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