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
Data Visualization Courses London. In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational visualizations This course is ideal for managers and data analysts who need to make business decisions based on data.
ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card.
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: 2nd August, 2024 Date: 25th August, 2024 Date: 29th September, 2024 Date: 29th October, 2024 Date: 29th November, 2024 Time: 10:00 am – 05:00 pm Venue Location Birmingham: 44 Blucher Street, Birmingham, B1 1QJ Date: 21st August, 2024 Date: 24th October, 2024 Date: 12th December, 2024 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.
Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises
Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.
Android Studio Taster Course. Brilliant for a beginner to get started quickly. introduction to the Android Studio environment, to get you started. An interesting and fun session. Hands-on, Practical Course, Instructor-led. 1 hour In our London classroom or online with Gotomeeting.com
Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.