387 Courses in London

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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 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. 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

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.

Who is this course for? SketchUp - Rendering with V-Ray Course This course is tailored for architects, designers, 3D artists, and anyone interested in enhancing their rendering skills using SketchUp and V-Ray. Whether you're a beginner or an experienced user, this course provides in-depth training to create stunning visualizations and realistic renders in SketchUp using V-Ray. Check our Website Course Duration: 6 hours  Training Method: 1-on-1, (Face to Face) or Live Online session. Personalized to your needs. Course Content Overview: SketchUp and V-Ray: Exploring Intermediate Modeling Techniques Mastering V-Ray Materials: Textures, Sources, and Editing Managing and Optimizing Textures for Graphics and Bitmaps Illuminate Your Designs: Delving into Lighting: Types, Placement, and Scene Enhancement Understanding V-Ray Camera: Exposure, White Point, and Efficient Setup Achieve Stunning Renderings: Rendering Scenes: Digital Output, File Formats, and Best Practices Optimizing Quality Settings for Efficient Scene Creation Transitioning from 2D to 3D: Modeling Essentials for Visualization Utilizing Follow-Me and Push-Pull Techniques Enhancing Designs with Components: Choosing Between Groups and Components Mastering V-Ray Frame Buffer: Automatic 2D Graphic Saving File Types, Properties, and Effective Usage Perfecting V-Ray Materials: Materials Editor: Layering, Previews, and Shiny Surfaces Incorporating Bumps and Bitmaps for Realism Exploring Advanced Techniques: Unveiling Ambient Occlusion Effects Advanced Modeling, including Magic Box and Polygon Techniques Optimizing Texturing: Projected UVW Mapping Fine-Tuning Mapping Size and Position Locking Mapping for Consistency Alpha Channels: Preparing Graphics with Alpha Channels Integrating Rendered Output with Photoshop Hands-On Learning: Practical Exercises: From Concept to Stunning Renderings Vray for SketchUp Trial. https://www.chaosgroup.com/vray/sketchup/free-trial. Texture resources https://www.vray-materials.de/ and https://textures.com After completing the SketchUp and Vray course, participants will: Gain expertise in creating realistic 3D architectural and interior design scenes using Vray for SketchUp. Master lighting, camera settings, and composition for visually striking renders. Excel in applying Vray materials and textures for enhanced design quality. Produce high-quality renderings and refine them with post-production techniques. Receive a certification of attendance and 30 days of post-course email support. Job opportunities include roles in architectural visualization, interior design, real estate marketing, product design, and more. Skills Acquired: Advanced SketchUp Proficiency: Master advanced techniques for modeling and designing in SketchUp. V-Ray Rendering Skills: Learn how to use V-Ray to create realistic, high-quality renders in SketchUp. Texture Mapping and Material Application: Understand the art of texturing and applying materials for lifelike renders. Lighting Techniques: Explore various lighting setups to enhance the realism of your renders. Post-Processing: Gain skills in enhancing renders further through post-processing techniques. Job Opportunities: Architectural Visualizer: Create detailed and realistic architectural visualizations for projects. Interior Designer: Develop compelling interior visualizations for residential or commercial spaces. 3D Artist: Work in the gaming or animation industry, creating 3D models and environments. Visualization Specialist: Provide visualization services for real estate, marketing, or design agencies. Freelance Renderer: Offer your rendering services on a freelance basis to various clients. Why Choose Our Training? Personalized Coaching: Benefit from one-on-one training sessions conducted either Face to Face (SW96DE) or Live online, ensuring a tailored experience with practicing architects and designers. Flexible Hours: Our training is available Monday to Saturday from 9 am to 7 pm, accommodating your schedule for a seamless learning experience. Tailored Tutorials: Take advantage of custom video tutorials designed specifically for you, providing additional resources to enhance your learning journey. Comprehensive Reference: Receive a digital reference book to support thorough revision, ensuring a comprehensive understanding of each concept covered. Ongoing Support: Enjoy free and continuous support via phone or email even after the course concludes, ensuring your success beyond the classroom. Adaptable Syllabus: We customize the syllabus and projects to meet your specific needs, ensuring a focused learning experience on what matters most to you. Official Certification: Receive a certificate upon completing your course, recognizing your achievement in mastering the content. Why Us? Individualized Learning Support: Our courses, ranging from 10 hours to 120 hours Diploma training Courses, provide consistent support. With personalized assignments and post-course assistance, we guide you towards mastering software with dedicated help. Personal Attention, No Crowds: Say goodbye to crowded classrooms. Experience the intimacy of one-on-one learning, ensuring you receive the focused attention necessary for a confident and comfortable learning environment. Financial Flexibility: We understand the financial aspects of education. We offer various payment plans tailored to your needs, making your learning journey accessible and affordable. Expert Instructors, Real-world Knowledge: Our instructors are industry experts chosen for their extensive knowledge and teaching passion. Dedicated to imparting invaluable skills, they provide real-world insights to anyone eager to learn.

