2226 Courses in London

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Did you know that following a cardiac arrest, every minute without CPR and defibrillation reduces a casualty’s chance of survival by 10%?  Sudden cardiac arrest is one of the UK’s biggest killers, and yet statistics show that most of the British public are unaware of the life-saving difference they can make by performing CPR and defibrillation.  The QA Level 2 Award in Basic Life Support and Safe Use of an Automated External Defibrillator (RQF) qualification has been designed to provide candidates with the skills needed to administer safe, prompt and effective basic life support and use an AED safely in emergency situations.  With an estimated 60,000 out of hospital cardiac arrests occurring every year in the UK alone, make sure you are prepared!

Dermaplaning is an exfoliation treatment that removes the dead skin cells in the upper layer of the skin. It uses a surgical scalpel to lightly 'shave' the skin's surface, removing the face's fine vellus hair (peach fuzz). The treatment will produce a brighter and more youthful glow to the client's skin and allow skincare products to be absorbed more easily. Clients also find that their makeup sits more smoothly on their skin following "peach fuzz" removal. The treatment can be performed monthly in under thirty minutes and has minimal downtime. Course Entry Requirements: Minimum 18 years of age Good command of English Be able to learn independently A strong desire to build a career in aesthetics Previous skin and facial training are desirable; we suggest that learners new to the industry enrol on our facial and skincare course before enrolling on our ClinicCare skin peel course. Course Pre-Study/Practical & Length:  This intensive course includes 4 hours of theory study via our e-learning portal and five practical hours. Course Agenda: All courses are intimate with four learners in class 2-1 ratio. Anatomy and physiology of the skin and hair Infection control Sharps and hazardous waste training History of dermaplaning Treatable skin conditions Contraindications Legal concerns and consultation requirements Aftercare Practical training 1 model per area Practical set up Professional live demonstrations Course Benefits Student & Client Benefits Skill Development: By enrolling in our Dermaplaning Training course, you will acquire the knowledge and skills needed to perform dermaplaning treatments effectively. You will learn the proper techniques for safely and precisely exfoliating the skin using a surgical scalpel. This skill development will enhance your expertise in the field of skincare and expand your service offerings. Versatile Treatment Option: Dermaplaning is a versatile exfoliation treatment that can benefit a wide range of clients. It effectively removes dead skin cells, peach fuzz, and superficial vellus hair, resulting in a smoother, brighter, and more even complexion. By mastering dermaplaning, you can cater to clients seeking a non-invasive exfoliation treatment with immediate results. Client Satisfaction: Clients will benefit from the dermaplaning treatment in several ways. The removal of dead skin cells and facial hair can improve the absorption of skincare products, enhance the effectiveness of other treatments, and leave the skin looking fresh and rejuvenated. Clients will appreciate the immediate improvement in the texture and appearance of their skin, leading to increased satisfaction with your services. Increased Client Base: Adding dermaplaning to your skill set can attract new clients and expand your customer base. Many individuals are seeking safe and effective exfoliation treatments to improve their skin's texture and overall appearance. By offering dermaplaning, you can cater to this demand and attract clients who value the benefits of this treatment. Personal and Professional Growth: Enrolling in our Dermaplaning Training course provides an opportunity for personal and professional growth. You will gain valuable knowledge about skincare, exfoliation techniques, and client consultation. This knowledge can be applied not only to dermaplaning but also to other skincare treatments and services, enhancing your overall expertise and career advancement opportunities. Earning Potential Additional Service Revenue: By offering dermaplaning as a service, you can generate additional revenue for your beauty or skincare business. Dermaplaning is a popular treatment that clients often choose to receive on a regular basis to maintain healthy and glowing skin. Repeat business can contribute significantly to your overall earning potential. Upselling Opportunities: In addition to offering dermaplaning as a standalone treatment, you can upsell clients on complementary skincare products and services. Dermaplaning prepares the skin for better product absorption, making it an ideal opportunity to recommend and sell skincare products that can further enhance the clients' results. This can boost your earnings through product sales and additional treatments. Frequently Asked Questions Who is eligible to enrol in the Dermaplaning Training course? Our Dermaplaning Training course is open to anyone interested in learning and mastering the art of dermaplaning. Whether you are a beauty professional, esthetician, skincare enthusiast, or a beginner in the industry, you can enrol and benefit from this course. What will I learn in the Dermaplaning Training course? In this training course, you will learn the theory and practical aspects of dermaplaning. You will gain knowledge about the skin, skin types, and the benefits of dermaplaning. The course will cover techniques for safe and effective exfoliation using a surgical scalpel, as well as post-treatment care. Hands-on practice will be provided to develop your skills and confidence.

