394 Teaching courses in London

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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

Whether starting from scratch or beginning again as an adult after regretting giving up at an earlier age (a most common scenario!), I'm confident you will find what you need here to have a most satisfying hobby or interest that can be done at any age and at any time.

Effective report writing, the exchange of information, ideas, opinions and decisions between people at all levels, internally and externally, makes a vital contribution to organisational success.

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

Learn Angelic Reiki with multi-award winning Master Teacher, Jayn Lee-Miller, who was one of the first to work professionally with angels and is now approaching her 18th year of teaching Angelic Reiki. Please email info@healingangels.co.uk for full details of this healing module which has been channelled through the Archangel Metatron especially for this time as the consciousness of humanity is collectively ascending to fifth dimension. The Angelic Kingdom of Light is assisting in helping us hold a place of unconditional love to help us remember the divine beings we truly are. In Angelic Reiki you are attuned by Angels to The Angelic Kingdom of Light and during healing exchanges you actually become the Angel you are channelling.

Powerful 1-hour Python workshop course understand Python Basics. Practical. Instructor-led. Online. Learn to code a Password Validator in 1 hour. 

Instantly get that 'Dream Job' working in Spa, Salon or Cruise Ship and charging up to £50.00 per treatment. This is the perfect course for students starting out in 'Beauty Therapy'. You can choose to learn for 33 evenings or the 'Fast Track' of ONLY 5 Days plus coursework, case studies and homework. This course is accredited by the VTCT and recognised by the HABIA- Hair and Beauty regulated government standards. Professional Skincare & Facials This unit will allow a student to give a professional facial using a leading brand. It will prepare them for work in a salon/spa, allow them to identify different skin types and textures and provide a facial which is tailor-made to each client. Course Objectives To prepare students for certification in Professional Skincare & Facials, by covering the following: How to identify areas of improvement and apply the correct products Related anatomy and physiology Contraindications Health, safety and hygiene Consultation and record keeping Treatment planning Product knowledge Correct cleansing Spritz toning Controlled exfoliation Steam & extraction Different types of face mask Correct moisturisation Use of sun screen Mineral make up Manicures & Pedicures This unit will allow the student to perform a professional manicure and pedicure on a paying customer. It will prepare them for work in a salon/spa and allow them to identify potential nail conditions, to file and paint correctly and to apply luxury applications such as paraffin wax. Course Objectives To prepare students for certification in Manicures & Pedicures, by covering: Removal of nail polish Cuticle work Correct nail filing Nourishing and conditioning the nails and hands How to apply nail polish Arm and hand massage Correct washing and cleansing of the feet Exfoliation and removal of dead skin cells Correct nail filing Nourishing and conditioning the feet and toe nails Cuticle work How to apply nail polish Leg and foot massage Health & Safety Related anatomy & physiology (The hands and nails) Contra-indications After-care Extras not offered in other schools: Heated paraffin wax Hand and foot masks Deep exfoliation Heated hand mitts and booties Hot oil treatment Waxing This unit will prepare the student to provide a professional waxing service using warm and hot wax to specific areas of the body. They will learn about hair growth cycles, correct application of wax and removal. What To Expect From This Course This is an exciting and intensive course which will teach students how to perform strip waxing. Areas covered will include: Arms Legs Back Eyebrows Lip Chin and face An extra unit is now covered with hot wax application for the more safe removal of hair to the following area: Bikini Eyelash and Brow Tinting This unit will teach a student how to correctly identify the correct colour for tinting of eyebrow and eyelash and will allow them to improve the appearance of clients who may have pale or uneven hair growth. Client consultation Contra-indications and Contra-actions Related Anatomy & Physiology Patch Testing prior to treatment Health & Safety pre-requisites Tinting Eyelashes & Eyebrows Identifying the correct Colour for All Types of Skin Tone and Hair Colour Aftercare advice Cosmetic Make Up This unit will guide the student on how to perform a correct make-up application. They will be able to perform the correct application for day, evening and occasional. Client consultation Contra-indications and Contra-actions Related Anatomy & Physiology and Health and Safety Facial Examination and skin analysis Cleansing and preparing the Skin Skin Anatomy and facts Correct choice of Make Up Products Correction Techniques Day, Evening & Special Occasion Make Up How to identify Diiferent Face, eye and lip Shapes, Skin Types and skin tone Aftercare advice Mineral Make Up Our school works with the accredited mineral make-up Bella Pierre. Know for camouflage and health purposes, mineral make-up is one of the only make-ups that can be applied after a facial treatment. Health & Safety, Client Care Health and safety in salon and spa is an essential criteria which is necessary to ensure the safety of the student and the client. How to avoid cross-contamination First Aid Coshh Riddor Hygiene in the workplace Related Anatomy & Physiology The study and certification of Anatomy and Physiology is a pre-requisite required in order to legally carry out treatments as a working therapist. It allows a therapist to recognise how their treatment can effect and improve bodily functions. The course will cover the following: Cells and Tissues The Skeletal System The Integumentary System The Blood Lymph Systems The Muscular System Neurology The Digestive and Excretory Systems The Respiratory and Olfactory Systems The Endocrine and Reproductive Systems Arthrology Health and Safety Issues Salon Management Hygiene in the Workplace Certification Upon completing all units, assessments and criteria and receiving 85% achievement, an NVQ Level 2 Certificate will be issued Pre-Requisites This course is for a complete beginner and offers a full introduction into the beauty industry What You Need To Bring What you need to bring along to the course. Towels, creams, oils, lunch! What We Provide We provide - massage couches, safe and enjoyable place to learn. Purchasing a kit for this course We provide a fully operational kit for our students. Please enquire as to costs. Duration 1 day a week on Friday for 8 weeks, 9.30am – 4.30pm Evening course option: 1 evening per week 6pm – 9pm for 13 weeks -- OR -- Optional training tailor-made to suit your needs and requirements These courses are on going so you can join at any stage and integrate into existing classes. FAST TRACK AVAILABILITY ONE PLACE LEFT FOR: Sat 5th April to Tue 8th April and Tue 15th and Wed 16th April FURTHER FAST TRACK DATES AVAILABLE ON REQUEST. WE OFFER ONE TO ONE TRAINING TOO! (Subject to availability and a price supplement). Remember, we are different, there is NO other Academy like us. We set our dates around you. OUR MISSION STATEMENT: Here at The Angel Academy of Teaching and Training, we go that step further to help our students. We offer the opportunity for a student to attend a course as many times as they would like until they feel truly confident and they only ever have to pay ONCE! We also offer assistance and guidance throughout their course and unlike other Schools will assist student's in completion of their log book, assessments and portfolio. Don't Miss Out- BOOK NOW! Dates and Costs Please see below our list of upcoming courses. Click on the course for further information, request a call or email regarding the course or book now! We are quite flexible in terms of course dates so if you would like to organise a course around your timetable, please contact us! Course Days Dates Cost NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 OPEN OPEN £1599 NVQ Level 2 In Beauty Therapy ** FAST TRACK ** 8 14/10/2023 21/10/2023 £1680 NVQ Level 2 In Beauty Therapy 'FAST TRACK' 8 7/11/2023 14/11/2023 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 12/12/2023 19/12/2023 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 20/01/2024 28/01/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 16/02/2024 23/02/2024 £1680 NVQ Level 2 in Beauty Therapy ** FAST TRACK WEEKENDS OPTIONAL 8 3/03/2024 10/03/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 8 14/04/2024 21/04/2024 £1680 NVQ Level 2 In Beauty Therapy ** FAST TRACK OPTION ** 1 11/05/2024 17/05/2024 £1680

