• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

824 Cells courses

Wellbeing Singing Retreat in Brecon May 10th - 12th 2024

5.0(17)

By Breath Voice Body Song

Singing retreat, meditation, body work, sound bath, vegan feast, community, singing, choir, walking, breathing, wellness, retreat.

Wellbeing Singing Retreat in Brecon May 10th - 12th 2024
Delivered In-Person in BreconTwo days, May 10th, 15:00
£225

INSTANTLY GET THAT 'DREAM JOB' WORKING IN SPA, SALON OR CRUISE SHIP AND CHARGING UP TO £50.00 PER TREATMENT. THIS IS THE PERFECT COURSE FOR STUDENTS STARTING OUT IN 'BEAUTY THERAPY'. YOU CAN CHOOSE TO LEARN FOR 33 EVENINGS OR THE 'FAST TRACK' OF ONLY 5 DAYS PLUS COURSEWORK, CASE STUDIES AND HOMEWORK. -------------------------------------------------------------------------------- This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. PROFESSIONAL SKINCARE & FACIALS This unit will allow a student to give a professional facial using a leading brand. It will prepare them for work in a salon/spa, allow them to identify different skin types and textures and provide a facial which is tailor-made to each client. COURSE OBJECTIVES To prepare students for certification in Professional Skincare & Facials, by covering the following: * How to identify areas of improvement and apply the correct products * Related anatomy and physiology * Contraindications * Health, safety and hygiene * Consultation and record keeping * Treatment planning * Product knowledge * Correct cleansing * Spritz toning * Controlled exfoliation * Steam & extraction * Different types of face mask * Correct moisturisation * Use of sun screen * Mineral make up MANICURES & PEDICURES This unit will allow the student to perform a professional manicure and pedicure on a paying customer. It will prepare them for work in a salon/spa and allow them to identify potential nail conditions, to file and paint correctly and to apply luxury applications such as paraffin wax. COURSE OBJECTIVES To prepare students for certification in Manicures & Pedicures, by covering: * Removal of nail polish * Cuticle work * Correct nail filing * Nourishing and conditioning the nails and hands * How to apply nail polish * Arm and hand massage * Correct washing and cleansing of the feet * Exfoliation and removal of dead skin cells * Correct nail filing * Nourishing and conditioning the feet and toe nails * Cuticle work * How to apply nail polish * Leg and foot massage * Health & Safety * Related anatomy & physiology (The hands and nails) * Contra-indications * After-care * Extras not offered in other schools: * Heated paraffin wax * Hand and foot masks * Deep exfoliation * Heated hand mitts and booties * Hot oil treatment WAXING This unit will prepare the student to provide a professional waxing service using warm and hot wax to specific areas of the body. They will learn about hair growth cycles, correct application of wax and removal. WHAT TO EXPECT FROM THIS COURSE This is an exciting and intensive course which will teach students how to perform strip waxing. Areas covered will include: * Arms * Legs * Back * Eyebrows * Lip * Chin and face An extra unit is now covered with hot wax application for the more safe removal of hair to the following area: * Bikini EYELASH AND BROW TINTING This unit will teach a student how to correctly identify the correct colour for tinting of eyebrow and eyelash and will allow them to improve the appearance of clients who may have pale or uneven hair growth. * Client consultation * Contra-indications and Contra-actions * Related Anatomy & Physiology * Patch Testing prior to treatment * Health & Safety pre-requisites * Tinting Eyelashes & Eyebrows * Identifying the correct Colour for All Types of Skin Tone and Hair Colour * Aftercare advice COSMETIC MAKE UP This unit will guide the student on how to perform a correct make-up application. They will be able to perform the correct application for day, evening and occasional. * Client consultation * Contra-indications and Contra-actions * Related Anatomy & Physiology and Health and Safety * Facial Examination and skin analysis * Cleansing and preparing the Skin * Skin Anatomy and facts * Correct choice of Make Up Products * Correction Techniques * Day, Evening & Special Occasion Make Up * How to identify Diiferent Face, eye and lip Shapes, Skin Types and skin tone * Aftercare advice MINERAL MAKE UP Our school works with the accredited mineral make-up Bella Pierre. Know for camouflage and health purposes, mineral make-up is one of the only make-ups that can be applied after a facial treatment. HEALTH & SAFETY, CLIENT CARE Health and safety in salon and spa is an essential criteria which is necessary to ensure the safety of the student and the client. * How to avoid cross-contamination * First Aid * Coshh * Riddor * Hygiene in the workplace RELATED ANATOMY & PHYSIOLOGY The study and certification of Anatomy and Physiology is a pre-requisite required in order to legally carry out treatments as a working therapist. It allows a therapist to recognise how their treatment can effect and improve bodily functions. The course will cover the following: * Cells and Tissues * The Skeletal System * The Integumentary System * The Blood Lymph Systems * The Muscular System * Neurology * The Digestive and Excretory Systems * The Respiratory and Olfactory Systems * The Endocrine and Reproductive Systems * Arthrology * Health and Safety Issues * Salon Management * Hygiene in the Workplace CERTIFICATION Upon completing all units, assessments and criteria and receiving 85% achievement, an NVQ Level 2 Certificate will be issued PRE-REQUISITES This course is for a complete beginner and offers a full introduction into the beauty industry WHAT YOU NEED TO BRING What you need to bring along to the course. Towels, creams, oils, lunch! WHAT WE PROVIDE We provide - massage couches, safe and enjoyable place to learn. PURCHASING A KIT FOR THIS COURSE We provide a fully operational kit for our students. Please enquire as to costs. DURATION 1 day a week on Friday for 8 weeks, 9.30am – 4.30pm Evening course option: 1 evening per week 6pm – 9pm for 13 weeks -- OR -- Optional training tailor-made to suit your needs and requirements These courses are on going so you can join at any stage and integrate into existing classes. FAST TRACK AVAILABILITY ONE PLACE LEFT FOR: Sat 5th April to Tue 8th April and Tue 15th and Wed 16th April FURTHER FAST TRACK DATES AVAILABLE ON REQUEST. WE OFFER ONE TO ONE TRAINING TOO! (Subject to availability and a price supplement). Remember, we are different, there is NO other Academy like us. We set our dates around you. OUR MISSION STATEMENT: Here at The Angel Academy of Teaching and Training, we go that step further to help our students. We offer the opportunity for a student to attend a course as many times as they would like until they feel truly confident and they only ever have to pay ONCE! We also offer assistance and guidance throughout their course and unlike other Schools will assist student's in completion of their log book, assessments and portfolio. Don't Miss Out- BOOK NOW! DATES AND COSTS Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! CourseDaysDatesCostNVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **8OPENOPEN£1599 NVQ Level 2 In Beauty Therapy ** FAST TRACK **814/10/202321/10/2023£1680 NVQ Level 2 In Beauty Therapy 'FAST TRACK'87/11/202314/11/2023£1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **812/12/202319/12/2023£1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **820/01/202428/01/2024£1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **816/02/202423/02/2024£1680 NVQ Level 2 in Beauty Therapy ** FAST TRACK WEEKENDS OPTIONAL83/03/202410/03/2024£1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **814/04/202421/04/2024£1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION **111/05/202417/05/2024£1680 

