5413 Courses in Cardiff delivered Live Online

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people. Course overview Duration: 2 hours This course looks at how you can create a list of contacts with emails and then build a document to email out to everyone. This ensures that everyone gets a personal email but no one else sees the recipients. Objectives  By the end of the course you will be able to: Create source data to use in a merge Create a document to email out Attach source data contacts Filter recipients Send out emails to all Content Creating source contact data Creating your source data in Excel Creating a Word mail merge document Starting a mail merge document Attaching your source contact data Building the document Emailing your document Previewing the results Running a test to a document Setting up any filters Sending your document to emails

Learn the proper way to use PowerPoint and the background features that can make a real difference. Course overview Duration: 1 day (6.5 hours) Our PowerPoint – Professional Presentations course looks at creating professional, business focussed presentations quickly and easily. It ensures delegates are aware of the key concepts in using the tool such as slide masters and by the end of the day you will be able to create and run high quality presentations. This course is designed for new and existing users of PowerPoint who want to get the best out of the tool. Objectives  By the end of the course you will be able to: Create a new presentation Amend the slide master/template Create text slides Animate text on slides Insert pictures and objects Set object animation Insert and work with SmartArt Create charts Run a presentation Content Creating a new presentation Creating a new presentation from a template Using your company template Changing slide layouts Copying, deleting and inserting slides Using the slide master Modifying the Slide Master Using Slide layouts Multiple Slide Masters Slide dates, footers and numbers Creating text slides Working with bullet points Setting spacing Changing text and bullet styles Using Outline view Text animation on a slide Slide titles Bullet points Applying animation to the Slide Master Animating text Slide titles Bullet points Applying animation to Slide Master Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Inserting and working with pictures Inserting pictures Inserting online pictures Formatting pictures Adding Drawings Inserting lines and shapes Using Quick Styles Selecting and grouping objects Aligning and positioning objects Add text to a shape Duplicating objects Object animation Simple object animations Working with SmartArt Inserting SmartArt Graphics SmartArt formatting Converting text to SmartArt Inserting charts Creating a slide with a graph Changing chart types Setting chart options Graph animations Presenting your presentation Slide show settings Using Presenter view Using the PowerPoint viewer Slide show presentation tips

Service Level Agreements (SLAs) are extensively utilised to define the scope of work and key responsibilities between a customer and a service provider. It is fundamental that all relevant personnel are familiar with the defining characteristics of SLAs and how the design and implementation of these contracts can impact operational efficiency and brand reputation. PARTICIPANTS WILL LEARN HOW TO: Understand why SLAs are so important for good business management Apply a process to develop effective SLAs that define service level expectations and drive desired behaviours Identify methods by which the SLA can be measured and performance monitored Have an understanding of KPI’s and the relevance of critical success factors COURSE TOPICS INCLUDE: Procurement cycle, process structure and tendering Best practice contract management and the 3 C’s Supplier performance measurement and KPIs SLA use, benefits and application The SLA development process The monitoring and control of SLAs

