58886 Courses

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 debtorThe delaying debtorThe genuine debtorThe cashflow or hardship problem debtorThe 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 callsWhat 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

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

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

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

The work of a technical team is invariably challenging and often unpredictable. Definition of the work can be problematic, timescales can be hard to estimate and the right technical approach difficult to select. Staff involved in this type of work usually have very high levels of specialist knowledge in their field and have high expectations of those who lead them. In addition to the challenges of the work, the team leader often has to balance the need for professional excellence with financial and commercial considerations and to ensure that team goals are realistic by being an effective negotiator with other project and senior managers. These characteristics make technical team leadership a demanding and complex activity. This programme aims to help participants develop the skills needed to become an effective technical team leader. The objectives of this programme are to help participants: understand the significance of leadership skills and their impact on team performance review the key skills needed to be an effective, 'multi-dimensional' team leader and learn how to develop, adapt and apply them in practice learn how to identify the preferred leadership style for the context and organisational culture and how to develop personal style versatility understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team DAY ONE 1 Technical teams and leadership What is a leader? How much can leadership be learned? The team environment and the impact of leadership skills The characteristics of high performance teams and their leaders Some useful models and theories of leadership explored Types of leadership; choosing how to use leadership power Evaluating personal leadership style; how to develop style flexibility 2 Essential skills for team leaders 3 key dimensions of effective leadership: inwards, outwards and upwards Developing and promoting a 'team vision': strategic thinking skills The vital role of communication skills and how to develop them Understanding others; emotional intelligence skills Being a visible leader; behavioural and influencing skills Building effective relationships; the importance of trust and respect DAY TWO 3 Leading inwards to build the team The role of leadership in developing team performance Understanding individuals in the team; recognising team role preferences Managing conflict and promoting positive team dynamics Setting standards, maintaining discipline and rewarding performance Harnessing team potential: building motivation within the team Promoting team learning; the team leader as coach / mentor 4 Leading outwards and upwards to support the team Negotiating realistic team goals; effective influencing skills Gaining empowerment and support from the key stakeholders Leading upwards: knowing when and how to take the initiative Building team credibility within the organisation; helping the team deliver Becoming an effective team player in leadership teams Building and maintaining rapport with influential stakeholders