54547 Courses

A key-worker role is to provide the best individual care for people they support and carry out effective assessment and support planning. Staff need to know how to motivate individuals to achieve their personal goals and understand how to advocate on their behalf. Staff also need to know how to improve communication between colleagues, individuals, other professionals, and contribute to service improvement.

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

AAT Level 3 - Prepare Final Accounts for Sole Traders & Partnerships: AAT Level 3 is an Advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. You will be awarded an AAT Level 3 Advanced Diploma in Accounting certificate from the association of Accounting Technicians(AAT), once you have passed all the advanced-level qualification exams and skill tests. The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

AAT Level 3 - Cost and Revenues Overview: AAT Level 3 is an advanced or Intermediate level of AAT qualification in accounting. This course gives successful students the skills and knowledge to work competently in finance, accountancy, or bookkeeping role. Moreover, the students also have the opportunity to progress their studies with the AAT Level 4 Diploma in Accounting and acquire full membership of the AAT. You will be awarded an AAT Level 3 Advanced Diploma in Accounting certificate from the association of Accounting Technicians(AAT), once you have passed all the advanced-level qualification exams and skill tests. The Level 3 Diploma in Accounting covers the following areas: Advanced Bookkeeping Final Accounts Preparation Indirect Tax Management Accounting: Costing Ethics for Accountants Spreadsheets for Accounting

The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning

Our Bowel Care training will enable learners to deliver effective and thorough support to individuals who have difficulty managing their bowel habits due to immobility or illness. Bowel Care training is aimed at support workers with no experience of bowel care and can also be attended by nurses who may like to update their knowledge.

This one-day workshop is designed to help users work with advanced features within Word. It includes hands-on exercises to help make complex documents more manageable. Participants will learn how to share and collaborate on documents and track document changes. This course will help participants: Add document links to files, websites, bookmarks and headings Create and revise footnotes and endnotes Use cross-referencing Insert and mark a document index Use comments within a document Create and edit document templates Set up picture and table captioning Work with tracked changes, including viewing, accepting and rejecting changes Use tables of contents Transfer styles across files using styles organiser Protect and restrict the opening and editing of documents Work with document themes Work with subdocuments Use ribbon buttons and groups 1 Adding document links Adding links to a document Linking to files, websites and email Adding and linking to bookmarks Linking to document headings 2 Captioning and cross-referencing Inserting picture and table captions Creating and updating a table of figures Adding and revising endnotes and footnotes Understanding cross-reference types Creating a cross-reference Marking and inserting a document index 3 Collaborating on documents Inserting and viewing documents Navigating through comments Replying to a comment Printing comments 4 Tracking changes Using tracking changes within a document Choosing how to view document revisions Accepting and rejecting changes 5 Comparing documents Comparing two documents Combining changes into a single document Accepting and rejecting changes 6 Protecting a document Restricting opening or editing of documents Defining regions for editing Restricting document formatting 7 Outline view Collapsing paragraphs with heading styles Managing files with subdocuments Editing and locking subdocuments Sharing subdocuments 8 Document themes Standardise document formatting with themes Using a theme to match corporate branding Transferring themes across files 9 Creating templates Creating and editing document templates Adding font and heading styles to templates Defining file locations for shared templates Copying styles across templates and files 10 Customising the ribbon Customising ribbon buttons Adding new ribbons Adding buttons to ribbon groups

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

Any successful business manager will tell you that you never get the deal you deserve - you always get the deal you negotiate! This two-day workshop includes recent research and practical techniques from the Harvard Business School Negotiation Project and provides a unique opportunity to learn and practice these skills in a safe environment using up to date materials and life-like practice negotiation case studies. This course will help participants to: Understand the basics of negotiation Develop negotiating skills Increase their business acumen Develop their communication skills Learn the models, techniques and tools for an effective negotiation Identify the barriers to agreements Close the deal 1 What is negotiation? Key skills for negotiation Types of negotiation Win-lose negotiations versus Win-win negotiations Wise agreements and Principled Negotiation 2 Four key negotiating concepts BATNA - Best alternative to negotiated agreement Setting your reservation price ZOPA - Zone of possible agreement Creating and trading value 3 Business acumen Understanding pricing, gross margins and profit Knowing the key points on which to negotiate 4 A Four Phase Model for negotiation Nine steps to successful planning Discussing a deal - creating and claiming value Making and framing proposals Bargaining for the winning deal 5 Effective communication Effective questioning Active listening skills Understanding and interpreting body language Barriers to effective communication 6 Understanding influence and persuasion Influencing strategies Ten proven ways to influence people Six universal methods of persuasion Understanding why people do business with other people 7 Negotiating tactics Tactics for win-lose negotiations Tactics for win-win negotiations Effective team negotiating Understanding and using powerv What do you do when the other side has more power? 8 Barriers to agreement Common barriers to agreement The Negotiators Dilemma Dealing with die-hard negotiators Dealing with lack of trust 9 Potential barriers to cross-border agreements Understanding business methods and practice in other cultures Figuring out who has the power and who makes decisions Recognising and dealing with cultural differences What's OK here might not be OK there 10 Closing the deal Four steps to closing the winning deal

The duty of care is a legal requirement and comes with the job role for any Care worker. It is part of the code of conduct for healthcare support workers and adult social care workers in England and applies as soon as someone receives treatment or care. Employees also have a duty of care to other workers.