A flexible, modular-based, programme to heighten participants' awareness of ways in which their operations can affect the environment, the principles of environmental management and the practical steps they need to take as individuals and as an organisation to improve environmental performance. Depending on the course modules selected, this programme will give participants: Increased awareness of relevant environmental issues A greater understanding of, and commitment to, the organisation's environmental management programme Preparation for any responsibilities they may have under an Environmental Management System Further benefits according to options chosen 1 Environmental awareness Definition of 'the environment' Key environmental issuesGlobal warmingOzone depletionAcid rainAir qualityWater pollutionContaminated landLand take and green belt shrinkageResource usageHabitat destruction and species extinctions. Option: This module can be used to explain the key environmental issues related to the activities of your own organisation. Diagrams, photos, pictures, examples and statistics relevant to your own organisation are used where possible to illustrate the points being made. 2 Environmental legislation Key elements of environmental legislation affecting the activities of your organisation - including international, European and UK legislation. Legislation of particular relevance to your organisation - how it affects the operations of your organisation Option: Legislation can be dealt with according to which aspect of the environment it protects (eg, air, water, waste) or which part of your organisation's activities it affects Consequences of breaching legislation 3 Environmental management systems Overview of what an environmental management system isHow is an Environmental Management System (EMS) designed and put together?Key elements (emphasising Plan - Do - Check - Review cycle)The need to continually improve Pros and consReasons for having an EMSBenefits of an EMSConsequences of not managing the environmentCosts of installing an EMS Explanation of ISO 14001 and EMAS standards and guidance as applicable to the EMSs of your organisationOverview of your organisation's EMSHow it was set up / is being developed / operatesWho is responsible for itKey parts of system (eg, environmental policy, objectives and targets) identified and discussedEMS documentation - what and where it is. Workshop option: Brainstorm 'Pros and cons' with the participants, come up with all their ideas for good and bad things about EMS and demonstrate that the 'good' list is longer than the 'bad' 4 Environmental consequences Define what an environmental impact is and discuss how they are determined, with reference to the EMS Identify why we want to determine the environmental consequences of operations and activities; how they are used in the EMS for planning, and reducing the impact on the environment Establish key environmental consequences of construction and operational activities on the site; discuss significance ranking and the control measures in place in your organisation. Workshop option: In small groups, participants are asked to identify the impact on the environment of your organisation's activities or a part of their activities. They are then asked to rank these impacts in terms of their significance, using guidelines provided to help them be aware of the contributing factors (eg, frequency, severity). For a selected number of the impacts, the participants are asked to identify what control measures there are and which of these they play a part in. All stages can be discussed with trainers as a whole group at various stages during the workshop. 5 Protected species, nature conservation and invasive weeds Nature conservation, landscape and visual issues in the planning process - overview of key nature UK wildlife legislation, EIA, appropriate timing of surveys, Hedgerow regulations and landscape and visual impact issues Ecological issues - ecological legislation, significant species, hedgerows Archaeology in the development process - why archaeology is important, organisation in the UK, legislation and planning guidance Construction phase issues and consents - major environmental issues during construction, including water resources and land drainage consents, discharges to land or water, water abstraction, public rights of way, tree protection, waste management, Special waste, noise, good practice pollution control and Environmental Audits Identification and management of invasive weeds - including legal position regarding management 6 Chemicals and fuels handling and storage How health and safety management is closely linked to environmental management of materials Planning - what mechanisms are in place for planning materials use; legislation, guidance and policies which define how to manage materials Materials storage - what are the considerations for storing materials, covering:Labels: what are the different types and what do they tell us?Storage facilities: what are the requirements for safe storage of materials (eg, signs, secondary containment, access, segregation, lids/covers)Handling: safe handling for protecting the environment, organisational procedures, high risk situations (eg, decanting, deliveries), how to reduce the risks (eg, use of funnels, proper supervision, training)COSHH and MSDS: brief explanation of legislation and its role in environmental control of hazardous materials, how to use the information provided by COSHH assessments Option: These sessions can be illustrated with photographs/pictures and examples of good and bad storage and handling practices Workshop Options: Labelling Quiz - quick-fire quiz on what different labels tell us; Build a Storage Facility - participants are asked to consider all the environmental requirements for building a safe storage facility for their organisation 7 On-site control measures Overview of the legislation associated with nuisance issues on site and mitigating problems when they arise Examples of bad practice, including fuel storage tanks and mobile equipment - costs involved with prosecution of fuel spills, remediation costs, management costs, legal fees, bad PR coverage Identification and management of contaminated land and relevant legislation Workshop option: Participants are provided with a site plan containing information on site features, environmental conditions and indications of potential issues 8 Waste management Why worry about waste? - a look at how waste disposal can impact on the environment, illustrated by examples of waste-related incidents, statistics on waste production on national, industry-wide and organisational levels, landfill site space, etc Legislation - overview of the relevant legislation, what the main requirements of the regulations are, what penalties there are, and the associated documentation (waste transfer notes) Waste classification - a more in-depth look at how waste is classified under legislation according to hazardous properties, referring to Environment Agency guidance Handling and storage requirements - what are the requirements of the applicable waste legislation and how are they covered by organisational procedures? Examples of good and bad environmental practice associated with handling and storing waste. Workshop option: 'Brown bag' exercise - participants pass round a bag containing tags each with a different waste printed on. They are asked to pick out a tag and identify the classification and the handling, storage and disposal requirements for the waste they select Waste minimisation - overview of the waste minimisation 'ladder' and its different options (elimination, reduction, reuse and recycling), benefits of waste minimisation, examples of waste minimisation techniques Workshop option: Participants are asked to identify opportunities that actually exist within the organisation for minimising production of waste that are not currently being taken advantage of 9 Auditing Requirements for environmental auditing of operations Auditing the EMS Types of internal and external audits Requirements EMS standards (ISO 14001 and EMAS) Carrying out internal audits and being prepared for external audits Workshop options:Mock audit 'Brown Bag' - can be used either for trainers to test participants as if they were in an audit situation, or for the participants to test each other and practice their auditing technique. The bag contains tags each with a different topic printed on (eg, waste skips); participants pass the bag round and select a tag; they are then questioned by the trainer or another participant about that topic as if they were in an audit situation. If the participants are auditing each other, they will be provided with a set of guidelines to keep in mind during the workshop.Virtual auditing - a more practical workshop where participants review photographs of situations/activities relevant to the organisation's operations. They are asked to identify all the good and bad environmental practices that are occurring in the situations. 10 Incident response What should you do when an incident does happen? What should be in a spill kit? When should you call in the experts? When should you inform the Environment Agency or Environmental Health Officer? Workshop option: The participants are provided with some incident scenarios and asked to develop a response to the incident 11 Monitoring and reporting Environmental monitoring programmes and procedures Monitoring and reporting as control measures for environmental consequences Monitoring and environmental 'STOP' card systems - personal and behavioural monitoring and reporting
Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code
This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.
This course is designed to enable learners to increase their understanding of risk assessment and risk management in Health and Social Care settings.
AAT Bookkeeping Course Online Overview 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, Foundation Certificate in Bookkeeping Advanced Certificate in Bookkeeping Once you pass all 5 exams successfully, you can gain AATQB status giving you a 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
AAT Bookkeeping Course Online Overview 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, Foundation Certificate in Bookkeeping Advanced Certificate in Bookkeeping Once you pass all 5 exams successfully, you can gain AATQB status giving you a leading edge to build a successful career in bookkeeping. Next steps after qualifying You will be awarded Foundation Certificate in Bookkeeping and Advanced Certificate in Bookkeeping from the 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
The first Club and Community Forum will be held online on September 30th, 7-8pm. We'll discuss: Introduction to the forum and gathering your expectations. Active Lancashire and Sport Welfare Officer roles. Creating positive club and community cultures. Future forum plans and your input. The forum aims to connect people, share experiences, and promote best practices. We look forward to a successful first meeting.
VAT Accounting, Preparation and Submission Training Course Overview: Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Certificate of Attendance Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme
Overview Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme
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, Foundation Certificate in Bookkeeping 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