4206 Courses in London

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

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

Project Leadership Skills: In-House Training To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan

Project Stakeholder Relationship Skills: In-House Training This course is designed to provide project managers with the ability to: Analyze the complexities of major stakeholder relationship categories Apply the most appropriate interpersonal relationship skills to the different categories of relationships Align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle What you Will Learn Examine traditional and non-traditional ways to identify and assess stakeholders Explain how competence, character, and trust lead to project success and strong relationships with stakeholders Utilize 'Embodied Leadership' skills to build stakeholder relationships Apply stakeholder engagement best practices to case study and real-life scenarios Getting Started Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations

This course is designed for experienced permanent makeup artists looking to enhance their skills and offer more to their clients. The focus is on advanced techniques and practical skill, providing the learner with the knowledge and equipment they need to become a confident eyeliner and lash enhancement artist. COURSE PREREQUISITES This course is designed for qualified permanent makeup artists with experience in the industry. If you are looking for a course suitable for beginners or those new to permanent makeup, learn more about our VTCT Level 4 Micropigmentation course EYELINER & LASH ENHANCEMENT TRAINING COURSE STRUCTURE: 10 hours e-learning: This self-paced online learning module will cover advanced cosmetic tattooing theory including Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. 1 day of in-house training: This intensive hands-on training day will allow you to apply the theory you've learned in a practical setting. You'll practice the eyeliner and lash enhancement technique on latex and later on skin under the guidance of our experienced instructors. STUDENTS WILL LEARN THE FOLLOWING: Advanced Cosmetic Tattooing theory: You'll delve deep into topics such as Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. Pre-drawing: Learn how to sketch the desired eyeliner shape and style before the actual procedure. This is a crucial step in ensuring client satisfaction. Colour mixing: Master the art of mixing pigments to achieve the perfect shade for every client. Eyeliner and lash enhancement technique: Learn how to create a soft, diffused eyeliner color that enhances the natural beauty of the eyes. Treatment protocols: Understand the steps to follow before, during, and after the procedure to ensure the safety and satisfaction of your clients.

This advanced course is designed for qualified permanent makeup artists looking to enhance their skills and offer more to their clients. The focus is on advanced techniques and practical skill, providing the learner with the knowledge and equipment they need to become a confident lip blush artist. COURSE PREREQUISITES This course is designed for qualified permanent makeup artists with experience in the industry. If you are looking for a course suitable for beginners or those new to permanent makeup, learn more about our VTCT Level 4 Micropigmentation course LIP BLUSH TRAINING COURSE STRUCTURE: 10 hours e-learning: This self-paced online learning module will cover advanced cosmetic tattooing theory including Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. 1 day of in-house training: This intensive hands-on training day will allow you to apply the theory you've learned in a practical setting. You'll practice the lip blush technique on latex and later on skin under the guidance of our experienced instructors. STUDENTS WILL LEARN THE FOLLOWING: Advanced Cosmetic Tattooing theory: You'll delve deep into topics such as Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. Pre-drawing: Learn how to sketch the desired lip shape and style before the actual procedure. This is a crucial step in ensuring client satisfaction. Colour mixing: Master the art of mixing pigments to achieve the perfect shade for every client. Lip blush technique: Learn how to create a soft, diffused lip color that enhances the natural beauty of the lips. Treatment protocols: Understand the steps to follow before, during, and after the procedure to ensure the safety and satisfaction of your clients.

This course is designed for experienced permanent makeup artists looking to enhance their skills and offer more to their clients. The focus is on advanced techniques and practical skill, providing the learner with the knowledge and equipment they need to become a confident Ombre eyebrow artist. COURSE PREREQUISITES This course is designed for qualified permanent makeup artists with experience in the industry. If you are looking for a course suitable for beginners or those new to permanent makeup, learn more about our VTCT Level 4 Micropigmentation course OMBRE BROWS TRAINING COURSE STRUCTURE: 10 hours e-learning: This self-paced online learning module will cover advanced cosmetic tattooing theory including Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. 1 day of in-house training: This intensive hands-on training day will allow you to apply the theory you've learned in a practical setting. You'll practice the Ombre eyebrows technique on latex and later on skin under the guidance of our experienced instructors. STUDENTS WILL LEARN THE FOLLOWING: Advanced Cosmetic Tattooing theory: You'll delve deep into topics such as Health and Safety, Colour Theory, Client Suitability, Consent, Anatomy & Physiology, Treatments and Tools. Pre-drawing: Learn how to sketch the desired eyebrow shape and style before the actual procedure. This is a crucial step in ensuring client satisfaction. Colour mixing: Master the art of mixing pigments to achieve the perfect shade for every client. Ombre eyebrows technique: Learn how to create a soft, diffused eyebrow color that enhances the natural beauty of the eyebrows. Treatment protocols: Understand the steps to follow before, during, and after the procedure to ensure the safety and satisfaction of your clients.

This course is an excellent follow-on course for students who have completed our classic eyelash extension training course or eyelash technicians trained with an alternative provider and have gained some experience delivering individual eyelash extensions. Course Prerequisites We accept students aged 18 and over. Students must have good written and spoken English. Course Structure Course Agenda: Aftercare Consultation Fan technique Infection control Professional demonstration Practical training 1 model Classic eyelash extension theory Anatomy and physiology of the hair and eye

Non-surgical treatments for inch-loss & body contouring. This course is designed to train candidates to provide expert treatments to the highest standards. This will enable you to gain insurance and to commence work legally to perform these treatments in the public sector. Ultrasonic Cavitation & Radio frequency can be used in the following areas: Abdomen Buttocks Arms Inner and Outer Thighs Love Handles Course prerequisites No previous experience or qualifications are necessary to enrol onto this course with a good command of english required. Course structure You are required to complete our online theory study via our accessible e-learning portal and practical training onsite. All courses are kept intimate with a maximum of 6 learners to a class. Areas covered within the course: What are Ultrasonic Cavitation and RF, and how do they work? Benefits of Ultrasonic Cavitation and RF include fat reduction and skin tightening Anatomy and Physiology related to Ultrasonic Cavitation and RF Understanding Fat Cells Client consultation Pre and post-treatment advice Contraindications Treatment contra-actions Treatment process including live model experience for cavitation Frequently Asked Questions How can I book? We have a few options for you to book. You can book by selecting an available training date above here on our website, by contacting us through email at hello@cosmetic.college or by contacting us on 0333 015 5117. Where is the Cosmetic College The Cosmetic College is located at: 3 Locks Court, 429 Crofton Road, Orpington, BR6 8NL Is a deposit required to book? All enrolments are charged an administration fee which is non-refundable. When you enrol you can elect to pay a deposit of 10% plus the administration fee or pay the total training course in full. We have full details of the terms and conditions of training course enrolments here What is the course duration? 1 day + pre-study via our online learning platform. Is there a kit included in this course? The are a few different options we provide for our students on this course. The advertised price is for training only. We stock table-top machines at a separate cost subject to availability as well as provide links to recommended alternative suppliers.

With a focus on both theory and practical, we provide a breakdown of each vitamin and quantities for attendees to thoroughly understand IV therapy and succeed in this regenerative field. 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 Introduction History of nutrition therapy and regulations Intravenous Micronutrient Supplementation (IMS) Essential Micronutrients IVNT protocols Safety & efficacy Practical fundamentals Combination and cocktail IV injection protocols and treatments Treatment and specific ingredients and protocols for IV nutrition Informed consent & medical history Trainers demonstration Live model delivery sessions