389 Code courses

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

REFERENCE CODE 603/7493/7 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The Level 2 NVQ in Insulation & Building treatments is for those who work with different types of insulation and building treatments and want to prove their competence in one or more of the following areas: Wood preserving and damp-proofing, Wall Tie replacement, Cavity Wall insulation, Solid Floor insulation, Under Floor insulation and Cold Roof insulation. There is also a Level 2 qualification available that may be more suitable for those in the sector with a greater degree of experience or level of responsibility

If you want to keep up with the latest trends in business and project management, IIL's International Project Management Day is the must-attend event of the year! Approaching its 19th Anniversary, IPM Day gathers thought leaders, industry experts, and business professionals worldwide for a rich and immersive learning experience. You will gain new knowledge, skills, and best practices to navigate complex projects and adapt to change in a dynamic business landscape. Embrace the need for change and adaptability. By embracing new ideas, perspectives, and approaches we open ourselves up to endless possibilities for growth and improvement. Empower yourself and your teams by providing them with the necessary tools, resources, and support to drive meaningful and sustainable transformation. Evolve and harness the power hidden behind the uncertainty of our current world. Together we can build a brighter, more efficient, and sustainable tomorrow. Use code FINDCOURSES to receive $12 off this event! Up to 26 PDUS Keynotes The Key to Project Management Leadership Success: Engaging Your Team Members The Missing Piece in Leadership Styles & Practices AI in Project Management & Business: Panel Discussion Presentations Embracing Hybrid Ways of Working Project Management 4.0, PMO Mindset, and Project Manager Power Skills Maximizing Team Performance: The Intersection of Brain Chemistry and Team Building Becoming the Warrior: Strategies for Achieving Goals Arrows in Your Project Management Quiver Excel Tips & Tricks You Probably Haven't Seen Before Unleashing the Potential of a Distributed Workforce From Risks to Requirements - An Approach to Project Initiation Practical Implications of Artificial Intelligence to the Project Management Community Smart City Lab - Project Perspective Inclusive Leadership: Building Great Companies on Purpose Self-Paced Courses Kanban: A Beginner's Guide to Getting Started Understanding Lean Fundamentals

REFERENCE CODE 603/6964/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification enables the learner to demonstrate and recognise their skills, knowledge and understanding and to demonstrate their competence in a real workplace environment so that they can work in the Site Logistics Operations sector within the construction industry. 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 routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete.

REFERENCE CODE 600/6515/1 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview 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 routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete. This qualification is specifically aimed at those carrying out general construction operations work; there is a Level 2 qualification for those involved in maintenance along with a suite of specific qualifications in a wide range of construction occupations available.

Java Front-ends for desktop and mobile With Java FX Programming Java Front-ends for desktop and mobile With Java FX In this course we create attractive, functional Front-ends using JavaFX. Prerequisites: Delegates already have basic Java Skills. Duration: 2 consecutive days, the first date shows as the booking date Where: Online with Gotomeeting.com Download: Download Java JDK and Eclipse IDE. London classroom: on request locations, bring you own device Location: Online Interactive Instructor-led Webinar. Our Style: This is a very practical course giving you hands-on practice. Included: Course exercises, notes, examples, computers, evaluations Certification: PCWorkshops JavaFX Qualification Java Intermediate and Front-end Course Description Database Concepts Revision: DataBase SQL, database principles and JDBC GUI's with Java FX Building Java FX GUI's Course Contents: GUI's with JavaFX Building Java GUI's. Create a front-end form interface for an application. Working with nodes, labels, inputboxes, prgress bars, etc. Formatting your front-end. Import a Java package to interact with the front-end. Interact with a database via the front-end. Practical Examine the Java SE event model. What is an event. What is event handling. Develop event handlers. Develop Lambda-style event handlers. Practical Create a quotation app. Create a movie booking app. How to create your installer and upload your app Webservices Java Web services What are Web Services? Why Java Web Services? Web Services - Characteristics Web Services - Architecture Web Services - Examples and exercises What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java Intermediate and Front-end Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

REFERENCE CODE 603/2369/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed those who carry out activities in the Construction Industry working with Glass Reinforced Plastics (GRP) products. The qualification has a core group of 5 mandatory units that cover the generic areas including Health and Safety, transport and storage of tools, materials and equipment, checking and confirming the job specification and communication skills. The qualification also has a group of optional units that cover preparation, positioning, testing, installation and assembly. The qualification, along with the required separate proof of Health and Safety knowledge will give candidates a route to the relevant CSCS card required for site access.

REFERENCE CODE 603/7248/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The aim of this qualification is to confirm that the candidate has the skills and knowledge to install Curtain Wall systems on site. It is not expected that all curtain wall installers will carry out identical tasks as there are many variations in system types and installation environments, so the qualification had been developed to allow as wide an uptake as possible. All of the work needs to be completed in accordance with relevant legislation, regulations and health and safety guidelines

The three-day FAW course is our most thorough First Aid course. It is designed for you if you are a nominated First Aider in a hazardous environment, such as a factory or a construction site, as well as providing you with complete training for any other work situation.

Chemical Peel Course What are chemical peels? A chemical peel is a procedure in which a chemical solution is applied to the skin to remove the top layers. The skin that grows back is smoother. With a light or medium peel, you may need to undergo the procedure more than once to get the desired results. Course content * Health and safety * Code of practice for hygiene in beauty salons * Sterilisation and disinfection * Appearance of the therapist * Ergonomics * Handwashing * What are chemical peels * Skin ageing * Free radicals * Fitzpatrick skin types * Glycolic Acid * Lactic Acid * Tartaric Peel * Malic Acid * Phytic Peel * Mandelic Peel * Enzyme Peels * Salicylic Peel * PHA Peel * Alan Peel * TCA Peels * Jessner Peel * Contra-actions * Contra-indications * Treatment protocols Kbh Training kit * Seanergy peel 1x * Aftercare cream 2x How does the course work? The course is divided into 2 parts, the first part is theoretical which you have to complete before you come for your practical training, and the second one is a practical assignment. The practical assignment is done on the day which will be agreed upon course purchase. You will spend around 2-3 hours practising on a model in our venue in London E106RA. Will I require a model? Yes, usually 1 model is required Do I Need Experience Before Booking a Course? We’re pleased to offer courses to people with lots of different experiences. However, previous experience nor qualifications are not necessary if you would like to enrol on our Course. Certificate You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public Payment By paying for the course you agree to our Terms and Conditions