305 Courses in Cardiff

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 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

leadership management training course mentoring coaching

leadership management training course

leadership management training course

NPORS Scissor Lift Training The aim of the NPORS Scissor lift training is to provide the candidate with the basic knowledge and practical skills involved in operating Mobile Elevated Working Platforms. NPORS Scissor lift training delegates will be enabled to: Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. Boom Lift Training We at Vally Plant Training also offer the Boom Lift Training Course. The two can run at the same time so you are able to gain both qualifications to operate these MEWPS in the workplace Mobile Elevating Work Platform (MEWPS) Course Summary An Introduction to the Construction Industry. Provision and Use of Work Equipment Regulations. Lifting Operations and Lifting Equipment Regulations. Health and Safety at Work Order. Other current relevant regulations. Introduction to the machine. Pre – shift inspections. Controls and instruments. Operators Code of Safe Practice. Components and types of Mobile Elevating Work Platforms. Limitation of use. Moving and locating machine. Emergency controls. Servicing and Inspection Testing. Scissor Lift Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of the Scissor Lift and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built MEWP practical training area to simulate an actual working environment. Our Scissor lift training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS scissor lift Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. Who should take the Scissor Lift Training? This training is ideal for individuals who need to operate Mobile Elevated Work Platforms (MEWPs), particularly scissor lifts, in various industries. 2. What does the Scissor Lift Training cover? The training includes site safety awareness, machine control familiarization, pre-start checks, safe operating techniques, recognizing hazards, and emergency procedures. 3. How long is the Scissor Lift Training? The course typically lasts 1 day and can accommodate up to 6 candidates. 4. What certification do I receive upon completion? Participants receive an NPORS card, either the traditional card valid for 5 years or the NPORS card with CSCS logo, initially valid for 2 years. 5. Are there any prerequisites for the Scissor Lift Training? Candidates must have a good understanding of English. For the NPORS card with CSCS logo, a CSCS Health & Safety test must have been completed within the last two years. Our more courses: Refine your expertise with our specialized Lift Supervision Training, Slinger Signaller Training, Ride-On Road Roller, Telehandler Training, Cat & Genny Training Slinger Signaller, Abrasive Wheels Training, Lorry Loader Training and Telehandler Training. Elevate your skills for safer and more efficient operations in construction and logistics. Enroll today to advance your career prospects. For those looking for a “NPORS Scissor Lift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

NPORS Ride On Roller Training The aim of the NPORS Ride On Roller Training is to provide both theoretical and practical training in the safe and efficient use of the ride on roller . On successful completion of the ride on road roller training you will be issued with the NPORS identity card with or without the CSCS logo. Discounts are available for multiple bookings NPORS Ride on road Roller Training or testing can be carried out on your site nationwide or at our Training Centre in Gloucestershire Ride On Roller Experienced Worker Test Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Ride On Roller Experienced Test Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Road Roller Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Click for our terms and conditions Your skills, our commitment—always at the best price. NPORS Ride On Roller Test is for operators who have received some form of training in the past or alternatively has been operating the Ride On Road Roller for a period of time. If you are unsure if you qualify to go down the test route please contact us to discuss this in more detail. Turn your Ride On Roller red card to blue with our hassle free Roller NVQ, for more information CLICK HERE Ride On Roller Course Content The course time is spent on developing skills and knowledge associated with the road roller. Topics covered include:- Site Safety Awareness. Operating Safety Code. Introduction to machine / Control Familiarisation. Pre-Start Checks and Refuelling. General Operating. Set the roller for compaction duties Explain actions required for hazards underground and overhead services Recognise compacted/uncompacted areas Conditions that may cause instability of the roller Safety procedures when working up to unsupported edges. Park and shut down procedures. NPORS Multi-Choice Theory Test. NPORS Practical Skills Test. Variations Pedestrian Roller Ride on articulated Ride on rigid Ride on heavy duty Ride on vibrating Dead weight Ride on articulated/vibrating Ride On Road Roller Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of Ride On Road Rollers and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical road roller training area to simulate an actual working environment. Our Ride On Roller training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Roller Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. Who should take the Ride On Road Roller Training? This training is ideal for individuals who need to operate ride-on road rollers, both novices and experienced operators. 2. What does the Ride On Road Roller Training cover? The course includes site safety awareness, machine control familiarization, pre-start checks, operating techniques, recognizing hazards, compaction procedures, and safety protocols. 3. How long is the Ride On Road Roller Training? For novices, the course lasts 3 days. Experienced operators can take a 1-day test. 4. What certification do I receive upon completion? Participants receive an NPORS card, either the traditional card valid for 5 years or the NPORS card with CSCS logo, valid for 2 years initially. 5. Are there any prerequisites for the Ride On Road Roller Training? Candidates should understand English. For the NPORS card with CSCS logo, a CSCS Health & Safety test must have been completed within the last two years. More courses: Refine your skills with our Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Scissor Lift, Slinger Signaller, Abrasive Wheels Training, Lorry Loader Training and Telehandler Training. Elevate your expertise for safer and more efficient operations in construction and logistics. Join us today to advance your career prospects. For those looking for a “NPORS Scissor Lift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

