7219 CLO courses delivered Online

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

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

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.

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

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

In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales. One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer. By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer. By the end of this course, participants will be able to: Understand the power of a positive customer experience in developing sales opportunities Recognise and develop a sales opportunity when it arises Engage with customers and develop rapport and trust Use verbal and non-verbal communication skills and pick up on signals Ask powerful questions - and listen to the answers Create 'magic moments' for the customer Turn a complaint into an opportunity Know when to ask for referrals and testimonials Pass on leads to the relevant people 1 Introduction Aims and objectives Beliefs about sales 2 Building rapport First impressions Short cuts to rapport Finding common interests 3 Selling or serving? Managing emotions and behaviour - Transactional Analysis Moments of truth - creating 'magic moments' Speed sells - the follow-up 4 Meetings Planning a successful meeting Pre-meeting connection and assistance Sales meeting failure reasons Right v wrong mindset 5 Communication - verbal and non-verbal The 3 Vs - Visual, Verbal, Vocal Picking up on signals 7 power questions Questioning techniques LISTEN - 3 types of listening skills 6 Influencing 6 levels of influence Framing to change perspectives Turning complaints into opportunities 7 Referrals The power of referrals How and when to ask for a referral 5 steps from rapport to referral 8 Presentation and pitching (optional session) Basic presentation structure and delivery Creating powerful impressions Creating a 60-second pitch The elevator 10-second pitch - answering 'What do you do?' Sales presentations Emotion v Intellect - how to engage Using visuals

This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning

Introduction to Diabetes (2-Day Course) - Norfolk ICB OnlyThis course is for those from the Norfolk ICB only using the unique booking code. Applicants not using this code nor Identifying themselves as Norfolk ICB employees will not be able to attend.Course Description:These two days of comprehensive training are designed for nurses, nurse associates, pharmacists, paramedics, and other Allied Healthcare Professionals (AHPs), and experienced healthcare assistants (HCAs) who are new to or fairly new to the field of diabetes care. If you've recently started seeing patients with diabetes, or are planning to; this course is tailored to provide you with the fundamental knowledge and skills required to confidently care for individuals with diabetes. The primary focus is on adults with Type 2 diabetes, although key recommendations and signposting for patients with Type 1 diabetes will also be covered.Diabetes presents a significant healthcare challenge, costing the NHS £10 billion each year and impacting patients and their families. Primary care professionals play a pivotal role in managing the ever-increasing numbers of people diagnosed with Type 2 diabetes. Good diabetes care is crucial and aligns with national and local policies supported by robust NICE guidance.These interactive days of learning will incorporate various methods, including case studies, to help you progress from basic knowledge to a more confident and positive approach in reviewing and managing patients with diabetes. 2 Day Introduction to diabetes management in primary care (This is intended to provide an overview the programme may change slightly) DAY ONE 09.15 Coffee and registration 09.30 Introduction and course objectives 09.45 Setting the scene - screening, diagnosis, prediabetes, patho-physiology and symptoms, remission in Type 2 diabetes 10.45 Coffee 11.00 Type 1 Vs Type 2 Diabetes 11.20 Metabolic Syndrome and Diagnostic Criteria 11.45 Diabetes Prevention Programme 12.15 Managing Diabetes in Primary Care and Supporting Lifestyle 12.30 Lunch 13.30 Pharmacological Management of Type 2 Diabetes 14.30 Methods for Monitoring Glucose 14.45 Diabetic Emergencies (hypos, HHS and DKA) 15.15 Sick Day Rules 15.30 Action plan, evaluation, and resources 15.45 Close DAY TWO 09.15 Coffee and registration 09.30 Review progress since Day 1 09.45 Macrovascular Complications 10.15 Modifiable Risk Factors leading to CVD 11.00 Coffee 11.20 Cholesterol & Hypertension Management 12.00 Microvascular Complications 12.30 Lunch 13.30 Diabetes and Emotional Wellbeing 14.30 Case Studies 15.30 Q&A, Evaluations 15.45 CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the physiology of diabetes and differentiate between Type 1 and Type 2 diabetes.2. Discuss methods for diagnosing diabetes and provide information to individuals newly diagnosed with Type 2 diabetes.3. Describe approaches that support achieving remission in Type 2 diabetes.4. Explain basic advice related to a healthy diet, various dietary approaches, and carbohydrate awareness.5. Discuss the modes of action of commonly used non-insulin medications.6. Identify major complications that may arise in individuals with long-standing diabetes and measures to limit or prevent them.7. Describe key advice for patients regarding the recognition and appropriate treatment of hypoglycaemia.8. Discuss DVLA guidance concerning driving and diabetes.9. Explain the risks of acute hyperglycaemia and provide advice to patients on self-managing illness periods.10. Provide examples of referral pathways to other services such as weight management, secondary care, podiatry, structured education, activity, and psychological services.11. Describe the process of routine foot review and factors influencing diabetic foot risk status.12. Discuss local recommendations for the appropriate use of blood glucose and ketone monitoring.13. Explain the key components and processes of an annual diabetes review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective diabetes care within primary care settings.