This workshop will help you create, develop and close business opportunities using a consultative approach and a value-based (not price-led) proposition. Value-based selling means working the way your customer wants to buy, not how you want to sell. It also means: In a transactional sale the customer knows the answer without help from a salesperson (or cannot see why they should choose you), or is prepared to stay with what they have. Customer decision criteria are price and convenience and customers resent time spent with (new) salespeople, mainly because the salesperson adds little or nothing to what the customer already has and just wastes time. In a consultative or value-based sale, by contrast, the customer doesn't know the answer already. The salesperson must take the role of an advisor, not just a 'product promoter'. Customers demand expertise, advice and customisation during the sales process. Often customers insist on multiple meetings with salespeople and others to develop advantages that you can bring and reduce the perceived risk of changing. In this way the salesperson often adds more value than the product or service alone. This very practical workshop will help you use proven strategies and tactics to build, manage and successfully close sustainable business opportunities using a consultative approach and a value-based (not price-led) proposition. This includes: Increased impact of your new sales conversations, presentations and proposals - leading to faster decisions and increased conversion Greater confidence, consistency and professionalism throughout the business development process Enhanced sales questioning skills and techniques, leading to better, faster and more accurate development of customer needs, problems, value and expectations Improve your people, communication, influence and persuasion skills when approaching, consulting or presenting your services and solutions How to build value at all points in the customer's buying process through your knowledge, skills and structured approach Proven ways to gain additional business and referrals from existing customers and contacts, through direct approach and lead generation Being better able differentiate your firm, your solutions, track-record and expertise clearly and accurately with tailored value statements for each stage and for each opportunity Overcome and avoid price-based objections, buying criteria and negotiation 1 Introduction and key principles of value-based selling Introduction and review of pre-course questionnaires - KPIs, personal learning objectives and key principles The main principles of value-based selling and how they benefit you and the customer How value-based selling differs from 'transactional' or 'price-based' selling The stages of the customer's buying cycle - how to identify and work through strategies for each stage The concept of structured and set-piece selling and proposing Presentation by participants: Personal sales improvement goals 2 Value-based selling strategies and skills What is value? How can one move away from a price-led agenda? How to survive and resist price pressure - six techniques A review of key competencies and skills needed for a value-based approach Strategies, case studies and examples with discussion and review Defining your initial value proposition and comparative advantage How best to established the right level of trust, rapport and credibility Planning and practice session: Strategy - mapping a value-based sales process. 3 Connecting skills Research before the meeting and the first few minutes - ways to gain instant rapport and setting the foundation for a successful outcome in a first sales call How to structure an effective first time sales call or meeting - the subtle differences that are important to master How best to differentiate your solutions and build credibility and enthusiasm early or at the start of the buying process Overcoming initial buying resistance and relaxing the prospect; gaining rapport, opening the meeting: PBC (purpose-benefit-check) and gaining agreement to proceed Planning and practice session: Connecting - first meeting with a new contact 4 Consulting - building, developing and influencing client needs Understanding the power of high-impact and third-level questions to influence people based around specific needs and solutions The importance of body language and other personal communication dynamics when asking questions; empathic listening, run-on questions, drawing out skills, summarising, etc Creating a 'disturb' approach to creating needs and opportunities and positioning your solutions Using proven advanced sales questioning techniques with greater skill: Outcome, SPIN and qualification questions 'Decision-making criteria' - tools to help you develop the relevant criteria with the customer and in doing so progress your sales opportunities more effectively Planning and practice session: Questioning skills 5 Convincing - presentation and persuading skills practice Substance and style - selecting the right tone and content to engage and enthuse your prospect Compelling benefits and reducing perceived risk - key messages to deliver Helping the customer choose your proposition - by being convincing, compelling and credible when you present Professional and effective presentation skills - with personal coaching and practice sessions The keys of influence and persuasion and the keys to convincing a new customer to choose you for the first time Planning and practice session: Role-play in presenting your solution 6 Commitment Knowing when and how to close for commitment to the next stage in your sales process, plus ways to ask for commitment professionally and effectively How to isolate, prioritise and answer objections and concerns more openly and accurately, using a consultative not a confrontational approach Deal more effectively and profitably with price objections and reduce buyer's remorse (which can lead to an 'I want to think about it' reaction and cause delay and inertia) Key negotiation skills around the closing process - getting to 'yes' Planning and practice session: Role-play in closing and negotiation skills 7 Assessed role-play - Final practice session Live role-plays There is an option for external participants to be brought in to the live training workshop to take-part in the final assessed role-play or assist with other sessions run during the course. Performance assessment - 'Dragon's Pitch' The final afternoon of the course is an assessed role-play using a prepared scenario and external 'CEO'. The assessment criteria will be agreed prior to the workshop. 8 Workshop summary and close Personal action plan and learning summary

