453 Courses in Nottingham

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

Are you a manager in Early Years? Do you need some new skills to help manage your teams and be the best you can be? Then have a look at what this course covers and get in touch to book. Week 1. Exploring the role of a Manager in Early Years. Characteristics of an effective manager. Exploring different Leadership Styles and identifying your own. Looking after your own wellbeing. Week 2. How to manage difficult Conversations Exploring different personality types. Developing resillience. 4 Step process for managing a difficult conversation. Week 3. Creating Connection & Belonging within your team The importance of Connecting with a Diverse team. How to create a culture of connection & belonging. An introduction to Leading with Emotional Intelligence. We deliver this session on a one to one virtual platform or face to face. We can deliver to small groups but please contact us separately for costings. This specific course is for training one person at a time.

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

This is an essential programme for managers or members of staff (or students) who need to be able to read and summarise information on screen faster and more effectively. The session focuses on the different types of reading style and encourages better retention of written material through the use of specific speed-reading techniques. By the end of this programme participants will be able to: Explain the principles of speed reading Understand the barriers to reading Use different reading styles according to the information being read Read more effectively from tablet and computer screens Co-ordinate eye movements better Minimise any poor reading habits Increase reading speed by over 50%, without losing comprehension Improve retention of information using specific techniques The programme focuses on how to maximise reading from electronic devices by exploring techniques which will reduce eyestrain and improve reading effectiveness. The session also explains different types of reading styles and how to learn new, positive reading habits. 1 An introduction to speed reading The history of speed reading Assumptions about reading The process of reading Schema and its influence on interpretation Eye/brain relationship How our brain processes written information 2 Minimising barriers to reading Understanding eye tics Mouthing The influence of different light sources Body clocks and making use of natural patterns 3 Reading styles Importance of choosing the right reading style Speeds and their influence on retention Reading for pleasure Proof reading Scanning Skimming Reading for retention SQRW principles 4 Reading from electronic devices The challenge of reading from screens Importance of breaks and proper display screen evaluation Calibrating screens and background colours Formatting documents Using eye guides

Negotiation is an everyday challenge for some whether it be in the office, field or at home. Have you ever walked away from a situation thinking "if I'd only put my thoughts, side, opinion or words across better"? This 2-day course is perfect for managers, supervisors and sales people. It will focus on negotiation skills and the techniques that go with it. In this energy-charged provision you'll learn and practice negotiation, assertiveness and influencing techniques. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One An Introduction to Negotiation Assessment of your current sales and negotiation strengths and improvement areas What is negotiation? Identifying objectives and all factors affecting negotiation The negotiation model - the four stages Module Two The Preparation Stage The significance of preparation and why we need to prepare What do you need to prepare? Preparing a set of objectives: yours and theirs Understanding constants and variables Researching the other party Creating a "win-win" situation Preparing yourself for possible set-backs and objections Module Three The Discussion Stage The importance of rapport building Opening the negotiation The power of effective questioning techniques Improving your listening skills Controlling emotions Spotting the signs - non-verbal communication and voice clues Module Four The Proposing Stage Stating your opening position Responding to offers How to deal effectively with adjournments Module Five The Bargaining and Closing Stage Making concessions - the techniques Adopting key bargaining skills Dealing with objections and underhand tactics Closing techniques Confirming the agreement Creating long term, lasting commitment 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.

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

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.