Beauty NVQ Level 2
Delivered In-Person in LoughtonFull day, May 11th, 08:30 + 7 more
£1680

ABT Accredited Reflexology

By The Angel Academy Of Teaching & Training

Course Introduction for VTCT upgrade The VTCT qualification is recognised around the world and will allow you to be employed in a clinic, salon or allow you to set up your own business. The Federation of Holistic Therapists and the Association of Reflexology, two of the biggest Holistic Therapy organisations which both accept members with this qualification. Description Reflexology uses many techniques to manipulate reflex zones found in the feet, of which correspond to a specific body part. The zones have been mapped and this enables the Reflexologist to treat the whole body via these reflex zones on the feet. The treatment is primarily used for the stimulation of all bodily systems and aiding relaxation. Reflexology is performed frequently within the Health Service personnel and has a role in comforting and supporting terminally ill patients. This 5 day VTCT Course leads to practitioner status, focusing on providing you with knowledge of the principles of reflexology, competence in dealing with clients, correct use of consultation techniques and good use of planning treatments. You will also learn the benefits and techniques of reflexology and how to target certain key areas such as: Pregnancy or Hand Massage. Duration 5 days, 10.00am – 5.30pm. Practical elements are covered over 5 days attendance at our Academy. Theory elements are covered by homestudy. Qualification Structure T/501/9101 - Knowledge of Anatomy, Physiology and Pathology for Complementary Therapies F/501/9117 - Provide Reflexology A/501/9116 - Reflective Practice for Reflexology Y/501/9253 - Principles and Practice of Complementary Therapies K/501/9256 - Health, Safety and Hygiene for Complementary Therapies H/501/9255 - Business Practice for Complementary Therapies D/501/9111 - Knowledge of Less Common Pathology for Complementary Therapies Course Contents Health, safety, hygiene and security with regard to the complementary therapy industry. Principles and practice of the complementary therapy industry. Knowledge and understanding of anatomy, physiology and common pathology of the human body. How to prepare for and provide an effective reflexology treatment and adapt to client requirements. Contra-indications and contra-actions, advice to be given to the client, record-keeping, evaluation of treatments and reflection on professional practice. Recognising Body Language Stress and Illness Analysis of Posture Legal Aspects, Code of Conduct and Ethics Advanced Techniques including the use of Meridian lines and Chakra's Home Study You can register your place and receive your lifetime membership. You can then make a start on some of the theory work sent to you by us here at the Academy. This includes your Anatomy and Physiology assignments that you can work on in the privacy of your own home. This allows you to have more time to focus on the practical when the class meets together. Approx. 5-10 hours per week need to total your home study time spent. The home work will need to meet the quality of National Standards. You will also be expected to complete 100 reflexology treatments from the start to the end of the course. You will also need to complete some assignments that will be required for your portfolio and a work-book will need to be completed. There are also 2 small exams that will be taken at the Academy in order to assess your understanding of Health and Safety and Anatomy and Physiology. These are multiple choice assessments and are nothing to worry about! Included in the Course Comprehensive course materials, handouts and work-book Online Resources: Virtual Learning Environment packed with extensive support materials, resources, help and advice Post-training support by phone, instant messaging or email (if desired) Assessment of practical/written work included (Must be sent Recorded Delivery) VTCT QCF Diploma in Reflexology Lots of fun and knowledge from Tutors with a whole wealth of skills and experience Light refreshments including tea, herbal tea, coffee and water Cost Training - £999