NPORS Plant Mover Training Provide candidates with the training and knowledge to enable them to carry out the movement of plant equipment safely. NPORS Plant Mover Training course is aimed at people who are responsible for moving the machinery around the site, this could be maintenance staff or drivers who deliver the machinery to site. All staff should be trained in the safe operation of plant or machinery. NPORS is an approved CSCS Partner Card Scheme, providing evidence that individuals working on construction sites have the appropriate training and qualifications for safe movement of construction machinery. Furthermore, Plant Mover training criteria is based on the approved standards of the Construction Leadership Council. Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. Course Content Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator. Have a working knowledge of the manufacturer‘s handbook for each machine. Be able to locate and identify the major components of the machine and explain their functions. Be able to locate and identify all controls and operate the machine safely. Conduct all pre-operational checks in accordance with the manufacturer‘s recommendations. Use the correct PPE for Plant Movers. Prepare machinery for movement and operate machinery safely in forward and reverse gears over varying terrain. Conduct all necessary safety checks in the working area. Correct Storage and transportation of machinery attachments (buckets, forks, breakers etc). Carry out all end of shift and shut down procedures. Variations: Lifting equipment Earthmoving equipment Accessing Equipment Plant Mover Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of plant movers and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment for the movement of plant Our Plant Mover training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Plant Mover Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. What qualifications do I need to enroll in the Plant Mover Training course? The course is intended for individuals who have some prior training or extensive experience with plant moving. If unsure, it’s advised to contact the training center for specific eligibility requirements. 2. What does the Plant Mover Training include? The training covers industry basics, safety responsibilities, machine operations, pre-operational checks, and correct use of personal protective equipment. It includes both theoretical and practical sessions to ensure comprehensive learning. 3. How long does the course last, and what are the class sizes? The course duration varies: 2 days for novices with a maximum of 6 candidates, and 1 day for experienced workers with a maximum of 8 candidates. 4. Are there any certifications provided after completing the course? Yes, successful candidates receive an NPORS card, which is a recognized certification for operating plant machinery safely. The type of card (traditional or with CSCS logo) depends on the specific requirements met during the course. 5. Can I take this course at my workplace? Yes, the training center offers options to conduct training at your site nationwide, though additional charges for mileage and accommodation may apply. 6. Is there funding available for this training? CITB funding might be available for eligible candidates, which can help cover the cost of the training. More courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. For those looking for a “NPORS Scissor Lift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