Understand what Emotional Intelligence is and how it impacts you and others around you. Course overview Duration: 1 day (6.5 hours) Emotional intelligence (EI) is increasingly being regarded as a major key to personal success. IQ measures our ability to problem solve and is pretty difficult if not impossible to change. Our emotional intelligence is our ability to problem solve about emotions and like any other skill can be developed and honed. Some of the most successful people in life today are those who are regarded as having a high level of emotional intelligence whatever their level of IQ. Being able to manage themselves and others successfully is often a crucial factor in their success. With a growing emphasis on ‘soft skills’, leaders and managers need to be able to sensitively handle other people, both within and outside the organisation. Emotions are important in work life. They drive motivation and commitment; they are an inherent part of what we do whatever our job role. Effective individuals are proficient at recognising, using, understanding, and managing emotions in themselves and others. This one day course will help participants improve their understanding and skill in these areas. Objectives  By the end of the course you will be able to: Identify the aspects of your role where emotions are important Recognise the four key elements of Emotional Intelligence Use a range of skills to build and maintain key relationships Develop an emotionally intelligent ‘culture’ in your part of the organisation Create a personal action plan to continue to enhance and monitor your Emotional Intelligence Content Emotional Intelligence (EI) What is Emotional Intelligence? Where does it sit in the “whole person model” IQ, Personality Traits, Skills and Knowledge and EI Dispelling the myths and legends about EI The RUUM Model of EI Recognising emotions in self and others Using emotions Understanding emotions Managing emotions Developing Skills in each of the 4 areas of EI Short and long-term strategies to develop EI Developing compensating strategies where needed Practical application of EI Leveraging EI strengths Practice using RUUM Model Case studies and scenarios Video analysis Examples in the public eye we can all relate to Incorporating EI into your day to day role Practical steps Peer coaching Action planning Optional Follow-up After completing this course, you have an opportunity to complete a psychometric to understand more about emotional motional drivers and derailers. If you would like to do this, you will be invited to complete a psychometric questionnaire called Lumina Emotion.It can be done online and takes between 30-60 minutes. The results are compiled into a report which one of our trained and accredited coaches will go through with the participant individually to work up an action plan to leverage their EI strengths and develop strength where needed.This can be very powerful in building EI into your people and your organisation.

Gain the insights, tools, and frameworks to make impactful decisions that steer your organisation towards success. Elevate your strategic thinking and drive results Course overview Duration: 1 day (6.5 hours) Strategic decision making is messy, complex and full of uncertainty. These are factors which work against the human mind when it comes to making effective decisions. This course provides delegates with insights into the factors influencing strategic decision making. Using psychometric profiles delegates will learn about their own preferences when making decisions, how to influence others and how to create the ideal conditions for successful strategic decision making. Objectives By the end of the course you will be able to: Explain the challenges of VUCA – Volatility, Uncertainty, Complexity & Ambiguous Use models of Strategic Thinking Understand the impact of perception, bias and judgement in decision making Understand personal preferences and approaches to decision making Speed read other people’s approach to decision making Use decision making models for strategic thinking Apply Mindsets, Skillsets and Toolsets for decision making Content The decision lifestyle - personal preferences Understand the human facts that influence decision making Understanding personal preferences and approaches to decision making Understand the impact of Perception, Bias and judgement in decision making Speed reading others’ approach to decision making Frameworks to provide context for decision making Understand the business factors that influence decision making – VUCA The Cynefin Framework – decision making in complex situations Understanding which business context you operate in – simple, complicated, complex or chaotic Models to improve strategic thinking How to understand yourself better How to improve your decision making How to understand others better How to improve other’s decision making Human centred decision making How to put humans at the centre of your decision making The art of Creative Problem Solving Using Design Thinking to reduce human complexity in decision making

