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.
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!
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.
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.
Mindfulness is a practical technique for developing a greater sense of awareness and focus on the present moment. It is the opposite of mindlessness, meaning that actions and reactions become conscious and deliberate. It is an extremely useful tool for any busy work environment. Currently being used by the likes of Google and Pepsi, mindfulness can be adopted within the workplace to reduce stress and anxiety, provide greater focus and clarity, improve leadership capabilities and enhance the general wellbeing of staff at all levels. This workshop has been developed for forward-thinking organisations wanting to make a real and sustainable commitment to improving workplace wellbeing and productivity. This workshop will help you to understand the basic principles and benefits of mindfulness, and how it can be used in the workplace setting. It will also enable you to develop techniques to alleviate overwhelming feelings of stress or anxiety, prepare for important or challenging meetings, and generally achieve a greater sense of focus, clarity and calm whilst dealing with a hectic schedule.
This intensive one-day IACCM-approved programme helps participants develop the skills, knowledge and competencies required to plan for and carry out effective negotiations in a range of different environments. By the end of the programme participants will be able to: Understand the basic concepts of negotiation and how it adds value to the organisation Recognise the stages of negotiation and the skills required at each stage Make use of tried-and-tested negotiation planning tools Apply a range of negotiation tools and techniques to support the organisation in obtaining value for money, quality and fit-for-purpose outcomes Set negotiation objectives Appreciate the importance of interpersonal skills in maximising the opportunities for reaching win/win agreements 1 Welcome Introductions Aims and objectives Plan for the day 2 Why negotiate? Understanding the negotiation context Negotiating with suppliers Negotiating with stakeholders 3 Understanding the process The phases of negotiation and what to do in each phase Before During After 4 Planning Appreciating the importance of planning Different approaches Identifying the key variables Setting objectives for each of them Practical negotiation planning exercise 5 Doing The key skills required, Communication Numeracy empathy Applying these skills in a role play: practical exercise 6 Close Review of key learning points Personal action planning
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.
Date: 9th 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!
This comprehensive one-day programme has been designed to provide participants with an overview of basic supply chain principles and concepts and to identify potential opportunities for reducing costs, minimising risks and adding value across the supply chain. This could include reducing inventory, procurement, transport and storage costs. Fundamentally, the object of the programme is to empower participants to be able to collaborate with all key stakeholders across the supply chain. This course will help participants: Appreciate the importance of the supply chain as a source of competitive advantage Understand the tools and techniques available to improve supply chain performance Analyse and mitigate risks across the supply chain Identify opportunities for improvements in their respective supply chains Demonstrate competence in the pro-active management of the supply chain
To provide a fundamental understanding of building services in the context of: The working environment The success of the core business The health and safety of the occupants Operating cost and environmental impact The optimisation of cost and value Strategies for continuous improvement DAY ONE 1 Building services fundamentals The function of services in commercial buildings and their importance to the core businessElectrical servicesLightingHeatingVentilation and air conditioningLiftsWater Understanding IT and communication systems Practical exercises 2 The provision of comfort and safety Statutory requirementsHealth and safety legislationControl of contractorsRisk assessmentFire precautionsLegionella, sick building and other risks Business requirementsUnderstanding user requirementsMatching systems to business needs Practical exercises 3 Getting the design right What the FM needs to know about design and its procurementSuccessful space planningRelationship between services, space planning and designGetting the brief rightSupplier selection and management Practical exercises DAY TWO 4 Operation and maintenance Why maintain?Maintenance contractsInput and output specificationsResource optionsContracts - principal elementsTendering - key stepsSelection criteriaOperational criteriaMaintenance trends Performance-based service provisionInput and output specificationsKPIs and thresholdsRisk containmentValue-add opportunitiesPerformance contract strategy Practical exercises 5 Contingency planning Being ready for the unexpected Identifying and reducing riskInternal risksExternal risksIdentifying threats at your site Managing riskProtective systemsOccupier obligationsFire managementTesting Practical exercises 6 Commissioning services systems Physical commissioning Common problems Typical costs Commissioning stages Continuous commissioning Energy efficiency and the scope for environmental improvement Practical exercises 7 Satisfying the occupants Obtaining and responding to feedbackWhen to get feedbackWhyHowWhat to do with it Practical exercises 8 'Air time' Sharing experience and addressing specific issues of interest to participants Course review Close