1609 Courses in Birmingham

BAB Training Solutions offer a range of Level 2 Plant qualifications which are appropriate for individuals aged 16 and over working in the construction sector who specialise in plant operation and are looking to achieve their NVQ Diploma or Certificate which enables them to upgrade their trained operator cards to competent operator cards. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. There are large number of qualifications available within this sector including dumper, roller, excavator, tele-handler and much more. Please get in touch to discuss your plant operations requirements and we will be pleased to provide you with the right information and advice. CSCS Cards In order to obtain your full CSCS/ CPCS card you will need to hold CPCS/ NPORS (or equivalent) trained operator or have achieved your category relevant level 2 plant NVQ prior to undertaking the ‘New Entrant – (S)NVQ held’ application route. Please ask to speak with our qualification experts if you are unsure as to what qualification or route you should take.

The NVQ Level 2 Diploma in Curtain Wall is appropriate for individuals aged 16 and over working in the construction sector who specialise in the installation if Curtain Wall and Aluminium Architectural Glazing Systems and are looking to become eligible for the Blue CSCS Card. The aim of this qualification is to recognise the knowledge, skills and competence of individuals who specialise in this area and upon completion of the qualification, you will be awarded the NVQ Level 2 Certificate in Curtain Wall CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for this qualification. The red CSCS card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. In order for candidates to obtain their CSCS Card for Curtain Wall Installation they must also fulfil the requirements for technical knowledge as set out by the Council for Aluminium in Building and are generally required to complete CAB 1 day Curtain Wall essential knowledge training course. For more information regarding the CAB Course and CSCS requirements, please see the information below.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.

Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.

We will come to your school at a time that suits you and run a 2-hour workshop for all staff. We will present in clear and simple terms the school’s duties under the Equality Act, help you guard against discrimination, and leave you with useful resources. How will this workshop help your school? This is a practical, "hands on" workshop designed to be engaging and constructive. Over and above helping your school fulfil its legal duties, it will help ensure that nobody is left behind or discriminated against. The workshop will show how all protected characteristics covered by the Equality Act 2010 can be reflected positively in everyday school life. It will consider real-life examples and make this more meaningful and relevant by inviting participants to bring their own examples of equality challenges in school. We will show you how to get the best out of CSIE’s toolkit ‘Equality: Making It Happen’ – a succinct and user-friendly set of reference cards to help schools promote equality – and leave you with at least two complimentary copies. Above all, the workshop will help develop a shared understanding and build a consistent response to diversity and equality. We understand that all schools are at different stages of this journey, so this workshop will assist you in determining next steps and areas of specific focus for your setting. What will the workshop cover? The workshop will: provide an overview of the Equality Act 2010, including the Public Sector Equality Duty and what it means for all schools bring awareness to unconscious bias and how it can influence our interactions present strategies for removing barriers to learning and participation address intersectionality and how it affects people’s experiences help develop confidence and language for discussing sensitive equality issues add flesh to the bones of all the above, by considering real-life examples Who is it for? The workshop has been designed for all primary and secondary school staff and governors; delivery is adjusted to the context of each school. We encourage all teaching and non-teaching staff to attend, so that your school can develop a coherent and consistent response to diversity and equality. Feedback from previous CSIE equality workshops: Very knowledgeable presenter. I feel more empowered. Clear and concise. Very thought provoking. Clear, compassionate presentation.

This 3 day practical course (taken in professional beauty salon) designed to show You how to carry out manicures. This course is designed for complete beginners, who wish to learn from basic to professional most popular nail art techniques to start Your career as nail technicians. It is also good to refresh knowledge and learn new techniques for those of You that are already in business.

Aim To equip care staff with the knowledge, confidence, and practical skills to respond effectively and safely when a resident experiences a cardiac arrest, ensuring best practice in emergency resuscitation procedures. Learning Objectives By the end of the session, staff will be able to: Recognise the signs of cardiac arrest in a care home setting. Initiate a safe and effective emergency response, including correct positioning of the resident. Perform high-quality CPR on an adult using correct technique and rhythm. Use a defibrillator (AED) confidently and correctly. Identify environmental risks and adapt the environment to enable effective resuscitation. Demonstrate teamwork and role allocation in an emergency. Reflect on the importance of debriefing and support following a resuscitation incident. Location for delegates attending in person Foresters Nursing Home, Walton Pool, Stourbridge DY9 9RP Timings of the course 9.30am to 11.30am 12.00pm to 2.00pm 2.30pm to 4.30pm Before you book: Please do not send along staff who have just worked a nightshift. People arriving tired, stressed or late cannot gain the most benefit from a training course. We reserve the right to turn away individuals too exhausted to focus on the training or staff who turn up late for a course and disturb the flow of the proceedings. All CH Care Training courses are fully inclusive, but if you have any concerns about a member of staff's ability to participate because of physical, sensory or learning differences then please let us know in confidence in advance, so that we may make the appropriate adjustments. Cancellations CH Care Training operates a sliding scale of cancellation; If you cancel more than two weeks before the start date of a course, you can ask for a full refund, to change the names of the delegates being sent along, or to transfer a delegate to another training date. If you give less than two weeks but more than one week's notice of cancellation, 50 percent of the booking can be refunded. If you cancel less than a week from the training delivery date we wont be able to refund. There are no refunds for staff who do not turn up on the day of the training course. If CH Care Training needs to change the date or cancel a course for any reason we will give you the maximum notice we can. In exceptional circumstances we may cancel a course due to extreme weather or circumstances at the training venue. You will be offered a full refund or the opportunity to transfer your booking to an alternative date. Please ask your staff to read the following guidance before they attend the course: Arriving at the Venue The course will start promptly so please arrive at least 15 minutes before the start time of the training to allow plenty of time to use the toilet, and be seated ready for the start of the course. You can call Training direct on 0798 999 5180 if you are struggling to arrive on time. Please note that the meeting will be locked to late arrivals 10 minutes after the actual course starts. During the course As this is a working environment please ensure you allow the necessary time and focus to get the best from the material being presented. Please bring pen and paper to make notes during the course. Our training sessions are fun and very interactive. We will encourage plenty of comments, points of view and the sharing of lived experiences. Delegates should not share any sensitive information about a client or organisation. Our session agreement asks delegates to maintain confidentiality about individuals and organisations and to respect the views of others on the course. All CH Care Training courses are inclusive, but if you have any concerns about your ability to participate, such as sensory or learning differences then please let the Trainer know in confidence before the start of a course, so that they may make the appropriate adjustments. If the course contains practical elements such as Moving & Handling or First Aid, then please wear appropriate clothing to take part in these activities. You will be asked confidentially if you have any health concerns that could prevent you from taking part in the practical activities. Please let a Trainer know if you have any concerns about taking part in the practical courses. Refreshments are provided for free. Please bring a packed lunch for any full-day courses. After the course We will email you a pdf of the course once the training has finished and we have checked that everyone was able to join. If your Manager booked you onto the course using your work or personal email, or if you book yourself onto a course, you will receive the pdf directly. If your Manager booked you onto the course using your organisation’s email address a copy of the course will be available on request from your Manager. We will also email a link to an online evaluation and we ask that you please fill this in and return it to us so that we can continue to improve our services. All of our evaluations are gathered anonymously. If you have any questions, please contact Training on 0798 999 5180 or email sales@chcaretraining.co.uk.

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

Mediation and Conflict Course