1952 Courses in Sheffield

One of our greatest strengths is our ability to tailor any of our open management courses to the needs and requirements of different businesses in different industries. We understand that whilst our open management training courses provide a wealth of knowledge in their particular area of focus, not all of it may be relevant for your business and the particular industry you operate in.Rather than making delegates sit through management training that is irrelevant to their job role, we offer bespoke management training where we tailor the course to cover the specific needs of your organisation, ultimately relieving the inevitable boredom and "switching off" that would come with having to sit through training that a person knew they would not need. Why choose us for your bespoke management training needs? We have provided tailored, bespoke management training courses to some of the largest organisations in the UK. Using our acquired experience and knowledge of running these courses, we will be able to work with you to create a bepoke management training programme that delivers a significant return on investment, both in terms of tangible and intangible results. ILM accredited management training courses Because we charge a daily training rate rather than a per delegate fee, if you have a number of delegates requiring management training, a bespoke management training course can often be less expensive than putting them all on an open course. A number of courses have been accredited by the ILM, which means you can be assured as to the standard of the course content and delivery. For more information on these, please see our page on ILM Management Training. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Interested in finding out more about bespoke management training? Between us, we can come up with a training plan which will provide relevant, bespoke management training for your delegates which will maximise the return on both your time and cost. We are happy to come to your premises or arrange training facilities nearer to your location if this would be more convenient. Feedback Below is a small selection of past feedback for our management training and development courses and programmes: "Excellent instructor. I looked forward to our monthly lectures knowing that I would have a good laugh but also that I would learn more about the subject and myself. He has been very helpful to me and the rest of the students, not just during the lectures but often in his own time. His enthusiasm for all of the subjects covered during the course was evident throughout, which again helped me to enjoy and understand the subjects and lectures.  If I get the chance in future to attend a further course with you, I would jump at the chance."Senior Acquisitions SurveyorGalliford Try "A very accomplished trainer and someone who I would very much like to be involved in our business training going forward. The feedback I have had from all levels of our team structure is excellent."Group HR OperationsEADS Personnel Services UK "Phil has a lot of energy which he throws into the course. This visably broke down resistance and attendees entered into the exercises wholeheartedly."Senior QSBullock Construction Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

Microsoft 365 training courses on: Microsoft 365 for End Users Teams SharePoint OneDrive Planner Flow Forms Click on the link below for full details: Microsoft 365 courses

In order to be an effective manager, it is extremely important to have good communication skills so that you can get your instructions across clearly and in a manner which will get you the results you desire from your employees. Our 2-day Effective Communication and Influencing course aims to provide attendees with a range of skills and behaviours which will allow them to communication clearly and effectively. Course syllabus modules include explaining the communication process, the different styles of influencing, the importance of body language and tone of voice, non-verbal communication and more. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One The Communication Process Identifying, what is effective communication? Recognising the different ways in which we communicate The barriers to effective communication Looking at Johari's™ Window, to better understand how communication flows Module Two Effective Communication Skills Demonstrating a positive mental attitude Establishing active listening Developing your questioning skills Using positive language Module Three Different Types of Influencing Looking at influencing versus manipulation Developing your own preferred influencing style Understanding the different influencing styles and their uses adopting a flexible style for the desired outcome Module Four Behaviour Breeds Bahaviour (Transactional Analysis) Looking at the history of hidden transactions in communications The hidden meaning in what we say and what we receive How to recognise if what you're saying is calm, rational, logical and professional Module Five Body Language Understanding the impact of body language in effective communication Noticing how your own body language influences others positively and negatively Analysing and practicing the techniques of successful body language Module Six It's All in the Voice Learning the importance of tone of voice in effective communication Realising how your tone of voice influences others Module Seven Written Communication Understanding the pitfalls of opening a discussion Identifying the different types of written communication Recognising the importance of preparation and planning Looking at different structures and layouts of written communication Using the correct words and phrases Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