ABT Accredited Reflexology
Delivered In-Person in LoughtonTwo days, May 17th, 08:00 + 5 more
£425

From Cells to Ecosystems: Complete Biology Mastery

5.0(2)

By Studyhub UK

In the heart of the UK's current ecological challenges, our course, "From Cells to Ecosystems: Complete Biology Mastery," emerges as a beacon of understanding and action. As the delicate balance of ecosystems faces unprecedented threats, from climate change to habitat loss, this comprehensive programme equips you with the knowledge and skills to comprehend, tackle, and potentially reverse these issues. Explore the intricate web of life, from the microscopic world of cells to the grandeur of entire ecosystems, and become a steward of our planet's biological wealth. This From Cells to Ecosystems: Complete Biology Mastery Bundle Consists of the following Premium courses: * Course 01: Ecology * Course 02: Basic Biology * Course 03: Ecological Restoration: Principles and Practices * Course 04: Exploring the Fascinating World of Entomology (Insect Studies) * Course 05: Evolutionary Developmental Biology (Evo-Devo) * Course 06: Marine Biology Courses Online * Course 07: Zoology * Course 08: Sustainable Agriculture: From Farm to Fork * Course 09: Online Course in Conservation * Course 10: Diploma in Mycology: Fungi Studies * Course 11: Weeds Identification and Control: Maintaining Green Spaces * Course 12: Microbiology Diploma * Course 13: Delving into Plant Pathology: Understanding Crop Health * Course 14: Aquaculture and Fisheries Management Diploma * Course 15: Horticulture Online Course * Course 16: Cell Biology, Glycolysis and Gluconeogenesis Diploma * Course 17: Human Anatomy, Physiology and Medical Terminology Diploma * Course 18: Create Your Own Organic Food Garden * Course 19: Ornithology: In-Depth Study of the Fascinating World of Birds * Course 20: Causes & Spread of Infection 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- * Course 01: Effective Communication Skills Diploma * Course 02: Business Networking Skills * Course 03: Influencing and Negotiation Skills * Course 04: Delegation Skills Training * Course 05: Time Management * Course 06: Leadership Skills Training * Course 07: Decision Making and Critical Thinking Online Course * Course 08: Emotional Intelligence and Social Management Diploma * Course 09: Assertiveness Skills * Course 10: Touch Typing Complete Training Diploma Learning Outcomes: Upon completion of this From Cells to Ecosystems: Complete Biology Mastery bundle, you should be able to: * Analyse and address current ecosystem issues using ecological principles. * Demonstrate a deep understanding of the diverse branches of biology. * Apply principles of ecological restoration for sustainable environmental practices. * Investigate the intricate world of insects, fostering entomological expertise. * Comprehend the role of evolutionary developmental biology in species evolution. * Acquire practical knowledge in marine biology for informed environmental stewardship. Unveil the mysteries of Ecology, delve into the fundamentals of Basic Biology, and champion the restoration of ecosystems with a dedicated focus on principles and practices. Engage in the mesmerising realm of Entomology, unravel the secrets of Evolutionary Developmental Biology, and dive deep into Marine Biology. From Zoology to Sustainable Agriculture, Conservation to Mycology, this course encompasses the breadth and depth of biological sciences. Discover the wonders of ornithology, learn the essentials of microbiology, and cultivate your own organic food garden. With a spotlight on issues like infection spread and sustainable practices, this course equips you to be a catalyst for positive change in the realm of biology. CPD 300 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? * Enthusiasts seeking a profound understanding of the biological world. * Environmental advocates aiming to make a positive impact on ecosystems. * Biology students and graduates desiring a holistic grasp of their field. * Individuals interested in sustainable agriculture and ecological restoration. * Nature lovers keen on exploring the diverse realms of zoology and ornithology. * Anyone passionate about preserving biodiversity and tackling ecological challenges. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. REQUIREMENTS To participate in this From Cells to Ecosystems: Complete Biology course, all you need is - * A smart device * A secure internet connection * And a keen interest in Biology CAREER PATH * Ecologist - •30,000 to •45,000 per year * Conservation Officer - •25,000 to •35,000 per year * Entomologist - •25,000 to •40,000 per year * Marine Biologist - •28,000 to •45,000 per year * Horticulturist - •20,000 to •35,000 per year * Microbiologist - •25,000 to •40,000 per year CERTIFICATES CPD ACCREDITED CERTIFICATE Digital certificate - Included * CPD Accredited e-Certificate - Free * CPD Accredited Hardcopy Certificate - Free * Enrolment Letter - Free * Student ID Card - Free