Fraud should not happen, but it does. It can happen at the highest to lowest levels in an organisation. Recent surveys show that incidents of fraud are not decreasing. Fraud costs companies money and, perhaps even more importantly, reputational damage. The losers are not just the shareholders, suppliers, customers, etc, but society as a whole. This programme shows why frauds happen, how organisations put themselves at risk and what they can do to prevent it. This programme will help directors and others understand: The motives for committing fraud Directors' responsibilities for identifying and reporting fraud What types of frauds there are How frauds are perpetrated How they can be prevented How regulators deal with fraud Above all, the principal objective of this programme is to help make your organisation as secure as possible from the threat of fraud. 1 Motives for committing fraud - drivers of fraud Session objective: to understand why people might commit fraud Drivers of fraudulent behaviourAmbitionGreedTheftConceit? And more! 2 Accounting mechanisms that allow fraud Session objective: to review the elements of the accounting, internal control and management processes that allow creative accounting Income or liability? Asset or expense? Coding errors and misclassification Netting off and grossing up Off-balance sheet items 3 Structures that allow fraud Session objective: to consider company and trading structures that allow frauds to be perpetrated Group structures Trading structures Tax havens Importing and exporting 4 Interpretations and other non-compliance that allow fraud Session objective: to look at how creative interpretations of law and accounting practice may permit fraud The place of accounting standards Accounting policies Trading methods The place of auditing standards 5 Money laundering Session objective: to review what constitutes money laundering Types of money laundering Identifying laundering Preventing laundering 6 Preventing fraud - proper management structures Session objective: to review the place of proper corporate governance Corporate governance Company management structure Audit committees The place of internal audit 7 Preventing fraud - proper accounting Session objective: to review best accounting and auditing practice Accounting standards Internal accounting policies Adequacy of internal controls Internal audit 8 Preventing fraud - regulation Session objective: to look at how regulators aim to prevent fraud The regulatory environment Financial services regulation 9 Conclusion Course review Open forum Close 10 Course summary - developing your own cost action plan Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs

In today's fast-moving competitive environment, sales are often made or lost on the strength of a telephone conversation or a brief email. This means that not only is customer service everyone's responsibility - so is sales. Customer service staff are failing the customer if they don't think about sales. And sales staff are failing customers if they don't think about service. And anyone failing a customer is failing both themselves and their employer. Too often, customer service staff feel neither capable nor empowered to recognise or capitalise upon a sales opportunity. Too often, sales people pursue the short-term opportunity at the expense of the bigger picture. The good news is - it doesn't have to be this way! Sales and customer service skills can be acquired, developed and polished just like any other skill. This tried-and-tested programme shows you how to do it. As a result of this course, participants will be able to: Take control of a customer conversation, with confidence Refresh and polish their customer service and sales performance Recognise and develop a sales opportunity Engage the customer and build rapport Identify a customer's needs Match the customer's needs to the organisation's products or services Handle objections confidently Ask for the order At the end of the workshop each participant will have developed their own action plan for developing and using their skills in the workplace. 1 Introduction Course overview, objectives and introductions 2 Serving or selling? Feelings and attitudes - How we can affect the outcome by our feelings and behaviour What is selling? - Selling is helping people to buy, identifying the opportunities that exist within the conversation to develop the customer's interest in our products or services 3 Developing the right skills Communication- The impact of body language, voice tone and words- How to make the best impression on the customer and create a 'buying environment' Rapport-building- What makes a good working relationship?- What do customers look for when they call us?- How can we match their expectations in terms of our own interpersonal skills? Relating to different types of people by identifying and matching their communication style on the telephone 4 Making it easy for the customer Starting it right- Opening the conversation positively- Building rapport- How to develop interest in our products or services Gaining and clarifying information- Questioning skills and questioning style- What do we need to know from the customer?- How can we use that information in the conversation? Active listening- The most under-rated skill of all- Picking up on the 'Golden Moments' when a customer shows they may be interested Presenting information confidently- Knowing the benefits of our products or services- How to tell the customer what they need to know in order to enable them to buy Closing on a positive note- When and how to ask for commitment Dealing with the customer's objections and concerns in a positive manner 5 Course summary and action plans Review of main learning points Presentation of personal action plans