3438 Design courses in Oxted delivered Live Online

In this new series we will be exploring the culture of personal brands and how creators position themselves.

This is an upgrade to and will replace, the already existing City & Guilds 17th Edition Wiring Regulations all subsequent amendments. Course Description: If you have passed your 17th Edition since the last amendment then you are eligible to take this short 1 day 18th Edition update course! Save time and money by covering the topics you need for the new regulations, without having to go over all that you already know. If you have not yet done the 17th Edition then you will need to take our 3 day 18th Edition course. Changes for 18th Edition are as follows: Protection against overvoltages – Clause 443 is likely to be overhauled. Protection against fire – Chapter 42 will be updated with extra information on arc fault detection Electrical Embedded heating – Section 753 will be extended to include embedded electrical heating systems for surface heating, and will include de-icing and frost prevention systems. Energy efficiency – There will be a brand new section covering energy efficiency Please be aware that the Wiring Regulations course is not designed to teach you every regulation in the book but it will teach you the best practices on how to reference the latest regulations as you would on the job. As such key topics currently covered on the 17th Edition will still be included. We have been delivering Wiring Regulations courses for many years and although it is mainly theory based you cannot beat real training in a real classroom. By training with other people in your class you will benefit from being able to ask relevant questions as well as finding the answers to many questions from your fellow students that you may not have even thought of. City & Guilds The City & Guilds 2382-22 course will replace the current C&G 2382-15 certificate. This upgrade course will outline the change in the regulations and candidates must complete an online, multiple choice exam. Focus: You will study the latest standard of the IEE wiring regulations, including essential subjects such as safety, selection and erection of electrical equipment. There are 8 key modules and current amendments: Section 1 – Scope, Object and FundamentalsSection 2 – DefinitionsSection 3 – Assessment of general characteristicsSection 4 – Protection for SafetySection 5 – Selection and Erection of equipmentSection 6 – Inspection & TestingSection 7 – Special Installations or locationsSection 8 – Functional Requirements This course does include the latest amendments such as: Electromagnetic Disturbance Surge Protection Medical locations Operating and Maintenance Gangways Arc Fault Detection Devices (AFDDs) Changes to fire safety requirements in chapter 422, covering the design of electrical installations in industrial, commercial and multiple-occupancy homes, as well as new information for ‘protected escape routes’ Protection against over voltages Changes across Part 7: Special Locations This classroom based course will show, teach and perfect you on how to reference and use the book for situations that you will encounter while working in the field.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for those who have experience authoring content in HTML and CSS, and want to learn how to use new HTML5 and CSS3 features. This course can be taught on Windows©, Mac OS© X, or Linux©, and supports developers who work in any of those environments. Although JavaScript© knowledge is helpful, HTML and CSS are the focus, so this course does not require that the learner have extensive JavaScript skills. Overview In this course, you will develop web content in HTML5 and CSS3 following principles of responsive web design. You will: ?Optimize HTML content to take advantage of HTML5 and CSS3 features.?Write advanced CSS3 selectors and media queries.?Use advanced background and border options introduced in CSS3.?Use advanced text formatting options introduced in CSS3.?Use HTML5 graphics and multimedia elements, including transforms, animation, audio, and video. ?Follow best practices to enable HTML content to be successfully processed by many different web browsers and machine readers. This course focuses on the new and advanced features of HTML5, covering how to create HTML5 and CSS3 markup that will work well on the widest possible variety of web browsers, mobile devices, and machine readers, such as search engine web crawlers. Creating HTML5 Content Develop Web Content to Follow Standards Update Legacy Web Content to Meet HTML5 Requirements Using Advanced Techniques to Select and Apply Styles Use Advanced CSS Selectors Provide Alternate Layouts Based On Device Characteristics Using Advanced Background and Border Techniques Use Advanced Techniques to Create Backgrounds Use Advanced Techniques to Create Borders Incorporating Advanced Text Formats Use Web Fonts Apply Advanced Text Styles Adding Animation and Multimedia Use 2D Transforms Use Animation Styles Embed Audio and Video in a Web Page Making HTML Readable and Accessible Support Various Browsers Improve Markup to Benefit Human and Machine Readers Additional course details: Nexus Humans HTML5 - Content Authoring with New and Advanced Features training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the HTML5 - Content Authoring with New and Advanced Features course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

The two-day Adult MHFAider® courses are tailored around supporting adults, and can be attended by anyone from age 16 upwards. A lot of the education settings we work with have now trained a number of Adult MHFAider®’s to support their colleagues as part of their whole-school/college approach to mental health and wellbeing.

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

In this series we will be joined by a collection of creators and exploring their career including education, career steps and challenges.

To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable:  Tuesday 4 June: 9 - 12:30 Friday 7 June: 9 - 12:30 Friday 14 June: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.

To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable:  Wednesday 10 April: 9 - 12:30 Wednesday 17 April: 9 - 12:30 Thursday 25 April: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.

To make the drastic carbon reductions that are needed around the world, we need a global population that is educated, engaged and empowered to make the necessary changes. That’s why we believe Carbon Literacy training is so important – and why we need a multitude of trainers to deliver it. The Lighthouse Carbon Literacy - Train the Trainer course is designed to prepare you for delivering Carbon Literacy training, and support you on your journey to becoming a Carbon Literacy Trainer (CLT). Train the Trainer is normally delivered online to cohorts of up to 6 learners. Course timetable:  Tuesday 12 March: 9 - 12:30 Friday 15 March: 9 - 12:30 Friday 22 March: 9 - 12:30 Learners can arrive from 8:45am onwards. What we provide: Three half days of interactive workshops Facilitated peer learning amongst a small group Guided self-study and resources Guidance to inform your road to becoming a certified Trainer Skills for creating your own Carbon Literacy course A practical and hands-on approach to Carbon Literacy training 1:1 follow up coaching session Private LinkedIn Group. What you commit to: Attend and engage in training workshops Complete all self-study and homework Complete and submit Trainer evidence to the Carbon Literacy Project. Course requirements: The Lighthouse Train the Trainer course is designed to develop confidence, understanding and training skills in learners who already have a level of understanding of carbon and some experience of delivering training. Before commencing this course, learners should: Have experience of delivering training Have completed a Carbon Literacy training course Have worked with business in some capacity Aspire to deliver Carbon Literacy training either internally within the business they work in, or externally to other businesses. Why Lighthouse? Lighthouse has a proven track record of working with businesses to deliver sustainability improvements, from building circularity into business models to reducing carbon impacts. Last year we trained more than 700 employees from companies including Beko plc; Silent Night; Boston Scientific and PZ Cussons. Our course is fast-paced, informative and action-focused. Price: £750 + VAT. And if these dates don't suit you... If you want to book a course for your employees or discuss the design of a bespoke course, contact hello@lighthouse-sustainability.co.uk.

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE