6450 Courses in Rutherglen delivered Live 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

Become a professional in the Telecomms industry with our EUSR SHEA Telecommunications Card Training Overview Our Energy Utilities Skills Register Safety Health Environmental Awareness EUSR SHEA Telecommunications Card Training is designed for professionals working in telecommunication-related industries, such as Telephone Exchanges, on the network, customer properties and more. The course equips participants with essential knowledge and skills to ensure safe and environmentally responsible practices on work sites near telecommunication environments. Upon completion, you’ll receive the coveted EUSR SHEA Telecommunications Card.

A 10 week SATs Success course for students in year 6. Tutoring in English and Tutoring in Maths in a small group year 6 tutor session.

Public Speaking and Presenting - a one-day interactive training taught in small groups. On this page: What participants of this course say Tutoring Booking Information Refund policy Industry-specific public speaking training Follow-up training options Enquiries This is a one-day interactive course on the delivery of public speaking – a beautiful art that can be mastered with quality training and practice. What participants of this course say "10/10. Excellent trainer. Found most useful : - the Feedback session; tutor being very patient in asking/teaching us to pause and repeat with correct tone. - Link to Psychology and Genetics, rather than just techniques." “This course struck the perfect balance of theory/practice application for me. I appreciate the individual feedback and Fatos was a fantastic teacher. Very knowledgeable." 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 info(@technotruth.co.uk). The price for group bookings starts from £1,925, covering a maximum of 8 people. 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: For all enquiries, and to be regularly updated on upcoming AIR courses, please email: info (@technotruth.co.uk). Industry-specific public speaking training Public Speaking for Diplomacy Interview Skills Public Speaking for Academics / Researchers Public Speaking for Business Professionals (Bankers, Lawyers, Media Professionals) Find out more about all of the AIR courses available to you. Enquiries For all enquiries, and to be regularly updated on upcoming AIR courses, please email: info (@technotruth.co.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.

CPD accredited Level 3 Cleaning Technology and Control course. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.

CPD accredited Level 2 HACCP & Food Safety course. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.

CIEH Level 2 Food Safety in manufacturing. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.

CIEH Level 2 Foundation HACCP certificate in manufacturing. Delivered online (Zoom) by a live tutor. Exam and Certificate fee included in the price.

This qualification is designed for Water Network Field Managers, Operational Managers, Project Managers, Department Heads, and other practising Senior and Middle Managers. The qualification will develop your technical skills and understanding of the Management of demand Management & Leakage and improve your performance. It will encourage strategic thinking at this level of management to foster business improvement. Main themes Understand the role demand management plays in the water industry sustainability plan Understand the range of demand management tools available and their effectiveness Understand the application of leakage strategies, the economic value and the external influences Understand data handling, meaningful leakage calculations and the interpretation of leakage data Understand various leakage control methods used and their respective effectiveness and economic cost-benefit Understand network repair and maintenance methods and the provision of these services Instructions This online course will be delivered using CISCO Webex. You will need a suitable device with a camera and microphone like a laptop. If you have any questions about what is required, please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.

Details This course is aimed at Water and Wastewater managers, field managers, asset managers and others involved in meeting compliance within the Water industry. As Wastewater Treatment compliance now comes under increasing regulatory scrutiny from OFWAT the overall ability of the Water Industry to effectively oversee and manage the Wastewater Treatment process comes under sharper focus. Demonstrating the competence of those responsible will likely become increasingly the focus of public awareness and form a key strand of the regulator’s investigation. Main themes Demonstrate an understanding of the current regulatory framework pertaining to pollution incidents Understand the sources of pollution Understand pollution risks specific to the Water and Wastewater industry Critically analyse the stakeholders’ views of pollution from the Water and Wastewater industry Understand the importance of stakeholder communication, feedback and involvement in the context of pollution incidents Understand the impact of pollution in terms of the environment, customers, cost, H&S and from the regulatory perspective Describe the cumulative effect of point source and diffuse sources of pollution Describe and explain the collective responsibilities and ethical and moral issues as pertaining to pollution incidents Critically evaluate the use of internal systems and mechanisms for delivery of pollution risk reduction strategies Develop a pollution risk reduction strategy appropriate to your organisation. Instructions This online course will be delivered using CISCO Webex. You will need a suitable device with a camera and microphone like a laptop. If you have any questions about what is required, please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.