From Cells to Ecosystems: Complete Biology Mastery
Delivered Online On Demand
£289

VTCT LEVEL 4 CERTIFICATE IN LASER AND INTENSE PULSED LIGHT (IPL)

By The Angel Academy Of Teaching & Training

Intense Pulsed Light or Laser Hair Removal. Hugely popular in the UK, this treatment leads the way in permanent hair removal. Salons around the UK command very good profits from a course of IPL or laser. In the 2000's, women have the opportunity to be hair free and this has led to an increase in the demand for hair free bodies. Certain cultures dictate that women be as hair free as possible and IPL allows for this. There are certain IPL machines in the market that are virtually pain free, making it possible for a woman to have a 'brazilian' or a 'hollywood' treatment. Please enquire if you wish to know more. -------------------------------------------------------------------------------- HOW DOES IPL WORK The treatment involves the application of a focused, broad-spectrumlight (xenon), which is applied to the surface of the skin using a hand-held application head. Selective photo-thermolysis involves the process of the light, which travels across and within the range until it reaches the hair shafts or the root of the hair (the bulb). The bulb is usually where the highest concentration of melanin is located. The melanin is what determines our hair/skin colour and once this melanin has been destroyed there can be no growth. The IPL light is changes into heat. This will literally 'blow up' the root of the hair. If a hair has nowhere to grow with no hair bed, it cannot grow! This intense heat also destroys the papilla. IPL treatments will permanently reduce the total number of body hairs but will not result in a permanent removal of all hair and many factors can trigger re-growth such as hormones, menopause, pregnancy and medication. With an IPL treatment, the hair growth cycle has to be in Anagen (the active stage). The hair growth cycle differs on different areas of the body which is why we need to recommend a course! A- Anagen (active stage) C- Catagen (transitionary stage) T- Telagen (resting phase) As the hair growth cycle process can take between 4-6 weeks, this is why we recommend a client to return for their course every 4 weeks. It has the best track record. IPL & Laser has the best overall results (on large areas), versus any other method, in getting rid of hair for longer periods of time if not permanently. All skin types and hair colours can be identified. IPL (intense pulsed light) it does target pigmentation (this determines hair and skin colour), but an ND Yag Laser is not determined by the Fitzpatrick Scale. WHAT IS THE DIFFERENCE BETWEEN LASER AND IPL Laser and IPL are identified by their wavelength which is usually shown in nanometres (nm). IPL systems are different to a Laser machine as they have a range of emissions. With the AATT Freeze 1 machine the range for hair removal is 640-1200nm (this is a ruby wavelength). For photo-rejuvenation the range is 540-1100nm (this is a green wavelength). The Poly lightbulb emits a range of wavelengths to appear as a flash of white light The Wavelengths are incoherent and travel in all directions with no order between them The High beam spreads out more rapidly than a laser beam The Focus is on a large area which reduces the risk of eye damage compared with coherent sources such as a laser beam. IPL is the abbreviation of Intense Pulsed Light. The machines have been widespread in use since the beginning of the 1990's. The flash lamp is commonly a xenon (huge uses across industry, photographic and medical) WHAT DOES THE COURSE INCLUDE? When choosing a course ensure that it includes both theory and a wide variety of practical content. Every course should include: * Anatomy and Physiology * Types & structure of the hair * Health & Safety Management * Salon Management * Client Care * Laser & IPL Hair Removal Application * Laser and IPL for Photo-rejuvenation * Skin, blood and lymphatic circulation * Reproductive and endocrine system * Theory of Electric Currents * Consultations & Record Cards * Contra-indications & contra-actions * Aftercare advice * Accurate techniques * Legislation, Hygiene and Sterilisation WHAT IS EXPECTED OF THE STUDENT TO COMPLETE A FAST TRACK COURSE? * Full attendance of the lesson dates * A full commitment to work hard * Health & Safety Management * Salon Management * Client Care * Successful Laser & IPL Hair Removal Application * Successful Laser and IPL for Photo-rejuvenation * Completion of a Portfolio * Performing Competent Assessments * Producing a Written Assignment * Home Study and Practice Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! CourseDaysDatesCostVTCT Level 4 IPL & Laser26/04/20247/04/2024£999 VTCT Level 4 IPL & Laser223/05/202424/05/2024£999 VTCT Level 4 IPL & Laser221/06/202422/06/2024£999 VTCT Level 4 IPL & Laser224/07/202425/07/2024£999 