1 Day Course Advanced Deep Tissue Massage Accredited Practitioner Diploma Course

This qualification is aimed at individuals who require training in conflict management. It is appropriate for a wide range of sectors, including Security, Healthcare Services, Event Organisers, Customer Service, Teachers and is suitable for anyone who has a customer-facing role, deals with service users or the public.

Overcoming the challenge of public speaking - dealing with nerves, fine tuning delivery and engaging your audience with authentic confidence.

Join Dr Andrew Morrice for a deep dive into what the latest mind-body research tells us about the impact of sleep, the microbiome, nutrition, culinary practices and more on our mental and physical health, and recovery … Length: 1 day (9.30am - 4.00pm) A brilliant framework to understand the neurobiology of our needs and how to manage stressDR ALLY JAFFEE, NHS DOCTOR Why take this course Sleep and sound nutrition are widely recognised to be essential to mental health – this day gives you an opportunity to learn about these two areas in depth, including the role of the Microbiome. A greater understanding of these two areas can be vital in freeing ourselves from the ‘mind-only mindset’ to help us quickly and effectively resolve many of our difficulties in life. Sleep has always been integral to the human givens approach and this course is a chance to catch up on recent advances in understanding and evidence as to which approaches best help with poor sleep. We will explore how sleep allows for the physical recuperation, learning and emotional regulation that are key to improving many mental health problems. The role of food and the microbiome in mental health is seldom part of managing the immediate challenges we face, yet is so important in preventing difficulties, or maintaining recovery, that it is an area in which we can benefit from feeling greater confidence when guiding and advising our clients (or ourselves!). Throughout the day, tutor and GP Andrew Morrice draws on the latest research and his decades of experience managing the complex combination of mental and physical health problems in General Practice (20 of those years, using the Human Givens model), to take us on a deep dive into two of the key interfaces between mind and body: sleep and food, and their effects on our health. Andrew is a most inspiring teacher who is passionate about his subject. Furthermore, his experience as a doctor was invaluable...PSYCHOTHERAPIST / COUNSELLOR What will you learn The structure of sleep – and the functions of the different stages of sleep, including Non-REM and Slow Wave/Deep sleep The fundamental conditions required to promote healthy sleep The challenges of assessing sleep properly both for ourselves and others The complex relationships between sleep disturbances and depression, anxiety, pain syndromes and fatigue states, plus Simple organising ideas for navigating all this complexity What we can do to help resolve sleep difficulties so that we can wake feeling refreshed and emotionally prepared for the next day The fundamental science of the Microbiome – and its links to inflammation, mental health and physical health The eating patterns that worsen or help in mental and emotional health How and why processed foods undermine and confuse our innate guidance systems An understanding of the many other factors impinging on our ability to ‘forage’ well in the modern ‘food environment’ The basis on which foods or eating can become addictive, and how this can point to ways to address these difficulties Why we should consider the implications of the fasting state for our work How Human Givens tools can help clarify many of the confusions around food How to spot diet cults, tribes, and misleading claims Eating patterns we can confidently recommend to support health and wellbeing A review of how depression can be seen as a mind-body state rather than a ‘mental health disorder’ You will also have time to ask our expert tutor questions and benefit from group discussions Course Programme The ‘The Mind-Body Connection in depth: Movement, Emotion and Calm’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Microbiome and Diet – Finding our Food: how did this get so complicated and confusing? 10.45am Discussion over tea/coffee 11.15am Understanding Processing, Addiction and Tribalism 12.45pm Lunch (included) 1.30pm Getting a good night's sleep 2.45pm Discussion over tea/coffee 3.00pm Sleep, depression and inflammation 4.00pm Day ends Who is this course suitable for? The Mind-Body Connection In Depth series is open to anyone interested in deepening their understanding of mental and physical health. If you previously attended Andrew Morrice’s Mind-Body Connection course, and would like to spend more time on practical applications, the microbiome, the interface between diet and mental health and to thoroughly review the topic of sleep – this course is for you. Please note: you don’t need to have attended the previous Mind-Body Connection course to come on this one, or its sister course ‘Movement, Emotion and Calm’. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

