5590 Courses in Nottingham delivered Live Online

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: * Ensure the integrity of their databases * Manage field properties * Use the query functions effectively * Save time with the query expression builder * Create different types of query more quickly * Design better forms * Link expressions in forms * Create better and more useful reports * Import and export tables more easily 1 TABLE RELATIONSHIP INTEGRITY * Identifying relationships * Identifying criteria for data integrity * Applying referential integrity * Managing relationship join types 2 TABLE FIELD PROPERTIES * Field properties overview * Using input mask field * Using default value fields * Using field validation rules 3 QUERY FUNCTIONS * Running aggregate function calculations * Running sum, average, count, max and min functions * Grouping calculated data 4 QUERY CALCULATIONS * Using query operators and expressions * Adding calculated fields to a query * Using the query expression builder 5 ACTION QUERIES * Creating make table queries * Creating append queries * Creating update queries * Creating delete queries 6 DESIGNING FORMS * Adding form controls * Aligning and arranging form controls * Adding pictures and labels to forms * Adding new fields to a form * Controlling tab order * Adding command buttons * Adding a combo box control * Formatting data using conditional formatting 7 FORM EXPRESSIONS (CALCULATIONS) * Using the form expression builder * Working with a property sheet within a form * Linking expressions within a form 8 WORKING WITH REPORTS * Creating reports with the report wizard * Inserting report fields * Formatting fields * Inserting report headers and footers * Working with a property sheet within a report 9 GROUPED REPORTS * Creating groups with the report wizard * Sorting grouped data * Grouping alphabetically * Grouping on date intervals * Creating sub reports * Adding calculations to groups 10 IMPORTING AND EXPORTING TABLES * Importing tables into Access * Exporting tables from Access * Importing and linking data in Access

Developing the high performing team takes time and effort. But above all, it requires an understanding of the dynamics of high performing teams. This programme helps managers and leaders understand what high performing teams do and how they do it. It focuses on enabling managers to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. A core theme is the need for managers of teams to 'hold up the mirror' to themselves and to see themselves as a leader of people, to reflect on how others see them and to modify their style accordingly. This programme will help managers / team leaders: * Analyse the constituents of a 'high performing' team * Apply essential influencing techniques * Use a range of communication techniques to support effective teamwork * Create and articulate team vision * Generate common values * Assess team effectiveness and take/recommend the appropriate actions * Make more efficient use of team time * Understand and agree on techniques to manage conflict * Define and implement team meeting protocols that will facilitate team effectiveness * Use the Prime Focus model to create the environment and framework for a high performing team * Draft your team strategy to take them to the next level DAY 1 1 WELCOME AND INTRODUCTION * Participants are welcomed to the programme and invited to share their personal objectives and people challenges * Participants are given an action plan template to complete throughout the workshop 2 YOUR TEAM * The concept of 'positive intention' * The difference between a team and a high performing team * Assess your team effectiveness * What is your 'interference'? 3 THE TEAM ENVIRONMENT * Setting the scene * Building rapport * Active listening * Team goals and role profiling 4 YOUR STYLE * Tuckman model of team stages - how do you manage each stage? * Team standards and goals * Your team vision 5 EFFECTIVE TEAM MEETINGS * Influencing in team meetings * How to make them interesting and relevant * The pure role of the chair DAY 2 1 EFFECTIVE COMMUNICATION TECHNIQUES * Giving and receiving feedback * Your communication style * How to adapt, pace and lead to build rapport * The Mehrabian theory of communication 2 HOW TO MANAGE CONFLICT * What is conflict? * What is your default conflict approach? * Tools and tips for managing conflict * Practice sessions 3 TEAM SKILLS * Undertake a team skills analysis * Types of team member * Motivating team members * Reframing situations 4 SETTING YOUR STRATEGY * Seeing the bigger picture * The Prime Focus Model * Your strategy for success * Articulating your strategy * Action plans revisited

This one-day programme explores the role of intellectual property (IP) in relation to innovation and creativity. It examines the different forms as well as the key processes, together with some of the oddities and idiosyncrasies of the legal regime that protects IP. It delves into the various IP models you should be aware of as well as key IP facts and figures and current IP trends across the global economy. This session is designed to give you a deeper understanding of: * The main forms of intellectual property * The importance of IP - both to your organisation and to the wider economy * The key processes in the creation, commercial exploitation, and legal protection of IP * The different models for the use of IP * Some more advanced concepts for reviewing, valuing and managing IP 1 MAIN FORMS OF INTELLECTUAL PROPERTY (IP) * Patents * Trademarks * Copyright * Design * Trade secrets 2 GLOBAL IP BUSINESS CONTEXT * Global IP facts and figures * Figures for key jurisdictions * Analysis of a company using IP data * IP trends * Overview of the key entities in the IP sector 3 KEY IP PROCESSES * IP creation * IP portfolio management * IP enforcement * IP exploitation * IP risk management 4 IP MODELS * IP models explained * IP licensing * IP litigation 5 IP CONCEPTS * The IP maturity ladder * Relative IP value and risk * Axis of control 6 IP AS AN ASSET CLASS * Costs * Valuation * Financial perspective

Maximising the team's sales capability is the key aim for any sales manager. When sales people struggle to hit their targets, it falls to the sales manager to provide support and help colleagues to find their way again. One of the most effective techniques for sales managers to improve and maintain sales performance is by providing live sales coaching. Sales coaching encourages sales people to find their own solutions and take responsibility for their own development. This course will help participants: * Develop people to fulfil their sales potential * Provide motivational feedback * Identify strengths and weaknesses of their team members * Understand personal learning styles * Identify and adapt for different personality styles * Prepare and conduct on-the-job observations * Motivate sales people to greater performance 1 HOW IS SALES COACHING DIFFERENT FROM SALES TRAINING? * What is coaching? * Discover how coaching empowers sales people * Learn the best time to use sales coaching * Decide which people should be coached first * Creating a development plan 2 UNDERSTANDING LEARNING, BEHAVIOURAL AND COMMUNICATION STYLES * Use practical tools to help you assess individual styles * Tap into the essence and energy of the person you are developing * Understand your own learning, behavioural and communication preferences * Develop a strategy to adopt for each member of your team * Discover what motivates you and your salespeople to perform * Appreciate how this knowledge will improve your sales conversion 3 USING THE GROW COACHING MODEL * Learn the secrets of a successful coaching session * Discover the importance of SMART objectives and instructions * Understand and capture what coachees are currently doing right * Develop their problem-solving and decision-making skills * Help your colleagues crystalise their plans and actions * Provide follow-up opportunities to embed the learning 4 GIVING MOTIVATIONAL FEEDBACK * Understand why effective feedback is so powerful in sales * Learn key models for motivational feedback * Discover how to manage and structure more difficult conversations * Understand the power of positive reinforcement * Encourage sales people to coach and support colleagues 5 PUTTING IT INTO PRACTICE * Use realistic scenarios to provide opportunities for practice * Discover what it feels like to be coached * Receive immediate feedback on your coaching style * Share common performance issues with fellow sales managers * Create a personal development plan 6 PREPARING ON-THE-JOB OBSERVATIONS AND JOINT VISITS * Build a strategy for coaching and team development * Prepare an observation template for effective coaching * Learn the key elements of preparation for your next coaching session * Agree common areas to focus on with coachees 7 ACTION PLANNING * Personal action plans

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: * Create custom shows to personalise presentations for individual clients * Make the Slide Master work collectively with slide layouts and themes * Seamlessly interact with external content using links * Work with advanced animations and transitions, and video/audio tools 1 THEMES AND MASTERS * Add a Design theme to a presentation * Make changes to the Slide Master * Delete layouts from the slide master * Saving a slide master with themes as a template 2 ADVANCED GRAPHICS AND DIAGRAMS * Drawing, duplicating and resizing shapes * Grouping, aligning and stacking shapes and graphics * Using SmartArt for diagrams and organisation charts 3 GRAPHS AND CHARTS * Inserting and formatting a chart * Linking an Excel chart to a slide * Linking Excel tables to a slide * Animating charts 4 VIDEO, CUSTOM ANIMATION AND HYPERLINKS * Adding and editing video * Animating pictures and drawings * Hyperlink to another Slide or Website * Compressing and optimising media 5 PRESENTING * Reuse slides * Hide slides * Rehearsing timings * Enabling a presentation to run continuously

Do you hear yourself saying the same thing over and over again? Do you want to bring some new skills to your role? If you have been in a sales role for some time it is easy to fall into a comfortable pattern. This workshop will help you incorporate advanced techniques drawn from NLP, behavioural science and social psychology into your existing skills. This course will help you: * Use the consultative sales process to achieve more cross-sales * Employ advanced rapport-building skills * Assess the buying preferences of a customer * Articulate the link between customer goals and needs * Identify your customer's needs and wants * Use advanced questioning techniques to gather information * Resist the temptation to tell when it would be better to ask * Identify communication preferences * Given various scenarios, present a product to the explicit need of a customer * Appreciate the impact of the language used during this stage of the sale and decide what language is appropriate with a variety of customers * Handle objections positively * Close the sale or gain commitment to further action 1 INTRODUCTION * Aims and objectives of the training * Personal introductions and objectives * Self-assessment of existing sales skills * Overview of content 2 UNDERSTANDING YOURSELF AND YOUR CUSTOMERS * Personal communication style and what this means in a sales situation * Wants versus needs * What motivates people to buy * Using social media tools such as LinkedIn * Managing your portfolio to maximise sales * Preparing to sell 3 THE SALES PROCESS * Overview of the consultative sales process * Review personal strengths and weaknesses as a salesperson * Habits of top-performing sales people * Common pitfalls * Articulate sales goals 4 BUILDING RAPPORT * 11 decisions that customers make in the first 9 seconds * Spotting buyer communication preferences * Building rapport with a wide variety of customers * Dealing with emotions * Keeping control 5 QUESTIONING AND LISTENING * Assumptions and how they trip us up * Structured questioning * Looking for cross-sales * Honing your listening skills * Identifying buyers' motivation * Using summaries to move the customer forward 6 PRESENTING PRODUCTS AND SERVICES TO CUSTOMERS * Choosing the right time to present * Using features, advantages and benefits * Tailoring your presentation of products and services to match buyer preferences and motivations 7 GAINING COMMITMENT * When to close * Dealing with difficult customers * 5 things to avoid when handling a customer objection 8 MANAGING YOUR BUSINESS * The link between service and sales * Using customer surveys * Winning back lost business 9 PUTTING IT ALL TOGETHER * Skills practice * Personal learning summary and action plans

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 THE QUERY EDITOR * Grouping rows in a table * Split row by delimiter * Add days to determine deadlines * The query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 THE QUERY EDITOR M FUNCTIONS * Adding custom columns * Creating an IF function * Nested AND logics in an IF function 4 DAX NEW COLUMNS FUNCTIONS * Including TRUE with SWITCH * Using multiple conditions * The FIND DAX function * The IF DAX function * Logical functions IF, AND, OR 5 EDITING DAX MEASURES * Making DAX easier to read * Add comments to a measure * Using quick measures 6 THE ANATOMY OF CALCULATE * Understanding CALCULATE filters * Add context to CALCULATE with FILTER * Using CALCULATE with a threshold 7 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentages 8 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED with SUMX * Create a RANKX * RANKX with ALL 9 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 10 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 11 VISUALISATIONS IN-DEPTH * Utilising report themes * Applying static filters * Group data using lists * Group numbers using bins * Creating heatmaps * Comparing proportions * View trends with sparklines 12 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint

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

Customers are astute and well-practised in researching and seeking information, solutions and added value in the minimum number of clicks online. There's only so much time they're willing to spend carrying on clicking. This mentality isn't just restricted to the world of B2C. In our increasingly hectic world, where information is expected to be available instantly, it applies just as much to B2B. In this workshop, we look at how putting yourself in the shoes of your customer and mapping their decision-making and buying journey is critical to ensuring that you provide what they perceive as fast solutions and added value. You will learn all about the three pillars for creating competitive brand experiences: Customer engagement planning puts you firmly in the shoes of your customer, helping you to build meaningful marketing communications delivered through the right resources at the right time to inspire your customers to engage with you. This programme will help participants to: * Understand the evolution of the customer buying journey * Map a customer buying journey for your brand or solutions * Understand the customer micro-moments and signals indicating interest and buying intent, both online and offline * Apply the psychology of branding to build marketing communications with impact * Develop sales and marketing content that differentiates your brand(s) from the competition by demonstrating unique value and how you can meet your customer's needs 1 THE EVOLUTION OF THE CUSTOMER JOURNEY * Understand how the use of mobile has had an impact on the customer buying journey where today's customers can research and compare products and solutions whenever and wherever they like, making the purchase journey even less linear * Explore how marketers are adapting to this new customer behaviour and drawing upon various strategies to win the hearts and minds of their audiences 2 THE SEE-THINK-DO-CARE FRAMEWORK * Explore the many different frameworks used to track the customer journey * Understand and apply the modern marketing model, where the internet has enabled the customer to hop between multiple touchpoints before making a purchase decision 3 CUSTOMER MICRO-MOMENTS AND SIGNALS IN THEIR BUYING JOURNEY * Understand the online and offline moments when customers seek information to research and make buying decisions * Apply this understanding to build a marketing communication plan to reach customers at all stages of their buying journey 4 THE ROLE OF BRANDING IN THE CUSTOMER JOURNEY * Explore the psychology of branding * Learn how to ensure your branding is relevant to your target customer needs * Bring together your brand value and story to achieve brand loyalty 5 THE WHY-HOW-WHAT FRAMEWORK * Apply a systematic approach to build a successful and compelling brand * Understand how starting with 'why' will help build your brand purpose * Apply the content marketing matrix to communicate your brand's value * Apply the hero-help-hub model to build engaging content marketing ACTIONABLE OUTCOMES We will use your brand examples to provide opportunities for practice: * You will learn and reflect on best practice examples of customer engagement * You will discover your brand value, purpose and the 'sweet spot' to drive engagement with your customers * You will create a customer engagement plan that can be implemented immediately within your business * You will receive immediate feedback on your customer engagement plan * You will have the opportunity to share common issues and solutions with your colleagues in the group