VTCT LEVEL 4 CERTIFICATE IN LASER AND INTENSE PULSED LIGHT (IPL)
Delivered In-Person in LoughtonFull day, May 23rd, 08:00 + 5 more
£999

Sound Bath by Candlelight

By Her Healing

In the modern world we do not take enough time to relax. We are woken up abruptly by our alarms, we leave no time to daydream, and when we feel those natural lulls in the day, mid-morning and mid-afternoon, we power through with chocolate or a coffee. Being in a relaxed state, and specifically a Theta brainwave state, is vital for human beings for a number of reasons. In this state our cells repair, our nervous system restores, we recover from stress and process grief. As our current lifestyles allow us very little time in this state, our cell regeneration can go awry and our stress and grief can go unchecked. This Sound Bath has been designed to encourage you to achieve a deep relaxed Theta state for the majority of the session, the result of which can be incredibly calming and nourishing for your whole system. So bring a Yoga or exercise mat to lie on, a blanket, your cosiest socks and book now as there are limited spots available! Event Schedule 18:45 Doors open Ceremonial Cacao and herbal tea is served  19:00 Sound Bath introduction 19:15 Sound Bath commences 20:00 Sound Bath concludes 20:15 All guests to depart *Please arrive no later than 19:00    Contraindiactions Whilst both Ceremonial Cacao and Sound Therapy are safe on the whole, like many therapeutic treatments and medicines, there are a few contraindications to be aware of. With this in mind please read the below and if booking for more than one person please forward this email on so everyone is aware and in turn looked after.     Ceremonial Cacao Contraindications Between 6.45pm and 7pm there will be optional Ceremonial Cacao served, which can enhance your experience of the Sound Bath. If choosing to drink some of the cacao provided as part of your ticket, please make sure you are well hydrated before coming to the session, as cacao can be dehydrating (a little like tea and coffee). If you are on MAOI based antidepressants, cacao naturally contains tyramine, which is contraindicative of your medication. Cacao is not suitable for anyone with serious heart conditions, low blood pressure, or anyone on blood thinning or blood pressure lowering medication, as it is a vasodilator. It is also not suitable for anyone pregnant or breastfeeding. The cacao served during ceremonies is 20g per serving (based on one cup per person). The recommended daily dosage should not exceed 50g. The cacao will be made with 100% pure cacao, water and coconut milk. If you have any contraindications or allergies there will also be a variety of herbal teas available for your perusal.    Sound Therapy Contraindications The only absolute contraindication for Sound Therapy is if you are in the first trimester of pregnancy. Although there is no evidence that sound therapy would do any harm to an unborn child this is a standard requirement for insurance purposes across most holistic practices.   If you suffer with Epilepsy or seizures please let the host know in advance of the event. It is unlikely the sound frequencies used would trigger a seizure but by letting the host know we can ensure your needs are met. The Sound Bath itself is designed to encourage you into a deep state of relaxation that can produce imagery. With this in mind if you suffer with mental health challenges such as depression or anxiety the Sound Bath could be triggering. If this is a concern please contact the host directly and we are happy to chat this through with you. It is very rare, but occasionally sound frequencies set unsympathetic resonance with metal implants in the body. There is no problem with this, but if you do have metal plates in your body please let the host know upon arrival so we can check in advance if your implant causes any pain or discomfort. If you require lifesaving medication please let the host know upon arrival so we can ensure your needs are met also.    Inclusivity Policy This event is for anyone 16 years+ unfortunately children under 16 are not permitted. This session is warmly open to all, irrespective of gender, age, disability, sexual orientation, ethnicity, culture or religious beliefs. The venue and event is wheelchair-friendly however please inform the host if you require physical support to enter and/or leave the venue.

Sound Bath by Candlelight
Delivered In-Person in Tadworth1 hour 30 minutes, May 21st, 17:45
£15

London Yoga Teacher Training Course

By Catherine Annis Yoga

Intelligent Yoga Teacher Training (IYTT) is unique amongst teacher training courses. We offer an incisive, thoughtful and intelligent approach to yoga teacher training, driven by the most current scientific developments in anatomy and movement research. Delivered by an elite group of senior yoga teachers at the top of their field, IYTT offers a spacious, immersive modular structure which provides time and space for profound learning, integration and growth. Each of the teaching team draws on decades of practical experience of yoga, including particularly the work of Vanda Scaravelli and somatic, embodied practices.

