Overview In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models. Objectives Harness Excel's tools within a best practice framework Add flexibility to their models through the use of switches and flexible lookups Work efficiently with large data volumes Model debt effectively Approach modelling for tax, debt, pensions and disposals with confidence Build flexible charts and sensitivity analysis to aid the presentation of results Learn and apply Excel tools useful in financial forecasting Understand and design the layout of a flexible model Forecast financial statements of a public or private company Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation
The professional working world has changed more rapidly than could have been envisaged at the time of the introduction of GDPR and the Data Protection Act 2018. With more people working from home post-Covid and the ever increasing risk of cyber-attacks, this short course is aimed at taking stock of current practice and risk, as well as considering ICO enforcement action and the implications of hybrid working. It is also a great recap on the rules as they stand and what you need to know to comply. The course will cover: UK GDPR - A timely reminder of the rules ICO enforcement action and what we can learn Data Protection Impact Assessments - when and how to do them Hybrid working and UK GDPR Managing cyber attacks from a UK GDPR perspective Target Audience The online course is suitable for staff of all levels, from support staff to senior partners. Resources Course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Matthew Howgate, Consultant, DG Legal Matt is a non-practising solicitor who has considerable experience in regulatory issues and advising on complex issues of compliance and ethics. He is also an expert in data protection, UK GDPR and on the civil legal aid scheme. Matthew is a lead trainer on and co-developed the LAPG Certificate in Practice Management (a training programme for legal managers and law firm owners) as well as regularly providing training on legal aid Supervision, costs maximisation, data protection and security and on general SRA compliance.
This half day online course will assist candidates in preparing for the forthcoming initial Casework Assistant exam.
Embark on a transformative journey to become a qualified MHFAider®. Master your skills and learn how to spot and support people with mental health issues and make a difference whether at work, volunteering, or in your community.
The Level 1 Diploma in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.
Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care
The Level 1 Certificate in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.
The Level 1 Award in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.
FAA Level 3 Award In Principles Of Safeguarding And Protecting Children, Young People Or Vulnerable Adults (RQF) Face to Face Classroom: One day course Virtual Classroom: 3 session of 2 ½ hours For those who work with children, young people and vulnerable adults Promotes awareness of safeguarding, enabling learners to identify problems and show where to report these to Course Contents: Safeguarding and protecting children, young people or vulnerable adults How to respond to evidence or concerns that a child, young person or vulnerable adult has been abused Safeguarding legislation and guidance Indicators of abuse or neglect Making judgements Communicating worries and concerns Roles and responsibilities Sharing information Allegations and complaints Reporting allegations and complaints Benefits of this Course: In 2018/2019, 415,050 concerns of abuse were raised In 2018/2019, there were nearly 400,000 children in need 52,300 children were subject to a child protection plan 63% of adult safeguarding concerns are for people over 65 1 in every 42 adults aged 85+ have required safeguarding enquires... Child abuse often goes unreported and unrecorded - till it is picked up on by someone who then does something about it. This Level 3 Safeguarding course gives people the skills and knowledge to make a real difference to a person's life! Accredited, Ofqual regulated qualification Our Safeguarding and Protecting Children, Young People or Vulnerable Adults training course is a nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd. This means that you can be rest assured that your Principles of Safeguarding and Protecting Children, Young People or Vulnerable Adults Certificate provides information for best practice to make a real difference to protect the health and wellbeing of our most vulnerable. The Ofqual Register number for this course is 601/8471/1