The main aim of this workshop is to encourage and enable delegates to present their sales messages stylishly and persuasively to expert buying audiences and improve their conversion rates. The focus is placed firmly on performance and creativity in top level presenting. It is aimed at experienced sales professionals who are expert at selling but need to be able to present and pitch for business at high skill levels in order to land major accounts. Delegate numbers will be restricted to 4 people. Delegates should be willing and be prepared to give video-recorded presentations as part of the course. Course Syllabus The syllabus of the Sales Presenting course is comprised of two modules, covering the following: Module One Components of Top Presenting Preparation and performance in presenting Being stylish and compelling Differentiation, risk-taking and presenting Connecting with your audience Achieving impact and drama Creating a buying emotion Getting out of a comfort zone First delegate presentations Module Two Pitching in Teams Getting your act together - the plan Looking and sounding like a team The buyer's perspective Getting your moves right - choreography Dealing successfully with questions Rehearsing to succeed Second delegate presentations Dragon's Den Exercise The delegation is split into two groups, each with a specific product or service to win the Dragons' investment. They have to also present to the Dragon's Den their business case for feedback and negotiate with the Dragons to gain either an "I'm in" or an "I'm out" reply. A full debrief is then conducted covering: Planning Commercial consequences Putting forward a business case Critical thinking Negotiating Selling skills Presentation skills Profile building Scheduled Courses This course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information please contact us.

If your organisation manages contractors then your staff need to understand the health and safety issues. This course is the answer. The expert trainer will set out clearly the legal responsibilities of all relevant parties and explore the practical application of these responsibilities with the course participants. The course will then examine the issues associated with the planning of work to be contracted out and the evaluation, selection, control and monitoring of contractors engaged to undertake the work. Although the main focus is on health and safety, the course will also explain how health and safety issues need to be integrated into your organisation's functional management processes to ensure effective control of contractors. The course will consider all types of contracted activities, including construction and maintenance, cleaning, security, plant installation, etc. This programme will give participants: A clear understanding of the organisation's legal responsibilities for managing contractors The information they need to assess the competence of contractors A practical understanding of risk assessment principles and the transfer of risk to contractors A step-by-step guide to the key aspects of managing contractors in practice, covering:Planning of the workSelecting contractorsHandover prior to work commencementDuring the workReviewing the work on completion Practical guidance on the integration of health and safety controls into organisational procedures for contractor management 1 Introduction Who are contractors? Why manage contractors? Different types of contractors Costs of poor contractor performance 2 Overview of health and safety law and liability Health and safety law and statutory duties Relevance of civil and criminal law Enforcement and prosecution 3 Relevant legislation for controlling contractors Health and Safety at Work Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 1994 (as amended, 2007) Other relevant legislation Contract law 4 Managing contractors in practice Exercise - how well is it happening? The objectives Five step approachPlanning of the workSelecting contractorsHandover prior to work commencementDuring the workReviewing the work on completion 5 Planning the work Scope and extent Risk assessment Interface and other activities Who controls what? Contract arrangements 6 Selecting the right contractor(s) Locating contractor organisations Selection the right contractors Assessing contractor competence Approved lists/frameworks Tender process 7 Pre-work commencement Co-ordination and co-operation Exchange of information Contractor risk assessments and method statements Permits to work Case study exercise 8 During contract work Communication and liaison Supervision and inspection of the work Inspection and reporting procedures Security issues Facilities and access 9 Reviewing work on completion Why, what and how? Achieving continuous improvement in contractor performance 10 Questions, discussion and review