Our self-leadership and executive development programme can be fully ITA SDS funded supporting leaders and business owners and creating a growth plan. SDS INDIVIDUAL TRAINING ACCOUNTS (ITA) Rely On Our Team for Your Executive Development The Power Within Training offers unrivalled executive development training for go-getters and self-starters throughout England and Scotland. Did you know that approximately 55% of people making their living in sales don’t have the right skills to be successful? Good sales skills are some of the rarest and most sought-after skills in the workforce. Whether you’re running a business, looking to progress further in your career or want to sharpen your skills before returning to work, our self-leadership training will help you develop the skills you need to succeed. After completing our executive development training, you’ll have a sales mindset and the skills to secure your ideal role, perform better, and utilise high-payoff action-planning techniques. Don’t hesitate to contact us to learn more information. OUR TRAINING SOLUTIONS What is Self-Leadership Executive Training? Self-Leadership Development Our self-leadership development course was designed to give you total control of your career, business, and professional life. Most professionals will spend more than 80% of their time at work or in business. We’ve structured our executive training to help those looking to enhance their career prospects or business success by taking advantage of our unique Motivational Intelligence seven steps to success framework. The seven-step success system will take you through a journey of self-discovery, self-awareness, and self-development, which enables you to understand the barriers and self-limiting obstacles that have been holding you back. The Power Within’s self-leadership training will guide you through overcoming these barriers and eliminating them from your life. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Benefits of Self-Leadership Development The self-leadership training has been designed from the ground up to inspire, guide, and develop you into not only achieving your goals but being able to measure success in your career, help you find your dream job, and help make an immediate impact in everything you do. Completing our executive leadership development course will allow you to utilise emotional intelligence to get the best of your team while focusing on clear values and principles that increase your overall success and profitability. Working on your self-leadership skills will grant you greater insight into the factors hindering or impacting your success while giving you the tools to make decisions and get into action. Here are some additional benefits of our self-leadership training: Build Awareness – When you’re a leader, you must inspire and motivate people to achieve and go after the bigger picture for your organisation. You’ll need an effective and flexible leadership style to ensure your team succeeds. We’ll help you discover your leadership style and how you can use it effectively to the advantage of your business. Increase Team Engagement, Motivation, and Accountability – How can you expect your team to behave if you’re no longer motivated to succeed? The Power Within will give you the tools to keep striving toward success while ensuring your business is focused and motivated. Cultivating a High-Performance Culture – The right high-performance culture installs peak performance into every team member. Through our executive development, you’ll be able to help each reach their targets while they look for ways to improve constantly. Develop Strategic Skills – We’ll help you develop leadership skills and self-improvement goals, allowing you to introduce changes to your business based on your guiding visions while encouraging others to share the same vision. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. What Are the Key Skills Learned from Executive Development Training One of the first sets of vital skills for self-leadership you’ll learn is the ability to stop, step back, and reflect on the things that trigger us to react. When we react, we’re being controlled by the trigger. Another skill we’ll help instill is to consider intention. Intention is important to us, such as our values and what we’re trying to achieve. When you become intentional, you start to live a life of choice. Self-leadership and executive development are a journey. The more self-leadership we attain, the more successful we’ll become. The more successful we become, the more self-leadership we need. Here are some additional critical skills you’ll learn from our self-leadership training: Self-Awareness – It’s vital to hone your ability to see yourself as clearly as you are. This skill takes dedication, introspection, and mindfulness. Also, a dose of self-awareness helps with self-control, self-confidence, and feelings of validation. Overall, you should be open to critique and accountability. Goal Setting – A good self-leader must be proactive in not only identifying their goals but how to reach those goals in a manageable manner. Our executive development training will teach you how to break down a larger goal into more attainable steps to avoid burnout while helping you celebrate smaller milestones. Self-Motivation – A classic way to handle self-motivation is to divide long-term goals into smaller, more attainable ones. This optimization means recognising what about the goal that appeals to you, then forming a strategy that aligns with your strengths and values toward that goal. Constructive Thought Patterns – Through our leadership skills and self-improvement course, you’ll be able to review your performance and assess your intentions and effectiveness while providing an opportunity to ensure your strategies are geared towards success. This is done by focusing on improving strengths and the mental imagery of yourself that recognizes your capacity to grow, develop, and change. Self-leadership training teaches you to see yourself as having the ability to create, improvise, innovate, and adapt. OUR LIVE WORKSHOPS ARE BACK What’s Covered in Our Executive Development? Self-Leadership "It's a mindset thing" When you undergo our self-leadership training, you’ll experience several modules designed to allow your conscious and subconscious belief systems to work together for a predetermined goal or set of outcomes. Self-leadership is one skill that will significantly impact your career, team, and even your life’s happiness. Our executive leadership development course promotes bold and powerful decisions to get you back into the driver’s seat of your life and make the best of each day by setting goals, shifting your mindset, and finding your purpose. During each module, we’ll work with you and help you design and deliver your team leadership programmes catered to your team and your business dynamic. Our goal is to allow you to evolve into a bigger and better leader. Here are some of the modules in our self-leadership training: Unleash Your True Potential Create Your Personalised 7-Step Success Framework Peak Performance and Self-Mastery Growth Mindset and Mindset Performance The Power of Feedback Taking Back Control of Your Personal & Professional Journey Goal Setting & Defining If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Discover Who’s Leading Our Self-Leadership Training James Fleming, the co-creator of The Power Within, will lead your self-leadership training. James founded The Power Within with his wife, Enas Fleming. They wanted to inspire people around the world to think better, be better and achieve more. James believes that everyone can be whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Course Overview Our self-leadership development course is a quick-paced training that is between eight and twelve hours in length. After you attend the face-to-face workshops, you’ll be given access to our online self-leadership training portal. This allows you to continue your journey of self-development by ensuring you’ll always have a system and process to fall back on when you need it. One of the best parts of our executive development course is that you receive this information fully funded. Even if you aren’t eligible for funding, you can still invest in this course and begin a new chapter of professional development for yourself. Elevate yourself if any of our eligibility requirements apply and you early less than 22,000 a year.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print