4972 AR courses in London 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

EQ is a pattern of how people's biases in their thinking leads them to think one choice or thing is better than another, as well as their clarity in differentiating within those biases to exercise clear and sound judgement. Where your thinking and responses lie within your biases spectrum, and your ability in adjusting to the situation you find yourself in, will determine responses equating to poor or strong Emotional Intelligence (EI). This course will enhance and promote the skill set necessary for any working leader or manager, allowing our in-depth emotional intelligence knowledge to be applied into your working environment. From an employer's perspective, this award can be a significant long-term return on investment by further developing your leaders and managers. What Does This Course Offer? Our program offers an EQ-SWOT™ assessment and EI Model in detail, and through activity and discussion we explore how applying and possibly adjusting, you may offer an improved Emotional Intelligence. Our learning experiences are successful because the outcomes are quickly embedded and demonstrate an immediate visible impact on the day-to-day working environment. Our engaging learning inspires employees to want to personally add value to the companies they work for. We also offer our Paradigm EQ-SWOT™ online assessment and report as a frame of reference within the program. This assessment should be completed before attending the program, and will be expanded upon during the program delivery. Course Content The Emotional Intelligence for Today’s Leadership and Management course covers the following topics: What makes EI so important within the workplace Self-Awareness and your EQ Profile The EQ unpacked Unconscious Bias & EI How to develop your EI quotient Accreditation Activity Our accredited tutors deliver training that encourages delegates to confidently and practically apply all they have learnt as soon as they get back into the business. To achieve this award, delegates need to prepare and deliver a 3 minute presentation* on the highlights of their learning and immediate application avenues when back in their working environment. *Participants will be given 30 minutes during the program to prepare for their 3 min presentation at the end of the program. Scheduled Course Dates Unfortunately this course is not currently scheduled as an open course as it is primarily run as an in-house programme. For more information, please contact us. In-House Courses This is our own management training course which has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry. This means that the course syllabus is extremely flexible and can be tailored to your specific requirements. If you would like to discuss how we can tailor this management training course for you and/or run it at your premises, please contact us.

This Health & Safety in the Care Sector Course works alongside, and helps, learners understand Standard 13 of the Care Certificate. This Standard touches on the legislation, policies & responsibilities relating to Health & Safety in the care sector, as well as looking at accidents and sudden illnesses.

This Health & Safety in the Care Sector Course works alongside, and helps, learners understand Standard 13 of the Care Certificate. This Standard touches on the legislation, policies & responsibilities relating to Health & Safety in the care sector, as well as looking at accidents and sudden illnesses.

This course is for learners gain an awareness of the causes and effects and identify signs and symptoms of Epilepsy, lifestyle issues associated with Epilepsy and plan effective levels of care for people.

AAT Level 2 is the first level of qualification for people with limited or no accounts knowledge. This Foundation Certificate in accounting training equips you for an entry-level role in an Accounting or Finance department. Moreover, this AAT course also lays the groundwork for a promising future in the accounting profession. By the end of the course, you will have a greater understanding and skills of manual and computerised accounts and how to use them in a 'real business world' setting. Why AAT? Want a new direction for your career? Think Accountancy, according to statistics, the average salary for Accountants is £50,000; it is the sector where the employ-ability rate is greater than any other sector. What are the benefits after completing AAT courses? A newly qualified AAT member can expect to earn an average of £21,600. Some accounting technicians work as accounts assistant; others go on to become managing directors or finance directors of well-known companies. Some go to work as a self employed accountant as AAT allows the student to become chartered. Osborne Training is an AAT Approved Training Provider in London. In taking the Association of Accounting Technicians qualification with Osborne Training, you will make one of the greatest decisions of your career. Duration You can expect this qualification to take 1-1.5 year to complete for most students. Tutors Tutors are highly qualified with extensive knowledge of accountancy. Study Options Classroom Based - evening, Weekend and Daytime sessions for AAT course from London Campus. Osborne Training continuously opening new campuses throughout the UK. Online Live - Interactive online sessions through world-class Virtual Learning Campus with study materials are delivered to your home address. Distance Learning- Self-Study with Study Material and access to Online study Material through Virtual Learning Campus. Once you finish the AAT qualification and pass all exams successfully, you will receive a globally recognised AAT Level 2 Foundation Certificate in Accounting from AAT. AAT Level 2 Course syllabus Bookkeeping transactions Bookkeeping Controls Elements of Cost Work effectively in finance Using Accounting Software (i.e SAGE)

