412 Courses in London

Microsoft Excel® in Depth (In-Person) 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

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 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 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 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 3D Hairstroke 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 3D HAIRSTROKE 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 3D Hairstroke 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. 3D Hairstroke 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.

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

BYO materials, canvas, drinks from home and join us for a fun evening painting together and chatting with local artists and art enthusiasts. All is welcome w...

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.

Python Basics: Course Description Excellent for beginners, practical, in small groups of max 4 people, 1 Day Online Instructor-led. You could contact us for your prefereed date. Session 1: Python Data Types and Variables: Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python. Operators and Expressions: Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.. Exercise: Calculate Movie Tickets for a Party, Are there enough seats in the cinema? Decision Making & Loops If statement; If - else statement; If- elif - else statement; Nested if - else; Exercise: Calculate the travel fee to deliver goods The while, For loop Jump statements: break, continue; Nesting loops. Exercise: Enter a password, if incorrect 3 times, you are blocked. Session 2: Data Structures Lists. Tuples. Exercise: Hangman Game Exercise: Get a word for the game from a Json File, store the high score in a Dictionary file Session 3: Files and exceptions Exception Handling, Exception types; Using try and Except. Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files. API: Connecting to API’s. Session 4: OOP Creating and using custom Functions. Using parameters and return values. Creating a Class; Creating an Object; Using an Object; Adding Instance variables; Class Constructors; Parameterized Constructors. Inheritance. Override. Session 5: Pandas Dataframe Basics Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. Getting information about the dataframe, Filter, sort and query a Dataframes, Slicing Dataframes, Duplicate values,Working with null-values, Sampling. Exercise: Query the top 1000 grossing movies of the last century Session 6: Built in Functions: String, Math, Random Python built-in functions: Strings functions. Maths functions. Random Functions. Exercise: Find information in prose, to get the sentiment of the prose. Exercise: Get a word for the game from a txt File Exercise: Win the lottery Included: PCWorkshops's Python Programming Basics Certification Course notes, exercises and code examples Revision session after the course Refund Policy No Refunds