50382 Courses delivered Online

Learn how to use this innovative tool to analyse and validate your schedule, to add and model uncertainty and risk and to work with updated plans to compare project progress. Course overview Duration: 1 day (6.5 hours) This course looks at the powerful features of Nodes and Links. It looks at analysing and validating your schedule, adding uncertainty and risk and working with updated plans to compare project progress. Hands on practice will be gained throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Nodes and links, no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import and validate plans Analyse and review plans Add and model uncertainty Add and model risk Load updated schedules Re run analysis on updated schedules Content Validating your plan Importing a baseline plan Running a health check Analysing the results Reviewing the plan Analysing critical paths Reviewing activities Reviewing resources Adding Uncertainty Setting uncertainty templates Distributions Adding uncertainty Using Inherit Using AI Reviewing activity distributions Modelling Uncertainty Running the Analysis Reviewing the results Reviewing activity results Risk Drivers Filtering for activities Setting up the Risk Register Setting Risk Templates Adding Risks to the Risk Register Independent vs Dependant Events Setting Probability and Impact Modelling Uncertainty and Risk Mapping risks to activities Running the Analysis Reviewing the results Updated Plans Importing a new plan version Comparing plans Tracking progress Trend analysis Analysing Updated Plans Using updated plans Synchronising uncertainly and risk Rerunning analysis

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

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

Introduction to Diabetes (2-Day Course) - Norfolk ICB OnlyThis course is for those from the Norfolk ICB only using the unique booking code. Applicants not using this code nor Identifying themselves as Norfolk ICB employees will not be able to attend.Course Description:These two days of comprehensive training are designed for nurses, nurse associates, pharmacists, paramedics, and other Allied Healthcare Professionals (AHPs), and experienced healthcare assistants (HCAs) who are new to or fairly new to the field of diabetes care. If you've recently started seeing patients with diabetes, or are planning to; this course is tailored to provide you with the fundamental knowledge and skills required to confidently care for individuals with diabetes. The primary focus is on adults with Type 2 diabetes, although key recommendations and signposting for patients with Type 1 diabetes will also be covered.Diabetes presents a significant healthcare challenge, costing the NHS £10 billion each year and impacting patients and their families. Primary care professionals play a pivotal role in managing the ever-increasing numbers of people diagnosed with Type 2 diabetes. Good diabetes care is crucial and aligns with national and local policies supported by robust NICE guidance.These interactive days of learning will incorporate various methods, including case studies, to help you progress from basic knowledge to a more confident and positive approach in reviewing and managing patients with diabetes. 2 Day Introduction to diabetes management in primary care (This is intended to provide an overview the programme may change slightly) DAY ONE 09.15 Coffee and registration 09.30 Introduction and course objectives 09.45 Setting the scene - screening, diagnosis, prediabetes, patho-physiology and symptoms, remission in Type 2 diabetes 10.45 Coffee 11.00 Type 1 Vs Type 2 Diabetes 11.20 Metabolic Syndrome and Diagnostic Criteria 11.45 Diabetes Prevention Programme 12.15 Managing Diabetes in Primary Care and Supporting Lifestyle 12.30 Lunch 13.30 Pharmacological Management of Type 2 Diabetes 14.30 Methods for Monitoring Glucose 14.45 Diabetic Emergencies (hypos, HHS and DKA) 15.15 Sick Day Rules 15.30 Action plan, evaluation, and resources 15.45 Close DAY TWO 09.15 Coffee and registration 09.30 Review progress since Day 1 09.45 Macrovascular Complications 10.15 Modifiable Risk Factors leading to CVD 11.00 Coffee 11.20 Cholesterol & Hypertension Management 12.00 Microvascular Complications 12.30 Lunch 13.30 Diabetes and Emotional Wellbeing 14.30 Case Studies 15.30 Q&A, Evaluations 15.45 CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the physiology of diabetes and differentiate between Type 1 and Type 2 diabetes.2. Discuss methods for diagnosing diabetes and provide information to individuals newly diagnosed with Type 2 diabetes.3. Describe approaches that support achieving remission in Type 2 diabetes.4. Explain basic advice related to a healthy diet, various dietary approaches, and carbohydrate awareness.5. Discuss the modes of action of commonly used non-insulin medications.6. Identify major complications that may arise in individuals with long-standing diabetes and measures to limit or prevent them.7. Describe key advice for patients regarding the recognition and appropriate treatment of hypoglycaemia.8. Discuss DVLA guidance concerning driving and diabetes.9. Explain the risks of acute hyperglycaemia and provide advice to patients on self-managing illness periods.10. Provide examples of referral pathways to other services such as weight management, secondary care, podiatry, structured education, activity, and psychological services.11. Describe the process of routine foot review and factors influencing diabetic foot risk status.12. Discuss local recommendations for the appropriate use of blood glucose and ketone monitoring.13. Explain the key components and processes of an annual diabetes review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective diabetes care within primary care settings.

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