– BAG MAKING COURSE – LEATHER GOODS MAKING COURSE: MAKE A STITCHLESS LEATHER BAG – WHAT IS THIS COURSE ABOUT?This is one of our group leather goods making courses for beginners that we organise at our London studio.Using beautiful vegetable-tanned leather, basic leather tools and simple metal fittings, you will make a stitchless leather bag while learning five basic leather working techniques.You will customise your bag by choosing between two designs (see photo gallery) and selecting your preferred colours of leather and fittings.No sewing skills or experience is required!At the end of the course, you won’t just take home a beautiful bag made entirely by you but also an understanding of working with leather and essential leather tools.WHAT WILL I LEARN?During our leather goods making courses, you will always receive an introduction to:-Different leather types-Essential leather tools You will then learn these 5 basic leather working techniques:-Marking leather-Cutting leather-Folding leather-Punching leather-Burnishing leather In the second part of the course, you will apply the techniques learnt by hand-cutting and assembling your beautiful bag using screw studs. No sewing is required.INCLUDED IN THE COURSE:All materials and tools are supplied.WHAT ARE THE ENTRY REQUIREMENTS?This course on making a stitchless leather bag is suitable for beginners.You should be able to use measurements and understand verbal and written English instructions. ADDITIONAL MATERIAL PROVIDEDIn addition to the course, you will receive the following useful handouts to take home with you:– An introduction to leather types and features – A glossary of leather craft tools which includes images and helpful descriptions – A list of the basic fittings used in handbag making, including images and descriptions – A list of reputable suppliers to buy leather and fittings from (in London and online)HOW LONG IS THIS TUITION?:This tuition will require up to 7 hours to complete.We aim to provide customised and high quality tuition services and by only allowing up to 5 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Create your own unique textural mini-weaving, ready to hang on the wall. Learn open-weaving techniques - a hybrid of weaving and embroidery

Best way to unwind after a long week and create something beautiful.  Join us for our Friday evening class of flower arranging in a woven basket. We will provide:  A selection os seasonal blooms and foliage A woven basket Tools to condition the flowers Guidance during the 2h class from our floral artist A glass of bubbly or floral lemonade and light refreshments A beautiful floral basket arrangement to take home at the end of the class

The QA Level 3 Award in Administering Emergency Oxygen (RQF) qualification has been designed for those who are responsible for providing care to casualties where the administration of emergency oxygen may be required.  Over a half day period, candidates will learn about the clinical need for emergency oxygen and the safety considerations of this, as well as how to administer emergency oxygen when dealing with a range of conditions. Successful candidates will leave the course with the knowledge and skills needed to administer emergency oxygen both safely and effectively.  Achievement of this qualification confirms candidates have met both the theoretical and practical requirements, however, it does not imply a ‘license to practice’ – the scope of practice is determined by the organisation responsible for oxygen provision. This qualification does not allow candidates to obtain, store or administer oxygen without clinical governance.

Our 6 hour Emergency First Aid at Work course gives the participant the knowledge, skills and confidence to deal with with first aid incidents in the work environment. Employers can book this course for their employees in the knowledge that they are fulfilling their duty to provide quality first aid training to their employees.

Giving your child the gift of music while they are still young can be one of the most meaningful investments you could make in their life, and our London piano lessons for kids are structured to support the musical goals you have for your children. Your child’s or grandchild’s life will be permanently enriched from music lessons, whether they continue with music as a career, enjoy it as a serious amateur pursuit, or play casually for their own benefit and that of their friends and family.

Personalized Revit Training: One-to-One Sessions with Pay-as-You-Go Flexibility