698 Courses in London

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Our one-day Platelet Rich Plasma training course, also known as PRP or the Vampire Facelift, teaches you all you need to know to become a professional PRP treatment provider. You will practice the famous 'vampire facial' treatment and phlebotomy via simulation and on a live model, and full support is available once you have completed your PRP Course. This treatment is lucrative within your salon and clinic, with growing demand as the treatment becomes ever more popular. Course prerequisites A minimum of 18 years of age Prior Phlebotomy training (Introduction to Phlebotomy) Good command of English This training course requires you to be an active practising aesthetic practitioner with certification / qualification in phlebotomy. If you do not have this you can complete our Phlebotomy training course Course Agenda All courses are intimate with four learners in a class Anatomy and physiology of the skin and blood Infection control Sharps and hazardous waste training First aid and anaphylaxis training Pre-study of PRP theory Phlebotomy Face PRP Hair PRP Extraction, Preparation and Dosage Management How to achieve safe and predictable outcomes Patient management - expectations Practical training Clinical setup Professional live demonstrations

The 'No Blade Facelift' is the new trend made popular by numerous celebrities recently and it is an excellent and effective non-surgical technique to lift and tighten skin. In the right hands, it has the potential to re-define facial contours and induces collagen production. The treatment forms part of an integrated support structure for the tissue of the face by encouraging natural collagen synthesis with immediate results that peak at 6 months and last between 2-3 years. ​On this course, we aim to help you master a technique that will set you apart from most routine cosmetic treatment providers and enable you to step into the future of advanced cosmetic procedures. We will cover all you need to know in order for you to treat your patients confidently and safely; including anatomy, use of local anaesthetic, consultation and assessment, managing complications and aftercare. You will perform this procedure on live models under the supervision and guidance of highly experienced aesthetic practitioners Course prerequisites This course is suitable for those with or without a medical background. It is designed to provide the student with the ability to seek employment or start their own business upon qualification. At a minimum, students will be required to be qualified for at least one of the following: Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 If your qualification does not appear above, we offer a fast track access course for those completely new to the industry.  Course agenda Background of PDO Threads Health & safety In-depth anatomy and physiology Emergency protocols Product knowledge Sourcing clinical oversight (Prescriber) Complications prevention Client suitability Equipment use Needle stick injury protocol Pain management with the use of injectable anaesthetic Adverse effects Complications management Emergency Protocols Anaphylaxis Aftercare Consent forms Consultation process Client selection Live demonstrations Live model experience Recommended treatment charges Insurance Legalities Advance your training with our complete PDO Threads training package Take your training to the next level by enrolling on our complete PDO Thread training package. Included within this package: PDO COG Threads PDO Mono Threads Fox Eye Thread Lifts Pixie Nose Tip Lifts Check out the package here

