7723 Courses

The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.

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

Our Forensic Accounting Course is designed to help investment analysts detect earnings manipulation. It focuses on creative accounting rather than conducting detailed forensic analysis but we explain the tools short sellers employ to detect fraud and some of the techniques we used at hedge funds to identify short opportunities.

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

Introduction to Heat Pumps training cover all you need to know about Low Carbon Air Source Heat Pump Systems

Lloyds School of Motoring specialise in both minibus driver training and bus training courses. To maximise employment opportunities, we recommend that consideration is given to opting for the full bus licence when completing bus training courses.

Lloyds School of Motoring provides lorry training in our privately owned fleet of vehicles across all categories.

REFERENCE CODE 603/4678/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This is a work-based learning qualification for those involved in cavity wall surveys/inspections and/or clearance. The qualification has been developed at the request of and in partnership with OSCAR OSNITE https://oscaronsite.co.uk The OSCAR and this qualification are recognised by a number of UKAS Certification bodies, industry bodies, Local Authorities and industry stakeholders. Prior to registering on this qualification, individuals must be registered with OSCAR. The clearance pathway enables individuals to carry out the extraction of cavity wall insulation to create a clear cavity that can be reinsulated or insulated if the system has been used to remove debris only. Candidates must also prove knowledge and competence to create a clear cavity to be able to facilitate External Rendering and External Wall Insulation complying with current Building Regulations. All work must be completed following safe working practices, relevant legislation, and comply with contract information and the allocated timescales. The surveyor/inspection pathway requires candidates to demonstrate the skills and knowledge required to interpret information to be able to carry out a Cavity Clearance survey in accordance with the job specifications, following safe working practices and within the allocated time. The Surveyor must also understand how to communicate with others to ensure work is carried out effectively. This pathway includes identifying and selecting the correct quality of equipment, additionally candidates must understand how to calculate quantity, area and wastage. To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 3 mandatory units and 2 pathways. Candidates must complete the mandatory units and one or both of the pathways. The minimum credit value of this qualification is 24 credits. There is also an entirely optional additional unit, if achieved this will appear on the qualification certificate but does not count towards the minimum credit value of the qualification. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 240 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 84. Mandatory Units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Handling and Storing Resources in the Workplace 2 5 Pathway 1 Cavity Wall Clearance Cavity wall clearance in the workplace CWC1 Pathway 2 – Cavity Extraction Specialist Surveyor/Inspector Surveying/Inspection of Cavity wall clearance in the workplace Summary of the: GQA NVQ LEVEL 2 CERTIFICATE IN CAVITY WALL EXTRACTION OCCUPATIONS SICW1 Additional Unit Erecting and Dismantling Access/Working Platforms in the Workplace Achieving the combination of Mandatory units and the correct choice of Optional credits will mean the qualification has been completed and GQA will provide the qualification title. Where a candidate has completed additional credits, the qualification will list these as “additional credits”, in cases where the candidate has not completed the full qualification and will not go on to do so, a Certificate of credit can be issued for the credits achieved. Assessment guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.

REFERENCE CODE 603/4678/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This is a work-based learning qualification for those involved in cavity wall surveys/inspections and/or clearance. The qualification has been developed at the request of and in partnership with OSCAR OSNITE https://oscaronsite.co.uk The OSCAR and this qualification are recognised by a number of UKAS Certification bodies, industry bodies, Local Authorities and industry stakeholders. Prior to registering on this qualification, individuals must be registered with OSCAR. The clearance pathway enables individuals to carry out the extraction of cavity wall insulation to create a clear cavity that can be reinsulated or insulated if the system has been used to remove debris only. Candidates must also prove knowledge and competence to create a clear cavity to be able to facilitate External Rendering and External Wall Insulation complying with current Building Regulations. All work must be completed following safe working practices, relevant legislation, and comply with contract information and the allocated timescales. The surveyor/inspection pathway requires candidates to demonstrate the skills and knowledge required to interpret information to be able to carry out a Cavity Clearance survey in accordance with the job specifications, following safe working practices and within the allocated time. The Surveyor must also understand how to communicate with others to ensure work is carried out effectively. This pathway includes identifying and selecting the correct quality of equipment, additionally candidates must understand how to calculate quantity, area and wastage. To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 3 mandatory units and 2 pathways. Candidates must complete the mandatory units and one or both of the pathways. The minimum credit value of this qualification is 24 credits. There is also an entirely optional additional unit, if achieved this will appear on the qualification certificate but does not count towards the minimum credit value of the qualification. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 240 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 84. Mandatory Units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Handling and Storing Resources in the Workplace 2 5 Pathway 1 Cavity Wall Clearance Cavity wall clearance in the workplace CWC1 Pathway 2 – Cavity Extraction Specialist Surveyor/Inspector Surveying/Inspection of Cavity wall clearance in the workplace Summary of the: GQA NVQ LEVEL 2 CERTIFICATE IN CAVITY WALL EXTRACTION OCCUPATIONS SICW1 Additional Unit Erecting and Dismantling Access/Working Platforms in the Workplace Achieving the combination of Mandatory units and the correct choice of Optional credits will mean the qualification has been completed and GQA will provide the qualification title. Where a candidate has completed additional credits, the qualification will list these as “additional credits”, in cases where the candidate has not completed the full qualification and will not go on to do so, a Certificate of credit can be issued for the credits achieved. Assessment guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy