7077 Courses near Ludlow delivered Live Online

Look at the in depth features of charts and some specialist tools to make your charts come to life. Course overview Duration: 1 day (6.5 hours) Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually. By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts. The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts. Objectives By the end of the course you will be able to: Create and Amend Charts Format multiple areas of a Chart Use a Combo Chart Apply Conditional Formatting to a Chart Create Dynamic Charts Work with Custom Formatting Create an Advanced Dynamic Chart Content Creating and amending charts Creating Simple Charts Using the Chart Design tab Adding Chart Elements Changing the type of Chart Formatting charts Format Chart Area Format Data Series Format Data Point Format Axis Working with combo charts Adding additional data to a Chart Customising Chart types Creating Clustered Column/line Charts Applying conditional formatting on charts Using IF Statements Highlighting Max/Min Data points in Charts Using Series Overlap Dynamic charts Creating dynamic Target vs Actual Charts Introducing the NA function Hiding data used for Charts Custom formatting charts Formatting Data Labels Customising number formats Using Trend Arrows to show changes Editing Format Code Advanced dynamic charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Combining all elements to create an Advanced Chart Using Error Bars to create a line Adding a scroll bar and linking with data

This course will explore ways to support and enhance the quality of care provided to the individual approaching end of life, their families and their carers.

Look at some of the more advanced planning features available in Project. Course overview Duration: 1 day (6.5 hours) Our Project – Advanced Planning and Control course looks at advanced planning and resourcing techniques in Microsoft Project and how to customise your schedule to give better visibility and flexibility. The course is designed for experienced users of Project who have attended our Project Planning and Control introduction course or have equivalent knowledge. You must be confident using Project to build and resource schedules and create task dependencies. Objectives  By the end of the course you will be able to: Work with different types of task Amend resource load on a task Work with multiple resource rates Create custom tables Add custom fields Create calculated fields Add drop down lists in fields Filter and extract information Create new views Export information Content Advanced planning techniques Splitting tasks Task types Spreading work across activities Advanced resourcing techniques Resource types Assignment views Effective dates Work contours Overtime work Using multiple resource rates Creating custom tables Customising tables Adding fields Creating custom fields Adding text, number, date and time fields Using flag fields Defining pick lists Renaming custom fields Creating calculated fields Creating formulas Using graphical indicators Uploading and tracking progress Completing work Completing work per resource Updating tasks Updating the project Working with the status date Rescheduling work Viewing baseline against schedule Project overview statistics Working with filters Building standard filters Building interactive filters Task and resource filters Using highlight filters Creating custom views Creating customised views Customising text styles Using grouping techniques Exporting information Exporting to Excel

What are the aims of this course? What learning disability is and isn't The facts of learning disabilities What barriers people with learning disabilities face Medical barriers Societal barriers How to support people with learning disabilities

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 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

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

Unlock the Power of Teams: Elevate your leadership with our Building and Leading Effective Teams course. Learn the art of collaboration, communication, and synergy to create high-performing teams that drive success Course overview Duration: 1 day (6 hours) Everyone works in teams today in one way or another. Whatever we do in the workplace we need to interact with another person or a number of people at various times. It is important that we know how to communicate, how to listen, how to work together and how to overcome conflict when it arises in our workplace. Challenges are often created by a lack of trust, poor conflict handling skills, a lack of shared vision and confusion over roles and responsibilities. This course will help delegates understand how to encourage more productive team working in the workplace. By the end of the course delegates will be able to describe what makes a High Performing Team and realistically assess their current strengths and weaknesses. Delegates will also be able to identify and plan behavioural changes that will improve the team’s performance. The course is experiential based with lots of learning by doing activities, reflecting and discussion. This will allow team members to get to know/improve their knowledge of team colleagues and energise or re-energise teams. Objectives  Know more about their colleagues Be able to describe what makes a high performing team Understand the importance of playing to different strengths and skills Recognise the need for clear and effective communication Content The Importance of Team Work The importance of teamwork The ‘third dimension’ – how working together has the potential to achieve more The dangers of an overly competitive workplace culture Psychological Safety Team Development Models Stages of Team Development Behaviours at each stage Dysfunctional Teams – what does good and bad look like Characteristics of high performing and elite teams Teaming and Leadership Skills Teaming competencies Active Listening Proactive Language Values and Beliefs Building Mental Fitness of Teams Becoming an inspirational leader Establishing a climate of psychological safety Team Challenges The importance of Accountability The Team Charter Smart Teams:Building TrustBuilding CollaborationOvercoming ConflictGaining CommitmentDeveloping Shared Goals The importance of shared goals Effective Team communication

It is estimated that more than 1.2 million people in the UK are living with a learning disability. Healthcare and social care workers must have an adequate understanding of the needs of people with learning disabilities. It is also essential that they listen to the needs, hopes and aspirations of those living with learning disabilities, their careers, friends, and families. An improved knowledge, together with current guidance and best practice recommendations help to improve the care provided to people who have learning disabilities.

An instructor-led leadership learning programme based on emotional intelligence and social neuroscience, designed to boost leadership 'PowerSkills.' A practical programme that provides leaders with a learning journey that equips them with the tools and techniques to connect, empathise, communicate effectively, build employee engagement and influence.