11288 Courses

The European Society of Aesthetic Gynecology | ESAG is delighted to present a unique Masterclass on BHRT and PRP application in Regenerative & Functional Gynecology with a fully rejuvenated scientific program that will take place at Bader Medical Institute of London which is conveniently located on the well known Medical district of London in Marylebone, Central London. The Masterclass will start at 11:00 and end approximately at 18:15 and will focus on Bioidentical Hormonal Replacement Therapy (BHRT) and Platelets Rich Plasma (PRP) applications in Regenerative and Functional Gynecology. Scientific Faculty:  Maria Papadopoulou, MD, ABAARM Ob&Gyn Consultant (London) Board Certified American Academy of Anti-Ageing Medicine - A4M Vice-President of the European Society of Aesthetic Gynecology –ESAG Founder and Co-director of the Bader Medical Institute of London Prabhu Mishra, PhD MS in Molecular Medicine & Stem Cell Technology Doctoral degree, in addition to certificate courses in the field of Stem Cell Technology, Nanomedicine, and Translational medicine Covered Topics: Understanding the Female hormones Cortisol and its significant role in the balancing of Female hormones Where to test and how Treatment protocols Regenerative Medicine Procedures, Protocols and discussionsStem cells, Amniotic membranesPlacental extracts, Fat graftingNano Fat, SVF Functional Medicine Nutraceutical IV therapies, BHRT, Anti-Oxidants & supplementations Holistic Anti-Ageing therapies Platelet Rich Plasma Therapies in Gynaecology (Live demonstrations); Indications Covered:Thin Endometrium, Asherman Syndrome, Premature ovarian Failure, Oligospermia, Female Sexual DysfunctionsVaginal Laxity & Atrophy, Stress urinary Incontinence & Pelvic Floor diseasesInterstitial Cystitis And Vulvo-Vaginal Rejuvenation Limited exclusive seats available. An limited number of attendees will be able to participate and will benefit by being able to identify their patients’ needs and feel competent to manage and effectively treat them.

Electricians, take your first step towards becoming an MCS accredited PV installer in just three days!

Calling all plumbers and heating engineers! Take your first step towards becoming an MCS accredited Heat Pump Engineer in just three days!

Solar Thermal Hot Water Systems (BPEC NOS for MCS)

Barista Skills teaches the essential practical skills needed behind the espresso bar, such as how to set your grinder, make espresso, foam and texture milk for cappuccinos, and create latte art, as well as an exploration of health and safety issues, customer service protocols, and basic business practices. The Barista Skills Intermediate course builds on the concepts and skills introduced in the Foundation course. It is ideal for someone who has barista skills experience and wants to explore how to improve coffee quality and prepare for more complex job functions found in the barista profession. Through this interactive course, learners will gain a deeper understanding of the coffee itself, specifically, the impact of a coffee’s variety, origins and processing methods on flavour; the parameters of coffee quantity, grind texture, water quality, and shot time and their interaction when dialling in a brew recipe; drink construction and taste differences; workflow management and efficiency, sensory aspects of the espresso extraction; milk handling and techniques as well as latte art. In addition to coffee preparation, this course also covers key concepts regarding health and safety, customer service, and basic business practices. A written exam tests Intermediate course knowledge, while a practical exam assesses the learner’s ability in terms of grinder calibration, espresso extraction analysis, latte art skills and drinks construction.

Domestic Oil (aka OFTEC Courses)

3 intensive days of training and learning the fundamental knowledge of hair colour. Students are taken on a colourful and exciting journey of lectures, demonstrations and hands on training with our experienced educators. Students are provided with human hair mannequin heads before completing hair colouring techniques on live models.

Our Intermediate course is designed for Barbers and Hairdressers to further their skill set over an intensive three days of training. Keeping class sizes small, our educators will develop your techniques and introduce new methods to further you in your career with daily lectures, demonstrations and practical hands on sessions on up to 8 live models provided by the Sid Sottung Academy. A bespoke course catered to each student, you will leave with an extended understanding of mens cutting and a refined eye to detail.

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

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