Some people naturally possess an ability to sell and others over time develop their own style. We have created a highly practical course to give you the confidence and ability to sell over the phone or face to face. We focus the exercises, theory and discussion on your own job role and experiences to ensure you can return to the workplace to deliver tangible results. This 2-day course is designed for individuals who are new to selling, those in a sales role but have not received any formal training, or professionals who would like to brush up and enhance their current selling skills and learn some new techniques. Course Syllabus The syllabus of the Essential Selling Skills course is comprised of seven modules, covering the following: Module One Understanding the Customer The importance of good customer care Selling vs. selling attitude The reasons people buy Adopting a positive approach Module Two Self-Awareness Understanding your selling style Adapting your selling style to your customer Understanding your customers buying style Module Three Effective Communication and Rapport Building Why does communication need to be effective? Actively listening to your customers' needs Right question at the right time The impact of positive and emotive language Module Four Taking a Consultative Approach Different styles of selling Taking a consultative approach to selling Preparation techniques Buyer behaviour and motivation A selling approach to match the buyers mind Module Five Presenting the Solution Selling the benefits Sales tool kit Unique sales points Advanced questioning techniques Module Six Gaining Commitment Recognising and acting upon buying signals Dealing with customers concerns No means no? How to cope in stressful situations Module Seven Confirming the Sale Confirming or closing? Effective confirming techniques Going the extra mile Benefits For you as an individual This course will increase your confidence and ability to sell, having provided you with tools and techniques to achieve maximum results. Delegates always leave with fresh ideas, energy and motivation to succeed. For an employer The attitude of the delegates and the results they deliver will speak for themselves. All techniques are easy to apply back into the workplace for an immediate impact. What will I learn? By the end of the course, participants will be able to: Appreciate the need for preparation before a sales appointment Effectively identify and meet needs with advanced questioning techniques Identify verbal and non-verbal buying signals Construct professional answers to questions and possible objections Present your products and/or services with the buyer in mind Identify and use a selling style appropriate to capture the buyer's attention Recognise and overcome major objection types How to apply effective confirmation techniques with the buyer in mind Real Play Option We offer an innovative solution to engage the learners and bring real negotiation and closing scenarios to life. We use actors who improvise scenarios which have been specified by the group. The group is split the group into 2 sub-groups, one with the actor, the other with the trainer. Each group has a brief and has to instruct their trainer/actor on how to approach the scenario supplied. The actor and trainer perform the role play(s) as instructed by their respective teams; however during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) - not the performers. Scheduled Courses This course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information please contact us.

Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: Understand the economics of appraisal Be in control of their projects from the start Understand the economics of their projects - and devise the most appropriate mode Carry out sensitivity analysis and identify risk Improve their methods of appraisal and approach Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 Introduction Why appraise? Taking risk out of investment The short- and long-term results of not appraising business expenditure 2 Developing an appraisal process The process - overall and stage-by-stage objectives Understand business and technical risks Manage resources and time Do you invest enough time and effort at this stage? Take out the risks - control costs before you are committed to contracts and action Checklists 3 Appraisal arithmetic Review of the arithmetic of appraisalThe time value of moneyThe effects of different interest or required ratesThe effects of inflation (or deflation) in prices and costs Understanding the economics of appraisal is essential 4 Appraisal measures Meaning and use of appraisal measures Identifying the most appropriate measures for your particular business Payback Discounted cash flow measures - NPV and IRR Other measures - FW, AW, Profitability Index The meaning of the measures and their application in practice 5 Cost benefit analysis The effect on decision-making of more intangible benefits Cost benefit analysis Ensuring costs are genuine Measuring intangible benefits Environmental issues Consideration of intangible benefits in the appraisal decision-making process 6 Developing appropriate models Developing models - examples of spreadsheet models and measures for many different situations Modelling investment opportunities - summarising outcomes Sensitivity analysis - identifying, quantifying and taking out risk 7 Developing an appraisal process The process - managing risk from the outset Using the process in risk management, negotiating and project management Take out risk by thoroughly knowing your project - developing your own process

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

The 2-day Coaching and Mentoring for Managers course is designed for organisations that want their managers and team leaders to apply practical coaching and mentoring skills in everyday work situations in order to develop the performance of those they are responsible for, as well as improving communication within the business. Previous attendees have included chief executives, general managers, and HR managers, right through to production line supervisors and office staff. In fact, anybody that has to work as part of a team and relies on other people's efforts will benefit from this programme. Course Syllabus The syllabus of the Coaching and Mentoring for Managers course is comprised of four modules, covering the following: Module One Introduction to Coaching and Mentoring Exploding the myths surrounding coaching Benefits of coaching and mentoring The role of a coach and mentor How to avoid everyday interference that takes your time away from coaching people to achieve results How motivation works The difference between mentoring, coaching, directing, supporting & delegating, and learning when it is necessary to apply them Why coaching is an action orientated partnership purely focused on measurable results Coaching and mentoring outcomes Module Two Managing a Coaching Session The most important skills of a business coach The key characteristics of a good coach How to ask powerful coaching questions Opportunity to role-play using the STAR/GROW model Module Three Mentoring in Action Mentoring suggestions The first meeting Between first and second meetings The second meeting The Experiential learning cycle Model discussions Frequent questions asked by Mentors Duration of mentoring End of relationships Module Four Putting Learning into Practice Building a bank of great coaching questions Demonstration of what has been taught in a live coaching/mentoring meeting Individual feedback from a professional coach Creating SMART action plans Getting started as a work coach/mentor Group review and feedback on new learning Action steps for new coaches Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.