We are proud as a training organisation to be able to deliver this course in small groups. We only allow a maximum of 5 learners to attend this course as this ensures learners receive the support they require and plenty of hands on opportunity to learn this healthcare skill. This training course is delivered by Healthcare Professionals with many years of on-the-job experience and who can guide you through the theoretical and practical elements of this essential healthcare skill, and answer any questions that may arise during your training.
Advanced HP switches training course description A hands on course covering advanced features of HP switches. The focus of the course is on Layer 3 switching advanced features. Delegates will benefit the most from this course if they can supply us with their own configurations before the course. These configurations can then be used by the trainer in the course. What will you learn Configure and troubleshoot HP layer 3 switching. Configure and troubleshoot OSPF Harden HP switches. Explain the majority of their own configurations (if configurations are supplied to us before the course). Advanced HP switches training course details Who will benefit: Technical staff working with HP switches. Prerequisites: HP switches for engineers. Duration 2 days Advanced HP switches training course content Introduction VLAN review. Tagged and untagged ports. MSTP, PVST, UDLD, BPDU guard. Hands on VLANs, diagnostic tools debug, LLDP, remote port mirroring. L3 switching What are L3 switches? L3 lite, IPv4 and IPv6, routing protocols, routing tables. IP address on VLAN, no ip address on VLAN, connected interfaces, RIP. Hands on Routing between VLANs. Configuring and troubleshooting RIP. VRRP Default gateways, dead router detection, resilience. Hands on Configuring and troubleshooting VRRP. Static routes Why use static routes? Configuring static routes, default routes. OSPF Link state protocols, operation. Router types, LSA types, area 0. Hands on Configuring and troubleshooting OSPF. QoS Layer 2 QoS, 802.1Q, priorities, dscp mapping, rate limiting. Access lists Filtering traffic through the switch, controlling access to the switch, enabling and disabling ACLs, standard ACLs, extended ACLs Security DHCP snooping, ARP protection, STP guards, switch hardening. Summary Walkthrough of delegate configurations.
About this Virtual Instructor Led Training (VILT) Asia Pacific is set to be the largest and fastest growing Hydrogen market globally. This growth is driven by decarbonisation of energy-use, ammonia production and rising demand of fuel cell electric vehicles. Hydrogen as a fuel has outstanding energy carrying capacity and many application possibilities ranging from Petroleum refinery, Ammonia and Methanol production, Transportation and Power generation. Although the current petrochemical market segment will remain strongest in the near future, it is the transport and power sector which spurs the vision of a massive market takeoff in the next decade. The ever-rising share of renewable energies require flexible and scalable storage solutions, which in turn offers many additional revenue streams beyond pure electricity sales. Adding to this the strong impetus towards decarbonization of the transport sector from cars, trucks, trains to ships and even airplanes creates the breed for an exciting and yet untapped market potential. This course aims to clarify and assess the hydrogen business case along its value chain and versatile market applications. Training Objectives Understanding current hydrogen market status and recent developments Major drivers and inhibitors influencing the growth of the market Understanding and comparing various production technology processes Challenges and solutions in transport, distribution and storage of hydrogen Mapping the many petrochemical, energy and transport applications Analyse business cases from around the world and understand their economics Target Audience Project developers Equipment Manufacturers Oil, Gas and Petrochemical sector companies IPPs and utilities Transport sector companies and port operators Policy makers and regulators Investors and lenders Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Your expert course leader is an internationally renowned energy communicator and business educator, focused on the interconnected clean energy transition topics of renewable power, energy storage, energy system electrification and hydrogen. His own independent technology tracking, market assessment and opportunity/risk analysis is delivered to clients through a mix of business advisory work, commissioned content, small-group training (online & in-person), and one-to-one executive coaching (online). In the hydrogen sector, he is currently lead consultant and trainer to the World Hydrogen Leaders network, and writer of their 'This Week in Hydrogen' news column. He is also co-presenter of the 'New Energy Chinwag' podcast, which regularly covers hydrogen-related issues. During more than 15 years as an independent energy expert, he has helped companies from large multinationals to innovative start-ups - totalling assignments in over 30 countries across 5 continents. Most recently, he has presented clean energy training in locations as diverse as Singapore, the UK, South Africa, The Philippines, the USA, Mexico, Spain and Dubai - and, in recent times of course, online to international audiences from across the world. Prior to this, he was Research Director for over 10 years at Informa, a $9 billion business intelligence provider; where he drove new market identification, analysis and project deployment work, and managed teams in the UK and US. He has a strong science background, holding a 1st Class Honours degree in Natural Sciences from the University of Cambridge, a PhD in Earth Sciences and a further Diploma in Economics & Sustainability from the UK's Open University. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations
Work in Dentistry and provide sedation for your patients? This one day face to face course gives 7 hour vCPD and will refresh you on techniques and scenarios. Includes Practical training with blood pressure, pulse oximetry, cannulation and monitoring, along with emergency scenarios. THIS ONE DAY FACE TO FACE COURSE IS DESIGNED FOR DENTISTS AND NURSES ALREADY IN THE FIELD OF DENTAL SEDATION, WITH UPDATES ON REGULATIONS ALONG WITH PRACTICAL STATIONS ON CANNULATION, PROBLEM SOLVING, ASSESSMENTS AND MONITORING. PART OF THE DAY WILL INVOLVE SOME AIRWAY MANAGEMENT TRAINING AS WELL. Course Includes 24 Lessons 14 Quizzes Course Certificate About Instructor Rob Endicott Roy Bennett Dr Roy Bennett is the director of Mellow Dental Training, IACSD accredited trainer and mentor and former director of Portmans Dental Care. Dr Rob Endicott is an IACSD accredited trainer and mentor and is the ViceChair of the ADAS (Association of Dental Anaesthetists and Sedationists)
Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills
Give a compliment to your career and take it to the next level. This Coaching & Mentoring bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Coaching & Mentoring skills for your next job or elevate your skills for your next promotion, this Coaching & Mentoring bundle will help you stay ahead of the pack. Along with this Coaching & Mentoring course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Coaching & Mentoring Bundle Consists of the following Premium courses: Course 01: Coaching & Mentoring Course 02: Life Coaching | Online Course Course 03: Train the Trainer Course 04: Teach Anybody Anything Course 05: Training Techniques for Beginners Course 06: Personal Leadership and Influencing Skills Course 07: Motivation Skills Course 08: Resilience Masterclass Course 09: Leadership and Management Training Course Course 10: Counselling for Child and Adolescents Course 11: Effective Communication Skills Course 12: Positive Psychology Masterclass Course 13: Train the Trainer - Part 1 Course 14: Train the Trainer - Part 2 Course 15: Virtual Training Masterclass Course 16: Train the Trainer Recharge: The Healthy Trainer Course 17: Bereavement Counselling Course 18: Self Esteem and Assertiveness Development - Level 4 Course 19: Problem Solving and Decision Making Course 20: Time Management Enrol now in Coaching & Mentoring to advance your career, and use the premium study materials from Apex Learning. Coaching & Mentoring The Coaching & Mentoring bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Coaching & Mentoring expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Coaching & Mentoring from any place in your own time without travelling for classes. Coaching & Mentoring Course Curriculum: Life Coaching and Personal Development Module 01: Introduction to Coaching and Mentoring Module 02: Coaching and Mentoring: Objectives & Processes Module 03: Ethical Aspects of Coaching and Mentoring Module 04: Coaching and Mentoring Models Module 05: Effective Communication Skills Module 06: Personal Skills Module 07: Management Skills Module 08: Functional Skills Certificate: PDF Certificate: Free (Previously it was £6*20 = £120) Hard Copy Certificate: Free (For The Teaching Assistant: Previously it was £10) CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Coaching & Mentoring Anyone from any background can enrol in this Coaching & Mentoring bundle. Requirements Coaching & Mentoring This Coaching & Mentoring course has been designed to be fully compatible with tablets and smartphones. Career path Coaching & Mentoring Having Coaching & Mentoring expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course Teaching Assistant absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Trauma Informed Practice in Education is a research evidence based whole school systems approach that starts with you. Improved attendance, improved learning outcomes, reduced suspensions and exclusions and better staff recruitment, retention and wellbeing all begin from a place of understanding child development, the impact of adversity on child development and the role of us as educators in supporting opportunities for growth and resilience. Systems change takes teamwork, however the most important member of that team is you. On this Trauma Informed Practice Day you will learn the why and how to keep you well and resourced in order to support the emotional and academic progress of the children in your school. You may already have some knowledge or you may be coming as a complete novice. Either and anything in between is fine. Numbers are limited to keep the group small for the benefit of more enriched learning. On this practice day you will; • Take a deep learning dive into the nervous system and how this applies to you, your setting and the progress of your learners. • Learn practical skills and strategies to support yourself and others. • Have opportunities to discuss children you are working with through small group supervision sessions • Benefit from a day of immersion into the topic with two highly qualified and experienced practitioners.
Functional fitness exercises are designed to train the muscle to work together, and tend to use multiple joints and muscles to maximise your fitness levels. In this course, you will learn the basic principles of functional fitness, to fine tune your fitness regime. You will learn about the benefits of functional fitness and how it trains the muscles to work together. It also covers essential information on common mistakes to avoid when performing functional fitness exercises. This course will train you how to improve your balance, endurance and range of motion, developing your flexibility, with step-by-step video guidance. Whether you are looking to take your fitness routine to the next level, or kickstart a career in the fitness industry, this course introduces techniques that will help you get in shape in no time, from the comfort of your own home. Learning Outcomes: Learn about the benefits of functional fitness, and how it trains the muscles to work together Understand the common mistakes to avoid when performing functional fitness exercises Improve your balance and range of motion, with our step-by-step training Take your endurance to the next level and increase your flexibility Achieve your weight loss goals from the comfort of your own home Gain the practical skills and knowledge to kickstart a career in the fitness industry Enhance your fitness routine and strengthen your core muscles in no time Reduce the risk of injury and improve your quality of life Career Path On successful completion of this course, learners will be able to incorporate functional exercises into their everyday fitness routine, with the opportunity to earn valuable information of the following careers: Fitness Instructor Personal Trainer Fitness Coach Section 01: First Concepts & Benefits Introduction 00:01:00 What is Functional Fitness? 00:08:00 Benefits of Functional Fitness 00:08:00 Section 02: Understanding & Beating Anxiety Functional Fitness and Others Exercises 00:08:00 Common Mistakes with Functional Fitness 00:07:00 Functional Fitness and Power 00:08:00 Section 03: Strength, ROM, Balance & Endurance Functional Fitness and Strength 00:07:00 Functional Fitness And Range of Motion 00:06:00 Functional Fitness and Balance and Endurance 00:07:00 Section 04: Final Thoughts & Tips Conclusion 00:01:00