117 Courses in Bradford

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

It is essential that those charged with responsibility for credit control and debt recovery have a full appreciation of the relevant law: no-one can negotiate effectively to recover a debt if they don't understand the ultimate sanctions they can apply. This programme is designed to give them a practical, up-to-date understanding of the law as it applies to your particular organisation. This course will help ensure that participants: Understand the relevant laws Know how and when to invoke legal processes Avoid legal pitfalls in debt collection negotiations Specific, practical learning points include: Definition of 'harassment' How to set up an in-house collection identity Whether cheques in 'full and final settlement' are binding The best steps to trace a 'gone away'... and many, many more. 1 Data protection and debt recovery There are a whole range of things which can be checked on members of the public and which are not affected by the restraints of the Data Protection Act. These will be explained in simple, clear terms so that staff can use this information immediately. 2 County Court suing The expert trainer will show how to sue for money owed, obtain judgment and commence enforcement action without leaving your desk. This module is aimed at showing how to make the Courts work for you instead of the other way around! 3 Enforcement of judgments There are many people who have a County Court Judgment (CCJ) against their debtor but who still remain unpaid. This session explains each of the enforcement methods and how to use them to best effect. Enforcement methods covered include: Warrant of Execution Using the sheriff (now known as High Court Enforcement Officers) Attachment of earnings Third Party Debt Orders Charging Orders (over property and goods) Winding-up companies and making individuals bankrupt 4 Office of Fair Trading rules on debt recovery Surprisingly few people are aware of the Office of Fair Trading rules on debt recovery and many of those that do know think they don't apply to them - but they do. Make sure you know what you need to! 5 New methods to trace elusive, absentee and 'gone away' debtors Why write the money off when you can trace the debtor and collect the money you are owed? 6 Credit checking of new and existing customers It makes sense to credit check would-be, new and existing customers to evaluate the likelihood of payment delays or perhaps not being paid at all. This session shows a range of credit checking steps, many of which can be done completely free of charge, including a sample credit application/ account opening form. 7 Late Payment of Commercial Debts Regulations Do your staff understand this legislation and how to use it to make people pay quicker than ever before? The trainer shows how. 8 The Enterprise Act The Enterprise Act made some startling changes to corporate and personal insolvency. What are the implications for credit control and debt recovery within your organisation?

Customers are astute and well-practised in researching and seeking information, solutions and added value in the minimum number of clicks online. There's only so much time they're willing to spend carrying on clicking. This mentality isn't just restricted to the world of B2C. In our increasingly hectic world, where information is expected to be available instantly, it applies just as much to B2B. In this workshop, we look at how putting yourself in the shoes of your customer and mapping their decision-making and buying journey is critical to ensuring that you provide what they perceive as fast solutions and added value. You will learn all about the three pillars for creating competitive brand experiences: Customer engagement planning puts you firmly in the shoes of your customer, helping you to build meaningful marketing communications delivered through the right resources at the right time to inspire your customers to engage with you. This programme will help participants to: Understand the evolution of the customer buying journey Map a customer buying journey for your brand or solutions Understand the customer micro-moments and signals indicating interest and buying intent, both online and offline Apply the psychology of branding to build marketing communications with impact Develop sales and marketing content that differentiates your brand(s) from the competition by demonstrating unique value and how you can meet your customer's needs 1 The evolution of the customer journey Understand how the use of mobile has had an impact on the customer buying journey where today's customers can research and compare products and solutions whenever and wherever they like, making the purchase journey even less linear Explore how marketers are adapting to this new customer behaviour and drawing upon various strategies to win the hearts and minds of their audiences 2 The See-Think-Do-Care framework Explore the many different frameworks used to track the customer journey Understand and apply the modern marketing model, where the internet has enabled the customer to hop between multiple touchpoints before making a purchase decision 3 Customer micro-moments and signals in their buying journey Understand the online and offline moments when customers seek information to research and make buying decisions Apply this understanding to build a marketing communication plan to reach customers at all stages of their buying journey 4 The role of branding in the customer journey Explore the psychology of branding Learn how to ensure your branding is relevant to your target customer needs Bring together your brand value and story to achieve brand loyalty 5 The Why-How-What framework Apply a systematic approach to build a successful and compelling brand Understand how starting with 'why' will help build your brand purpose Apply the content marketing matrix to communicate your brand's value Apply the hero-help-hub model to build engaging content marketing Actionable outcomes We will use your brand examples to provide opportunities for practice: You will learn and reflect on best practice examples of customer engagement You will discover your brand value, purpose and the 'sweet spot' to drive engagement with your customers You will create a customer engagement plan that can be implemented immediately within your business You will receive immediate feedback on your customer engagement plan You will have the opportunity to share common issues and solutions with your colleagues in the group

