Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application. Very few users venture beyond the basics and therefore do not exploit the benefits of this formidable application.Advanced Level:•Use the Group feature•Protect workbooks, worksheets, cell ranges, add/remove a password•Understand, apply, modify, create styles•Use linking formulas•Understand and use data consolidation•Use advanced functions•Understand, manage and create a scenario manager

Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application.Very few users venture beyond the basics and therefore do not exploit the benefits of this formidable application.Microsoft Excel can be delivered to introductory, intermediate, and advanced level. Each level is scheduled into a one-day course which is trainer-led.This course will cover the following topics:Introductory level•Understand the principles of a Worksheet and Workbook•Create, edit, save, and retrieve spreadsheets•Copy and move data•Construct formulae and use functions•Format text and numbersIntermediate level•Link formulae and use more functions•Work with multiple worksheets and workbooks•Consolidate data•Create and customise charts•Create...

This course is designed to provide you with a recognised qualification, and the knowledge, skills and understanding to enable both the testing of portable electrical equipment and management of the testing of portable electrical equipment.This course meets the demands of legislation, which requires qualified personnel to administer and carry out the inspection and testing of electrical equipment.It is based upon the IET Code of Practice (COP) for In-service Inspection and Testing of Electrical Equipment. The subjects you will study will include:•The use of Portable Appliance Tester •Safety Mechanisms used in Portable Appliances •Recommended Portable Appliance Tests.

This course is intended for anyone involved in hospitality and catering, care sector, food retailing and food processing and anyone who is interested in food hygiene.It is a first step in food hygiene and will provide you with a basic understanding of food hygiene.•Introduction to food hygiene•Bacteria•Food poisoning and its prevention•Personal hygiene•The working environment•Cleaning practices•Pest control•Food safety legislationTutor support is given to all students through a Distance Learning approach and Microsoft Teams and College I-Learn Portal. Class meeting are held on a regular basis to assist the individuals at all times.

The aim of this evening course is to gain welding experience and lead to a single SQA unit of qualification in tungsten inert gas (TIG) or metal inert gas/metal active gas (MIG/MAG) welding skills.Suitable for professional upskilling.•Improve individual practical skill level using TIG or MIG/MAG welding and develop safe working practices•Comply with SQA single unit requirements in carbon steel and stainless steel plate•Identification of relevant materials and consumables in accordance with unit specification•Enhance employability within engineering, fabrication and welding sectors•Achieve SQA welding unit of qualificationOn completion of this course, you will have covered:•Introduction to TIG or MIG/MAG welding•Safe use and...

Microsoft Project is a powerful project management program that can be used to help build project plans, track work completed and account for variance from a baseline plan.This is a two-day course and is trainer led. The following topics will be covered:Overview of ProjectIdentify and create the work breakdown structureDefine and edit project calendarsSequence and create relationships between tasksSet project constraintsFilter and sort tasksSet up and assign resources to tasksCreate and use a resource poolAllocate costs to tasksBaseline and track projectsAs well as being open to any individual, this course can be delivered:to meet individual company requirementsto company housestyles and...

This course provides the underpinning knowledge to enable Health and Safety duties in the workplace to be undertaken more effectively. It is relevant for those who wish to progress and up-skill as managers, supervisors and employee representatives with health and safety responsibilities related to the construction industry. This comprehensive course, gives an excellent grounding in the fundamentals of occupational Safety and Health Management.This course provides the underpinning knowledge to enable Health and Safety duties in the workplace to be undertaken more effectively. It is relevant for managers, supervisors and employee representatives with health and safety responsibilities related to the construction...

The world's number one IT qualification, ECDL is the benchmark for digital literacy in educational systems around the globe.ECDL equips students with the skills to use a computer confidently and effectively, building on existing knowledge and motivating further learning.Tried, tested and trusted, ECDL programmes have been delivered to over 11 million people, in 41 languages across 148 countries. Over 2 million people have taken ECDL in the UK since 1997.ECDL is available at each of the main college campuses. This is a flexible learning programme which offers class tuition followed by testing. Most of the work can be carried out...

The world's number one IT qualification, ECDL is the benchmark for digital literacy in educational systems around the globe.ECDL equips students with the skills to use a computer confidently and effectively, building on existing knowledge and motivating further learning.Tried, tested and trusted, ECDL programmes have been delivered to over 11 million people, in 41 languages across 148 countries. Over 2 million people have taken ECDL in the UK since 1997.ECDL is available at each of the main college campuses. This is a flexible learning programme which offers class tuition followed by testing. Most of the work can be carried out...

The world's number one IT qualification, ECDL is the benchmark for digital literacy in educational systems around the globe.ECDL equips students with the skills to use a computer confidently and effectively, building on existing knowledge and motivating further learning.Tried, tested and trusted, ECDL programmes have been delivered to over 11 million people, in 41 languages across 148 countries. Over 2 million people have taken ECDL in the UK since 1997.The units that you can undertake are a choice of:• Word processing• Spreadsheet software• Presentation software• Improving Productivity• Database software• Security for IT Users• IT User Fundamentals• Using Email and the...