2626 Courses in Berkhamsted

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

Recognising the value of, and practising, clear and open communication at all levels is the first step to improving performance, whether at an individual, team, management, leadership or organisational level. We all know this, but why is it so difficult? This unique programme will make it much, much easier for you by giving you a robust framework to use - and the opportunity to practise your skills in a safe, supportive environment. It will help you have conversation that deliver tangible results. The programme will help you: Overcome the barriers to effective performance conversations Handle feedback conversations effectively Improve working relationships with your staff Set realistic expectations and targets (and get 'buy-in' for them) Improve your communication style Plan and prepare for honest conversations in the workplace 1 What is an honest conversation? Why don't we have them more often? What stops us? The cost of not having them 2 The feedback conversation Dealing with the impact of feedback conversations 3 Preparing for conflict 4 Effective working relationships 5 The expectations conversation 6 The targets conversation 7 Your communication styles 8 Planning and preparing for an honest conversation 9 Giving and receiving feedback skills

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

This course follows the Institute of Occupational Safety and Health's syllabus. A one-day programme, it is suitable for all people at all levels in the workplace and gives a basic introduction to the principles of environmental management. On successful completion of the course, participants will be able to: Understand the terms 'environment' and 'pollution' Understand the terms 'hazard' and 'risk' related to the environment Better appreciate environmental issues generally, and specifically in respect of their organisation Identify hazards to the environment from working practices Outline the procedures/controls necessary to prevent damage to the environment 1 What is the environment? - putting the environment in context Key environmental issues and how we contribute Definition of the environment 2 Working with the environment What is pollution? Sources, receptors and pathways Environmental consequences workshop - identifying the environmental consequences of our working practices Environmental risk assessment Effective control mechanisms 3 Protecting the environment - Environmental Management Systems What is an Environmental Management System (EMS)? What are the benefits of having an EMS? EMS structure and models Identifying what elements of EMS your company has and how they work Roles and responsibilities 4 Choice of module Option 1: Organisation-specific moduleThis module can be used to introduce environmental concepts that are specific to your activities and operations, and will be compiled through discussion with your organisation Option 2: Environmental best practiceIf no organisation-specific module is required, or if participants from a number of organisations attend, generic operational environmental best practices can be covered instead. Areas covered include waste management, fuel storage and use, hazardous materials, emissions to air and water and environmental incidents

Happiness? Are you serious? I'm struggling enough as it is! Not a nice feeling is it, when things aren't going well? But you push on regardless. Now you tell me, how's that strategy going? What are the consequences of that? Discover the hard facts about long-term success and resilience. This inspirational but hard-hitting presentation will give you the inside track on motivation, success and, yes, what it's got to do with happiness. No ten-point magazine-checklists to brighten your day, that change nothing. Just the straight physics of happiness.

The CIEH Foundation Certificate in Occupational Health and Safety supports businesses in their legal obligations to ensure employees are protected from harm. This course is ideal for those who want to develop their knowledge of health and safety issues in the workplace and of the regulations for maintaining a healthy and safe working environment. This course will focus on common hazards and how to control them. It will help you work more safely and be more aware of how your own actions can affect the health and safety of others.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

Budgeting is more than mere vague oversight. Budgeting should deliver the corporate strategy, add shareholder value and lead to a well-run business - for the benefit of all involved in it. Effective budgeting leads to real control - effective day-to-day operational control and more. This course demonstrates what proper budgeting and operational control can do. This course will help ensure that participants: Appreciate the importance of the budgeting process Take ownership of it Use it as a daily working tool - not an annual exercise - to help run their part of the operation Improve their reporting against budget Ensure their delivery against budget 1 Objectives of budgets The budget process Stages - what is the prime aim of a budget? What is forecasting? ObjectivesPlanningImplementation 2 Budget and cost control focus Choosing objectives Links with corporate strategy Links with resource management Can the accounting systems cope? 3 Traditional budgeting and control Benefits and drawbacks The process Control and feedback Reporting - what can be expected? 4 Advanced budgeting and control Understanding the business process Taking out costs Cost awareness ZBB - as valid as ever 5 Reports Reports for action The purpose of a report Content - deliverables and feedback Culture is so important

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?

This programme concentrates on the core planning skills needed to develop sound practical project plans in a team environment. This enables the plan to be modified should requirements change or difficulties arise. The programme also gives participants the confidence to practise those skills and apply them in the work environment and deliver their projects more successfully in the future. Participants learn fundamental project management concepts and terminology, demystifying the project management process, and, in particular, how to: Break a project down into manageable sections and ensure nothing is left out Understand and apply estimating techniques to develop realistic estimates Sequence work effectively and carry out critical path analysis to determine project duration and which tasks to pay closest attention to Manage project risk effectively to protect project value Monitor, control and re-plan the project to best keep it on track Close out the project and ensure the project comes to an orderly end 1 Introduction Self-introductions and personal objectives Course objectives Sharing of project issues 2 Project management concepts Characteristics of a project and what should be kept as operational responsibilities Understanding the triple and quadruple constraints - and their limitations Prioritising requirements through the MOSCOW technique Product v project life cycle Key project roles and responsibilities - the importance of sponsorship and clarity of roles 3 Starting a project, and the importance of the terms of reference / project brief Avoiding the pressure to 'just do it'! The importance and benefits of planning The best time to learn! Initial project documentation - the BOSCARDI approach 4 Breaking the work down Understanding alternative breakdown structures such as the product breakdown structure and work breakdown structure Guidelines for creating a work breakdown structure to ensure the full work scope is identified 5 Estimating Alternative estimating techniques and associated confidence levels Further considerations - loss and resource factors 6 Organising the work Use of network diagrams to develop a clear sequence of work Critical path analysis and calculating the project duration and task float - and usage 7 The management of project risk Understanding the nature of project risk The risk analysis and risk management processes How to best manage threats and opportunities Running a risk workshop Using the risk register 8 Scheduling the work The importance of the Gantt chart and understanding its limitations The Gantt chart layout and using alternative views such as the tracking Gantt Using alternative dependencies 9 Resource issues Assigning resources and resolving resource overloads Crashing and fast-tracking your project and potential issues to look out for 10 Controlling the project The control cycle and alternative feedback mechanisms Alternative progress reporting Assessing the impact The importance of re-planning The benefits of control Change control - the importance of impact analysis The steps of change control and the use of the issue register 11 Closing the project The project closure checklist Reviewing the project - things to avoid Developing meaningful lessons and ensuring they are applied effectively The post-project review - its importance to the organisation