This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course

As a qualified crystal healer, I can come to your home and provide a 1hr crystal healing session.   We can work on any areas you may be aware of that require some attention. Or I can do a full body scan and assessment, free up an unbalanced energy flow within the body and bring everything back into alignment.   I can also free the body from any negative energies and restore positive balance and harmony within. These sessions are a fantastic way to relieve stress and promote healing. For more information or booking enquiries, please contact me here.

I offer private sound healing and sound therapy sessions on either a 1:1 or 2:1 (couples/friends) basis. I come to you and provide this service within the comfort of your own home. These sessions can be completely tailored toward your individual needs. Popular subjects I am often asked to concentrate on are stress relief, anxiety, grief, sleep issues, physical or emotional pain and/or discomfort, letting go of burdens that you no longer wish to carry, setting new intentions, re-energizing and recharging or just an ultimate relaxation sound journey session that will leave you feeling beautifully peaceful, calm and relaxed. My sessions include the use of sound and vibration, guided meditation, and aromatherapy.   I also offer chakra rebalancing sessions to restore the natural flow of energy within us using Tibetan body work bowls, gong, powerful crystals, and guided meditation.   For more information on these popular 1:1 or 2:1 sessions please get in touch.

LOVE SPELL

Jennifer Holloway delivers keynotes, workshops and webinars for clients, both online and in person (no public courses are run). Here’s a selection of existing sessions to give you a flavour of what’s available (though new ones are being designed all the time, so if you don’t see what you need, just ask): Personal Brand – What? How? Why? An introduction to the subject of personal branding, this session explains what a personal brand is, why you already have one and how to define it so you can remain authentic at all times. Delivered as a 45-minute or 60-minute session x People Buy People – So Who Are You Selling? You want people to buy your personal brand…but what exactly is it? This session challenges people to think in a new way about what they bring to the table and what makes them tick, kicking off the process of defining their personal brand. Delivered as a 90-minute or 120-minute session x Discover Your Personal Brand When you really dig into the detail of not just what you offer but who you are, that’s when you discover your unique selling point. This session provides a step-by-step process to highlight your individuality and put it clearly into words. Delivered as a half-day or full-day session xx Deliver Your Personal Brand With Impact Every time you come into contact with people – whether online, on the phone or in person – they’re picking up clues about you. This session shares practical tips and techniques to ensure those clues create a positive impression. Delivered as a 120-minute or half-day session x Articulate Your Achievements To get the most from your personal brand you have to shine a light on the value you bring, but if you can’t communicate what that value is, you could be missing out. This session provides an easy-to-follow formula to set out your credentials in a subtle, yet very effective way. Delivered as a 60-minute or 90-minute session x How To Create A LinkedIn Profile To Be Proud Of Many of us have a LinkedIn profile, but how many of us are 100% certain it’s creating a positive impression? This session focuses on how to polish up your photo, headline and summary to get you noticed for the right reasons. Delivered as a 45-minute or 60-minute session x Networking For People Who Need Help Networking Some people are natural networkers – meeting people and building relationships with ease – but many feel less confident, unsure how to kick-start the process. This session offers easy-to-implement tips for connecting both in-person and online. Delivered as a 45-minute or 60-minute session And for those wanting an in-depth approach to developing their personal brand: Making The Most Of Your Personal Brand This programme delivers the full-monty: from learning what a personal brand is, to defining what your own brand is, to getting feedback on how others view your brand, to learning how to share your brand both in person and online. x It’s restricted to smaller groups, so every delegate gets individualised support, advice and feedback, plus it fosters an open and collaborative environment for each cohort. Delivered as blend of in-person and online learning, or entirely online