London Yoga Teacher Training Course
Delivered Online & In-Person in London4 days, May 23rd, 08:15 + 2 more
£500 to £1500

Excel - Automating Excel with Macros and Analysis Tools

By Nexus Human

DURATION 1 DAYS 6 CPD HOURS THIS COURSE IS INTENDED FOR TO ENSURE SUCCESS, STUDENTS SHOULD HAVE COMPLETED EXCEL ESSENTIALS AND EXCEL FUNCTIONS INCLUDING PIVOT TABLES AND LOOKUPS OR HAVE THE EQUIVALENT KNOWLEDGE AND EXPERIENCE. OVERVIEW UPON SUCCESSFUL COMPLETION OF THIS COURSE, STUDENTS WILL BE ABLE TO ENHANCE PRODUCTIVITY AND EFFICIENCY BY STREAMLINING WORKFLOW, COLLABORATE WITH OTHERS, AND AUDIT AND ANALYSE DATA. DESCRIPTION THIS COURSE IS DESIGNED FOR STUDENTS DESIRING TO GAIN SKILLS NECESSARY TO CREATE MACROS, COLLABORATE WITH OTHERS, AUDIT AND ANALYSE DATA, INCORPORATE MULTIPLE DATA SOURCES, AND IMPORT DATA. WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS * Working with Named Ranges * Link Cells Across Worksheets and Workbooks * Use 3D References to Calculate Across Worksheets * Consolidate Data USE FORMULA AUDITING AND ERROR CHECKING * Reveal Formulas * Trace Cell Precedents and Dependents * Locate Errors in Formulas * Watch and Evaluate Formulas REVIEWING AND PROTECTING WORKBOOKS * Control Data Entry via Data Validation * Protect Workbook Access * Protect Worksheets and Cell Content * Add and Edit Comments * Prepare a Workbook for Distribution * Modify Excel's Default Settings USING MACROS TO AUTOMATE WORKBOOK FUNCTIONALITY * Create Macros via Recording * Run Macros via Buttons and Shortcuts * Assign Macros to the Quick Access Toolbar and Ribbon * Assign Macros to Objects * View Macro Code FORECASTING AND ANALYSIS DATA * Use Conditional Formatting to Highlight, Sort and Filter Key Data * Advanced Conditional Formatting using Formulas * Create Sparklines to Visualise Data * Add Trendlines to Charts to Visualise and Forecast Trends * Use Data Tables and Scenarios to Project Potential Outcomes * Use Goal Seek to Calculate Outcomes * Forecast Data Trends Using Solver

Excel - Automating Excel with Macros and Analysis Tools
Delivered OnlineTwo days, May 28th, 08:30 + 6 more
£197

Excel - Excel Essentials and Formulas

By Nexus Human

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. DESCRIPTION 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

Excel - Excel Essentials and Formulas
Delivered OnlineTwo days, Jun 11th, 08:30 + 6 more
£197

ABT/NVQ Level 3 Upgrade Electrolysis Course

By The Angel Academy Of Teaching & Training

What Does The Course Include? When choosing a course ensure that it includes both theory and a wide variety of practical content. Every course should include: Anatomy and Physiology Types & structure of the hair Skin, blood and lymphatic circulation Reproductive and endocrine system Theory of Electric Currents Consultations & Record Cards Contra-indications & contra-actions Aftercare advice Choice of needles / probes Accurate probing techniques Legislation, Hygiene and Sterilisation Performing the correct stretch Short-wave Diathermy Galvanic/Blend The Heating Pattern Correct Insertion Techniques The Target Area Unusual Hair Growth FAQ’s Health and Safety Areas Treated This informal and structured weekend will teach all the required techniques necessary to perform successful hair removal treatments. Performed on massage couches, each student will receive guidance on how to effectively perform a full electrolysis treatment on the following areas: Leg Bikini Underarm Nape of Neck Brow Lip Chin Chest The Angel Academy prides itself on always a 100% pass rate for all of its courses since 2003. Classes are kept relatively small so that the tuition can always be of the highest standard. Over the years, all manner of student has come to the Angel Academy from Celebrity to Supermodel to Housewife to Career person looking for a way to relax from the every-day stress and strains that life presents them with.

ABT/NVQ Level 3 Upgrade Electrolysis Course
Delivered In-Person in LoughtonTwo days, May 29th, 08:00 + 7 more
£699

Educators matching "Cells"

Show all 34
Code Red The Empowerment Project

code red the empowerment project

London

