54558 Courses

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Course Description By enrolling on this course you will: Understand the role of an assessor and the principles and practices of assessment Plan assessments in workshops or classroom with at least two learners Use different assessment methods, make assessment decisions and give feedback to learners Involve learners and others in the assessment process – ensuring decisions are countersigned, quality assured and that assessment practice is standardised Apply legal and regulatory requirements to your assessment Benefits Gain the industry standard qualification to be a classroom / workshop assessor Interactive online workshops and one to one support to complete assignments One to one mentoring to support achievement of the practical unit Receive mentoring and support form qualified and experienced assessors

If you assess students in the workplace against industry or occupational standards, this is the industry standard qualification that you must hold. You must be able to work with 2 learners in the workplaces to demonstrate your assessing skills. Further Information The course is delivered split into 3 parts: 4 half day workshops delivered via Zoom The completion of 3 assignments. Carrying out assessment activity in the workplace Benefits By attending this course, you will be able to: Understand the role of an assessor and the principles and practices of assessment Plan assessments in the workplace with at least two learners Use different assessment methods, make assessment decisions and give feedback to learners Involve learners and others in the assessment process – ensuring decisions are countersigned, quality assured and that assessment practice is standardised Apply legal and regulatory requirements to your assessment

This training is for lawyers who may come into contact with vulnerable people through their work. In particular, it is aimed at those who hold legal aid contracts and must meet the requirements of the Specialist Quality Mark (SQM) standard in respect of safeguarding. Everyone has the right to be kept safe from harm, abuse or neglect. We all have obligations to ensure that vulnerable people are protected and that we have appropriate procedures in place to ensure that abuse is identified and reported.  We will help you to understand the following; What is safeguarding? The different types of abuse Example signs of abuse, harm and neglect What action should be taken if abuse is suspected The SQM requirements What a Safeguarding Policy should include Target Audience The online course is suitable for staff of all levels, from support staff to senior partners. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Amie Higgins, Consultant, DG Legal Amie is a Senior Solicitor, qualified under the Law Society’s Immigration & Asylum Accreditation Scheme (IAAS) as an Advanced Caseworker and Supervisor. Amie specialises in all aspects of Immigration, Asylum and Human Rights work, with a specialism in human trafficking/modern slavery cases and working with vulnerable clients. Amie is an experienced trainer, delivering a range of training on both legal and practice management topics.

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. Why choosing Mindmaps Wellbeing is a good choice for your mental health training. The MHFA England RRP is £325pp, our rate is £300pp and our fee includes: ✅ Instructor led training sessions over two days ✅ Course Manual ✅ Workbook ✅ Handy Cue Card ✅ MHFAider Certificate upon completion Plus, exclusively when you choose Mindmaps Wellbeing, it also includes: ✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life). ✅ Access to our online MHFAider peer support groups moderated by the instructor team. ✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider. ✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available. For a little extra: ✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. ✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Become a qualified assessor

This workshop has been designed to help you to apply the principles of emotional intelligence with world-renowned coaching models to enable others to achieve greater results. By increasing your coaching skills you will find ways of developing others in a way that maintains a trusted relationship, engenders change and promotes personal accountability.

Have you completed your Reiki Level 1 and are ready to take your Reiki practice to the next level?  Our Level 2 course is the ideal choice for both personal and professional growth.  Over 2 days, and following up with personal study and case studies, you will learn how to give Reiki to others as a professional practitioner. Your tutor Janie Whittemore has been working with Reiki for many years and has vast experience teaching and running her own practice. Feel free to book a chat! https://booking.setmore.com/scheduleappointment/12a7b75d-454c-4191-b267-2c703eacdde4/services/sf93d1524069400768?source=easyshare

Health & Safety, PPE Covid COSHH & RIDDOR Equality & Diversity, Human Rights Infection Control Food Safety Information Governance Data Protection (GDPR) Records Management Fraud & Bribery Conflict Resolution Lone Worker Moving & Handling level 2(practical covered) Fire Safety Freedom of Information Safeguarding Adult & Children level 3 Radicalisation Slips Trips & Falls Your Healthcare Career Person Centred Care Duty of Care Consent Communication Privacy & Dignity Complaints Handling BLS –CPR & Choking for Adults and Children (practical covered) Mental Capacity Act—DoLS Mental Health Act

Deep tissue massage course Deep tissue skills Learn deep tissue