It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans
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
In our constantly changing environment, if you always do what you've always done, then you'll always get what you've always got - and that's not enough! Building a strategic marketing plan is a powerful way to take a step back from day-to-day activities, review the opportunities available to your business and your products, and build a roadmap of tactics that will set you apart from the competition. In this workshop, we look at how to build a customer-focused strategic marketing plan to pin-point your milestones to success over a 12-month period. This programme will help participants to: Understand the key questions that a strategic marketing plan should answer Understand the value of customer and competitor insight and how to develop actionable insights to guide your plan Conduct a market analysis and identify the barriers and drivers to success Learn how to build a customer buying journey and how to identify the most valuable customers Develop a customer-focused strategy and customer engagement plans Develop core messages and winning tactics to engage with your key customers Identify the key metrics to review and measure to keep your plans on track 1 Situational analysis Introduction to marketing strategy Market and competitor analysis and insight generation Understanding the customer buying journey How to segment customers to identify your most valuable customer opportunities Identifying the barriers and drivers to your success 2 Strategy Introduction to strategy How to build strategic imperatives and SMART objectives How brand vision and positioning drive customer focus A guide to building key message themes 3 Tactics, messaging and measurement Introduction to building customer-focused tactics How to build a customer-engagement plan How to build key messages and a customer-focused tactical plan A practical guide to developing key metrics to review success and keep your plans on track Actionable outcomes Throughout the programme we will use your own product examples to build your plan, participants will: Learn best practice examples of strategic planning Discover market and customer opportunities to strengthen your competitive edge Create a strategic plan that can be implemented immediately within your business Start planning compelling marketing messages to reach the right customer at the right time Receive immediate feedback on your strategic marketing plan Have the opportunity to share common issues and solutions with colleagues in the group
Successfully closing a sale and negotiating the best outcome for the business is a key skill for all salespeople, and often an area that is overlooked. Investing in this skill will have a positive impact on interactions with customers, both new and existing, and lead to improved sales performance. Whilst understanding how to reach a conclusion with a customer faster means increased efficiency and more time to invest in sourcing new business. We have developed this programme to be practical, fun and interactive. Participants will learn proven techniques for influencing, persuading and negotiating with clients, gain increased confidence and clarity when reviewing contract terms and prices, and understand how to structure and manage sales negotiation and contract review meetings. This course will help participants: Learn a structured and proven approach to the negotiation of contract terms Apply the key principles of negotiation, playing the person and the problem Create a contract negotiation strategy - from opening to close Recognize and put to use proven negotiation tactics and techniques Learn how to embrace conflict positively - to 'say no, then negotiate' Plan and prepare for any commercial negotiation conversations Understand the stages of negotiation and how to move through them 1 Closing and negotiating from a position of personal power The eight steps of a sales or commercial negotiation Ten ways to resist price pressure How to draw on sources of power when you have less authority The six principles of influence and persuasion and how to use them 2 Effective negotiation - planning and theory How to plan and structure your negotiation for a successful and quick conclusion Influence: knowing how to 'push or pull' to win an argument Achieving a BATNA - a range of practical skills and techniques Case study: planning for a client negotiation around contract or price issues 3 Effective closing and negotiation - practice and reality Higher-level questioning techniques to investigate and solve problems Listening to lead - active listening and structuring your conversation The most common 'unforced' negotiation mistakes and errors Case study: setting objectives, sources of value, trading concessions 4 Sales negotiation tactics and playing the game How high - how hard - how soon; why now How to identify hidden or perceived currencies and values How to use these to establish a higher base price Negotiation best-practice checklist and summary
Sage Payroll Training Course - Fast Track This course brings you the skills you need to use this popular payroll program to confidently process any businesses payroll. Being able to use Sage 50 Payroll should lead to greater productivity. But it also helps the business conform to employment legislation and data security requirements. Furthermore, broken down into practical modules this course is a very popular and well received introduction to moving from manual payroll to computerised payroll. Moreover, it incorporates all the new government requirements for RTI reporting. Finally, Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. You will receive a CPD Completion certificate from Osborne Training once you finish the course. What skills will I gain? In this course you will be learning from Level 1 to Level 3 of Sage Computerised Payroll which could help you to land on your dream job in Payroll sector. Level 1 Introduction to payroll Introduction to Real Time Information (RTI) Preparing employee records Starters - new employees Calculation of Gross Pay The PAYE and National Insurance systems Creating Payslips and analysis Creating Backups and Restoring data Payment analysis Processing National Insurance contributions Voluntary deductions Processing Leavers Completing the payroll Procedures Level 2 Introduction to Payroll Introduction to Real Time Information (RTI) Preparing employee records Creating Backup and Restoring Data Starters - new employees Calculation of Gross Pay Deductions - Pension schemes and pension contributions Processing the payroll - introduction to the PAYE system Processing the payroll - income tax National Insurance contributions - Processing in the payroll Voluntary deductions Student Loan repayments Attachment of Earnings Orders & Deductions from Earnings Orders Processing Leavers Introduction to statutory additions and deductions Processing Statutory sick pay (SSP) Processing Statutory Paternity Pay (SPP) Statutory paternity pay and paternity leave Completing the processing of the payroll Creating Payslips and analysis Reports and payments due to HMRC Level 3 Advanced processing of the payroll for employees Preparation and use of period end preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Payroll Giving Scheme processing Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay
Maximising the relationship and sales potential of each active account is key to the sustainability of any business relying on repeatable custom. In this workshop we start by looking at key techniques for analysing the profitability and development opportunities for different clients before deciding upon the strategy and skills needed for moving the relationship to that of trusted adviser and partner. By understanding and creating the need we can use our influencing skills to harness any sales development potential. By creating the habit of explaining our ideas in a way that also meets the need of the other party we help everybody make the right decisions for them. This course will help participants: Assess the sales profitability and potential of existing key accounts Prioritise where time and energy is directed for maximum profitability Understand the key players in the decision making unit Create a strategic plan for the development of each client target Develop proactive sales consultancy skills Learn advanced communication and influencing techniques 1 What makes an effective account manager? The difference between order taking and account management How do you define a key account in your business? Why should existing customers remain with your company? How do you compare to the competition? 2 How do I prioritise my account management activity? Use practical tools to help you assess revenue potential Analyse the investment required versus the return on your time Create a SWOT analysis on your clients - Strengths, Weaknesses, Opportunities & Threats Appreciate how this knowledge will improve your sales development 3 Planning strategies for each account Create a list of priority accounts and activities Learn how to develop a long-term and sustainable relationship Discover how they make their purchasing decisions Research the make-up of the Decision Making Unit for each client 4 Learning and utilising the six principles of influence Learn the secrets these principles offer sales people Discover how these principles will work for you Create an influencing strategy for influencers within the client Learn new habits of influence 5 Proactive sales skills Plan proactive sales meetings for key accounts Set primary and secondary objectives for every touch point with the customer Structure sales meetings for maximum effectiveness Help the customer commit and achieve their objectives 6 Putting it into practice Discuss real scenarios to plan for putting these skills into practice Share common issues with fellow sales people Create a personal development plan
Payroll Accounting Training Fast Track (Level 1-3): This course brings you the skills you need to use this popular payroll program to confidently process any businesses payroll. Being able to use Sage 50 Payroll should lead to greater productivity. But it also helps the business conform to employment legislation and data security requirements. Furthermore, broken down into practical modules this course is a very popular and well-received introduction to moving from manual payroll to computerised payroll. Moreover, it incorporates all the new government requirements for RTI reporting. Finally, Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. In this course, you will be learning from Level 1 to Level 3 of Sage Computerised Payroll which could help you to land your dream job in the Payroll sector. As Osborne Training is a Sage (UK) Approved training provider, you could gain the following qualifications provided that you book and register for exams and pass the exams successfully: Sage 50c Computerised Payroll Course (Level 1) Sage 50c Computerised Payroll Course (Level 2) Sage 50c Computerised Payroll Course (Level 3) All exams are conducted online through Sage (UK). Level 1: Introduction to payroll Introduction to Real-Time Information (RTI) Preparing employee records Starters - new employees Calculation of Gross Pay The PAYE and National Insurance systems Creating Payslips and analysis Creating Backups and Restoring data Payment analysis Processing National Insurance contributions Voluntary deductions Processing Leavers Completing the Payroll Procedures Level 2: Introduction to Payroll Introduction to Real Time Information (RTI) Preparing employee records Creating Backup and Restoring Data Starters - new employees Calculation of Gross Pay Deductions - Pension schemes and pension contributions Processing the payroll - introduction to the PAYE system Processing the payroll - income tax National Insurance contributions - Processing in the payroll Voluntary deductions Student Loan repayments Attachment of Earnings Orders & Deductions from Earnings Orders Processing Leavers Introduction to statutory additions and deductions Processing Statutory sick pay (SSP) Processing Statutory Paternity Pay (SPP) Statutory paternity pay and paternity leave Completing the processing of the payroll Creating Payslips and analysis Reports and payments due to HMRC Level 3: Advanced processing of the payroll for employees Preparation and use of period end preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Payroll Giving Scheme processing Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay
Maximising the team's sales capability is the key aim for any sales manager. When sales people struggle to hit their targets, it falls to the sales manager to provide support and help colleagues to find their way again. One of the most effective techniques for sales managers to improve and maintain sales performance is by providing live sales coaching. Sales coaching encourages sales people to find their own solutions and take responsibility for their own development. This course will help participants: Develop people to fulfil their sales potential Provide motivational feedback Identify strengths and weaknesses of their team members Understand personal learning styles Identify and adapt for different personality styles Prepare and conduct on-the-job observations Motivate sales people to greater performance 1 How is sales coaching different from sales training? What is coaching? Discover how coaching empowers sales people Learn the best time to use sales coaching Decide which people should be coached first Creating a development plan 2 Understanding learning, behavioural and communication styles Use practical tools to help you assess individual styles Tap into the essence and energy of the person you are developing Understand your own learning, behavioural and communication preferences Develop a strategy to adopt for each member of your team Discover what motivates you and your salespeople to perform Appreciate how this knowledge will improve your sales conversion 3 Using the GROW coaching model Learn the secrets of a successful coaching session Discover the importance of SMART objectives and instructions Understand and capture what coachees are currently doing right Develop their problem-solving and decision-making skills Help your colleagues crystalise their plans and actions Provide follow-up opportunities to embed the learning 4 Giving motivational feedback Understand why effective feedback is so powerful in sales Learn key models for motivational feedback Discover how to manage and structure more difficult conversations Understand the power of positive reinforcement Encourage sales people to coach and support colleagues 5 Putting it into practice Use realistic scenarios to provide opportunities for practice Discover what it feels like to be coached Receive immediate feedback on your coaching style Share common performance issues with fellow sales managers Create a personal development plan 6 Preparing on-the-job observations and joint visits Build a strategy for coaching and team development Prepare an observation template for effective coaching Learn the key elements of preparation for your next coaching session Agree common areas to focus on with coachees 7 Action planning Personal action plans
We've all sat through far more bad presentations than good ones, but knowing what 'good' looks like is easier than successfully replicating it. Sales presentations are a performance and, as salespeople, fluffing our lines can cost us a lot more than hurt pride. Having discovered and understood the specific needs and burning issues our prospect has, then this course will help any salesperson avoid dropping the ball and instead wowing their prospects with a high-impact, tailored and compelling case for purchase. This course will help participants: Prepare mentally and physically for stand-up presentations Use voice modulation and bullet-pointing to demand attention Avoid boring their prospects Master the do's and don'ts of PowerPoint Deal more effectively with technical hitches and prospect's interruptions Use eye contact and engagement to avoid prospects 'tuning out' Deploy best practice essentials for presenting with colleagues Steer through the toughest Q&A 1 Preparing your presentation Mindset Knowing your objective(s) Vocal warm-up techniques Assembling pre-agreed benefits Time management Room set-up Technical preparation 2 How to open your presentation Vocal energy Summary and agreement of prospect's needs How to have posture and confidence Use of humour What to do with those dreaded hands Confident v non-confident body language 3 How to get and keep people's attention Bullet pointing Linking benefits to specific, stated needs Practical exercise - formulating and delivering tailored benefits Being selective with features Third party reinforcement and case studies 'Watering the garden' eye contact technique Practical exercise - participants practise 'sharing out' eye contact to audience How to handle a prospect's negative body language Handling interruptions 4 Presenting in groups Credentialing all participants Role delineation for group presentations Edifying other participants' messages - do's and don'ts How to maintain energy when not speaking Practical exercise - good and bad practice when not speaking Teamwork in Q&A sessions How to hand over professionally 5 PowerPoint do's and don'ts Use of visual aids Good and bad PowerPoint slides How to make PowerPoint work for you Classic PowerPoint errors Avoiding and handling technical problems Good and bad flipchart practice 6 Closing and / or achieving next action steps Power of summary Good Q&A practice Handling objections Practical exercise - handling objections on one's feet Creating consensus among prospect panel What to do when prospects disagree with each other When to trial close How to close on next action steps 7 Wrap-up Key learning points from each participant Action steps to be implemented on next presentations
This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review