This very practical two-day workshop analyses the content and implications of key MoD terms and conditions of contract. The programme explains the principles and terminology of the contractual aspects of defence procurement as well as considering a number of relevant policies and initiatives. The course covers key components, constructs and methodologies associated with any commercial venture entered into with the UK MoD. Starting at the MoD organisational level the workshop sets the scene by looking at the acquisition process and organisation, detailing the various roles and responsibilities of MoD personnel. The workshop provides an in-depth examination of MoD DEFCONs and many narrative terms, setting them in the context of the organisation and its structures. The workshop helps participants to gain an understanding of the content and purpose of the range of MoD DEFCONs and narrative conditions commonly used throughout the acquisition lifecycle. It includes a review of Part 2 of the Defence Reform Act 2014 regarding Single Source Pricing, which comes into effect in 2015 and is already starting to be applied to significant contracts. On completion of this programme the participants will understand the terminology associated with the MoD terms and conditions of contract and will have an accurate view of their relevance, usage and their legal basis and how they can affect contractual and commercial decision-making. They will have gained an insight into defence acquisition contracting and they will be more commercially aware. DAY ONE 1 THE COMMERCIAL ENVIRONMENT * Key roles and responsibilities of the MoD organisations at the heart of the acquisition process 2 TENDERING TO MOD * An appraisal of some of the obligations placed upon contractors when they are submitting a proposal to the MoD pre-contract 3 STANDARDISED CONTRACTING * MoD have introduced non-negotiable standardised contracts for certain levels of procurement. This section considers their use and relevance to defence contracting 4 PRICING, PROFIT, POST-COSTING AND PAYMENT * The parameters specific to a costing structure and the differences between competitive and non-competitive bidding * The role of the QMAC, the profit formula, the requirements for equality of information and post-costing * Different types of pricing and issues surrounding payment 5 DEFENCE REFORM ACT - SINGLE SOURCE PRICING * Single Source Pricing under Part 2 of the new Defence Reform Act * Changes from the existing position, how contractors are affected and the compliance regime that accompanies the new requirements 6 DELIVERY AND ACCEPTANCE * Specific requirements and the significance and impact of failing to meet them * Acceptance plans * Non-performance and the remedies that may be applied by the Customer - breach of contract, liquidated damages and force majeure DAY TWO 7 PROTECTION OF INFORMATION AND IPR * Contractor's and MoD's rights to own and use information * How to identify background and foreground intellectual property * Technical information and copyright in documentation and software * How to protect IPR at the various stages of the bidding and contracting process 8 DEFENCE TRANSFORMATION AND DEFENCE COMMERCIAL DIRECTORATE * Widening and increasing roles and functions of the Defence Commercial Directorate * Background to the Defence Reform Act 2014 9 LEGAL REQUIREMENTS * Terms used in MoD contracts to reflect basic legal requirements * Records and materials required for MOD contracts and therefore the obligations, responsibilities and liabilities that a company undertakes when it accepts these conditions * Overseas activities 10 SUBCONTRACTING AND FLOWDOWN * Understanding the constructs required by the MoD for subcontracting * Which terms must be flowed down to the subcontractor and which are discretionary 11 TERMINATION * Termination of a contract for default * Termination for convenience * How to optimise the company's position on termination 12 WARRANTIES AND LIABILITIES * Obligations and liabilities a company might incur and how they might be mitigated * MoD policy on indemnities and limits of liability 13 ELECTRONIC CONTRACTING ENVIRONMENT * Electronic forms of contracting * Progress toward a fully electronic contracting environment