Overview This course covers distressed debt analysis and investing, focusing primarily on corporates but also including financial institutions and sovereign debt as special topics. The programme begins with the foundations of the distressed debt market, causes of and early warning signals, possible outcomes and how to evaluate the probability of outcomes in different scenarios. Restructuring is reviewed in detail, as well as estimation of sustainable debt levels, business valuation and the importance of capital and group structure. Differences between active control and passive non-control investments are highlighted, including stakeholder tactics and due diligence. Case studies cover a variety of companies across sectors and geographies, challenging delegates to make investment decisions on real distressed debt situations. Who the course is for Distressed debt investors, Loan portfolio managers and Private equity investors Hedge fund managers High yield credit analysts and Equity analysts High yield asset managers and Mergers and acquisitions bankers Debt capital markets/leveraged finance bankers Business turnaround/restructuring accountants/corporate finance professionals Lawyers Strategy consultants 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

NPORS Plant Loader Securer Training The NPORS plant loader securer training course is intended for delivery drivers who operate plant equipment to load on to delivery vehicles, additionally for workers who are responsible for securing the plant using various securing equipment. Unsafe loads on vehicles injure more than 1,200 people a year and cost UK businesses millions of pounds in damaged goods. There has been an increasing number of accidents involving mobile plant during loading/unloading or during transportation resulting in fatalities. In line with recommendations from the Safety of Loads on Vehicles from the Department Of Transport, the course will provide both theoretical and practical training to ensure candidates are able to carry out the duties of Plant Loader Securer. NPORS is an approved CSCS Partner Card Scheme, providing evidence that individuals working on construction sites have the appropriate training and qualifications for the plant loader securer duties. Furthermore, training criteria is based on the approved standards of the Construction Leadership Council. Visit our page; The Art Of Securing Loads Experienced operator – NPORS Plant Loader Securer Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Plant Loader Securer Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Plant Loader Securer Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Plant Loader Securer Test is for operators who have received some form of training in the past or alternatively has been operating the Plant Loader Securer for several years. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. Discounts are available for multiple bookings There are two parts to the plant loader securer test, a theory section comprised of 25 questions and a practical session. Plant Loader And Securer Course Objectives Plant Loader and Securer Training covers: Legislation: All relevant health and safety and current legislation and British Standards Loading: Load or guide items of plant onto a transporter. Position items of plant on the transporter to ensure no overloading of transporter axles. Ensure integrity and security of items of plant plus attachments using a range of restraining equipment Preparations: Prepare an area for the purposes of loading and unloading construction plant. Prepare a transporter for receiving different items of construction plant, which must include tracked, wheeled and roller types. Agree and give appropriate signals to the plant operator. Check equipment prior to operations Travel: Prepare a transporter for road travel. Ensure intended route of travel is compatible with load weight, width and height. Explain the specific requirements of current legislation for equipment designed for transporting construction plant. State the requirements to be undertaken when loading and unloading plant on the public highway. Plant Loader Securer Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the loading and securing and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury, however this course must be on your site. With its own purpose-built practical training area to simulate an actual working environment. Our Loader Securer training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Plant Loader Securer Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. Who should take the Plant Loader Securer Training? This training is intended for delivery drivers operating plant equipment to load onto delivery vehicles and workers responsible for securing the plant using various securing equipment. 2. What does the Plant Loader Securer Training cover? The course covers legislation, load and guide items of plant, preparing areas for loading/unloading, securing equipment, preparing transporters for road travel, and ensuring compliance with safety requirements. 3. How long is the Plant Loader Securer Training? For novice operators, the training lasts 2 days. Experienced operators can take a 1-day test. 4. What certification do I receive upon completion? Participants receive an NPORS card, either the traditional card valid for 5 years or the NPORS card with CSCS logo, valid initially for 2 years. 5. Are there any prerequisites for the Plant Loader Securer Training? Candidates must have a good understanding of English. For the NPORS card with CSCS logo, a CSCS Health & Safety test must have been completed within the last two years. More courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. For those looking for a “NPORS Plant Loader Securer Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK