2939 Courses in London

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Come and spend the day with to learn about this staggering new sedative which has revolutionised how a lot of us perform sedation. From 20 minute appointments to four or five hours, Remimazolam can be predicable, controllable, with super fast recovery times. Join us to get the core knowledge you need to start using this sedative in your daily practice and welcome a new level of safety and comfort for the patient and the whole team. UKSedation is a UK leader in the training and use of Remimazolam, the most exciting advancement in dental sedation in the last 40 years. This is another tool in our sedation palette which can provide ultrashort and ultra long sedation with the same safety profile as midazolam, but with super fast recovery and the ability to control and adapt to the dental situation. REMIMAZOLAM IS NOW APPROVED FOR USE IN DENTISTRY IN THE UK, SEE THE IACSD STATEMENT 9TH JAN 2023 AT https://www.rcseng.ac.uk/-/media/fds/iacsd/iacsd-remimazolam-statement-090123.pdf After the success of our course at the Royal Society of Medicine in October 2022 with Dr Rob Endicott and Dr Roy Bennett, we are planning a series of events around the country, including bespoke training for your practice teams. If you would like to be kept up to date with courses near you, please fill in the form so we can be in touch. Or if you want to contact us about training needs directly, email us. IF YOU NEED A BESPOKE DAYS TRAINING FOR YOUR TEAM, SIMPLY CONTACT US About Instructor Rob Endicott Roy Bennett Dr Roy Bennett is the director of Mellow Dental Training, IACSD accredited trainer and mentor and former director of Portmans Dental Care. Dr Rob Endicott is an IACSD accredited trainer and mentor and is the ViceChair of the ADAS (Association of Dental Anaesthetists and Sedationists)

NPORS Suction Excavator (N021)

Acrylgel is a fusion between builder gel and acrylic powder tailored to create durable and extremely natural looking nail enchantments. Acrylgel is a revolutionary product for nail design. It convinces with an easy and quick application and its very long durability. Because of the extremely high viscosity you can model all nails on one hand and cure them at once without getting any gel in the nail edges. Our Acrylgel is very easy to file. - Stable as acrylic, flexible as a gel. - Quick and easy application, max. saving of time.This course will take you through the application procedure, ‘French Pink and White’ techniques, sculpting with forms and maintenance procedure, including aftercare advice. 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. THE CONTENT Health, safety & hygiene Consultation techniques Contraindications Nail preparation Introduction to tip application Extend nail bed using sculpting techniques French Pink and White techniques Maintenance procedure Removal procedure Aftercare advice DURATION This is one day course which runs from 10am to 5pm PRICE INCLUDES Acrylgel training kit . Upon successful completion an course certificate will be awarded

A course on Curating and the Psychology of Perception - which are very closely interlinked. Curating and the Psychology of Perception are very closely interlinked. Yet, psychologists and curators are rarely brought together to examine them together. This course has previously ran as part of the rich portfolio of (AIR interdisciplinary courses)[https://www.gold.ac.uk/short-courses/air]. It now runs as part AIR Courses at TechnoTruth. Taught by leading experts This course is taught by two leading experts. The course combines lectures on the history of the most important exhibitions of modern art with psychology of perception to address several important questions. Read more on the course page. Group bookings and Enquiries To book this course for a group, please email us at: info(@TechnoTruth.co.uk). Refunds: We will be happy to refund the fee, minus the Eventbrite fee, which is not refundable. For cancellations latter than 24 hours ahead of the start of the training, a proportion of the fee (£95) is non-refundable.

Children's Beginner Ballet classes in Fulham, London for kids aged 3-4 years old. Book ballet and dance lessons with Dakoda's Dance Academy.

6-7 Years Primary RAD Ballet dance classes in Fulham, London for kids aged 6 to 7 years old. Primary RAD Ballet dance lessons with Dakoda's Dance Academy & Knightsbridge Dance.

Pre-Primary RAD Ballet dance classes in Fulham, London for kids aged 4-6 years old. Pre-Primary RAD Ballet dance lessons with Dakoda's Dance Academy & Knightsbridge Dance.

NPORS Reach Lift Truck (N003)

The Level 2 NVQ Diploma in Trowel Occupations provides a nationally recognised qualification for those working in the construction and the built environment and specialise in the erection of masonry structures. Upon completion of the qualification, you will be awarded the NVQ Level 2 Diploma in Trowel Occupations which allows the holder to obtain the Blue Skilled Worker CSCS Card. The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role. Each candidate will be allocated a qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. Upon completion the card is upgraded to the full 5 year CSCS Card.