1293 Courses in London

This workshop is aimed at practice managers who work in GP Practices and Health Centres or their equivalent. The purpose of this workshop is to equip practice managers with the tools and techniques they need to run a busy practice and/or team.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Acceptance and Commitment Therapy (ACT) Package: Embrace Your True Self and Live Authentically Discover the transformative power of Acceptance and Commitment Therapy (ACT) with Miss Date Doctor’s specialized package. ACT is a cutting-edge form of therapy that helps you accept your thoughts and emotions while aligning your actions with your core values. Say goodbye to old patterns of avoidance and self-doubt, and embrace a life of psychological flexibility and authenticity. Our experienced therapists will guide you through targeted exercises and techniques that empower you to embrace discomfort, develop resilience, and make meaningful changes in your life. With the ACT package, you’ll find the courage to face challenges head-on, build stronger relationships, and achieve your personal and relationship goals. This comprehensive program will equip you with the tools needed to navigate life’s uncertainties and build a stronger, happier you. 3 X 1 HOUR SESSION https://relationshipsmdd.com/product/acceptance-and-commitment-therapy-package/

Why Choose Adobe Illustrator and Photoshop Training Course? Click here for more info Master vector graphics, digital illustrations, photo manipulations, and more. Certified tutors provide personalized guidance and feedback. Flexible scheduling available. Receive a Certificate of Completion. Learn Adobe Creative Cloud. Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This comprehensive and hands-on course introduces you to digital design through Adobe Photoshop and Illustrator. Learn how these three programs seamlessly collaborate to create stunning designs. Gain insights into bitmap and vector graphics and discover the most suitable image file formats for different scenarios. 10-hour course outline for Adobe Photoshop and Illustrator: Module 1: Introduction to Adobe Photoshop (1 hour) Overview of Photoshop interface and tools Understanding bitmap graphics and resolution Basic image editing techniques (cropping, resizing, color adjustments) Layers and their importance in design Module 2: Essential Photoshop Tools (1 hour) Working with selection tools (Marquee, Lasso, Magic Wand) Understanding brushes and brush settings Introduction to the Pen tool for precise selections Working with layers and layer styles Module 3: Advanced Image Editing (1 hour) Advanced color adjustments (Curves, Levels, Hue/Saturation) Photo retouching and manipulation techniques Creating composite images using blending modes Filters and special effects for creative designs Module 4: Introduction to Adobe Illustrator (1 hour) Overview of Illustrator interface and tools Working with vector graphics and paths Basic shapes and drawing tools Understanding anchor points and handles Module 5: Creating Vector Artwork (1 hour) Using the Pen tool for precise vector illustration Creating and editing shapes and objects Working with gradients and patterns Understanding the Appearance panel Module 6: Illustrator Typography (1 hour) Text tools and formatting options Creating text effects and artistic typography Combining text with shapes and images Working with text on a path Module 7: Combining Photoshop and Illustrator (1 hour) Importing Illustrator files into Photoshop and vice versa Working with smart objects and vector shapes in Photoshop Creating custom brushes and patterns in Illustrator for use in Photoshop Designing posters and flyers combining elements from both software Module 8: Integration with InDesign (1 hour) Exporting assets from Photoshop and Illustrator for InDesign Designing layouts in InDesign using assets from both programs Understanding print and digital design considerations Preparing files for printing and online use Module 9: Advanced Techniques and Tips (1 hour) Creating custom actions and automation in Photoshop Mastering advanced selection techniques Utilizing Illustrator's advanced tools (Pathfinder, Shape Builder, etc.) Exploring creative design styles and trends Module 10: Final Projects and Portfolio (1 hour) Students work on individual or group projects incorporating Photoshop and Illustrator skills Review and feedback on the projects Preparing a portfolio showcasing their work Download Adobe Illustrator - Free Trial https://www.adobe.com/uk/illustrator Throughout the course, you will explore various processes, including design and layout, workspaces, tools and palettes, importing files, and preparing files for both on-screen and print outputs. Course Objectives: By the course's conclusion, you will have a solid understanding of the fundamentals of each software package and their individual functionalities. You will learn how to efficiently work with all three applications in tandem and skillfully assemble print and digital-ready designs, leveraging elements crafted in Photoshop and Illustrator and integrated using InDesign.

