45710 Courses delivered Online

ADVANCED MICROSOFT EXCEL TRAINING COURSE ON BOOKKEEPING Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel Course Content * Creating worksheets, formatting text * Simple and complex formulas * Handling rows and columns * Average, max and min functions and using charts. * Use of IF Formula * Summing Techniques * Cell References * Formula Linking * Tables and Bordering * Look up References (Vlookup, Hlookup,etc) * Data Validation * Conditional Formatting * Date & Time Formulas * Charts & Graphs * Protection & Security * Creating Pivot Table * Pivot Table Analysis

This course is ideal to give all members of staff basic fire training to increase awareness and cooperation in the event of a fire in the workplace.

Discover the powerful schedule and cost risk analysis features of PRA. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. OBJECTIVES  By the end of the course you will be able to: * Import schedules into PRA * Add three point estimates onto plans * Perform schedule and cost analysis * Use templated quick risk * Run risk analysis * Interpret results from the Risk Histogram and Tornado graph * Add task percentiles to a Gantt chart * Set up a risk register * Add qualitative and quantitative risks * Link risk to activities in the plan * Create reports * Use the Distribution Analyser CONTENT Importing schedules * Importing MSP and Primavera Schedules * Running import checks * Checking schedule integrity SCHEDULE RISK ANALYSIS * 3 point estimating * Entering uncertainly * Different distributions * Using quick risk * Updating plan * Importing plans with 3 point estimates COST/RESOURCE UNCERTAINTY  * Resource loadings * Creating 3 point cost estimates * Resource distributions and escalations * Simple cost estimates TEMPLATED QUICK RISK * Setting up and applying templated quick risk * Assessing risk at WBS level RUNNING RISK ANALYSIS * Running risk analysis * Interpreting results on the Risk Histogram * Setting analysis options TASK PERCENTILES * Setting task percentile options * Including task percentiles on the Gantt chart TORNADO GRAPH * Creating a Tornado graph * Viewing sensitivity * Analysing sensitivity against activities SETTING UP THE RISK REGISTER * Setting Schema levels * Defining criteria and tolerances * Setting up a Risk Breakdown Structure (RBS) * Working with manageability and proximity * Saving scoring matrices * Adding custom fields EXPORTING DATA * Exporting to Excel, Word and PowerPoint QUALITIVE RISKS * Setting risk IDs * Adding risk cause, description and effect * Setting up risk details * Entering mitigation actions QUANTITATIVE RISKS * Linking risks to activities * Adding schedule and cost impacts * Defining how multiple risks impact * Correlation MIGRATING YOUR PLAN * Adding mitigation actions to your plan as tasks * Linking tasks to mitigation actions ACTIONING YOUR RISK REGISTER * Progressing risks * Importing progressed plans * Linking register to progressed plans * Risk history * The Waterfall chart SAVING AND REPORTING * Exporting the risk register * Running reports * Creating new reports BUILDING AND COMPARING RISK PLANS * Using the distribution analyser * Comparing dates and cost

Ideal for those already using Excel but who really want to get to grips with formulas and functions. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages.  It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. OBJECTIVES By the end of the course you will be able to: * Construct Formulas * Use a range of common Functions * Work with absolute and relative references in formulas * Create percentage calculations * Use named ranges in formulas * Use the XLOOKUP command * Create formulas with date and use date functions * Use formulas in conditional formatting * Use a range of Count functions * Use the formula auditing tools CONTENT Formulas vs Functions * Constructing formulas * Using functions * Common Excel functions * Using the function wizard vs the formula bar * Formulas in tables Absolute vs relative references in formulas * Using absolute references in formulas * Using partial absolute referencing Range Naming * Naming ranges * Using range names in formulas * Single and multi-cell ranges Working with percentages * Creating formulas with percentages * Percentage breakdowns * Percentage increases * Formatting as a percentage Using Lookups * Using XLOOKUP to insert information from other spreadsheets Calculating with dates * Calculating with dates * Using date functions Using formulas in conditional formatting * Using conditional formulas * Using functions in conditional formatting Count functions * COUNT * COUNTA * COUNTBLANK Formula auditing * Using the auditing facility * Tracing how formulas are made up * Tracing precedents and dependants * Evaluating formulas * Error checking * Showing formulas on a sheet