Why Join Digital Marketing Training Course at Osborne Training Osborne Training is well Recognised for quality Regular Lectures led by Industry Expert Tutors Unlimited Access to the State of the Art Virtual Learning Campus Exclusive Access to High quality study materials Flexible payment option available Join Digital Marketing Training course as Pure Online or Blended with Classroom Delivery Access to Digital Marketing Internship for 3 months at the end of the training Unlimited Tutorial Support from expert tutors Get a Student Discount Card from NUS* Get a Free Tablet PC for limited period* Practical Hands-on Projects, Practical focused Assignments and Group-work for greater skills enhancement and understanding real life issues for real life problems Once you complete the bookkeeping course, you will get a certificate from Osborne Training confirming your professional Digital Marketing Qualifications. What jobs could I qualify for? Senior Digital Marketing Manager Digital Marketing Coordinator Executive Digital Marketing Strategist Digital Marketing Consultant In these roles, you could earn on average more than £40,000 annually (source: Reed Salary Checker, UK). Moreover, many go on to become successful (Millionaire sometime) entrepreneur by offering Digital Marketing services or formulating successful Digital Marketing Strategy for their own business. Digital Marketing Qualifications Digital Marketing Qualifications at Osborne Training are developed in Association with Google. Osborne Training offers Total Digital Marketing Course which combines all major skills required to be a successful Digital Marketeer and you also have option to join a complementary Internship at the end of your course. In joining the Total Digital Marketing Course at Osborne Training, you will make one of the greatest decision of your career and can look forward to a successful career in digital marketing. Digital Marketing Course Overview Total Digital Marketing Course covers major areas of Digital Marketing to make you completely ready for the digital era. The Digital Marketing course comes with optional Internship at the end of the training making you highly employable. Practical focused and hands-on approach of the training method helps you to be ready to offer real life solutions for real life problems. Digital Marketing Training Course Content Basics of marketing Marketing In Digital Era All About Web Search Engine Optimization Search Engine Marketing Affiliate Marketing Social Media Marketing Email marketing and nurturing (inbound) Mobile app marketing Content marketing Web, mobile and app analytics Growth Hacking Creating robust digital marketing strategy

Payroll courses in London | Online Courses | Distance Learning Course Overview: Broken down into practical modules this course is a very popular and well-received introduction to moving from manual payroll to computerised payroll, and it incorporates all the new government requirements for RTI reporting Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. What support is available? Free high-quality course materials Tutorial support Highly equipped IT lab Student Discount with NUS card Exam fees and exam booking service Personalised individual study plan Specialist Career Management service State of the Art Virtual Learning Campus Free Sage Payroll Software Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime and Weekend sessions for Payroll Training Course from London campus. Online Live - Osborne Training offers Live Online sessions for Sage Payroll Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Benefits for Trainees Sage Payroll Qualifications open new doors to exciting careers, as well as extending payroll skills if you are currently employed. State of the Art Virtual Learning Campus Start your own payroll bureau Work in small businesses A payroll career can lead to great things Update your knowledge of Sage payroll Improve your employability prospects A career path into payroll Ideal Continuing Professional Development course Gain a qualification to boost your CV Option to gain IAB accredited qualification Start your training immediately without having to wait for the new term to begin 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 IAB exam or Sage certified exam. Syllabus Advanced processing of the payroll for employees Preparation and use of period end HMRC forms and returns preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Processing Payroll Giving Scheme Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Introduction to Auto-enrolment Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay

Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives  By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning

Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) Do you worry about how to give negative feedback or deal with performance issues? Are you concerned about giving bad news? This workshop is designed to give you the skills, knowledge and confidence to tackle these scenarios in a productive way. If you are a people manager, team leader or supervisor looking to make those challenging conversations less stressful and more effective, this workshop is for you. Lots of practical sessions will ensure you have the opportunity to relate your learning to your real life work situations. The one day session will use professional actors in the afternoon so that you can practice handling real-life challenging conversations. Objectives By the end of the course you will be able to: Deal with a wide range of challenging conversations Describe the preferred behavioural style for giving feedback State the most appropriate influencing technique to use in your situations Explain how to give successful constructive feedback Content What are challenging conversations What type of challenging conversations occur? Why do we find them challenging? Communication Practical exercise to demonstrate and act as a refresher of the fundamentals of communication Barriers to communication especially in a difficult discussion Choosing the right behavioural style Refresher of assertiveness and why it is important in this context Practical exercise demonstrating how behaviour breeds behaviour, and the impact of choosing an inappropriate style Steps to using assertive behaviour Influencing Cialdini’s model for influence How to use influencing techniques in handling challenging conversations Practical application Feedback Understanding feedback – positive vs. negative Using the ABCBC model for feedback Using the basics of emotional intelligence to give effective feedback Practical application Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.