Use Cases for Business Analysis The use case is a method for documenting the interactions between the user of a system and the system itself. Use cases have been in the software development lexicon for over twenty years, ever since it was introduced by Ivar Jacobson in the late 1980s. They were originally intended as aids to software design in object-oriented approaches. However, the method is now used throughout the Solution Development Life Cycle from elicitation through to specifying test cases, and is even applied to software development that is not object oriented. This course identifies how business analysts can apply use cases to the processes of defining the problem domain through elicitation, analyzing the problem, defining the solution, and confirming the validity and usability of the solution. What you will Learn You'll learn how to: Apply the use case method to define the problem domain and discover the conditions that need improvement in a business process Employ use cases in the analysis of requirements and information to create a solution to the business problem Translate use cases into requirements Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Overview of use case modeling What is a use case model? The 'how and why' of use cases When to perform use case modeling Where use cases fit into the solution life cycle Use cases in the problem domain Use cases in the solution domain Use case strengths and weaknesses Use case variations Use case driven development Use case lexicon Use cases Actors and roles Associations Goals Boundaries Use cases though the life cycle Use cases in the life cycle Managing requirements with use cases The life cycle is use case driven Elicitation with Use Cases Overview of the basic mechanics and vocabulary of use cases Apply methods of use case elicitation to define the problem domain, or 'as is' process Use case diagrams Why diagram? Partitioning the domain Use case diagramming guidelines How to employ use case diagrams in elicitation Guidelines for use case elicitation sessions Eliciting the problem domain Use case descriptions Use case generic description template Alternative templates Elements Pre and post conditions Main Success Scenario The conversation Alternate paths Exception paths Writing good use case descriptions Eliciting the detailed workflow with use case descriptions Additional information about use cases Analyzing Requirements with Use Cases Use case analysis on existing requirements Confirming and validating requirements with use cases Confirming and validating information with use cases Defining the actors and use cases in a set of requirements Creating the scenarios Essential (requirements) use case Use case level of detail Use Case Analysis Techniques Generalization and Specialization When to use generalization or specialization Generalization and specialization of actors Generalization and specialization of use cases Examples Associating generalizations Subtleties and guidelines Use Case Extensions The <> association The <> association Applying the extensions Incorporating extension points into use case descriptions Why use these extensions? Extensions or separate use cases Guidelines for extensions Applying use case extensions Patterns and anomalies o Redundant actors Linking hierarchies Granularity issues Non-user interface use cases Quality considerations Use case modeling errors to avoid Evaluating use case descriptions Use case quality checklist Relationship between Use Cases and Business Requirements Creating a Requirements Specification from Use Cases Flowing the conversation into requirements Mapping to functional specifications Adding non-functional requirements Relating use cases to other artifacts Wire diagrams and user interface specifications Tying use cases to test cases and scenarios Project plans and project schedules Relationship between Use Cases and Functional Specifications System use cases Reviewing business use cases Balancing use cases Use case realizations Expanding and explaining complexity Activity diagrams State Machine diagrams Sequence diagrams Activity Diagrams Applying what we know Extension points Use case chaining Identifying decision points Use Case Good Practices The documentation trail for use cases Use case re-use Use case checklist Summary What did we learn, and how can we implement this in our work environment?

