5435 Courses delivered Live Online

AAT Courses London AAT courses London campus offers Modern IT Lab, flexible timing and expert tutors. At Osborne Training London Canary Wharf campus, we offer various AAT courses to reach your dream career in accounting. AAT Level 2 Courses in London You can join evening, weekend or weekdays time for AAT Level 2 courses in London. We provide all books and study materials to ensure you are ready for aat level 2 exams. AAT Level 3 Courses in London You may join evening, weekend or weekdays training for AAT Level 3 courses in London. We provide all books and study materials for AAT Level 3 to ensure you are ready for aat level 3 exams and pass them first time. AAT Level 4 Courses in London You may join evening and weekend training sessions for AAT Level 4 courses in London. We provide all books and study materials for AAT Level 4 to ensure you are ready for aat level 4 exams and pass them first time. We also offer AAT Level 4 project support for students. AAT Evening Courses in London Our AAT evening courses mainly run between 6 pm to 9 pm. AAT evening courses in London are suitable for people who are working full time or have other commitments during daytime. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the evening. Our Canary Wharf campus is minutes away from the financial hub of London. AAT Weekend Courses in London Our AAT weekend courses mainly run on Saturdays daytime. AAT weekend courses in London are suitable for people who are working full time (Monday to Friday) or have other commitments during weekdays. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the weekend. Day Release AAT Courses London Our AAT day release courses in London mainly run on Wednesdays. AAT day release courses are suitable for people who can commit at least one day during weekdays. We offer AAT Level 2 and AAT Level 3 day release courses.

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns 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 Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Payroll Courses Online: What is Payroll? Payroll is a very important function for any businesses that pay their employees wages or salaries through PAYE Scheme. Through the payroll, function businesses calculate the correct amount Tax and NI to pay wages and salaries accurately. The payroll function is responsible for providing payslips and other documents to employees and reporting correctly to managers and HMRC. Sage Payroll Courses Starting our Sage Payroll courses will enhance your career potentials and give you the skills and knowledge you need to get started in Payroll. Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. Changes in Payroll Are you up to date with the latest RTI (Real Time Information) regulations introduced by HMRC? It's essential that companies comply with the changes. Payroll Jobs Available Payroll Manager Senior Payroll Administrator Payroll Adviser And many more... Professional or Industry specific qualification Our Sage Payroll Courses Sage Payroll Training Level 1 Sage Payroll Training Level 2 Sage Payroll Training Level 3 Sage Payroll Training - Fast Track (Level 1-3) Total Sage Training (Sage 50 Accounts + Payroll)

Attracting candidates and matching them to temporary or permanent job positions with client companies.

Ensuring learning and development contributes to improved performance in the workplace at an individual, team and organisation level.

Providing Customer service products and services for businesses and other organisations including face-to-face telephone, digital and written contact and communications

Ensuring an efficient flow of goods and services between manufacturers and their skilled trade customer base.

High quality specifications are of paramount importance in achieving the right technical performance and value for money. This long-established training programme has been developed to help those involved in producing specifications to create high quality documents in an organised and effective way. It provides a sound foundation for those new to the topic whilst at the same time offering new insights to those with more experience. The programme emphasises the need for a clear definition of requirements combined with the ability to communicate those requirements effectively to third parties. A structured method of preparing specifications is provided, and a range of practical techniques is presented, to enable participants to put the principles into practice. The commercial and contractual role of specifications is also addressed. The objectives of the workshop are to: Provide a clear understanding of the role and purpose of specifications Present a framework for organising and producing specifications Define the key steps involved in creating effective specifications Demonstrate methods for assisting in defining requirements Provide tools and techniques for scoping and structuring specifications Show the role of specifications in managing variations and changes to scope Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled DAY ONE 1 Introduction Review of course objectives Review of participants' needs and objectives 2 Creating effective specifications The role of specifications in communicating requirements The costs, benefits and qualities of effective specifications Understanding the differences between verbal and written communication The five key steps of 'POWER' writing: prepare-organise-write-edit-release Exercise: qualities of an effective specification 3 Step 1: Preparing to write - defining readership and purpose; the specification and the contract Designing the specifications required; applying BS 7373 Defining the purpose, readership and title of each document Effective procedures for writing, issuing and controlling specifications The roles and responsibilities of the key players Understanding contracts; the contractual role of the specification Integrating and balancing the technical and commercial requirements Writing specifications to achieve the appropriate contract risk strategy Deciding how to specify: when to use functional and technical specifications The role of specifications in managing variations and changes to scope 4 Case study 1 Teams review a typical project scenario and identify the implications for the specification Feedback and discussion 5 Step 2: Organising the specification content Defining the need and establishing user requirements Deciding what issues the specification should cover Scoping techniques: scope maps, check lists, structured brainstorming Clarifying priorities: separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, QFD, Pareto analysis 6 Case study 2 Teams apply the scoping techniques to develop the outline contents for a specification Feedback and discussion DAY TWO 7 Step 2: Organising the specification content (cont) Deciding what goes where; typical contents and layout for a specification The three main segments: introductory, key and supporting Creating and using model forms: the sections and sub-sections Detailed contents of each sub-section Tools and techniques for outlining and structuring specifications 8 Case study 3 Teams develop the detailed specification contents using a model form Feedback and discussion 9 Step 3: Writing the specification The challenges of written communication Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Problem words; will, shall, must, etc; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity Being concise and ensuring clarity Choosing and using graphics to best effect Exercises and examples 10 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 11 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 12 Course review and action planning What actions should be implemented to improve specifications? Conclusion

Designed to identify and discuss Personal Protective Equipment, correct hand hygiene, standard precautions when working with customers, dealing with sharps, COSHH and a brief look at specific infections.

There is so much more to this free tool than just creating PDFs. Learn what else you can do for free. Duration: 2 hours This Adobe Acrobat Reader course looks at the features of the Acrobat Reader tool. Learn how to create PDF and what options you have, complete and sign and mark up PDFs. Objectives  By the end of the course you will be able to: Create PDFs from other tools Complete and sign documents Mark up PDF documents Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Completing and signing documents Using fill and sign to complete forms Adding signatures Marking up documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio