431 Link 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

Who Should Attend Rhino 3D Evening Training Course? Click here for info. This Evening Course is for individuals seeking to learn 2D and 3D modeling skills in a supportive and creative learning environment. Whether you are new to Rhino or want to expand your existing knowledge, this course is for product, furniture, architectural, and jewelry design industries. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule hours of your choice, available from Mon to Sat between 9 am and 7 pm Course Inclusions: Free Lifetime email support: Enjoy the flexibility of a free lifetime email support. Expert Instruction: Learn from experienced architects, designers, and software professionals, ensuring top-notch teaching. Hands-On Learning: Engage in practical, hands-on lessons with personalized project work to apply your skills effectively. Digital Reference: Access valuable video tutorials and a digital reference book for convenient revision and continuous development. London Design Training Course Certificate of Completion: Receive a certificate upon course completion, enhancing your CV and LinkedIn profile. Free Career Guidance: Benefit from career guidance, including tips on job applications and setting up a creative business, to stand out in the competitive design industry. Rhino 3D Basic to Intermediate Training Course Course Duration: 10 hours Introduction to Rhino and Interface: Familiarizing with Rhino's command system and toolbar usage. Navigating the geometry menus, command line, and status bar efficiently. Understanding the Properties window and its functionalities. Managing file operations, including opening and saving files. Grasping the three entity types: curves, surfaces, and solids. Exploring various geometric elements, such as Bezier curves, B-splines, NURBS objects, isocurve surfaces, and mesh surfaces. Setting measurement units for accurate modeling. Navigation: Introducing the viewport and its features. Using construction planes to aid in modeling. Utilizing shading modes for better visualization. Learning essential viewport controls: pan, zoom, rotate, and reset. Workflow Basics: Creating basic objects like curves, surfaces, and solids. Performing fundamental transformations to manipulate objects. Organizing projects efficiently using layers. Drawing: 2D Geometry: Understanding the creation of lines, polylines, rectangles, polygons, arcs, circles, and ellipses. Drawing freeform curves for more creative designs. Modeling: 3D Surfaces: Comparing various 3D surface types. Utilizing extrusion to add features to models. Creating surfaces with loft, revolve, rail revolve, sweep rail, and network surface commands. Constructing complex surfaces with the Network Surface tool. Modeling: 3D Solids: Introducing solid modeling techniques. Creating solids with primitives and curves. Applying Boolean operators to create unique shapes. Editing solids using the solid edit tool. Transforming solids and incorporating modeling aids like Grid Snap, Ortho, and Planar. Editing and Transforming Objects: Using Fillet and Chamfer to edit corners. Employing curve Booleans for trimming and splitting. Mastering the Drag and Nudge tools for object movement and rotation. Copying, pasting, and grouping objects effectively. Scaling and duplicating objects with the Mirror command. Analysis and Degrees: Understanding degrees of curves and surfaces. Creating screen captures for quick proofs. Generating 2D views and rendering projects. Preparation for 3D Printing and Manufacturing: Preparing models for prototyping by ensuring closed gaps. Using the shell technique to create wall thickness suitable for 3D printing.

Face to Face Training Customised and Bespoke.

Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL ' 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 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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 Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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

Aftereffects face to face training customised and bespoke.

his course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects.