How to improve dating success Learning emotional intelligence Improve social awareness Training on emotional resilience Motivation and Patience training Learn Communication Skills Enhance Patience and Introspection Coping mechanisms for stress Learn how to understand people better Learn Assertive communication Improve observation skills Improve mental and physical attraction Are you tired of going on endless dates with no results? Do you struggle to communicate effectively with potential partners or build the confidence needed to succeed in the dating world? If so, Miss Date Doctor UK’s Dating Coach Course is here to help! Our comprehensive course is designed to provide individuals with the tools and knowledge needed to improve their dating skills and find meaningful relationships. Our expert coaches will guide you every step of the way, from developing your personal brand and building confidence to mastering communication skills and navigating online dating. The Dating Coach Course at Miss Date Doctor UK is ideal for anyone looking to enhance their dating experience, whether you’re single and searching for the right partner, or simply looking to improve your current relationship. Our course is tailored to meet the unique needs of each individual, and our coaches are dedicated to providing personalized support and guidance to help you achieve your goals. At Miss Date Doctor UK, we believe that finding love should be a fun and enjoyable experience. That’s why our Dating Coach Course is designed to help you approach dating with a positive and confident mindset, and to give you the skills and knowledge needed to make informed decisions about your dating life. Our course covers a wide range of topics, including building self-esteem, overcoming fears and anxieties, mastering communication skills, and navigating online dating platforms. Whether you’re looking to improve your social skills, build your confidence, or simply learn more about the dating world, Miss Date Doctor UK’s Dating Coach Course has everything you need to succeed. Our course is packed with the key pillars of improving your dating “personal development”, “relationship advice”, “self-improvement”, “emotional intelligence”, “interpersonal skills”, “communication techniques”, “love coaching”, “dating tips”, “online dating”, “dating apps”, and more! So why wait? Sign up for the Dating Coach Course at Miss Date Doctor UK today and start your journey towards a happier, healthier dating life! https://relationshipsmdd.com/product/dating-coaching-course/

Aqualyx is one of the leading brands that is used for fat dissolving. Aqualyx can be used on the face and body to great effect. Just one session can dramatically reduce fat deposits and return a more youthful and defined facial contour for small areas such as the jowls and chin. For larger areas like tummies, bingo wings and bums, clients may need up to 5 sessions to see dramatic results. Aqualyx & Deso are water-based solutions injected into the fatty tissue, surround the cells and destroy them. The remains of the fat cells are then excreted by the body safely as waste. Aqualyx is used for people who want to get rid of stubborn areas of fat in their faces and bodies and is clinically proven for these purposes. Course Entry Requirements: This course is suitable for both medics and non-medics. You can enrol on this training course if you meet one of the following:  NVQ Level 3 in beauty therapy, ITEC or HND Medically qualified as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. 12 Months of Needling Experience or 6 Months of Needling Experience and Anatomy & Physiology Level 3 or Above. Course Structure: 20 hours of pre-study E-learning and 1 practical training Course Agenda: Areas covered within the course: Anatomy and physiology of the skin and tissues Infection control Sharps and hazardous waste training First aid and anaphylaxis training Pre-study fat-dissolving theory training Practical training Clinical set up Professional live demonstrations Course Benefits Benefits for Students Specialised Training: Our course provides specialised training in Aqualyx and Deso fat dissolving treatments. You will learn the techniques, protocols, and safety considerations involved in these procedures. This specialised training will enhance your skill set and allow you to offer advanced fat dissolving treatments to your clients. Practical Experience: We prioritise hands-on learning to ensure that you gain practical experience in administering Aqualyx and Deso fat dissolving treatments. Under the guidance of experienced instructors, you will have the opportunity to practice these procedures on models. This practical training will increase your confidence and competence in performing the treatments effectively. Expanded Service Offering: By enrolling in our training course, you will expand your service offering as an aesthetics practitioner. Aqualyx and Deso fat dissolving treatments are highly sought after by clients who want to target localised fat deposits non-surgically. Adding these treatments to your repertoire will attract new clients and provide existing clients with more comprehensive solutions. Professional Advancement: Completing our Aqualyx & Deso Fat Dissolving Training Course will contribute to your professional advancement. You will gain in-depth knowledge about fat dissolving treatments, build expertise in these procedures, and enhance your professional credibility. This can lead to career growth opportunities, such as working in reputable clinics, establishing your own practice, or even training other professionals in the field. Benefits for Clients Targeted Fat Reduction: Clients seeking Aqualyx and Deso fat dissolving treatments desire targeted fat reduction in specific areas of their body. By enrolling in our training course, you will acquire the skills to accurately assess and administer these treatments, effectively helping clients reduce unwanted fat deposits in a non-surgical manner. Non-Invasive Solution: Aqualyx and Deso fat dissolving treatments provide a non-invasive alternative to surgical procedures for fat reduction. Clients benefit from a less invasive approach that involves fewer risks, minimal downtime, and reduced recovery periods. Offering these non-invasive treatments can attract clients who prefer a non-surgical solution to their aesthetic concerns. Customised Treatment Plans: As a trained practitioner, you will be able to create customised treatment plans for your clients. By assessing their unique needs and goals, you can develop tailored protocols and treatment strategies. This personalised approach ensures that clients receive individualised care and optimal results. Earning Potential The demand for Aqualyx and Deso fat dissolving treatments continues to grow. By enrolling in our training course and becoming proficient in these procedures, you can significantly increase your earning potential. Clients are willing to invest in effective fat reduction treatments, and as a skilled practitioner, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients often become repeat customers and refer others, further boosting your earning potential. Enrolling in our Aqualyx & Deso Fat Dissolving Training Course not only benefits you as a student but also provides valuable advantages for your clients and potential earning potential in the aesthetics industry. Take the opportunity to expand your expertise and offer innovative solutions to clients seeking fat reduction treatments. Frequently Asked Questions Is this course suitable for beginners or those with prior experience? Aqualyx & Deso Fat Dissolving Training Course is designed for aesthetics practitioners who already have a foundation in basic injection techniques and experience in the field. Prior experience in administering injections is essential to enrol in this advanced course. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in Aqualyx & Deso Fat Dissolving. This certification acknowledges your advanced skills and expertise in administering these fat dissolving treatments. It can enhance your professional reputation and provide a competitive edge in the aesthetics industry. What topics are covered in the course curriculum? Our course curriculum covers various topics related to Aqualyx and Deso fat dissolving treatments. These include product knowledge, patient selection and assessment, injection techniques, treatment protocols, managing complications, and post-treatment care. The curriculum is designed to provide you with a comprehensive understanding of the Are there any hands-on training opportunities? Yes, our Aqualyx & Deso Fat Dissolving Training Course includes hands-on training sessions. Under the supervision of experienced instructors, you will have the opportunity to practice and refine your skills in administering these fat dissolving treatments. This practical experience is vital for your professional development. Will I have access to ongoing support after completing the course? Absolutely! We provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you navigate your career in Aqualyx and Deso fat dissolving treatments. We are committed to supporting your continued growth and success. Are there financing options available for the course? We offer flexible payment options and financing plans to make our Aqualyx & Deso Fat Dissolving Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans.

