Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.
Expand your Excel knowledge and learn how to structure and analyse large data sets.
Enhance your dental practice's safety and compliance with our 3-hour CPD accredited Dental Practice Legionella Responsible Person Course. Designed for Practice Owners, Registered Managers, and Senior Infection Control Leads, this online course offers expert guidance on legionella management, aligning with HSE ACOP L8, HSG274 Part 2, HTM 04-01, and HTM01-05 standards. Gain advanced understanding and confidence in legionella prevention in dental settings. Receive a GDC-compliant CPD Certificate upon completion. Join our live sessions led by skilled instructors for a transformative learning experience in dental health and safety management.
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
Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data
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