The founder, Calvin E J Wilson LLM (LSE), is a Barrister who has a longstanding interest in educating students, young adults, and their parents on the workings of the criminal justice system. The Empowerment Project Qualifications and Studies Barrister at Law, Inns of Court, School of Law, United Kingdom Attorney at Law Supreme Court of Trinidad and Tobago Senior Crown Prosecutor, Crown Prosecution Service, United Kingdom Banker, Bank of Commerce, Trinidad and Tobago Master of Laws (Commercial) London School of Economics Bachelor of Laws University of London The Empowerment Project Experience Post graduate education and training in the law, with valuable experience on the frontline of the Criminal Justice System including almost eight years prosecution experience at the Crown Prosecution Service and the Criminal Courts, and operational experience with advising Teams at New Scotland Yard. Devised and successfully delivered this series of workshops and has conducted mentoring, motivational speaking and awareness raising sessions at Youth Clubs and Community Centres around London. Direct contacts with officers of the Met Police at ranks of Constable, Sergeant, and Inspector. Guidance and mentoring experience with black young adults. The Empowerment Project Skills Strong professional, administrative, managerial, and creative skills. Resolute adherence to good governance, accounting and auditing best practices. Devising and implementing new and improved working arrangements and innovative projects. Unique skill set that is critical to the effective leadership and delivery of the objectives of Code Red Empowerment. Established Consulting firm Calvin Wilson and Associates, which offers strategic and public affairs advice to governments and the private sector globally, on anti-money laundering and combatting the financing of terrorism issues, and on preventing trans-national criminal gangs from preying on young people. Founded The Empowerment Project The Empowerment Project Books Author of the book “Voices from Violence. A Woman’s Journey to Self-Healing” which is presented to audiences in the Readers Theatre format by CODE RED Ensemble, as an advocacy vehicle to empower young girls and women and to sensitise boys and men in order to reduce or eliminate the level of violence globally. Desilu Banton desilu banton I was born in Dulwich Hospital, East Dulwich Grove,SE22 3PT, on 11th December 1961. I began my life in a house at 102 Railton Road, Herne Hill,SE24 OET, on the ‘Front Line’ of ‘Brixton’, London. What I remember most of my childhood is drawing, drawing all the time, every opportunity. My father loved music and loved to dance. We would dance together. My mother designed clothes and was a dressmaker and cake baker. My parents had arrived in England in 1954 from Jamaica and lived in the Brixton area. They lived on Concannon Road from around 1955 and moved to Railton Road in 1959 after they had wed at the church at Santley Street, around the corner of Concannon Road. Today I live by my painting and continue in my mothers’ and fathers’ legacy as a creator. I am open to producing works of art by commission. painting Painting is expression, a way of me talking with everybody else about how I feel, like a bluesman would play his blues. The whole thing is about feeling. Painting is blues. I paint those feelings that are from inside my head, from inside my soul. The spiritual part of all this is the heritage, the thing that comes from my ancestors, the ingredients that everybody talks about when they talk about the past, where we all come from, which is DNA, the genes. What I am doing is recording the memory that comes to me from nature, along with the music that came from West Africa and the Atlantic experience, all of it, and what I do then is give it form, give it some skin, textures and colours, the whole thing is like an umbilical cord that has not lost its life force, it is the whole nine yards. Jackie Burton Jackie Burton Born and raised in West Yorkshire, I took a trip to London in 1983 and have remained here since then. I am a black woman, a Christian and a mother. A retired Social Worker, I have a passion for children, young people and their families. Over the last 40 years I have had roles in church including youth leader and Pathfinder club leader as well as teaching in children’s Sabbath school & children’s church. It was my joy, to find the most creative and interesting ways to engage children and young people with so many varied learning styles. Over the last 12 years of my career I was a Team Leader for a local authority Fostering Service; having responsibility for facilitating training, assessing foster carers and placing children from diverse and challenging backgrounds with those carers. Life-long learning is part of who I am and I started becoming more interested in paper crafts when my now, 25 year old son was around 3 years old. We started to make cards for every occasion and stopped buying them from the shops. Paper crafts opened the door to so many other crafting pursuits and my love for crafting has only grown since then, from wedding decoration, decoupage & canvas art to knitting & simple sewing, I have done many and various and still do. Nothing pleases me more than sharing my love for something with others, and creative crafts is certainly one of those very many things. I have done this via children’s craft workshops; transforming spaces for Vacation Bible School (VBS); school holiday clubs; card making workshops for children and adults. If it includes crafting, I will consider it. Currently I am involved in a weekly Craft Café project where we are using hobby crafts to support people in our community who may be lonely, socially isolated or feeling low. Sr Josephine Udie MP, MSc, GC HDip, NP Reverend Sister, Steer Right Project Coordinator, Power Coach Expert, Health Care Professional Reverend Sister, Steer Right Project Coordinator, Power Coach Expert, Health Care Professional Sister Josephine is passionate about the dignity of the human person. As a trained Power Coach and Health Care professional, Sister enjoys using her skills to coach, support and empower children and families to become who they are meant to be. Steer Right is a charity for which Sister Josephine is Project Coordinator, uses the strap line Little help Big Difference to highlight the effectiveness of what a small amount of intervention can do. Amari Smith-Foster Amari Smith-Foster I am a mental health advocate and a student counsellor. I am extremely passionate about mental health and well-being. After battling with my own mental health, being sectioned at just 13 and becoming part of the system, I am using those same life experiences to help others overcome. My story, my pain and this rollercoaster of a journey has given me great insight to help others and make a change. Me speaking up and using my voice, allows so many others, old, young, male, and female to feel heard, to feel seen. Now I am in a position, I have promised myself , it is pivotal that I make a change for the mental health system. My social profiles: Instagram: https://www.instagram.com/accounts/onetap/?next=%2F LinkedIn: https://www.linkedin.com/in/amari-smith-foster-26a68417b/ Youtube: https://www.youtube.com/channel/UCPMHXb5U40E0Zw1B3h4vcJg Please feel free to contact me should there be any issues. Norman Mine Norman Mine Norman Mine is an Italian-born London based multidisciplinary artist whose practice encompasses visual art, acting and social work. Using autobiographical scenarios as a starting point, Mine's practice expands into fantasy and delusion and in his alter-ego, Dino Desica, an aspiring Italian actor who exists only through a video format, as "performance to camera", becoming an ephemeral simulation of the self. Mine's practice explores the infinite possibilities of the self, the authenticity and the structures of inclusion and exclusion in which it is constructed. For the past three years Mine has run creative workshops co-working with people of different generations, backgrounds, and abilities; developing a specific approach that unsettles the scenario in which participants perform to stimulate creativity and imagination as an opportunity to navigate within. Mine has obtained a Masters Degree in Fine Art at Goldsmith College in 2018. His work has been shown at Performance Istanbul (2021), disORDER Live Collective (2020), Deptford X (2019), The Koppel Project (2019), Platform1 Gallery (2018), Art Night London (2017). He was a recipient of the DYCP grant, Art Council England (2021). In 2022 Mine has founded Norwood JunkAction, an eco-community art project based in Croydon, London. Diana Wilson Diana Wilson Diana Wilson is an Executive and Life Coach professional as well as a Psychodynamic Counsellor, who in parallel, has enjoyed a substantial career in Education and Training and Development across Schools and local Government. Diana is fluidly proficient in a myriad of modalities with a keen focus on Cognitive Behavioural Coaching. She offers leading-edge, inspirational coaching that stimulates thinking, accelerates transformation, and empowers clients to accomplish their aspirational goals. My social handles: Website: www.dwcoach.co.uk LinkedIn: linkedin.com/in/diana-wilson-564a6941 Richmond Trew Richmond Trew A Professional Trainer/Workshop Facilitator with 25 years’ experience of working in communities and custodial settings nationally and internationally. He is also a recording & performing artist fronting the collective Abstract Word and currently has Publishing & Production contracts with (Peer Music LTD-MAP Music). Richmond also leads a group of free-lance Arts Practioners under the name of Journeyman Arts (Using the Arts to share & pass on Knowledge). He also Runs 492 Korna Klub next generation Ltd that runs live improvised drama weekly on Galaxy Radio.