Choose what you want to learn in this fast-track hairdressing course. Aimed at those who’ve left college with a hairdressing qualification but don’t feel confident enough on the salon floor or those needing to brush up on a specific skill. Our training concentrates on cutting, colouring, styling and barbering.

Hard gel nail extension course is the most comprehensive UV gel extension course available in London. Our unique course structure and great teaching skills will help you to learn everything quickly and efficiently, all techniques are learnt in "hands-on" practical way. This course is a perfect balance of theory, demonstrations, and practice. Generation X - Sculpting Gels are specially formulated gels that complement a uniquely developed training Gel is one of the basic techniques in the world of professional nail enhancements, it is easier to apply than Acrylic and odour free. The product hardens in LED lamp and for that reason it gives you more time for creating a beautiful design, making it the ideal system for beginners.  THE REQUIREMENTS Salon attire must be worn during the course. Student must have clean nail without enhancements and long hair tied back. To ensure maximum practice, students will be required to work on each other throughout the day or on own hands. To attend this course must you have diploma for manicure or Gel polish course. Model for the day 3 THE CONTENT Safety & hygiene Client consultation Record keeping Importance of sanitising and sterilising Aftercare advice How to organise a workspace Technical structure of a nail’s enhancement Troubleshooting gel Correct shape of extended nail Correct White & Pink application Troubleshooting gel Rules on nail design In-fills and removal Advice on products & suppliers Portfolio building process Getting models for practice Charges and loyalty schemes for clients Marketing advice, website, and brand building Organising advertising events Tool and Product introduction Clear overlay – practice on tip & hand Pink & White – practice on tip & hand Application of UV gel set of nails using sculpting technique Form& tips on real hands. Day 3 The 3rd day is a practice and exam day which you will book at the end of day 2.  Price Include N2- David Collection Generation X - Sculpting Gels . Upon successful completion an course certificate will be awarded

Vectorworks Evening Course face to face One to one