“You don't take a photograph. You make it" - Ansel Adams Photography For Parents - Editing In Lightroom Next course starts 11 March 2024 Editing is an essential skill for anyone with even just a passing interest in photography. Much as we try, we can't always get everything right in camera and editing tools help us bring our vision to life, help correct problems and allow our images to look beautifully polished.  We teach how to do all these things in Adobe Lightroom because it's a powerful, intuitive and affordable tool used by Pros around the world for that very reason. KEY COURSE INFO: Course type: Instructor-led Course duration: 4 weeks + prep module Course format: Online course with interactive edit-along live classes, feedback on your learning and support group WHAT YOU LEARN: From being able to correct issues such as over/under exposure, issues with colour or graininess to bringing your vision to life, creating mood and tone to your images, knowing how to use editing software is a must. But good and purposeful editing goes way beyond just slapping on a preset or a filter - in our course we teach you all about the tools - not just what all of them do but how, and we teach you how to know what to use and when to achieve certain effects.everything you need to allow you to style your photos, confidently use the software and fix common problems. editing to correct common photo problems creating good editing workflow using powerful precision tools editing to achieve beautiful skin tones using light and colour creatively editing to bring out a mood of a feel THIS IS THE COURSE FOR YOU IF : Love taking photos but want them to look more polished - with colours that pop and light that's perfectly balanced You want to be able to fix common issues such as under- or overexposure, white balance or colour casts so that you never need to bin an image just because it wasn't right straight out of camera You want to get more creative with light and colour to make the images look just like the moment felt. Bring on the moody edits or sun soaked edits or light kissed skin tones or creative black and white conversions You want to confidently use the editing techniques so you can bring your vision to life every time, without guesswork You want to be able to prepare your images for print so that your walls can beam with pride at the beauty that you captured Next Editing in Lightroom course starts 11 March 2024  4 core course modules plus prep module Support Facebook group Weekly edit-along live webinar Practice files to learn on Feedback on your images HERE IS WHAT YOU WILL LEARN in this course :  Our Photo Editing in Lightroom course guides you through the photo editing process in Adobe Lightroom from start to finish – from setting it up correctly, organising your collections and creating a workflow that works for you, through learning the capabilities of all the editing tools - such as adjusting exposure, colours, light or sharpening the images; all the way to printing and creating photo books. We’ll show you how to create specific artistic effects ( high impact Black and white, vintage, light and airy, dark and moody etc ), and how to fix common photography problems ( grainy images, underexposed images, wrong colours etc). At the end of the course you will be able to confidently manage your photo collection with Lightroom, achieve desired artistic effects and make your photos truly stand out. Getting around in Lightroom and Lightroom Classic - shooting in full manual - but with clarity and purpose Correcting common problems - whether your photo started too dark or too bright, your child's face was in a shade, the white balance and colours were off, the grain was heavy, the light looked dull - you can fix it all within a couple of clicks in Lightroom Using Lightroom's super powerful intelligent masking tools to quickly and efficiently edit specific parts of your image - from brightening up the eyes to rescuing overblown skies Enhancing and adding beautiful light - light makes images stand out, but it can be hard capturing the atmosphere it creates in camera at times. Lightroom is where you can bring light to life and make your images feel how what you saw in real life Knowing how to shoot in camera so you can get the most in editing - photographers will often purposefully under or overexpose images in camera so that they have more chance of balancing the image just they way they want in Lightroom. INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 0: Getting set up in Lightroom This module is released a week before the course starts to give you a chance to fully familiarise yourself with the layout, structure and the best way of working in Lightroom Classic, including guidance of creating a smooth selection and culling process that helps you see and keep the best of your images, without getting bogged down with 100s near duplicates. Module 1: Getting Started In Lightroom - Global Edits In this module we introduce you to Lightroom's most powerful tools - the global edits. We help you understand how to tweak your images to achieve the effects you're after quickly - from adjusting over and under exposure, to correcting white balance in a few different ways, to having a play with my favourite Lightroom tool - the tone curve. Major Takeaways: At the end of the module you will have gained full control of lightroom key global tools and will be able to use them to correct any global - as in affecting the whole image - issues with your images. This includes perfecting your exposure, balancing your colour and white balance, sharpening and creating clarity and more. Module 2: Targeted Edits - Masks!  Lightroom allows us to apply edits to selected parts of the image through a range of its very powerful, intelligent and manual masks. This means you can now effortlessly select your subject from the photo to adjust them separately with just one click, you can pick only the sky, the subject's eyes or only colour green or any other element and treat them differently to the rest.  Major Takeaways: You will be able to use the full range of masks in lightroom and apply your edits exactly where they are needed, and nowhere else. This includes working with with the new AI powered masks which can detect a person's individual features and allow you to selectively edit them in a few simple steps, as well as those more manual tools, that allow you to literally paint with light and colour on your photographs. Module 3: Creative Editing in Lightroom  This is a brand new module in our course where we take all the tools introduced in Modules 1 and 2 and actually use them to achieve different effects on our photos. Wer show you how to be guided by light when editing, how to achieve a light and airy or a moody edit on your images, how to add light and how to convert to black and white, as well as how to edit skin in Lightroom! This module is all play!  Major Takeaways: You will learn how to create yoru own editing process - from knowing where to start and to understanding what elements of your photograph may need or benefit from adjusting and knowing how you can do so to achieve different outcomes. You will also learn how to edit your skin tones so they look delightful - no matter what your subject's complexion.  Module 4: After the edits We close the course with a module centered around all the things you might want to do after the edits - from preparation for print, creating photo books, but also sharing your images online and syncing them between different machines and adobe workplaces. PLUS there is a little Photoshop intro so you get a glimpse at how it's different and what it can do.    Major Takeaways: You will learn how to connect all of your Adobe ecosystem and sync and share your images across multiple devices. You will learn how to prepare your images for print so they look their very best and how to create photobooks. Next course starts 11 March 2024 Absolutely, without a doubt book Editing. I was very unsure at first. My interest in photography is to capture those memories so it felt like it was 'cheating' to edit. I can honestly say it's like magic.To finish off the pictures you love and just give you complete control over the exposure, colours to make them perfect, to rescue the disasters etc. I learnt so much in those few weeks and it made the biggest difference to my photos.  Kerry White Editing in LIGHTROOM Book your space now: COURSE STARTS : 11 March 2024 ( 4 weeks + 1 prep week)COURSE COST : £179 ( payment plans available ) What’s included: 4 weekly modules with step by step illustrated tutorials and videos + prep module weekly edit along class online class ( also recorded) - on Wednesday evenings feedback and advice on your edits private support group PDF workbook and downloadable videos Practice images to learn on Join our next group to really bring life to your images and make them look sleep, polished and full of light COURSE PREREQUISITES: Lightroom or Lightroom Classic CC software installed on your computer or tablet. RECOMENDED : Lightroom Photography Plan 25GB – a monthly subscription at approx £9pm – including Lightroom CC, Lightroom Classic CC and Photoshop. This plan can also be occasionally purchased at a lower price via Amazon or Groupon if you purchase a year’s worth of subscription in one go ( average savings – around 2-4 months worth depending on the deal) Please note that Adobe also has a Lightroom Plan with 1TB of storage – we do not recommend this plan as it restricts you to one version of software only. The increased Cloud storage can always be purchased as an add on or your plan can be switched from Photographer plan to CC only at a later stage if you prefer.

Qualsafe Awards has recognised the invaluable experience and training that CFRs bring to the table. As a result, they've introduced a bespoke 2-day FREC3 RPL Course, specifically designed for learners like you who already hold one of the approved qualifications. This course recognises your prior learning, allowing you to fast-track your way to the FREC 3 qualification.

Get strategies for developing numeracy and literacy across the curriculum.