916 Courses in London

#breathwork #transformationalbreath #workshop #breathwork #relaxation#London Health #stressrelease#anxiety #selfhealing#breathe#Londonclasses#Londonworkshop#unitedkindomevent#greaterlondonevents#thingstodoinlondon#creativity This one day Transformational Breath®️ workshop offers you a great opportunity to learn how to manage stress and anxiety.

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 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 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning

Designed for quiet, shy, self-conscious and introverted people. In this introductory evening, you will be discovering the keys to authentic confidence based on author and self-confidence specialist, Claire Schrader's experiences of being a shy introvert, and what really worked in getting her out of her shell so she could achieve things in her personal and professional life she never would have thought possible. You will meet Claire in person and experience a series of confidence exercises that you will be able to put into practice in your everyday life. Claire creates an informal, relaxed, non-judgmental atmosphere that will quickly put you at your ease, and free you of the internal pressures that normally inhibit you from expressing yourself. It's a very safe place for you to gently stretch out of your comfort zone with people who feel in the same boat as you.

Date: 10th October Time: 4pm Location: Studio A Come and join our introductory session with Film Buddy for 2023! From work experience to mentoring programmes, Film Buddy has everything you need to get to grips with your career in film and start on the right track. Sign up for your FREE TICKET and we'll see you there!

Discover effective new ways to: find out what the problem is, communicate with reluctant teens, discover their hidden strengths, promote positive behaviour change, improve their mental health – and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) The best live online I have attended so far and I’ve done eight! Everything was relevant – completely spot onTEACHER / TUTOR Live Online – Join Richard Brook on Tuesday 19th March for this live online training event via Zoom. Simply book your place and we will email you details of how to join the Zoom workshop the day before. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course This live online training event gives you the essential knowledge, tips and practical skills you need to help troubled teenagers unlock their potential and begin to build lives for themselves that work well. Tutor Richard Brook has a wealth of hands-on practical experience in adolescent mental health and social work which he draws on throughout the day – you will have plenty of time to ask questions and discuss how you can implement the skills and techniques in your own work or with the teens you care for.   The programme is varied and intensive, yet lively with a strong focus on gaining skills. It clarifies what healthy teenage development looks like, why things can go wrong and the best ways to help young people overcome obstacles and begin to create lives for themselves that work well. Richard also shows how, by working with the ‘givens’ of human nature, and ensuring that sound knowledge of how people really function is applied intelligently to teenagers, you can speed up progress, reduce anti-social behaviour and teen depression, and bring young people real benefits. At the end of the day you will find yourself more empowered to respond effectively to each individual’s needs and temperament, whilst avoiding yourself the emotional pitfalls of working in stressful situations. Such a realistic and logical approach – it's given me lots of ideas for working with a variety of people, not just teenagers!PROBATION OFFICER What will you learn An increased understanding of what drives most problematic behaviour, including anti-social behaviour Essential knowledge and skills to deliver effective interventions to young people, both individually and in groups A deeper understanding of the causes of adolescent mental health problems Simple yet effective techniques for engaging uncommunicative young people, building rapport and promoting behavioural changes Constructive ways to help prevent teenage depression, anxiety and stress Four vital guiding principles that ensure your work with young people is relevant and effective Ways to motivate young people and help them set achievable goals How to discover and build upon a young person’s strengths and engage them in practical problem-solving Knowledge of how the insights from the human givens approach can dramatically improve interventions and their outcomes The opportunity to discuss how you could implement these in your own work with a highly knowledgeable tutor who has years of hands-on experience Also covered: The common misconceptions about adolescence What healthy teenage development looks like – this may bring you some surprises! A clear and logical foundation upon which to structure creative and effective interventions Ways to respond effectively to each individual’s needs, temperament and learning style How to avoid the emotional pitfalls of working in stressful situations An expanded repertoire of skills and a refined understanding of what works and – most importantly – why Course Programme The ‘How to help troubled and troublesome teenagers’ course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am What’s the trouble? 11.00am Comfort break and discussion 11.30am How to communicate with teenagers 1.00pm Lunch break 1.45pm Practical problem solving 2.45pm Comfort break and discussion 3.00pm How to help them create a life that works well 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.