Learn the skills of being more confident and assertive in the workplace plus be able to influence people to do the things you would like them to do. Course overview Duration: 1 day (6.5 hours) This ‘Assertiveness and Influencing Techniques’ workshop is interactive and practical and facilitated by a subject matter expert via a virtual platform. Exercises and breakout rooms will be used during this training. Delegates are encouraged to login from a location where they feel safe to turn on their camera, use their microphones and engage in conversations as required. Objectives  The aim of this course is to introduce delegates to a variety of influencing skills and techniques to deal with aggression and challenging situations. These skills and techniques will improve confidence and personal effectiveness when working in groups / meetings. By the end of the course delegates will be able to recognise and define what assertive behaviour is and its benefits, the impact of non-verbal communication and how to use it to enhance influencing behaviours. Content What is influencing and assertiveness? Sources of power Influencing skills and choosing the right approach When to be assertive and alternative behaviours Assertive behaviour Behavioural styles and their impact on working relationships Identifying different behaviour types; assertive, aggressive, passive Building confidence and negotiating a win/win result Developing Skills Communication skills – the language of influence and communication dynamics Different influencing techniques and when to use them The art of saying ‘No’ - having the confidence to challenge Receiving criticism assertively and assertiveness behaviour analysis The language of assertion Meeting skills Giving and receiving feedback Dealing with confrontation, aggression and challenges in a confident manner Practical Exercises and Action Planning Practical exercises will be used throughout the training and the training will culminate with the creation of a personal action plan

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams. Course overview Duration: 1 day (6.5 hours)  Microsoft Visio is a powerful tool designed to simplify complex information through the creation of simple, professional-looking diagrams. While Visio is capable of producing almost any type of drawing this training concentrates on flowcharts, swim lane process diagrams and organisation charts. You will also discover the real power of Visio by adding essential data to the content of your diagrams and producing reports in Excel using this data. This course is designed for either new users of Visio or those who have dabbled and can create basic diagrams. Our course will give you the skills and knowledge you need to navigate your way around this powerful program and produce different types of diagram. Objectives  By the end of the course you will be able to: Create and amend flowcharts Create cross functional (Swim Lane) process flows Produce organisation charts by importing data Add essential data to shapes Export diagram data reports to Excel Present, publish and print Visio diagrams Content Visio essentials Finding your way around Visio Using the ribbon and Quick Access toolbar Keyboard shortcuts Shapes and stencils explained What Visio can do for you Creating basic flowcharts Working with shapes Adding and deleting shapes Joining, aligning and sizing shapes Using Auto-Connect Labelling shapes and connectors Editing and improvinC flowcharts Amending shape and connector labels Using colours to emphasise Changing line styles Moving and copying objects Grouping diagram elements Quick ways of working Cross functional flowcharts Creating Cross-Functional Flowcharts Manipulating functional bands Creating off-page references within diagrams and hyperlinks to other documentation Organising charts and shape data Using the wizard to create an organisation Chart Importing existing Data into to create an organisation chart Modifying an organisation chart Shape Data Adding shape data to a shape Creating shape data sets Diagram reports Exporting data to a report in Excel Exporting to HTML Creating and customizing reports Presenting, publishing and printing Using Page Setup Print previewing Embedding backgrounds Adding headers and footers Converting your final documentation to PDF Saving as HTML Visio with PowerPoint

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

This very practical session is designed to enable participants to improve the impact, clarity and accuracy of their reports. It focuses equally on the two key areas - structure and writing technique. This course will help participants: Scope reports based on objective and intended readership Write a structured report Use the Fog Index to ensure readability Write grammatically correct and well-punctuated text Review and edit their work. 1 Introduction Objectives and overview Introductions and personal aims 2 What makes a good report? Practical activity and feedback 3 Before you start The planning process and scoping a report Organising information Key report headings What goes where? Writing practice and review 4 Writing tips and techniques Clear English and use of language Grammar and sentence structure Refresher in punctuation Writing in the third person The Fog Index - and how to measure readability 5 Pulling it all together Reviewing and proofing 6 Review Summary of key learning points Action planning