This very practical and focused one-day workshop enables end-users, technical experts, proponents, internal customers and other key stakeholders to work with procurement and contracting to develop effective specifications and scopes of work, to ensure fit-for-purpose outcomes. The programme empowers participants to collaborate with all key stakeholders. This workshop will help participants: Understand the importance and value of clear and effective specifications Differentiate between the different methods of creating specifications and when to apply them Develop robust specification templates to ensure consistency Understand the use of appropriate language (critical to creating effective specifications) Appreciate the need to develop specifications in cooperation with stakeholders Make use of techniques such as value analysis and value engineering to define 'fit for purpose' in the context of creating effective specifications Embed key KPIs into the specification to ensure delivery Manage and mitigate legal and contractual risks in the specification 1 Introduction Learning outcomes Learning styles Plan for the day 2 The importance of effective specifications Scopes of work Impact of poor scopes of work Examples of costly errors 3 The critical role of language Terminology in creating effective specifications and scopes of work Problems of communication Lack of detail or too prescriptive 4 Encouraging cooperation Technical and commercial experts with responsibility for developing robust effective specifications and scopes of work Managing stakeholders' expectations Working with contractors 5 Types of specification Exploring and using the various approaches to the development of appropriate specifications and scopes of work Output Performance Technical Functional Solutions-based 6 The role of value analysis Value engineering in the process of developing scopes of work and specifications 7 Specifications and contracts The legal and contractual impact of poor specifications and scopes of work How to embed scopes of work and specification outputs into tender and quotation documents 8 Specifications as a management tool Developing KPIs and SLAs framed around robust effective specifications and scopes of work Negotiating with contractors Negotiating with stakeholders

Many managers question the value of appraisal programmes and many line managers believe appraisals are unduly time-consuming and bureaucratic. Yet the appraisal is a vital starting point when it comes to managing performance effectively and it is vital that managers appreciate this. Handled well, the benefits of formal appraisals are enormous. This thoroughly practical workshop has been designed to give line managers the knowledge, skills and confidence to deliver a well-structured appraisal - even in the most challenging circumstances. This course will help participants: Appreciate the benefits of the appraisal process Assess standards of performance objectively Plan and prepare for appraisals effectively Conduct a well-structured appraisal meeting Acquire the essential skills required for effective appraisals Improve their ability to discuss difficult issues more confidently Identify training and development requirements Agree clear and measurable development objectives Complete essential paperwork Understand the need to facilitate continual informal dialogue between appraisals 1 Introduction and course objectives 2 The appraisal process The aim of the appraisal process Understanding the bigger picture - the appraisal process as part of the employee development process The benefits of the appraisal process Common pitfalls Five steps to an effective performance appraisal 3 Step 1 - Assessment Using job standards as the basis for objective assessment Assessment of previous objectives 4 Step 2 - Preparation Documentation required Data on each appraisee Planning the meeting 5 Step 3 - The meeting The skills of appraisal interviewing The structure of the appraisal interview Dealing with poor performance and difficult situations Taking notes and completing documentation 6 Step 4 - Planning ahead and objective setting Identifying action to improve performance and enhance skills Establishing relevant training needs Agreeing SMART performance objectives Formulating a personal development plan 7 Step 5 - Action after the interview Essential paperwork Follow-up and action required between appraisal interviews Continuing informal dialogue 8 Video case study Bullets 9 Conclusion Course review / discussion Preparation of action plans for building on the skills learnt Close

This course has a simple objective: to help gain appointments with potential clients. In most consultative selling situations clients won't commit to purchases over the telephone. This means setting up a meeting to discuss the options with them face-to-face. But getting 'face time' can be tricky. This practical workshop can help. Participants will acquire essential tools, skills and methods; discuss specific organisational issues; and identify areas for improvement. They will discover how to: Increase their effectiveness through proper preparation Construct attention-grabbing opening statements Help potential clients feel comfortable agreeing to a meeting Develop tactics for responding to difficult excuses and objections Stress the benefits of a face-to-face consultation Develop and enhance their questioning and listening skills Prevent customers cancelling booked appointments 1 Introduction to appointment setting Key trends that have changed the way people buy today - and will buy tomorrow Why many sales people avoid picking up the phone The difference that makes a difference - what makes a good appointment-maker? 2 Before you pick up the telephone It all starts with a plan... Who and what to focus our attention How much research should we undertake and why? Setting primary and secondary objectives 3 Making your approach Key considerations Every call is an opportunity - creating a positive mind-set Using a structured approach Using partnership language 4 Gaining an insight into the customer's needs How to quickly 'tune in' to your customers, so that you can serve them more easily Developing speech patterns that put customers at their ease Using effective questioning and listening skills Finding and building pain points 5 Dealing with excuses and objections Pre-empting potential excuses Developing techniques for responding to client objections Keeping the door open for future contact 6 Securing the appointment Selling the benefits of a consultancy meeting Techniques for avoiding cancelled appointments Gaining commitment 7 Action plans Course summary and presentation of action plans