Calling all aspiring filmmakers and film enthusiasts! Join us for an engaging taster session on filmmaking, specially designed for students like you. Led by BA Practical Course Leader Devon Dickson, this session aims to explore the art of creating films that go beyond traditional performances and instead capture evocative and unforgettable cinematic truth. Discover how visual narrative can unlock your unique voice as a filmmaker. Devon Dickson, an accomplished writer, producer, and director with over 25 years of experience, will share his valuable insights gained from working on feature films, television shows, and over 300 commercials across 30 countries. His work has reached billions of viewers worldwide, making him a remarkable mentor for budding filmmakers. During this taster session, you'll delve into the philosophy and principles that form the foundations of our teaching here at Central Film School. Through practical examples and captivating case studies, you'll witness how this innovative approach to filmmaking can elevate your creativity and storytelling skills. Whether you're a film student, a passionate movie lover, or simply curious about the art of cinema, this taster session promises to be an inspiring and educational experience. No prior experience in filmmaking is required, so all students are welcome to attend. Don't miss out on this unique opportunity to learn from one of the industry's most experienced professionals. Reserve your spot now and embark on a journey to unlock your unique voice in filmmaking!

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 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 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation. This programme provides staff with the basic skills they need to sell. This course will help participants: Profile customers Research and identify potential new customers Use the consultative sales process Build effective rapport with customers Identify customer needs through effective questioning and listening Position products and services effectively Close the sale or gain commitment to further action Manage their customer portfolio to maximise sales 1 Introduction Aims and objectives of the training Personal introductions and objectives Self-assessment of existing sales skills Overview of content 2 Knowing your customers Who are your customers, and what do they want from you? What are your strengths, compared to your competitors? Who are your new potential customers? How do you communicate with new customers? What do you need to know about your customers before you start to sell? Making the initial approach Planning your pipeline - keeping the customers coming 3 The four-step sales process Overview of the consultative sales process Key benefits of using the consultative sales process Focusing on behaviours not targets The behaviours of a good salesperson Common pitfalls and mistakes Personal strengths and weaknesses 4 Building rapport First impressions - Mehrabian theory of communication Short cuts to building rapport Looking out for clues as to how the customer is thinking Looping back to keep the conversation flowing Acknowledging past communication Dealing with emotions such as anger Setting the agenda to keep control Getting past gatekeepers 5 Questioning and listening How to ask open questions to uncover information Left brain questions When closed question can be useful What stops us listening? The four levels of listening How to develop your listening skills 6 Presenting products and services to customers When to present Using benefits not features Making it personal Using reciprocity The tendency towards the middle Using consistency 7 Gaining commitment Testing the water Dealing with objections using ACLEO Asking for the business Getting referrals Ending with a personalised close Following-up 8 Managing your customer pipeline Spotting opportunities for cross-sales Managing your portfolio Maximising sales proactively Review meetings Customer satisfaction measures and surveys Mystery shopping 9 Putting it all together Skills practice Personal learning summary and action plans

Overview Understand the role of corporate structure, dividends and equity indices in equity markets. Become familiar with the building blocks of repos / stock lending, futures and forwards – and how to use these products. Understand how to price, and risk manage equity swaps and dividend swaps. Gain experience in their uses in trading, corporate finance and portfolio management. Learn how to price equity options and the features that make them different from other asset classes, explore how to use these products for taking equity risk, yield enhancement and portfolio protection. Understand strategies designed to trade / hedge volatility using options. Who the course is for Risk management Finance Sales and trading Treasury Technology Financial Engineering Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

DOG BEHAVIOUR At Cheshire Dog Services, emphasis is placed on modification of the dog’s behaviour through non-coercive and non-aversive methods. While basic training is a component of any behaviour modification program, it is likely you require assistance in devising a course of action that will help you and your dog successfully overcome any problems that arise during your dogs’ lifetime. Plenty of the problem behaviours that dogs’ develop can be a result of an owner’s misunderstanding of their dogs’ behaviour and can make matters worse when responding in an inappropriate way. Harsh methods can deteriorate your relationship with your dog and build distrust on both sides so using aggression to cure aggression does not work. Many nuisance behaviours or aggression problems are often very normal dog behaviours, therefore using harsh or aversive tactics to remove these undesirable actions are unwarranted and only delay in “fixing” the problem in the first place. Helping you understand dog psychology can give you the foundation to a happier life together! Glyn has a diploma (merit pass) in Advanced Canine Behaviour from the esteemed British College of Canine Studies. Are you experiencing problems with your dog such as: Jumping up Object guarding or stealing Aggression to other dogs, children & strangers Over guarding of you or your house Fear / nervousness / anxiety Excessive barking Getting into the car Barking at people or cars Behaviour Modification takes into account: Ensuring the Health & physical wellbeing of your dog. (physical health – diet, rest, exercise, medical illness ) & emotional wellbeing. Setting the dog up for Success – Avoiding putting the dog in a situation where he/she is likely to fail. Desensitisation & Counter Conditioning – presenting less threatening versions of the triggering stimulus & pairing it with things the dog enjoys. Positive Reinforcement / Differential reinforcement of Alternative Behaviour – teaching other skills the dog can do instead of the unwanted behaviour. Please contact us with the behaviour problems you are encountering and we’ll review what’s involved to help you. We would normally like to carry out a visit to your home, discuss the issue on full, meet your dog and set out what we need to do to help you. At this stage, we’ll set out costs involved as I’m sure you can understand that some behavioural issues can take longer to resolve than others. We would normally like to carry out at least one follow up visit and will provide you with a written report too. Please contact us for prices (they vary depending on what’s required)