Risograph printing intro workshop. Learn to print with GOOD STUDIO Brixton!

See more details and prices on my website. https://susanmetwaliyoga.com

Salsa/Mambo Progressive Workshop - Deep Dive into Social Dance Musicality by internationally renowned pro dancer & musician Alexistyle Funky Mambo presents "Salsa/Mambo Progressive Workshop - Deep Dive into Social Dance Musicality" Vol.2 by internationally renowned professional dancer & musician Alexis Ruiz (aka ALEXISTYLE) ************************************* Want to learn more about Salsa/Mambo? Want to up your game? This is your chance!!! Alexis is back in London especially for you!!! Learn from a Master!! You will learn with a progressive program how to connect the dots from instruments to how to predict songs and breaks, concluding with organic social dance patterns, and musicality without having to know the songs. Open to anyone who has fundamentals of dancing Salsa/Mambo: Improver to Advance - Alexis has a vast range of knowledge and will challenge you to learn new things. ********************************* Date: Sunday 25/02/2024 Time: 13:15 - 16:00 (incl. registration time & short break) Place: Husky Studios Studio 3 (White Room) 29a Amelia St (off Walworth Road) London, SE17 3PY (7 mins walk from Elephant & Castle tube & Kennington tube) ✅️ A spacious mirrored dance studio with a sprung floor Map: https://maps.app.goo.gl/cog5687D4ogS7Nzk9 Price: £35 in advance until 24 February £40 on 25 February - CASH, ONLINE, BANK TRANSFER or PAYPAL only !! NO CREDIT CARD accepted at the door !! **Limited spaces - Book your space early to avoid any disappointment! **Non-refundable once you paid the fee. About Alexistyle Alexis Ruiz started dancing and playing instruments almost before he could walk. Growing up in Antigua, Guatemala, his mother taught him to dance and teach together with her at her school Ritmo Latino. At the age of 12 he started teaching Salsa/Mambo and a diverse variety of Latin dances and Latin percussion. He has since then been teaching for over 25 years. At the age of 17, he moved to Japan where he opened his own dance school and created his own Latin jazz sextet "Foribale". He became an ambassador for Salsa in Japan, and travelled the world representing Japan at different congresses. The name "Alexistyle" was given to him by the legendary, Albert Torres. Mr Torres later awarded Alexis with an honorary award for his work in Japan, while teaching and performing at Los Angeles Salsa Congress. After 8 years in Japan, he moved to Norway. There he introduced the musicality of Mambo to the Salsa community in Norway, and his concept of Mambo Masterclass was born. Since then he has trained Norwegian champions, taught around the world on elite level, including London's leading Mambo School Funky Mambo, and created a vocabulary and a methodology that is completely unique. He is world famous for his lectures about "Salsa roots" where he dives into the history of both the music and the dance, and also the different musical influences in Salsa. He has an extensive background in Latin music, Latin dance and sound. He is a full-time professional dancer and musician. He got a degree in Afro-Cuban dances and percussion at "Conjunto Folklorico Nacional De Cuba", and has a Bachelor in sound engineering from Westerdals ACT, and is actively working on various TV and film projects. He has his own sound engineering company called AlphaRhythm. You can find his music on Spotify, iTunes and more. He plays all the instruments himself, record himself and edit, a multi-instrumentalist and musical genius! In Norway he is known for playing with some of the best Salsa bands like Sonora Cimarron, La Descarga, Banakao, Son on Fire, Son Candela and others! Through his career he has had several dance partners, while also working as a solo artist. Some of his most famous choreographies and shows, has been together with his long-time dance partner Katrin Lerner. In 2015 he created Norway's first Mambo dance company, Allure Dance company. Alexis focuses on musicality and rhythms, and shows storytelling and traditions in his choreographies. The company is project based, and performers has been varied through its years. He has toured all over Europe with the company. Today he is co-owner of Norway's only Tap dance school that he also teaches rhythmical concepts and music. He composes music with his wife Iselin Ruiz, and together they submerge in the world of dance and music. We are incredibly lucky to have him here in London. Don't miss this opportunity to learn from one of the BESTs, in the business!