City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..
This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.
Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.
The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence. Course Schedule: The 8 x 2-hour online sessions on - What the course covers Wine tasting: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT) Food and wine pairing: You will learn the principles of food and wine pairing Wine service and storage: You will learn the correct way to store and serve wine and how to recognise common faults found in wine Labelling: You will learn how to decode and understand wine labels Factors influencing the style of wine: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world Grape varieties: You'll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI's) around the world Sparkling and Fortified wines: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories. No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document HERE for full details of the content, structure and assesment criteria. Any questions please get in touch. Course delivery The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators This course includes 16 hours online tuition in 8 x 2hr sessions and we recommend a minimum of 12 hours additional study Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below) You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills. Examination To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam. The exam is taken online via a Remote Invigilation service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information HERE if you wish to take the exam online. Whats included All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor Exclusive access to practice multiple choice questions provided FREE OF CHARGE WSET exam fee Remote Invigilation service Internationally recognised WSET qualification, certificate and pin for those who pass the exam VAT at 20% (VAT receipt can be provided on request) Course Wines It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx £150 including VAT and delivery. Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. Special Educational Needs Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.
Course Information This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks. Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings. Is this course for you? Ideal for professionals engaged in GMP across various sectors, including: Research and Development (R&D) Contract Manufacturing Organisations Manufacturing Units Quality Control (QC) Laboratories Auditing Roles. What will you learn? Event objectives - by the end of the course, delegates shall: Have an awareness of the basic requirements of GMP Be aware of UK and EU GMP Rules and Guidance and relevant publications Understand the roles and responsibilities associated with GMP Be able to contribute to and maintain quality documentation Have a basic understanding of product lifecycle and manufacturing Understand the requirements of GMP in the QC laboratory context Have a basic understanding of risk management and mitigation principles Understand the need for quality systems and quality assurance activities Be aware of common regulatory findings. Learning outcomes: delegates will be able to: Implement their role within GMP with confidence and knowledge of the principle requirements Contribute effectively to the GMP quality system and their organisation’s compliance Comprehend where their organisation’s activities sit within the larger GMP arena Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet. Tutors Tutors will be comprised of (click the photos for biographies): Louise Handy Director, Handy Consulting Ltd Programme Please note timings may be subject to alteration. Day 1 09:30 Introductions and Scope of the Course Understand the group requirements and the tutor's background and experience. 09:45 Background and Regulatory Environment Setting the scene, understanding the context, key legislation. 10:30 Principles of GMP Key points and requirements. 11:15 Break 11:30 Personnel and Responsibilities Management and staff, duties and accountabilities. 12:00 Overview of GMP Manufacturing Basics of the product life cycle. 12:30 Lunch 13:15 Risk Management Workshop Practical exploration of risk and mitigation activities. 14:30 QC Laboratories Activities and practicalities. 15:15 Break 15:30 Compliance Quality Assurance and Self Inspection. 16:15 Question Time A chance for questions on the practicalities of GMP. 16:30 Close of Course Extra Information Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 7 Points Development Level Learn
Venepuncture and cannulation course Venepuncture training for healthcare professionals Cannulation skills development Intravenous access techniques Blood sample collection training Infection control in venepuncture Hands-on venepuncture practice Cannula insertion training Nursing revalidation hours CPD accredited course Healthcare professional skills development Venepuncture and cannulation procedures Venepuncture certification program Intravenous catheter insertion Best practices in venepuncture Patient assessment for venepuncture Troubleshooting venepuncture complications Venepuncture and cannulation simulation Real-life venepuncture scenarios Healthcare career advancement with venepuncture skills
Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments