2184 Courses in Sheffield

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: * Develop a clear and consistent process for new business development and lead-generation * Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' * Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals * Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach * Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities * Develop an engaging telephone voice and manner - and a 'networking personality' * Qualify potential opportunities with more accuracy on a consistent basis * Prioritise opportunities and manage their time when sourcing new business * Discover online sources of leads, contacts and referrals * Overcome psychological blocks to cold or warm calling - theirs and the client's * Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy * Make outbound sales or appointment calls with improved confidence, control and results * Improve the conversion of calls to appointments by using more effective questions and sales messages * Get past gatekeepers and assistants more effectively * Make the most of your CRM software and systems 1 ONLINE MARKETING - WHAT WORKS! * Workshop overview and learning objectives * Choosing your social media channels * LinkedIn for sales and marketing * Designing and implementing an effective new business email campaign online * Creating a lead-generation strategy online - with case studies * Avoiding common mistakes in social media marketing * Case study: 'Best practice in social media sales and marketing' * Using blogs and video-based marketing (eg, YouTube) * New trends and how to keep your finger on the 'social media' pulse * Twenty essential websites and online marketing tools 2 MAKING APPOINTMENTS BY TELEPHONE * Planning the call, telephone techniques, integrating with email and online marketing * Developing a clear and consistent process to appointment-making * Setting and achieving the right level of telephone activity to achieve your appointment goals * Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach * Overcoming the most common 'put-offs' to seeing or engaging with you * Overcoming psychological blocks to cold or warm calling - yours and the client's * Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy * Making outbound sales or appointment calls with improved confidence, control and results * Improving conversion of calls to appointments by using more effective questions and sales messages * The five keys to developing an engaging telephone voice and approaching manner 3 POWER NETWORKING * Strategies for networking and B2B referral-based marketing * The importance, and different types, of networking * How to work a room - preparation and strategy * Communication dynamics in networking - the power of the listening networker * Assumptions when networking * Business networking etiquette * Making connections, asking for cards, contact details and referrals, gaining follow-up commitments * Building relationships - follow-up and follow-through 4 DEVELOPING NEW LEADS * Strategies for first-time sales calls * Gaining rapport and opening first-time and new business sales calls effectively * Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences * Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal * Value message - differentiate your solutions clearly and accurately, with tailored value statements * Presenting the right initial USPs, features and benefits and making them relevant and real to the customer * Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price * Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 ORGANISED PERSISTENCE - CRM AND PROSPECT-TRACKING * Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management * Maintaining a good database for maximising new business ROI * Developing a contact strategy with different types and levels of contact * Analysing your contact base using state-of-the-art software and tools * Making the most of your CRM systems and solutions * Understanding that your attitude makes a difference when sourcing new business * Setting SMART objectives for new business development and lead-generation * Practical exercise - setting personal development and business goals * Time management tips to improve daily productivity * New business pipeline management strategies for peak sales performance 6 WORKSHOP SUMMARY AND CLOSE * Practical exercise - developing your new business action plan * Review and feedback

This highly practical one-day workshop has been designed specifically to help maximise sales where customers make contact by telephone. When customers contact us direct they have clearly already considered the possibility that they might buy from us, but we're still only half-way to making a sale. Unless we fully understand their needs and make it easy for them to buy, we may not secure the business. This workshop concentrates on the telephone skills and techniques needed to achieve the most positive outcome in any inbound customer call. A combination of excellent customer service skills and savvy sales awareness techniques will increase our chances of a successful outcome for both parties. The programme features the unique INBOUND model, to help remember the key principles for effective inbound telephone sales: Initial impressions Needs of the customer Bring them with you Open up the conversation Understand the triggers Narrow down the solutions Decision time! The programme also covers how to deal with difficult calls and challenging people - after all, every complaint is a sales opportunity! This programme will help participants: * Create the perfect interaction with any customer making contact by telephone * Make every call count * Build rapport quickly in any situation * Handle difficult calls and challenging people * Create sustainable and profitable relationships * Increase your sales conversions 1 THE INBOUND SALES PROCESS * Each customer who contacts us will be at a different stage of the sales process. Some might be making general enquiries whilst others will be ready to commit, having made most of their decisions already. Sales and customer service people need to be ready to find out the stage the customer has reached before helping them to make the right decision for them 2 ENGAGING WITH THE CUSTOMER * Having clarified where the customer is on their journey to making a purchasing decision, our next responsibility is to create and build a trusting relationship on both sides. This involves establishing rapport quickly to ease the communication process, thus enabling smooth transactions, both now and in the future 3 QUESTIONING AND LISTENING SKILLS FOR GATHERING INFORMATION * Developing these skills requires practice so that the communication becomes natural for the customer. This helps the customer to feel comfortable with us and work with us towards an effective solution. We discuss different types of question and how to use high-gain questions to uncover key information. Active listening will ensure that we can really help customers get what they need 4 OVERCOMING OBJECTIONS AND EXCUSES * If we have followed the process properly and really understood the customer, then there should no further objections or barriers to completing the transaction. The reality is that there will still be the occasional issue that needs clarifying, so we need to prepare for possible objections and questions that customers might have. This includes probing objections so that we fully understand the customer's perspective before constructing suitable responses or solutions 5 GAINING COMMITMENT AND ENDING THE CALL * Customers want to gain a solution to the issue they are facing and the sooner we can help them achieve that the better. Guiding the customer and helping them to believe in their own decision is part of our role. This section is dedicated to getting commitment all the way along the process, not just at the close 6 DEALING WITH DIFFICULT AND CHALLENGING SITUATIONS * The realisation that everybody is different, with different personality types, different ways of looking at the world and different goals, is key to understanding sales. With this is mind we discuss these differences and how we adapt our approach to ease communication and maintain trust and understanding 7 ACTION PLANS * Course summary and presentation of action plans

The market for professional services is becoming increasingly competitive, with some firms and individuals becoming very effective at winning new work, leaving others lagging way behind. Given the choice between spending time on client work and business development work, we all tend to choose that which we feel to be easier, more attractive and more aligned with our image of ourselves. We stay within our comfort zones, we focus on client work, and we only resort to business development work when we have to, which can also lead to 'feast or famine' syndrome. The programme will help participants: * Understand the professional business development approach and the style that is appropriate for their business and their clients * Follow a process to guide their conversations and business development meetings * Prepare thoroughly for a business development meeting/contact with a client to ensure they use their time efficiently and maximise results * Create a great first impression and professional opening to a conversation * Ask open questions and listen effectively in order to spot opportunities, understand needs and progress the opportunity * Identify and understand buying and decision-making processes and criteria * Skilfully and confidently handle questions and objections * Sell the benefits of their services and approach over those of their competitors * Progress the sale by agreeing next steps and gaining commitment appropriately 1 INTRODUCTION * Aims and objectives of the programme * Personal introductions and objectives * Workshop overview 2 AN INTRODUCTION TO BUSINESS DEVELOPMENT AND SELLING FOR PROFESSIONALS * What is selling? * Who are you selling to? * The buying experience * What clients want * The four-step business development process * The business development cycle and pipeline management * Upselling and cross-selling as well as winning new clients 3 NETWORKING AND GENERATING LEADS * What is networking? * Networking objectives * It's not what you know but who you know * Asking for referrals and introductions * Making appointments from networking activity 4 OPENING THE SALES RELATIONSHIP/SALES MEETING * What potential customers are thinking * Judging first impressions * Creating positive first impressions * Building rapport and creating interest and impact * Earning the right 5 CORE COMMUNICATION SKILLS FOR PROFESSIONAL SELLING * Overcoming barriers to listening * The art of listening * Questioning refresher * Types of questions * Questioning funnel 6 UNDERSTANDING AND IDENTIFYING NEEDS AND OPPORTUNITIES * Identifying the questions to ask to identify needs and opportunities * Questions to move us through the buying and selling process * Understanding their buying processes * Asking questions that position you as a 'trusted adviser' * The questions that give you a competitive advantage * Knowing when you have asked enough questions 7 INTRODUCING SOLUTIONS * Tailoring your 'pitch' to the client * Speaking the client's language * Using features and benefits * Applying the benefit cycle 8 HANDLING OBJECTIONS AND CONCERNS * Identifying the typical objections and concerns * Understanding why clients raise objections and concerns * Following a structure for handling objections * Handling the price objection 9 GAINING COMMITMENT * Knowing when to close * The art of checking * Recognising buying signals * Small c and big C 10 PUTTING IT ALL TOGETHER * Personal learning summary and action plans

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 GETTING STARTED * The Power BI process * Launching Power BI Desktop * The four views of Power BI * Dashboard visuals 2 CONNECTING TO FILES * Connect to data sources * Connect to an Excel file * Connect to a CSV file * Connect to a database * Import vs. DirectQuery * Connect to a web source * Create a data table 3 TRANSFORMING DATA * The process of cleaning data * Column data types * Remove rows with filters * Add a custom column * Append data to a table * Fix error issues * Basic maths operations 4 BUILD A DATA MODEL * Table relationships * Manage table relationships 5 MERGE QUERIES * Table join kinds * Merging tables 6 CREATE REPORT VISUALISATIONS * Creating map visuals * Formatting maps * Creating chart visuals * Formatting chart * Tables, matrixes, and cards * Control formatting with themes * Filter reports with slicers * Reports for mobile devices * Custom online visuals * Export report data to Excel 7 THE POWER QUERY EDITOR * Fill data up and down * Split columns by delimiter * Add conditional columns * Merging columns 8 THE M FORMULA * Creating M functions * Create an IF function * Create a query group 9 PIVOT AND UNPIVOT TABLES * Pivot tables in the query editor * Pivot and append tables * Pivot but don't summarise * Unpivot tables * Append mismatched headers 10 DATA MODELLING REVISITED * Data model relationships * Mark a calendar as a date table 11 INTRODUCTION TO CALCULATED COLUMNS * New columns vs. measures * Creating a new column calculation * The SWITCH function 12 INTRODUCTION TO DAX MEASURES * Common measure categories * The SUM measure * Adding measures to visuals * COUNTROWS and DISINCTCOUNT functions * DAX rules 13 THE CALCULATE MEASURE * The syntax of CALCULATE * Things of note about CALCULATE 14 THE SUMX MEASURE * The SUMX measure * X iterator functions * Anatomy of SUMX 15 INTRODUCTION TO TIME INTELLIGENCE * Importance of a calendar table * A special lookup table * The TOTALYTD measure * Change year end in TOTALYTD 16 HIERARCHY, GROUPS AND FORMATTING * Create a hierarchy to drill data * Compare data in groups * Add conditional formatting 17 SHARE REPORTS ON THE WEB * Publish to the BI online service * Get quick insights * Upload reports from BI service * Exporting report data * What is Q&A? * Sharing your reports 18 APPLY YOUR LEARNING * Post training recap lesson

This course is designed specifically to help improve your collection rates. The UK's leading trainer in the subject uses practical examples and case studies to show how to use debt collection techniques that really work. This programme will help participants to: * Understand debtors and communicate with them effectively * Improve their telephone and writing skills * Appreciate the key legal issues * Track down 'gone-aways' * Improve their collection rates 1 GIVING CREDIT AND COLLECTING DEBTS * The benefits when you get it right * The cost of getting it wrong 2 ANALYSING YOURSELF * The importance of making the right 'first impression' * Assessing your own personal communication style and how this affects your results * How do you (or might you) look in the debtor's eyes? What would you like to change? 3 ANALYSING YOUR DEBTORS * Types of debtor * The delaying debtor * The genuine debtor * The cashflow or hardship problem debtor * The ones who never intended to pay * Spot the most common reasons and excuses for non-payment - and learn how to deal with them 4 UNDERSTANDING DEBT RECOVERY AND THE LAW * Data protection issues * County Court suing enforcement methods * Human rights and debt recovery * Retention of title matters 5 TELEPHONE SKILLS FOR DEBT RECOVERY * A 7-point plan which works every time * Learning by example: listening to and analysing some pre-recorded (or live) collection calls * What was done well? * What should have been done differently? * Did the collector recognise opportunities? * Did the collector create opportunities where seemingly none existed? * Did the collector negotiate well or not at all? 6 WRITING SKILLS FOR DEBT RECOVERY * Key phrases to avoid * What to include * A sample letter which gets results in over 90% of cases 7 TRACKING DOWN THE 'GONE AWAYS' * A unique debtor-tracing plan * Why spend money on external tracers when you can find those 'gone away' debtors for yourself? 8 COURSE REVIEW * The traps to avoid * Key personal learning points

This is an essential programme for any member of staff whose role requires a high level of attention to detail. The focus is specifically on the handling of text and data, whether at the input stage or when collating information into reports and documents for use by others. The session looks at both prevention and cure. For 'prevention', it focuses on understanding how common errors occur and on developing an awareness of the factors which influence our level of attentiveness. It introduces key psychological theories around attentiveness including the 'capacity' and 'bottleneck filter' models. And it looks at how working styles can affect attention to detail. For 'cure', the programme looks at how to minimise the effect of stress on concentration as well as introducing a number of tools and techniques for promoting accuracy - at both the input and the checking stages. Particular attention is paid to proof-reading techniques. By the end of the session, participants will: * Appreciate why errors occur * Understand how stress and other factors can affect focus and accuracy * Know how to improve accuracy and reduce errors when handling text and data * Be able to proof-read text and number-based documents more accurately 1 THE IMPORTANCE OF ACCURACY * The impact of mistakes * Why accuracy is so important * Main reasons why errors occur 2 ATTENTIVENESS THEORY * The 'capacity' and 'bottleneck filter' models * Selective attention * Chunking - big picture / little picture 3 PREPARING FOR ACCURACY * Working styles - how they affect detail-orientation * Identifying and minimising the impact of stress on concentration 4 PRACTICAL STRATEGIES * How to improve accuracy and reduce errors when inputting text * Managing interruptions and distractions * Proofing text and numbers

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 GETTING STARTED * The Power BI ecosystem * Opening Power BI Desktop * Power BI's four views * Introduction to Dashboards 2 IMPORTING FILES * Importing data sources * Importing an Excel file * Importing a CSV file * Importing a database * Connect to an SQL Server Database * Import vs. Direct Query * Importing from the web * Importing a folder of files * Managing file connections 3 SHAPE DATA IN THE QUERY EDITOR * The process of shaping data * Managing data types * Keeping and removing rows * Add a custom column * Appending tables together * Hiding queries in reports * Fixing error issues * Basic maths operations 4 THE DATA MODEL * Table relationships * Relationship properties 5 MERGE QUERIES * Table join kinds * Merging tables 6 INSERTING DASHBOARD VISUALS * Things to keep in mind * Inserting maps * Formatting Maps * Inserting charts * Formatting Charts * Inserting a tree map * Inserting a table, matrix, and card * Controlling number formats * About report themes * Highlighting key points * Filter reports with slicers * Sync slicers across dashboards * Custom web visuals 7 PUBLISH AND SHARE REPORTS * Publishing to Power BI service * Editing online reports * Pinning visuals to a dashboard * What is Q&A? * Sharing dashboards * Exporting reports to PowerPoint * Exporting reports as PDF files 8 THE POWER QUERY EDITOR * Fill data up and down * Split column by delimiter * Add a conditional column * More custom columns * Merging columns 9 THE M FUNCTIONS * Inserting text functions * Insert an IF function * Create a query group 10 PIVOTING TABLES * Pivot a table * Pivot and append tables * Pivot but don't aggregate * Unpivot tables * Append mismatched headers 11 DATA MODELLING EXPANDED * Understanding relationships * Mark a date table 12 DAX NEW COLUMNS * New columns and measures * New column calculations * Insert a SWITCH function 13 INTRODUCTION TO DAX MEASURES * Common measure functions * Insert a SUM function * Insert a COUNTROWS function * Insert a DISTINCTCOUNT function * Insert a DIVIDE function * DAX rules 14 THE CALCULATE MEASURE * The syntax of CALCULATE * Insert a CALCULATE function * Control field summarisation * Things of note 15 THE SUMX MEASURE * X iterator functions * Anatomy of SUMX * Insert a SUMX function * When to use X functions 16 TIME INTELLIGENCE MEASURES * Importance of a calendar table * Insert a TOTALYTD function * Change financial year end date * Comparing historical data * Insert a DATEADD function 17 HIERARCHIES AND GROUPS * Mine data using hierarchies * Compare data in groups

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 very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: * Identify the purpose of writing their documents - to themselves and to their readers * Recognise and meet the needs of their readers * Plan documents systematically and improve the layout, flow and structure * Express the content more clearly, concisely and correctly * Adapt the tone and style of writing to the circumstances * Proof-read and edit work effectively, using formal marks and techniques * Improve visual layout, format and appearance 1 COURSE OBJECTIVES * Welcome and Introductions * The problems now - group discussion 2 WRITING BETTER BUSINESS DOCUMENTS * What points to highlight / exclude * Starting off * Introductions * Conclusions * Executive summaries 3 RULES AND STANDARDS * George Orwell's famous maxim * Why write? - clarifying your aims and objectives * A seven-step method for better preparation * The three-stage process for writing well * Grouping information for your reader 4 PROOF-READING AND EDITING * The difference between proof-reading and editing * Proof-reading methods and strategies * Proof-reading marks and techniques * Training your eye for detail * Knowing what to look for 5 EFFECTIVE EDITING * Grammar and English standards * Words - usage and spelling * Sentences - units of thought * Paragraphs - themes * Punctuation - spotting and correcting common errors * Say what you mean - active v passive language 6 HOW'S YOUR ENGLISH? * Grammar quizzes and punctuation test * Spotting spelling errors * Rephrasing jargons and clichés * Common error's and mistakes 7 DOCUMENT LAYOUT * House style * Use of white space * Fonts and effects 8 ONE-TO-ONE WORKSHOPS * These are practical sessions with one-to-one consultation with colleagues and the trainer * They are held at key points to consolidate the learning from different sessions 9 COURSE SUMMARY * Summary of key points * Action plans

Some 60% of injuries at work are caused by lifting heavy objects. This powerful, practical programme is designed to help stop any of your staff from becoming the next statistic. 1 INTRODUCTION AND OBJECTIVES 2 OVERVIEW OF HEALTH AND SAFETY LEGISLATION AND HSE INJURY STATISTICS * Health and Safety at Work Act 1974 * Management of Health and Safety at Work Regulations (MHSWR) 1992 * MHSWR 1999 specific duties to risk assess * Manual Handling Operations Regulations (MHOR) 1992 * Breakdown of injury statistics and costs of poor manual handling 3 THE MUSCULOSKELETAL SYSTEM EXPLAINED * Prevention and ill-health * Ergonomics * RSI * The spine in detail 4 RISK ASSESSMENT * General principles * The TILE method * Employees' duties * Workplace scenarios