14484 Courses

Microsoft Excel® in Depth (Virtual) 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

Practical Creative Pattern and Gament Making Course, for teachers of GCSE D&T and Art & Design Textiles.

6 Days (Excluding Weekends) We run weekly open courses for accreditations including CPCS, CSCS Health & Safety, NPORS, IFAP, SMSTS and more. We also offer bespoke training courses or in house training nationwide. Upon arrival at our centres candidates will be inducted to the site by their qualified instructor who will be training them for the day. After registration candidates will be issued with a pack full of information relevant to the category they are being trained in. Included in this pack are theory questions, practical specifications, pre-start check lists, marking sheets and more. We ensure that these materials provided excel the individual to successfully complete their course. We are aware that having good quality machines give candidates a significant advantage when undertaking their training. We endeavour to supply candidates with the highest quality plant training and machinery on our site using a variety of certified suppliers. These machines come equipped with all the health and safety features and include – but are not limited to – JCB, Magni, Merlo, Caterpillar, Thwaits and Manitou. Get in touch with us today to find the right course for you. Our team are on-hand and ready to support you with your construction training requirements.

Level 2 NVQ Diploma in Piling Rig Operations - Piling Rig Operative

What is Person Centred Planning? How is it different to any other kind of meeting or planning? On this day all will become clear… Give your team the opportunity to pause and reflect on what matters most to them about the work they do. The act of listening to each other creates relationship and strengthens trust and inclusion within the team – in creating a shared vision, groups of people build a sense of commitment together. They develop images of ‘the future we want to create together’, along with the values that will be important in getting there and the goals they want to see achieved along the way. Unfortunately, many people still think ’vision’ is the top leader’s job. In schools, the ‘vision task’ usually falls to the Headteacher and/or the governors or it comes in a glossy document from the local authority or the DfES. But visions based on authority are not sustainable. Making inclusive action plans using full participation and graphic facilitation Drawing on the planning tools MAPS and PATH (Pearpoint, Forest and O’Brien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. Jack Pearpoint, Marsha Forest and John O’Brien developed these innovative approaches in North America and they are being used successfully in many parts of the UK. The planning can focus on an individual, group or organisation and provides a powerful problem solving opportunity, which is flexible and robust enough for many occasions. Tell the story, find the dream, touch the nightmare, and explore who you are, what are the gifts and strengths of the person or group, what are the needs of those present and what is the action plan for the future? Learning objectives  Participants understand Person Centred Planning and its values and applications Participants have skills and confidence to facilitate PATH/MAP processes Participants learn graphic as well as process facilitation skills Strengthens practitioners inclusive practice Provides additional tools for those involved in inclusive work in schools and the community Further develop problem solving and planning skills Course Content The course answers the questions: Need to find new ways to bring Pathway Planning alive? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LA? Inclusive Solutions offer an introductory day to person centred planning or a 3 – 10 session course which is practical as well as values based. Participants will receive direct individualised coaching and training. We will cover: The person being at the centre Family members and friends being full partners Planning reflecting the person’s capacities, what is important to the person and specifying the support they require to make a full contribution to their community Planning building a shared commitment to action that will uphold the person’s rights Planning leading to continual listening, learning and action and helping the person get what they want out of life. Essential Lifestyle Planning, PATH MAPS Personal Futures Planning.

Better Business Cases™ Foundation and Practitioner: Virtual In-House Training Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the combined foundation and practitioner course is to develop a candidate's ability to deliver a comprehensive business case through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this course, a candidate will be able to start applying the model to a real business case development project. The outline presented in the course overview will be addressed in the first 2 days, with the Foundation exam conducted on the morning of Day 3. Then the topics will be revisited at a deeper level, for 2 more days, with the Practitioner exam conducted on the afternoon of Day 5. What you will Learn At the end of this program, you will be able to: Develop the lifecycle of a business case and establish the relationships between the five cases Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario. Overview of Better Business Cases Alignment with the strategic planning process Importance of the Business Case using the Five Case Model Overview of the Five Case Model Purpose of the key stages in the development of a spending proposal Purpose of a Business Justification Case Business Case Development Process Purpose of project / programme assurance and assurance reviews Responsibility for producing the Business Case Determining the Strategic Context and Undertaking the Strategic Assessment Scoping the Scheme and Preparing the Strategic Outline Case Planning the Scheme and Preparing the Outline Business Case Procuring the Solution and Preparing the Full Business Case Implementation and monitoring Evaluation and feedback Making the Case for Change Agree on the strategic context Determine spending objectives, existing arrangements, and business needs Determine potential business scope and key service requirements Determine benefits, risks, constraints, and dependencies Exploring the Preferred Way Forward Agree on critical success factors Determine long list options and SWOT analysis Recommend a preferred way forward Determining Potential Value for Money Revisit the short list Prepare the economic appraisal for short-listed options Undertake benefits appraisal Undertake risk appraisal Select preferred option and undertake sensitivity analysis Preparing for the Potential Deal Determine the procurement strategy Determine service streams and required outputs Outline potential risk apportionment Outline potential payment mechanisms Ascertain contractual issues and accountancy treatment Ascertaining Affordability and Funding Requirement Prepare the financial model Prepare the financial appraisals Planning for Successful Delivery Plan programme / project management Plan change and contract management Plan benefits realization Plan risk management Plan programme / project assurance and post-project evaluation Procuring the Value for Money Solution Revisit the case for change Revisit the OBC options Detail procurement process and evaluation of best and final offers (BAFOs) Contracting for the Deal Set out the negotiated deal and contractual arrangements Set out the financial implications of the deal Ensuring Successful Delivery Finalize project management arrangements and plans Finalize change management arrangements and plans Finalize benefits realization arrangements and plans Finalize risk management arrangements and plans Finalize contract management arrangements and plans Finalize post-project evaluation arrangements and plans

Electric Vehicle Technicians have had access to certified training at different levels of competency for a number of years, but this has not been the case for Vehicle Dismantling Technicians until now. Vehicle repairers have been taught how to diagnose faults on Electric or Hybrid vehicles, make them safe, repair or replace the high voltage component and then put the vehicle back together and make them work. Vehicle dismantlers need to know how to assess Electric and Hybrid vehicles, store them properly, make them safe and dismantle them, store the parts and ship them out for re-use, repurposing or recycling, so the accredited and certified training for vehicle repair technicians met some of the criteria for dismantling but not all. Electric Vehicle Dismantling Training raises the professional standards of the vehicle dismantling and recycling industry, provides consistent training standards across the world, helps develop knowledge and understanding, enables team members to grow their own abilities, and achieve accredited training.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Inspirational Leadership Skills: Practical Motivational Leadership Course Overview: The "Inspirational Leadership Skills: Practical Motivational Leadership" course is designed to empower aspiring leaders with the essential skills to lead with confidence and inspire others. This course covers a wide range of leadership aspects, including emotional intelligence, effective communication, public speaking, and decision-making. It is ideal for those seeking to enhance their leadership capabilities, foster motivation, and create positive organisational change. Learners will develop the skills needed to influence and motivate others, solve complex problems, and lead with emotional intelligence, setting them up for success in leadership roles. Course Description: This course offers a comprehensive exploration of key leadership principles that every leader must master. Topics include the development of self-leadership, the role of emotional intelligence in leadership, and mastering communication skills for effective team engagement. Learners will delve into public speaking techniques, critical thinking strategies for decision-making, and methods for motivating and counselling individuals. Additionally, the course covers management and leadership strategies, equipping learners with the tools to handle organisational challenges. Throughout the course, learners will gain the knowledge and confidence to lead with influence and drive positive results. Inspirational Leadership Skills: Practical Motivational Leadership Curriculum: Module 01: Developing the Leader Within You Module 02: Emotional Intelligence in Leadership Module 03: Communication Skills Module 04: Public Speaking Module 05: Critical Thinking in Problem-Solving and Decision Making Module 06: Motivation and Counselling Module 07: Management and Leadership (See full curriculum) Who is this course for? Individuals seeking to enhance their leadership capabilities. Professionals aiming to improve their managerial and communication skills. Beginners with an interest in leadership or management roles. Those aiming to motivate and inspire teams in various industries. Career Path: Team Leader Manager Executive Leadership Consultant Public Speaker HR Professional Motivational Speaker

Manual Handling full-day Train The Trainer course Aim of the course: To equip Team Leaders and Co-ordinators in Care Homes with the knowledge, skills, and confidence to deliver engaging and safe manual handling training to their own staff — including practical techniques, training methods, and peer teaching practice. Learning Objectives: By the end of this course, delegates will be able to: Outline the legal and professional responsibilities related to manual handling in care. Identify manual handling risks and describe common injuries and incidents. Demonstrate safe manual handling techniques, including hoist use, slide sheets, and repositioning methods. Plan and structure a complete manual handling training session. Select and adapt training materials and equipment to suit different learners and settings. Deliver clear, confident explanations and demonstrations of manual handling techniques. Support learners during practical sessions, including correcting unsafe practice. Facilitate discussions and reflective learning with care staff. Evaluate learners’ understanding and performance through observation and questioning. Maintain accurate training records and identify when refresher training is needed. Deliver a short theoretical and practical training activity to peers, receiving feedback. Reflect on their own strengths and areas for development as a trainer.