The latest mind body research gives us profound insights into the effects on mental health of 'physical' factors, including breathwork and time in Nature, new ways to improve mental and physical health, and more… This wide-ranging day will deepen your knowledge of the mind-body system and the impact ‘physical factors’ can have on our emotions, state of mind and memory – with additional ways to help people quickly and effectively… Accredited CPD: 6 hours 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 Having a deeper understanding of the latest research into the effects on mental health of ‘physical’ factors – such as movement and exercise, time in Nature, ‘breathwork’ and real-time connection with others – enables us to tailor powerful therapeutic interventions and deliver more informed psycho-education. This jam-packed day also covers the physiology of responses such as ‘freeze, fight or flight’, the effects of physical activity on emotional, mental, memory and brain health, why stress can become chronic, the many ways we can activate our innate capacity to restore calm through our breath and attention, why these relaxation techniques work and what they do for us physically. The findings you will explore on the workshop have implications for many areas of mental health, even addiction, and give us additional ways to help people resolve many difficulties quickly and effectively, as well as improve overall health. The HG approach recognises that meeting our emotional needs and using our resources well are key to good mental health – yet the impact of ‘physical’ factors on our emotions and state of mind can be just as profound. Even though our physical needs may appear obvious – a healthy diet, regular physical exercise etc – we know that most of the chronic diseases sweeping through the Western World are linked to “lifestyle”, indicating that many people are not actually meeting their physical needs in healthy balanced ways – despite the vast array of information available to them. Finding clarity about how best to meet our own physical needs can also help us maintain our capacity to help others. Throughout the day, Dr Andrew Morrice, a practising GP, draws on both 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). We will sift the sense from the nonsense, and see the fundamentals behind the buzzwords and trends, making it easier to think clearly about our own health as well as that of our patients or clients… Really insightful course with an amazing way into practical applications of the HG concepts...ALIYA DRAKE, HG THERAPIST What will you learn How the now well-known human ‘needs and resources’ relate to our evolutionary past, and physical lives The many ways physical movement affects the functioning of the mind and our emotions A deeper look into the physiology of emotional responses, such as ‘fight, flight, freeze’ and their impact on health Greater knowledge of the fundamentals of how we can find calm – and the very many ways these can be used to help people New information from the latest mind/body research that has implications for therapeutic lifestyle changes Also covered: What is ‘health’? And how do we get it? Key practices to support your own health, as well as your clients’ How to avoid the unhelpful psychology and aversive ‘pattern match’ that many of us have when it comes to ‘exercise’ Whether we can really be addicted to exercise and if so why? A deeper understanding about the role of “Green Space” in mental health Increased knowledge of the ways in which physical changes in the body contribute to emotional distress The many ways in which movement and physical activity are connected with mental health How thinking and moving, memory and place are inextricably linked Why stress becomes chronic (long-lasting) Greater clarity about the role some emotions play in creating physical ill health – and the powerful ways in which other emotional states promote health (including the key role of oxytocin) The science of the relaxation and oxytocin responses, and how these relate to many types of addiction, including smoking Organising ideas to understand how 6 different types of relaxation practice relate to each other A practical exploration of the many ways the relaxation response can be activated through breath and attention – including a new technique for dealing with panic Why some people may have come to believe that ‘the breathing’ can’t or won’t help them Summaries of the role of diet and sleep on our health – along with the factors considered today in ‘Therapeutic Lifestyle Change’ 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 What is health and how do we 'get it'? 10.45am Discussion over tea/coffee 11.15am The physiology of fear and calm 12.45pm Lunch (included) 1.30pm The physiology of rapport (and other topics) 2.45pm Discussion over tea/coffee 3.00pm Physical domains of mental health 4.00pm Day ends Who is this course suitable for? This course is open to anyone interested in mental and/or physical health If you enjoyed the original 1-day Mind-Body Connection course and would like time to explore in more detail the themes covered in the first half of that course, this new 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 ‘Food, Mood and Sleep’. 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.

Photoshop one day training course bespoke 1-2-1 with lifetime support

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.

– the practical skills you need Discover how to combine key new insights into the causes and symptoms of depression with a range of powerful psychological techniques to make treatment easier and more consistently effective … Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Practical, inspiring and full of hopeDR GINA JOHNSON, GP Why take this course Until recently depression was little understood but key new insights into its causes and symptoms have made treatment easier and more consistently effective. On this day you will learn how combining these insights with a wide range of different psychological techniques enables the majority of cases to be lifted surprisingly quickly … even severe ones. Although antidepressants can play a role in reducing symptoms, they can also be dangerous and prove hard to withdraw from – research shows that appropriate counselling is more effective at lifting even the most severe depression, with a much lower rate of relapse. The approach you will learn on this workshop is in this category and is proving very effective – 10,000s of people have already been successfully helped with the knowledge and skills you will learn on the day. I feel much more confident in my understanding of the process of depression and how to target it with helpful interventionsDANIEL COOPER What will you learn New insights into why depressed people wake up tired and unmotivated, and what to do about it Information about the links between inflammation and depression Clear, practical steps for lifting even severe depression Demonstrations of the skills that quickly break the cycle of depression, move people on and prevent relapse A profound understanding of why these work and are a big improvement on drug therapy Practice sessions in using these proven skills and techniques yourself What to do if you suspect someone may be feeling suicidal How to establish what’s not working in a person’s life and why, using a case history Techniques for tackling rigid thinking, negative expectancy and the pessimistic rumination that causes depression How to work with your clients to find effective ways they can get their innate emotional needs met well and in balance A range of additional useful tips and strategies that you can easily incorporate into your work The opportunity to watch a film of master therapist Joe Griffin working quickly and successfully with a highly depressed patient You will also have plenty of time to ask questions of the tutor, who is also a practising therapist herself… Everyone, not just the caring professions, should do this day.GENERAL PRACTITIONER Who is this course suitable for? If your life is affected by depression in any way – perhaps the staff or students you are responsible for at work present with depression, or a friend or family member is depressed – you will benefit from attending Anyone who, for whatever reason (personal or professional), would like to better understand the causes of depression and be able to offer practical help to people who are depressed If you would like to know how best to prevent relapses and help clients build long-lasting resilience against future setbacks, this workshop is for you Anyone concerned about the side effects of drug treatments for depression, who would like to know about the easy-to-learn psychotherapeutic techniques that can lift depression quickly, will benefit from attending It is essential training for counsellors, psychotherapists, social workers, occupational therapists, HR professionals and all other health and welfare professionals – since depression is now so common, it is crucial to understand it and know how to treat it quickly and effectively. Good to know This workshop complements our online course: How to break the cycle of depression. Guided imagery and visualisation and Therapeutic Language are useful skills to have for implementing the strategies taught on this workshop. Course Programme From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Understanding depression and what you can do about it 11.00am Discussion over tea/coffee 11.30am Exploring how to work with depression 1.00pm Lunch (included) 1.45pm Practice in using the HG approach 2.45pm Discussion over tea/coffee 3.00pm Guided imagery for depression 4.00pm Day ends 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.