AAT BOOKKEEPING COURSE If you want to become a certified bookkeeper with AATQB (AAT Qualified Bookkeeper) status, then you must complete the AAT bookkeeping course successfully. This bookkeeping course is broken down into two levels, 1. Foundation Certificate in Bookkeeping 2. Advanced Certificate in Bookkeeping Once you pass all 5 exams successfully, you can gain AATQB status giving you leading edge to build a successful career in bookkeeping. NEXT STEPS AFTER QUALIFYING You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. WHAT YOU WILL GAIN? Firstly, this course will help you develop your skills in double entry bookkeeping and give you an understanding of management and administrative processes. You'll learn how to use manual bookkeepin systems and to work with the purchase ledger, sales ledger and general ledger. You would also get better understanding about VAT system and how to do VAT Return. You will be awarded with Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from Association of Accounting Technicians (AAT) once you have passed all the exams. Therefore, you will be eligible for Certified Bookkeeper Status. It gives you greater recognition and professional approval. The AAT bookkeeping course covers the following areas: * Bookkeeping transactions * Bookkeeping Controls * Advanced Bookkeeping * Final Accounts Preparation * Indirect Tax

Enjoy our outstanding blues singing courses for adults and develop the blues growl used by Bessie Smith, Big Bill Broonzy or Little Richard. Discover amazing vocal techniques that will make your blues feel authentic and enhance your vocal abilities under the tutoring of experts.

This course will explore what we mean when we say someone has dementia. The course will challenge you to think more about how we can best care for and support people with dementia.

Understand and explore what you and others do that develops and destroys working relationships. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) This is an exciting opportunity to dive into the very heart of human behaviour as we encourage you to explore what you and others do that develops and destroys working relationships.  We start by getting you to determine where in your working life you need to develop effective relationships before guiding you through a process of analysing personalities and behaviours and then giving you the skills to create and maintain great relationships.  OBJECTIVES  By the end of the course you will be able to: * Create a stakeholder map and analyse which relationships need to be developed * Describe different personality types and how these can cause connection and conflict * Develop behaviours that help build relationships * Bring more assertiveness to your relationships * Have courageous conversations and handle conflict should it occur CONTENT GETTING STARTED * The benefits of great working relationships * Determining what you want specifically from your relationships at work * Developing a stakeholder map to enable you to analyse who you need to build relationships with and how you might do this * Defining your personal brand * How your personal brand could impact relationships UNDERSTANDING OTHERS * Exploring different personality types * Understanding how others are both similar and different to you * Identifying when personality differences might cause conflict BETTER BEHAVIOUR * Exploring the concept of transactional analysis * How transactional analysis can help to build or break relationships * Understanding life positions * How life positions impact your behaviour and that of others * How to use transactional analysis in creating better relationships DEVELOPING RELATIONSHIPS * Understanding the common ways poor communication can cause problems in relationships * Developing assertive communication * Making human connections at work in order to build better relationships and create trust MAINTAINING RELATIONSHIPS * Recognition and Tiny Noticeable Things * How to have courageous conversations e.g. giving feedback * A model for handling conflict when it occurs

Understand what diversity and inclusion is and how to manage it affectively in the workplace. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Diversity and Inclusion in the workplace will help you develop an understanding of why diversity and inclusion is important to a business, what it is and how individuals and teams can work effectively together and harness the power that comes from valuing diversity and promoting inclusion. OBJECTIVES  By the end of the course you will be able to: * Describe why diversity and inclusion is important in teams and organisations * Explain and overcome unconscious bias and other beliefs that cause exclusion and impact the workplace * Recognise your own diversity and understand the value of diversity and inclusion in teams * Develop an Action Plan to create an inclusive work climate CONTENT UNDERSTAND DIVERSITY AND INCLUSION * What the Equality Act 2010 says about diversity * Understanding protected characteristics * Learn how to create an optimum climate to unlock the power of a diverse teams UNDERSTANDING YOURSELF AND UNCONSCIOUS BIAS  * Identify your own unique characteristics and how these could impact your performance * Examine self-limiting beliefs and how these can impact personal performance * Experience how unconscious bias impacts our information gathering, problem solving, judgement and decision making CREATING A DIVERSE AND INCLUSIVE TEAM CLIMATE * Understand the importance of respect, the role of trust and what valuing diversity really means * Apply the ABC Model to the creation of a diverse climate: * Awareness – be alert, self-aware and aware of others * Boundaries – understand how things can go wrong when working with others: boundaries, banter and bullying * Coaching – learn listening and coaching skills to promote inclusion * Create an achievable, personal action plan that can be applied immediately in the workplace to improve diversity, promote teaming and create an inclusive work climate

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