138 Abs courses in Nottingham delivered Live Online

– in yourself and others Research shows that exercising self-compassion creates more resilience against stress, greater ability to focus, increases happiness and optimism, improves relationships and more. This live online course explains why and gives you a range of effective techniques you can use straight away…  -------------------------------------------------------------------------------- * Accredited CPD Certificate: 6 hours * Length: 1 day (9.15am - 4.00pm BST) -------------------------------------------------------------------------------- > Absolutely brilliant live workshop from beginning to end! > > CARMEL AUSTIN Many people struggle with showing themselves compassion – they may be highly critical of themselves, or wracked with feelings of shame, self-doubt or self-worth – but with the right approach it is possible to help them develop this key component of recovery and wellbeing. This new online self-compassion course provides you with all you need to know to bring self-compassion into your practice, your personal life and the lives of others – with plenty of time to try out the techniques for yourself. Join our expert tutor Julie Johnson [https://www.humangivens.com/person/julie-johnson/] live online on Tuesday 4th June 2024 for this helpful CPD training delivered via Zoom. When you book, we’ll email your booking confirmation – your link for joining the Zoom workshop will be sent the day before the event – numbers are limited so book soon to ensure your place. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties, so you’ll also get a recording afterwards for a limited time to maximise your learning. WHY TAKE THIS COURSE Being compassionate towards ourselves when things go wrong, or we are struggling to cope, is not self-pity – it is an essential skill that can be learnt and developed, giving people the strength to move forward. When things don’t go our way or we feel we can’t cope – or something bad has happened to us – we may feel ashamed or blame ourselves for not being good enough, capable enough, strong enough and so on. This negative self-criticism can be highly damaging and hold us back. It is far more empowering to turn towards ourselves with compassion (which is what self-compassion literally means). Helping people to find the best ways to draw out their self-compassion is a skill that needs to be learned. Different from empathy (the ability to appreciate what another person is experiencing) and from self-pity (which is self-focused, exaggerates personal suffering and is disempowering and draining), self-compassion enhances resilience, allowing us to recognise our personal failings while appreciating that we are all human and make mistakes – thus helping us to move on past them. Learning how to use self-compassion from a human givens perspective makes it an extra-valuable tool for supporting our clients in getting their innate needs met and making best use of their innate resources. It may also help you in your own life. This indepth 1-day live online self-compassion experiential training day shows you how. > A wonderful online learning experience, jam-packed full of useful teaching and > loads of references to resources for further self study and development... > > KARSTEN ALVA-JORGENSEN, EXECUTIVE COACH WHAT WILL YOU LEARN * What self-compassion is and isn’t * Research findings that demonstrate the positive effects on the body and mind of exercising self-compassion * Why some people find self-compassion difficult * The roots of self-compassion * A new empowering perspective on making mistakes * How practising self-compassion helps our ability to problem solve * An important adjunctive tool for working with harsh self-criticism, trauma, emotional pain; bereavement, loss, change, and chronic-conditions * Why self-compassion increases resilience * Simple techniques for self-soothing and self-care * How to apply these new understandings in therapy * The especial value of using these techniques with parents and children * How to bring these technique seamlessly into everyday life * Ways that self-compassion helps with meeting emotional needs * The impact of self-compassionate practice on organisations * How self-compassion can help children become happier and kinder * Why compassion for oneself enhances sense of status * Ways that exercising self-compassion lowers emotional arousal and unhelpful thinking * How self-compassion differs from both compassion and empathy * The dangers of too much self-compassion * How self-compassion helps focus the imagination positively * Creative applications of self-compassion * How self-compassion maps onto every human need and innate emotional resource, making it an essential tool in every HG practitioner’s toolbox * Practical examples and case histories to learn from -------------------------------------------------------------------------------- WHO IS THIS COURSE SUITABLE FOR? * Anyone interested for personal or professional reasons * Including anyone working as a practitioner helping those in mental distress or with chronic physical conditions * Anyone interested in skills to help promote their own wellbeing and that of others * Anyone working or living with children, or young and older people * Anyone working with parents * Anyone working within a caring context, such as carers, teachers, NHS workers, foster carers, social workers etc * Therapists, counsellors and mental health professionals -------------------------------------------------------------------------------- COURSE PROGRAMME The ‘Developing Self-Compassion’ live online training day starts at 9.15am and runs until 4.00pm. (BST). * 9.15am Join the Zoom meeting * 9.00am Introduction to self-compassion * 11.00am Comfort break and discussion * 11.30am Unpacking self-compassion * 1.00pm Lunch break * 1.45pm Self-compassion skills * 2.45pm Comfort break and discussion * 3.00pm Pulling it all together * 4.00pm End days -------------------------------------------------------------------------------- This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

LOOKING FOR: ADULT FICTION Louise Buckley has worked in publishing for well over a decade. She was inspired to enter the publishing industry after completing an MA in Creative Writing and then spent a hugely enjoyable year working as a bookseller for Waterstones, wishing that she could have a hand in publishing books. After a year working at Dorling Kindersley, she then spent almost five years working in the commercial fiction division at Pan Macmillan, where she published a mix of commercial bestsellers and award-winning authors. Most recently, she was an Associate Literary Agent at Zeno Agency Ltd. As an agent she represented a roster of commercial and literary fiction, including Anne Griffin’s When All is Said, which spent five weeks at number one in Ireland and sold into 17 territories. She is delighted to be working with Hannah at Hannah Sheppard Literary Agency. Louise is looking for:- Literary and upmarket fiction that focusses on the underdog, the repressed, the suppressed. Louise is especially interested in novels that represent working-class people or children going through difficult circumstances (think Shuggie Bain by Douglas Stuart, My Name is Leon by Kit de Waal or Boys Don’t Cry by FÍona Scarlett). Irish literary and book club fiction. Think Claire Keegan, Louise Kennedy or Anne Griffin. In commercial fiction she loves novels set during the Second World War, such as The Nightingale by Kristin Hannah, The Beekeeper of Aleppo by Christi Lefteri or The Midwife of Auschwitz by Anna Stuart. Louise recently read and loved The Last List of Mabel Beaumont by Laura Pearson and would love to see anything in the same ‘older person going on a journey’ category, a more recent The Unlikely Pilgrimage of Harold Fry. Louise had a lot of fun publishing a ‘pet fiction’ novel as an editor (Molly and the Cat Café) and would love to find an author who can write an Alfie the Doorstep Cat/Dog. She has a soft spot for novels featuring time-travel or parallel universes, a ‘what if’ that plays around with conventions. At the literary end this would be books like Life After Life by Kate Atkinson, The Shining Girls by Lauren Beukes or This is How You Lose the Time War by Amal El-Mohtar and Max Gladstone. At the more commercial end Louise loved Wrong Place, Wrong Time by Gillian McAllister, Dark Matter by Blake Crouch and Oona Out of Order by Martina Montimore. She also enjoys novels set in the real world but featuring a hefty dose of magic or the supernatural. They can be commercial or literary, present-day or historical. Think Rivers of London by Ben Aaronovitch, Threadneedle by Cari Thomas, A Discovery of Witches by Deborah Harkness or The Gifts by Liz Hyder. And also cosy fantasy in the vein of Legends and Lattes or The House in the Cerulean Sea. Cosy or humorous crime. Recently, Louise absolutely loved Over My Dead Body by Maz Evans. When she was an editor Louise published the hit Luckiest Girl Alive by Jessica Knoll and would love to represent incisive, intelligent suspense written by authors such as Jessica Knoll and Gillian Flynn, or something a little more subversive and blackly comic like My Sister, the Serial Killer by Oyinkan Braithwaite. More generally, Louise would also love to see novels with a disabled protagonist or someone (like myself) who is living with an invisible disability. As an ex-primary school teacher, she also warmly welcomes submissions from teachers, especially if the submission falls into one of the other categories she has listed. Following-on from this, she enjoys reading stories that follow a ‘beating the system’ narrative. Louise is NOT looking for: -romance -romantasy -epic, traditional fantasy -space opera -straightforward women’s fiction -children’s fiction of any kind -non-fiction Louise would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Louise is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk [agent121@iaminprint.co.uk] to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Tuesday 28 May 2024

Introduction to Menopause (via Zoom) Course Focus: This comprehensive two-day course serves as an invaluable introduction to menopause care within the primary care setting. Understanding menopause, its effective management, and the ensuing implications for women's well-being are pivotal aspects for healthcare practitioners, particularly practice nurses who frequently engage with women facing menopausal transitions during their consultations. Course Highlights: Understanding Menopause: Dive into the core concepts of menopause, grasping its multifaceted aspects, and gaining a deep understanding of its physical, emotional, and psychological dimensions. Effective Menopause Management: Explore optimal strategies for managing menopause, equipping practitioners to provide well-informed guidance to women traversing this life phase. Short and Long-Term Implications: Delve into the implications of menopause for women's well-being, both in the short and long term, enabling practitioners to offer holistic care that addresses immediate concerns and promotes long-term health. Tailored Approach for Practice Nurses and AHP's: Recognize the pivotal role of practice nurses and AHP's in menopause care, understanding the specific challenges they encounter during consultations with menopausal patients. Competency Framework for Progression: Access a comprehensive competency framework that empowers nurses to work towards mastery in menopause care. This framework can be validated by experienced team members, fostering ongoing skill development. Dynamic Learning Environment: Through interactive sessions, case studies, and discussions, participants will engage in a dynamic learning environment that facilitates the absorption of knowledge and practical insights. The course encourages networking and collaboration, enabling practitioners to learn from both expert facilitators and fellow participants. Learning Outcomes: Upon completion of this two-day course, participants will be equipped to approach menopause care with heightened confidence and competence. Whether they occasionally encounter menopausal patients or engage with them more regularly, practitioners will leave with the tools and strategies to provide informed and supportive care, positively impacting women's well-being during this transitional phase. Target Audience: This course is tailored for a diverse range of primary care practitioners, including practice nurses, cervical sample takers, and those who regularly engage with menopausal patients without specialized training. All practitioners seeking to enhance their expertise in menopause care are welcome to attend. Day One 09.15Coffee and registration 09.30Introduction and course objectives 09.40Physiology and definitions 10.00Menopause symptoms 10.45Coffee 11.00What do we need to ask? 13.00Lunch 14.00Management Strategies: Hormonal and non-hormonal treatment of menopause symptoms 14.30Diet, Lifestyle and Exercise 14.30Complementary therapies 15.00Case Studies  15.30Action plan, evaluation, and resources 15.45Close DAY 2 09.15Coffee and registration 09.30Review of Day 1 and tasks 09.45Women with special needs 10.00Contraceptive options for peri-menopausal women 10.45Coffee 11.00What do we need to ask? 13.00Lunch 14.00Which HRT when and how 14.30The older woman 15.00Case Studies  15.30Action plan, evaluation, and resources 15.45Close

Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - AN INTRODUCTION TO POWER AUTOMATE * What is Microsoft Power Automate? * The benefits of automation * How to get to Power Automate * Lab 1: Setup your tenant * Setup Office 365 * Download Course Files * Customise your App Launcher * Create accounts for colleagues * After completing this module, students will be able to: * Know what Microsoft Power Automate is * The Benefits of using Power Automate to automate processes * How to access a Power Automate 2 - GETTING STARTED WITH POWER AUTOMATE * Using Power Automate templates * Navigating in Power Automate * Editing a Power Automate * Publish and trigger a Power Automate * Turn off or delete a Power Automate * Lab 1: Building processes in Office 365 * Create a Team with a channel * Build an absence business process * Testing the absence process * Optional: Create Feedback Form * Optional: Power Automate to Notify of Bad Ratings * Optional: Test your Form and Power Automate * After completing this module, students will be able to: * How to use Power Automate tempaltes * How to navigate around Power Automate * How to edit Power Automates * How to publish and trigger Power Automates * How to turn off or delete Power Automates 3 - POWER AUTOMATE LOGIC * Adding conditions * Designing switches * Using apply to each * Configuring do until logic * Adding a scope * Lab 1: Scheduling documentation reviews * Setup a policy library in SharePoint * Design a policy review schedule * Testing the policy review process * Optional: Notify if a file nears review * After completing this module, students will be able to: * How to add condtions in a Power Automate * How to design switches for a Power Automate * How to use apply to each * How to configure do until logic * How to add a scope 4 - INTEGRATION * Standard and premium connectors * Connecting to web services * Using Power Automate with on-premises data * Lab 1: Using Power Automate and SQL to Review Sales * Create a new orders list * Designing the price check process * Testing the price check process * Optional: Update with managers * After completing this module, students will be able to: * How to use Standard and Premium connectors * How to connect to web services * How to using Power Automate with on-premises data 5 - THE MOBILE APP * Downloading the mobile app * Signing in and account management * Building and managing Power Automates * Creating buttons * Feeds and approvals * Lab 1: Optional: Using the Power Automate mobile app * Setting up the Power Automate mobile app * Create a new Power Automate in the mobile app * Using Power Automate buttons in the app * Uninstall the Power Automate mobile app * After completing this module, students will be able to: * How to download the mobile app * How to sign into the mobile app * How to build and manage Power Automates in the mobile app * How to create buttons in the mobile app * How to feed and use approvals in the mobile app 6 - ADMINISTRATION AND MAINTENANCE * Maintaining a Power Automate * View history and analytics * Sharing a Power Automate * Export and import Power Automates * Office 365 administration for Power Automate * Environments * Data policies * Data integration * Lab 1: Maintaining your Power Automates * Share a Power Automate with a colleague * Disabling an active Power Automate * Deleting a Power Automate * After completing this module, students will be able to: * How to maintain a Power Automate * How to view history and analytics for a Power Automate * How to share a Power Automate * How to export and import Power Automates * How to administrate a Power Automate in Office 365 * How to use data policies in a Power Automate * How to use data integration in a Power Automate

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. GETTING STARTED WITH EXCEL * Navigate the Excel User Interface * Use Excel Commands * Create and Save a Basic Workbook * Enter and Edit Cell Data * Fill Cells with Series of Data (AutoFill and Flash Fill) * Use Excel Help PERFORMING CALCULATIONS * Create Worksheet Formulas * Insert Functions and use Autocomplete * Reuse Formulas and Functions * Create an Absolute Reference MODIFYING A WORKSHEET * Insert, Delete, and Adjust Cells, Columns, and Rows * Move and Copy Data between Cells * Search for and Replace Data * Use Spellcheck and Proofing FORMATTING A WORKSHEET * Apply Text Formats * Apply Number Formats * Align Cell Contents * Apply and Copy Cell Styles * Apply Basic Conditional Formatting PRINTING WORKBOOKS * Preview and Print a Workbook * Controlling Page Layout * Adding Headers and Footers * Set Print Titles and Print Ranges MANAGING WORKBOOKS * Manage Worksheets * Insert and Delete Worksheets * Manage Workbook and Worksheet Views * Manage Workbook Properties

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is an IT, facilities or data centre operations professional working in and around the data centre and having the responsibility to achieve and improve high-availability and manageability of the data centre. Overview After completion of the course the participant will be able to:? Understand the design life cycle of data centres and the stages involved? Discuss the data centre requirements in great level of detail with vendors, suppliers and contractors to ensure that these requirements are met? Validate design plans, quotes and offers proposed by vendors/contractors? Understand redundancy levels for both the data centre design/setup and maintenance? Understand the various building considerations such as bullet proofing, mitigation of seismic activity, fire ratings and thermal stability? Understand how to install a raised floor that meets requirements, avoiding misalignment, level differences and leakage? Understand how to read a Single Line Electrical Diagram to identify and avoid the most common design issues? Choose the correct UPS and parallel configuration, learn and avoid classic parallel installation mistakes? Understand how to calculate battery banks, validate offered configurations to ensure they meet requirements? Understand what distance to keep to avoid EMF issues for human safety and equipment disturbances? Understand the fundamental cooling setup, CFM, Delta-T and other important factors? Understand contamination factors and limitations? Understand full details of fire suppression options, how to calculate gas content and verify installations? Understand how to measure data centre energy efficiency and how to improve it The course will bring participants to the level of a suitable sparring partner with suppliers. They will be able to verify offers provided by vendors for correctness, effectiveness and efficiency. DATA CENTRE DESIGN/LIFE CYCLE OVERVIEW * Overview of the phases of a data centre life cycle Planning, re-alignment and continuous improvement STANDARDS AND RATING LEVEL DEFINITIONS * Rating level history Difference between Uptime and TIA-942 Rating level definitions Redundancy options (N+1), 2N, 2(N+1) Concurrent Maintainability/Compartmentalisation Example configurations Substation and feed requirements Maintenance options Operational processes guidelines/standards Skill development BUILDING CONSIDERATIONS * Building location considerations Floor and hanging loads requirements Fire rating for walls and glass Blast protection Bullet proofing Forced entry protection ADVANCED RAISED FLOOR & SUSPENDED CEILING * Raised floor installation guidelines Techniques to install a proper and leveled raised access floor Common mistakes Choosing the right tiles and their locations Seismic-mitigating floor constructions Choosing the correct suspended ceiling ADVANCED POWER * Power infrastructure layout; Formulas which you should know for the data centre Single Line Electrical diagrams; how to read to ensure key components are present for protection Over current protection devices (MCB/MCCB/VCB/ACB/Fuses) definitions and what to use where Earth Leakage devices (RCB/RCD/ELCB/GFCI/ALCI/RCBO), definitions and what to use where Sizing of protective components Lightning strikes and surge protection devices (TVSS/SPD), how they operate, where to use and how to install Power cabling and cable run considerations PDU/DB setup and minimum requirements Generators; Generator types: Standy/Prime/Continuous Component make up and functions Fuel storage and calculation Paralleling of gen-sets Generator room/area requirements UPS Systems; Required specifications for UPS systems How to read data sheets and select the correct UPS Requirements for parallel configurations and avoid pitfalls such as single point of failures How parallel installation should be done, classic mistakes made by installers and how to avoid these Harmonic Filters; Active/Passive filters and their application Battery Banks; Battery bank terminology Designing battery banks, how to calculate, and double check the battery bank to be installed Battery charging pitfalls and ensuring the right charger is being installed and used Using parallel battery banks; how to properly install them, limitations and risks when using batteries in parallel How to test batteries correctly and make decisions on cell/block or string replacement Battery casing choices; ABS, V0, V1, V2 Alternative energy storage; flywheel, re-usable cell, compressed air UPS, etc. ADVANCED ELECTRO MAGNETIC FIELDS * Sources of EMF Difference between single, three phase and bus-bar EMF Options available to measure EMF and how to interpret the results from single-axes and composite measurements Guidance on safe distance for equipment and humans Calculation of EMF attenuation factor for shielding material permeability and saturation factors ADVANCED COOLING * Important definitions; dry-bulb, wet-bulb, dew-point, RH, sensible and latent heat Psychometric chart and ASHRAE recommendations Environmental class definitions and thermal specifications Temperature/humidity measurements guideline Heat dissipation methods Altitude impact on temperature intake to ICT equipment Floor plan setup for effective cooling Differences in tile surface and supporting structure and the air-flow performance impact Rack door construction and the flow performance impact Equipment Delta-T and its impact Optimising air flow Thermal units conversions Calculations for air volume displacement (CFM/CMH) Cooling capacity calculations Air-conditioning selection De- / humidifying options Air conditioning efficiency SHR impact on cost saving Efficiency indicator New cooling principle and techniques (Submerged, VSD/VRF/ECF/water- and air side economisers) Redundancy guidelines for air-conditioners avoiding classic misconceptions and mistakes for meeting ANSI/TIA-942 compliant designs Installation requirements Connections to fire panel and EPO Commissioning of air conditioners Set points and calibration CFD (Computational Fluid Dynamics) ADVANCED FIRE PROTECTION * The fire triangle and elements to stop a fire Detection systems in detail (VESDA, VIEW, smoke sensors) Considerations for installation of sensors Proper testing of smoke sensors Water based systems i.e. deluge, wet-pipe, dry-pipe, pre-action and why most of them don't work and how to detect this Details on Inert and Halocarbon systems and how to select the correct system for your data centre How to calculate the gas content ensuring the appropriate level is installed to suppress the fire including safety considerations Other requirements for gas systems such as release times, hold times, pipe install requirements and other important factors Requirements for the fire detection panel Installation verification, methods, what to check and how New advanced fire suppression technologies DESIGN AND INSTALL SCALABLE NETWORKING CABLING SYSTEM * ANSI/TIA942 cabling structure topology ToR, EoR Design Intelligent patching systems Installation best practice such as routing, bending radius, separation from power, containment fill ratio, fiber link loss calculator, bonding and grounding requirement Standard for telecommunications labeling and administration ENVIRONMENTAL SPECIFICATIONS AND CONTAMINATION CONTROL * Acoustic noise effects, regulations, specifications and limits Data centre contaminations and classifications Measurements, standards and limits Preventive measures and avoidance DATA CENTRE EFFICIENCY * Business drivers to go Green High-availability or Green? Green guidelines and standards How to measure it and what are acceptable numbers compared to the general industry PUE classes defined by Green Grid and issues with PUE Techniques for saving energy in all parts of the data centre i.e. application/system level, cooling, power distribution MOCK EXAM EXAM: CERTIFIED DATA CENTRE SPECIALIST

Platelet-rich Plasma (PRP) treatments Nationally Recognised Qualification No previous experience or qualifications needed Open College Network Accreditation Level 4 (as required for minimally invasive procedures) Covers standards set by HEE Employed (salon) or Self-Employed opportunities Basic understanding of English language required OPEN TO ALL APPLICANTS

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. USING VBA TO SOLVE BUSINESS PROBLEMS * Use Macros to Automate Tasks in Excel * Identify Components of Macro-Enabled Workbooks * Configure the Excel VBA Environment 2. RECORDING A MACRO * Use the Macro Recorder to Create a VBA Macro * Record a Macro with Relative Addressing * Delete Macros and Modules * Identify Strategies for Using the Macro Recorder 3. WRITING VBA CODE DIRECTLY * Write VBA Code * Discover Objects You Can Use * Create a Custom Function 4. SOLVING PROBLEMS THROUGH CODE * Make Decisions in Code * Work with Variables * Perform Repetitive Tasks 5. IMPROVING YOUR VBA CODE * Debug VBA Errors * Deal with Errors * Improve Macro Performance 6. CONTROLLING HOW AND WHEN MACROS RUN * Prompt the User for Information * Configure Macros to Run Automatically ADDITIONAL COURSE DETAILS: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

-------------------------------------------------------------------------------- Thanks for expressing interest in the course. Please note this is a provisional booking and confirmation of your place is subject to completion and approval of eligibility forms which will be sent to you via email shortly   Promoting and supporting employee health and wellbeing is at the heart of our purpose! Championing better workplaces and working lives because an effective workplace health and wellbeing programme can deliver mutual benefits to people, organisations and communities.    Healthy workplaces help people to flourish and reach their potential. This means creating an environment that actively promotes a state of contentment, benefiting both employees and the organisations.   Our Level 2 NCFE Introduction to the Workplace Health Champion allows you to gain an understanding of the concept of workplace health and the role to support. Gain an deeper understanding of the leading factors affecting physical and mental health, key behaviours, the need to safeguard adults as a workplace health champion and an understanding of how to plan initiatives in the workplace. If you and your Organisation recognise that investing in employee workplace health can lead to increased resilience, better employee engagement, reduced sickness absence and higher performance and productivity then this is the course for you!   For more information regarding this course, please contact champions@activelancashire.org.uk [champions@activelancashire.org.uk]  -------------------------------------------------------------------------------- Please note both sessions must be completed in order to gain the qualification

Course Introduction Covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms. Please note: this course is for health care professionals  or those working in Primary Care. It is not open to Beauticians unless you are a registered healthcare professional. If in doubt- please email annie at training@anniebarr.com [training@anniebarr.com] or phone +44 7500048222 ABOUT THIS EVENT COURSE INTRODUCTION This course concentrates on B12 deficiency, symptoms, treatments and management. The course covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms of  pernicious anaemia.  This course is interactive and we include case studies and discuss issues regarding diagnostic testing.  We review inclusion and exclusion criteria and identification of appropriate clients. Delegates will get the opportunity to review practice with hands on practical demonstrations of how to give injections correctly. We will cover administration techniques, where to give the injections and record keeping / documentation. We will discuss role and responsibilities and contraindications and precautions. The delegates will leave this course with an example of an individual protocol of Patient Specific Direction (PSD) and a competence based framework document to be used in practice. This course is  very interactive. AIMS AND OBJECTIVES * Understand the need for accountability and responsibility in relation to role development * Demonstrate an understanding of safe practice * Describe the signs and symptoms of pernicious anaemia * Describe pernicious anaemia and its impact on patients * Fully understand the principles, and practice B12 deficiency and B12 injections * Understand the importance of safety issues related to giving injections * Understand the law relating to role and function of the HCA and prescribing. * Describe why patients require B12 injections * Be able to correctly identify anatomical sites for injections * Demonstrate correct administration techniques * Demonstrate how to correctly dispose of waste * Demonstrate correct infection control procedures and use of PPE * Describe when patients require referral and understand the importance of referral using correct clinical pathways * Demonstrate an understanding of anaphylaxis and emergency procedures * Understand the need for correct prescribing procedures * Be able to document consultations following your organisations procedures     COURSE CONTENTS * Role and responsibilities * Accountability guidelines and requirements * Pernicious anaemia  * Blood- function * B12  Deficiency * Risk factors/groups * Causes of B12 deficiency * Diagnosis and reference ranges, testing * Protocols and guidelines * Factors affecting B12 diagnosis and treatment * Factors affecting absorption * B12 injections and common side effects * Could it be B12 Deficiency * Supplements * Side effects and management including ADR’s * Contraindications and Precautions * Correct Administration and techniques including practical session * Injection sites * Legal Issues including consent * Prescribing and Patient Specific Directions * What to record * Storage * Disposal of injections/waste * Infection control * Needle stick injuries * Competence and supervised practice * Policies and procedures * Facts and Figures * Setting up and running a clinic * Insurance/indemnity * Research/evidence base and resources Please note Anaphylaxis is not covered on this course, however we do run a separate Anaphylaxis 1hr training course, which takes place at the end of this B12 webinar. If you wish to do the 1 hr Anaphylaxis also, you should book onto BOTH courses. * WHO SHOULD ATTEND? * HCAs * Nurses * Doctors * Pharmacists * Anyone interested in Vitamin B12 deficiency and pernicious anaemia and those working with clients with B12 deficiency AB Health Group awards CPD points / certificate of attendance for each course.  If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this.  The charge for the certificate including postage is £30.