Course Entry Requirements: This course is suitable for learners who have completed the Foundation Dermal Fillers course. This course is available to those who meet one of the following:  NVQ Level 3 in Beauty Therapy or equivalent Medically qualified (Doctor, Nurse, Dentist, Dental Nurse) 12 months needling experience 6 months needling experience and Anatomy & Physiology Level 3 Foundation Dermal Fillers or equivalent qualification This training course requires you to be an active practising aesthetic injector with a minimum of six months experience with a demonstrable portfolio of client treatments. Course Pre-Study/Practical & Length: This intensive course includes 10 hours of theory study via our e-learning portal with 1 practical treatment. Course Agenda: This intensive course includes 10 hours of theory study via our e-learning portal with 1 practical treatment. All courses are kept intimate with a maximum of 6 learners to a class. Areas covered within this course are: Dermal filler injection, cannula techniques and methods for jawline, cheeks and chin. Danger zones training Start Business up (How to set up a business, insurance, stockist, social media, managed, join our Instagram group) Professional live Demos Practical training Areas that are covered in this course: Injection techniques with both needles and cannula Jawline enhancements Cheek enhancements Chin enhancements Course Benefits Benefits for Students Advanced Expertise: This masterclass will provide you with advanced knowledge and techniques specifically tailored to enhance the cheeks, jawline, and chin using cannula dermal fillers. You will acquire specialised skills that set you apart as an expert in facial contouring, enabling you to deliver exceptional results to your clients. Comprehensive Curriculum: Our masterclass covers a wide range of topics, including facial anatomy, patient assessment, product selection, injection techniques, and safety considerations. The comprehensive curriculum ensures that you gain a thorough understanding of the subject matter, equipping you with the knowledge necessary to excel in this specialised field. Hands-on Training: Practical experience is vital in developing your skills and confidence. Our masterclass offers hands-on training sessions where you will have the opportunity to practice the techniques on models. Under the guidance of experienced instructors, you will refine your skills and become proficient in achieving natural-looking and harmonious facial contours. Expert Guidance: You will learn from knowledgeable and experienced instructors who are well-versed in the field of aesthetics. They will provide guidance, share insights, and offer valuable tips to help you refine your techniques and approach. Their expertise will accelerate your learning process and ensure you receive the highest quality education. Benefits for Clients Enhanced Results: Clients seek professionals who possess advanced skills and knowledge in facial contouring. By enrolling in this masterclass, you will be able to provide your clients with exceptional results that enhance their cheeks, jawline, and chin. They will appreciate the natural-looking and harmonious outcome, leaving them feeling more confident and satisfied with their appearance. Specialised Expertise: With your training in cannula dermal fillers for the cheeks, jawline, and chin, you can offer specialised treatments that address specific areas of concern. Clients will benefit from your in-depth understanding of facial anatomy, tailored treatment plans, and the ability to create customised solutions that meet their unique needs. Safety and Trust: As a graduate of our masterclass, you will prioritise safety and adhere to industry best practices. Clients will have peace of mind knowing that their treatments are being performed by a skilled and knowledgeable professional who places their well-being as the top priority. This trust and commitment to safety will contribute to a positive client experience. Earning Potential Earning potential can increase significantly after completing the Cheeks, Jawline & Chin Cannula Dermal Fillers Masterclass: Expanded Service Offerings: With advanced expertise in facial contouring, you can expand your service offerings to include specialised treatments for the cheeks, jawline, and chin. This allows you to attract a broader client base and offer premium services that command higher prices. Client Satisfaction and Retention: By delivering exceptional results, your clients will be more satisfied with their outcomes. Satisfied clients are more likely to become repeat customers and refer others to your practice, leading to increased client retention and a growing client base. Competitive Advantage: As a graduate of our masterclass, you will differentiate yourself from competitors by offering specialised skills in facial contouring. This competitive advantage can position you as a sought-after professional in the aesthetics industry, allowing you to set higher prices for your services and increase your earning potential. Frequently Asked Questions Is this masterclass suitable for beginners or those with prior experience? Our Cheeks, Jawline & Chin Cannula Dermal Fillers Masterclass is designed for experienced professionals in the aesthetics industry. Prior experience and knowledge of dermal fillers are required to enrol in this advanced training program. What specific techniques will I learn in this masterclass? In this masterclass, you will learn advanced techniques for enhancing the cheeks, jawline, and chin using cannula dermal fillers. The curriculum covers topics such as facial assessment, product selection, injection techniques, and achieving natural-looking results. You will gain the expertise to create balanced and harmonious facial contours. Will I receive hands-on training during the masterclass? Absolutely! Hands-on training is a crucial component of our Cheeks, Jawline & Chin Cannula Dermal Fillers Masterclass. You will have the opportunity to practice the techniques on models under the guidance of our experienced instructors. This practical experience will enhance your skills and confidence in performing the procedures effectively. Will I receive a certification upon completion of the masterclass? Yes, upon successfully completing our Cheeks, Jawline & Chin Cannula Dermal Fillers Masterclass, you will receive a certification of completion. This certification acknowledges your advanced training and expertise in the area of facial contouring using cannula dermal fillers. Are there any post-training support or resources available? Yes, we provide post-training support to our students. Our instructors are available to answer any questions or provide guidance even after you complete the masterclass. Additionally, you will have access to resources and materials that can further enhance your knowledge and skills. Can I use the techniques learned in this masterclass immediately in my practice? Yes, upon completion of the masterclass, you will have the skills and knowledge necessary to apply the techniques in your practice. However, it is important to comply with the regulations and guidelines set by your professional licensing board or regulatory body. Are there any financing options available for the masterclass? We offer flexible payment options and financing plans to make our Cheeks, Jawline & Chin Cannula Dermal Fillers Masterclass more accessible. Please contact our admissions team for detailed information on available payment options and financing plans.

Gain the knowledge and skills to manage ear wax buildup with our "Management of Ear Wax Training" course. Ideal for healthcare professionals.

Join AAT Level 2 Bookkeeping | Online | Learn From Home at Your Flexible Time | Excellent Support and Advice | Join Now

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!

Soulmates are your best friend and your biggest supporter. If you want to make your relationship with your soulmate work, you really need to learn how to love yourself first. This seminar will teach you how to do just that. You will learn how to develop a strong relationship with yourself, build a foundation of trust and understanding, and keep your relationship fresh and new. Your soul mate is out there waiting for you, so don't miss this opportunity to find them! Register now and start on the path to finding true love today.

Aimed for GP reception staff and HCAs, who work face to face booking patients in or HCAs doing the initial triage/observations. Receptionists and HCAs working in the urgent care setting or walk in centres may also find this beneficial as they also book patients in and monitor the waiting room.