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
About this course This practical course will help primary teachers to understand the purpose of assessment in history and consider current best practice. We will explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies. We will go through practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment. This course will provide guidance and support to help develop the accuracy of teacher judgements. During the course, we will look at examples of writing and outcomes from different schools and consider how these outcomes demonstrate progress and attainment in history. Outcomes • understand the purpose of assessment in history • consider current best practice • explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies • explore practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment • provide guidance and support to help develop the accuracy of teacher judgements Course leader The course is led by Steven Kenyon. Steven is a member of the Historical Association’s primary committee, having worked as a primary school teacher and then Deputy Head Teacher between 2004 and 2018. He joined Lancashire Professional Development Service in April 2018 as a Teaching and Learning Consultant for Primary History and English. He works closely with Lancashire Archives to promote and develop local history work in primary schools. This year he is a judge for the Historical Association's Young Quills Awards.
A four-hour workshop for HR Professionals in the area of Attraction, Selection and Recruitment of Neurodiverse people.
To help address this complex and yet commonplace experience, we’ve designed a one-day workshop to help professionals who experience passive-aggressive behaviour and toxic interpersonal communication in the workplace cope more effectively. Designed to be a decisive first step into gaining control over workplace toxicity, over the course of one day, attendees will be taught to recognise patterns of passive-aggressive behaviours and will learn how to respond appropriately to it. The workshop we will work through exercises to help demystify passive-aggressiveness so that it can be rendered increasingly more harmless to those who experience it routinely. Through specially designed exercises informed by the field of Emotion Psychology and Neuroscience you will also learn how to be less affected by it without resorting to repressing your emotions and shutting down.
Face to face One to one.
CHANGE YOUR LIFE IN JUST 36 HOURS 3 DAYS PACKED FULL OF FUN, CHALLENGE, INSPIRATION, INSIGHTS AND MOTIVATION. THIS 3- DAY EVENT MIMICS ASPECTS OF YOUR EVERYDAY LIFE THROUGH CHALLENGES, EXERCISES AND TASKS. IT HELPS YOU SHIFT FROM FEELING STRESSED, STUCK, SEARCHING TO ENERGISED, ELEVATED AND ENGAGED.
Data analysis translates numbers and data into information that can be used to solve problems or track business performance. Data analysis produces graphs, charts, tables and reports. Data analysis is in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education. The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data but be able to provide insight and analysis through clear visual, written and verbal communication. This course provides the knowledge and skills to help you hone your data analysis skills.
Do you want to boost your medical career by learning about the cannulation process? This comprehensive cannulation course is ideal for you! You can learn about the whole venepuncture and cannulation procedure in this Venepuncture and Cannulation Training Course, as well as the safest methods for handling, flushing, and removing a cannula. This course will provide you with the necessary training to flourish in your profession, whether you are a novice or an experienced individual wishing to enhance your career in the healthcare industry. Course Highlights Designed by healthcare professionals Accredited by the CPD Certification Recognised and Valuable Certification Self-Paced Online Theoretical Learning High-Quality Study Materials Interactive practical training Practical Day Class Schedule – 1 Day Face-to-Face Training Venue Location London: Bank Studio, 23 Park Royal Road, NW10 7JH Date: 21st February, 2025 Date: 30th March, 2025 Date: 28th April, 2025 Date: 27th May, 2025 Date: 21st June, 2025 Time: 10:00 am – 05:00 pm Venue Location Birmingham: 83-85 Hagley Road, Birmingham, B16 8QG Date: 25th January, 2025 Date: 24th February, 2025 Date: 23rd March, 2025 Date: 21st April, 2025 Date: 26th May, 2025 Date: 26th June, 2025 Time: 10:00 am – 05:00 pm This extensive IV Cannulation Course covers the following credentials: Selection of veins for cannulation Arm and hand physiology and anatomy Types of cannula Process of cannulation Safety measures Proper insertion of the cannula Classroom-Based Cannulation Course Practical learning We offer comprehensive theoretical study materials and practical sessions for our cannulation training. As part of the practical training, you will receive practical dry lab demonstrations and hands-on experience to justify your role. Who is this Venepuncture and Cannulation Course for? This Venepuncture and Cannulation course is primarily aimed at: Health Visitors Healthcare professionals Nurses, midwives, pharmacists and doctors Freshers looking to begin their career in the healthcare sector Anyone looking to enhance their cannulation skills Aims and Learning Outcomes of this Venepuncture and Cannulation Training Course Know how to select the appropriate veins for cannulation Understand the anatomy and physiology of hands and arms Recognise the various sizes of a cannula Identify the risks concerning cannulation Know how to insert the cannula properly Recognise the safety precautions that should be maintained Gain knowledge about the dressing procedure Know how to safely flush and remove a cannula Learn how to securely dispose of all the sharps Learning how to perform Phlebotomy Trainingand Catheterisation Training can help you to provide better care to your patients. By being able to insert a catheter quickly and effectively, you can administer necessary treatments more efficiently, which can improve patient outcomes and reduce discomfort. Entry Requirements There are no academic entry requirements for this cannulation course, and it is open to students of all educational backgrounds. You need to join the Phlebotomy Training before attending the Cannulation Training. Assessment Method In this Venepuncture and Cannulation training, learners will be assessed via observation. That means during the practical training, you will be observed by the supervisor/trainer. Upon successful demonstration of blood sampling and blood draw, you will be awarded a CPD-accredited certificate accepted by thousands of professional bodies and government regulators in the UK and worldwide. Whether you are a fresher looking to kickstart your career in healthcare or practising healthcare looking to enhance your cannulation skills, this course will help you achieve your professional aspirations by all means. Course Curriculum 1. Cannulation Training - Course Introduction 2. What are Venepuncture and Cannulation 3. Anatomy and Physiology of the Circulatory System 4. Legal Aspects of Venepuncture (Phlebotomy) and Cannulation 5. Practitioner Requirements 6. Professional Competence and Accountability 7. Documentation and Record Keeping 8. Vicarious Liability 9. Consent 10. Influencing Factors during Venepuncture 11. Infection Prevention and Management 12. Haemolysis 13. Selecting Correct Equipment 14. Procedure of Venepuncture and Cannulation 15. Order of Draw 16. Peripheral Cannula and Venepuncture 17. Procedure Prior to Cannulation 18. During Cannulation 19. Cannula Size and Cannulation Aftercare 20. Removal of Cannulation 21. Complications 22. Cannulation Training - Conclusion Recognised Accreditation This course is accredited by Continuing Professional Development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement On successful completion of the cannulation course, you will be eligible to obtain a CPD-accredited certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy.
UNV CCTV Training, covering off the fantastic protfolio of UNV CCTV products, looking at how to configure them, what manufcaturer tools are available and how to connect remotely and via mobile apps to installed systems.