2172 Courses in London

Learn how to finish your resin piece from part one of the course.

A pioneering provider of independent mentoring services  For adults who are training to be teachers and Early Career Teachers (ECTs), our mission is to support and empower aspiring educators as they navigate their journey towards becoming skilled and confident professionals in the teaching profession. As a mentorship program tailored specifically for adults pursuing a teaching career, we understand the unique challenges and expectations placed upon trainees in the profession. We are committed to providing comprehensive and personalised support to help trainees meet the teaching standards set by the Department for Education in England. The teaching standards and expectations in England Our experienced mentors are well-versed in the teaching standards and expectations in England. We provide guidance and practical assistance to trainees in areas such as lesson planning, classroom management, assessment strategies, and creating inclusive learning environments. Our aim is to help trainees develop a deep understanding of the curriculum, pedagogical approaches, and effective teaching techniques. Planning Planning is a crucial aspect of a teacher's role, and we offer specialised support to trainees in this area. Our mentors work closely with trainees to develop effective lesson plans that align with curriculum requirements and engage students in meaningful learning experiences. We provide guidance on designing differentiated instruction to meet the diverse needs of students, fostering a supportive and inclusive classroom environment. Confidence Confidence is essential for success in the teaching profession, and we are dedicated to helping trainees build their self-assurance. Our mentors provide individualised coaching and feedback, helping trainees develop their teaching skills, classroom presence, communication abilities, and interpersonal skills with other staff. We create a safe and supportive environment where trainees can explore their strengths, identify areas for growth, and gain the confidence needed to deliver impactful lessons and engage with students and the wider school community effectively. High quality resources In addition to planning and confidence-building, GLA Tutorsoffers a range of other support services to trainees. We provide resources and guidance on effective behavior management strategies, assessment and feedback techniques, and effective use of technology in the classroom. Our mentors also offer guidance on professional development opportunities, helping trainees stay updated with the latest educational research and best practices in teaching. A collaborative and ongoing process At GLA Tutors, we believe that mentorship is a collaborative and ongoing process. Our mentors build strong relationships with trainees, offering ongoing support, guidance, and encouragement throughout their training and early career stages. We understand the challenges and triumphs that trainees may encounter, and we are dedicated to helping them navigate their journey towards becoming successful and impactful teachers. ChooseGLA Tutorsas your trusted partner in your teaching journey. With our experienced mentors, personalised support, and comprehensive resources, we are committed to helping you meet the teaching standards, develop as a confident educator, and make a positive impact in the lives of your students.  Invest in your future as a teacher and join us at GLA Tutors today.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

An opportunity to learn about various heart rhythm disturbances, their aetiology, management and treatment strategies.

Its peony season, Chelsea Flower show is underway and London is in bloom! What better way to celebrate the season by creating a beautiful bouquet of gorgeous peonies. Come join me in the studio at West 16th SE21 where we will learn the art of building a beautiful hand-tied bouquet of the best seasonal flowers. Mix a gorgeous selection of flowers, fillers and foliage using the 'spiralling' technique used by the pros. We will be chatting through peony varieties, how to get the most out of them and sharing lots of flower hacks, tips and tricks along the way. We finish by tying, wrapping and presenting and you'll leave with your floral creation to enjoy at home and the ability to do it all again. The workshop will be held in the studio of West 16th, SE21 who will supply drinks and snacks included within the workshop price.

Its peony season and London is in bloom! What better way to celebrate by creating a beautiful bouquet of gorgeous peonies? Our clients all time favourite flowers and one we look forward to coming into season each year. Come join me in the studio at West 16th SE21 where we will learn the art of building a beautiful hand-tied bouquet of the best seasonal flowers. Mix a gorgeous selection of flowers, fillers and foliage using the 'spiralling' technique used by the pros. We will be chatting through peony varieties, how to get the most out of them and sharing lots of flower hacks, tips and tricks along the way. We finish by learning presentation techniques and you'll leave with your floral creation to enjoy at home. The workshop will be held in the studio of West 16th, SE21 who will supply drinks and snacks included within the workshop price.

Create your own unique textural mini-weaving, ready to hang on the wall. Learn open-weaving techniques - a hybrid of weaving and embroidery

A one-day programme of study designed for Registered Nurses, Doctors, and Allied Health Professionals working in a variety of care settings, whose role may include supporting and advising patients who are end of life.

Participants at this workshop will have the opportunity to develop their knowledge and skills using a coaching style technique and practice these skills in a conducive manner during the session.

Join Wildside London in the creative studio at West 16th for a Christmas Wreath workshop on Thursday 5th December at 7pm.  Kick off the festive season by learning to create a gorgeous wreath with an array of seasonal florals. Our workshops are fun, immersive and relaxed and we provide all the materials and instruction to enable you to design and build a fabulous wreath. The evening provides an opportunity to plan a creative Christmas get together that will put you right into the Christmas spirit. Mulled wine and mince pies will be served alongside the wreath making tutorial, or book a table in the restaurant for dinner before and make a night it it.