Uvence dba Health Medical Bank

uvence dba health medical bank

London

Uvence is the first cosmetic clinic to offer personalised Super Enriched Tissue. The Uvence procedure uses natural tissue extracted from a patient that is purified to enhance its regenerative potential. Uvence is the first cosmetic clinic to offer personalised Super Enriched Tissue. The Uvence procedure uses natural tissue extracted from a patient that is purified to enhance its regenerative potential. Super Enriched Tissue, is comprised of living cells such as; Mesenchymal Adipose and Haematopoeitic Stem Cells, Progenitor Cells, Fibroblasts, Lymphocytes, Pericytes, Vascular Endothelial Cells, and Macrophages, can be stored for up to 5 years, which allows patients the capability to have on-demand Uvence treatments on potentially multiple future occasions. The Uvence treatment is simple. An extraction of adipose tissue (fat transfer) directly from a patient is made, via a small non-invasive liposuction procedure wherein the extracted tissue is used to create proprietary and entirely personalized cosmetic injectables for the patient, which are then stored cryogenically and made available to the patients’ physician on demand. Super Enriched Tissue, is comprised of living cells such as; Mesenchymal Adipose and Haematopoeitic Stem Cells, Progenitor Cells, Fibroblasts, Lymphocytes, Pericytes, Vascular Endothelial Cells, and Macrophages, can be stored for up to 5 years, which allows patients the capability to have on-demand Uvence treatments on potentially multiple future occasions.