1894 Courses in Cardiff

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

leadership management training course

leadership management training course

Care/Support planning will cover a range of topics including assessments, record keeping and managing information. The training will give your care and support workers the knowledge and understanding to effectively write a care plan for the people they support and ensure a clear log is kept ready for CQC inspections. Explore the key features of Care Planning including person centred planning and the promotion of personalised services including goal setting.

leadership management training course mentoring coaching

The fundamental tool to identify waste, create effective process flow, reduce process cycle times, and implement process improvement.

Reliability Centred Maintenance (RCM) is commonly used to help establish safe minimum levels of maintenance, determine changes to operating procedures and help establish maintenance regimes and plans. Successful implementation can result in cost savings, machine uptime and improved risk management. But the devil's in the detail - how can you achieve these benefits and successfully implement RCM in your organisation? This programme will help you do just that. Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. To provide a better understanding of RCM, particularly: What, why, how and who? Opportunities and benefits Risks Cost effectiveness Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. 1 What is maintenance? Why maintain? Traditional maintenance methods Common current practices and trends 2 What is Reliability Centred Maintenance? Its history Its development Current usage Where can it be cost-effective? 3 How does it work? Basic features Key criteria Maintenance options Key outcomes 4 Making the business case and preparing the strategy Identifying and quantifying current risks Identifying and quantifying current costs Motivating decision-makers Identifying and empowering those who have to deliver the results Educating / gaining buy-in from interested parties 5 Implementation Identify business functions Prioritise functions Verify correct usage Identify failure modes Identify the consequences of failure Understand the failure process Specify the appropriate maintenance action(s) 6 Ongoing requirements Monitoring Recording Analysis Continuous re-evaluation 7 Open discussion Sharing experience and addressing specific issues of interest to participants Course review Close

Meetings are a fact of working life - both virtual and physical meetings. Recording the key points from meetings is critical to making sure that accurate information is captured, and action points are clearly identified and allocated. This virtual training session will support members of staff to develop their skills in recording the key points from meetings and discussions. This course will help participants: Describe the different levels of note taking and pick the appropriate style for the meeting Prepare to take minutes in the virtual and the physical environment Liaise and work in partnership with the meeting Chair Use a template to enable the capturing of key points Set up the room ready for the meeting Identify key points to record, versus what not to record Interrupt the meeting confidently to check key points Take neutral, accurate and concise records Produce a well-laid out set of minutes. 1 Introduction Objectives and overview Introductions and personal aims 2 An introduction to minutes Purpose and use Different levels of notetaking 3 Preparing to take minutes Identifying the purpose of the meeting Working with the Chair Tips and techniques to prepare effectively Case studies, review and discussion The physical environment: setting up for a meeting 4 Listening and recording Tips and techniques to make the process easier How to interrupt a meeting What to record; what to leave out Recording in short-form using playscript and bullet-points Listening neutrally Activity: Minuting a Meeting The tricky ones and how to overcome problems in the meeting 5 Preparing the minutes Producing a set of draft minutes Tips on grammar, punctuation and layout Stylistic variation Managing feedback from the Chair 6 Review Summary of key learning points Action planning

To provide a fundamental understanding of building services in the context of: The working environment The success of the core business The health and safety of the occupants Operating cost and environmental impact The optimisation of cost and value Strategies for continuous improvement DAY ONE 1 Building services fundamentals The function of services in commercial buildings and their importance to the core businessElectrical servicesLightingHeatingVentilation and air conditioningLiftsWater Understanding IT and communication systems Practical exercises 2 The provision of comfort and safety Statutory requirementsHealth and safety legislationControl of contractorsRisk assessmentFire precautionsLegionella, sick building and other risks Business requirementsUnderstanding user requirementsMatching systems to business needs Practical exercises 3 Getting the design right What the FM needs to know about design and its procurementSuccessful space planningRelationship between services, space planning and designGetting the brief rightSupplier selection and management Practical exercises DAY TWO 4 Operation and maintenance Why maintain?Maintenance contractsInput and output specificationsResource optionsContracts - principal elementsTendering - key stepsSelection criteriaOperational criteriaMaintenance trends Performance-based service provisionInput and output specificationsKPIs and thresholdsRisk containmentValue-add opportunitiesPerformance contract strategy Practical exercises 5 Contingency planning Being ready for the unexpected Identifying and reducing riskInternal risksExternal risksIdentifying threats at your site Managing riskProtective systemsOccupier obligationsFire managementTesting Practical exercises 6 Commissioning services systems Physical commissioning Common problems Typical costs Commissioning stages Continuous commissioning Energy efficiency and the scope for environmental improvement Practical exercises 7 Satisfying the occupants Obtaining and responding to feedbackWhen to get feedbackWhyHowWhat to do with it Practical exercises 8 'Air time' Sharing experience and addressing specific issues of interest to participants Course review Close

REFERENCE CODE 610/0501/0 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Qualification mandatory units (Mandatory – Credits: 144 Minimum, 144 Maximum) A/650/0295 (VR40V3) Erecting Masonry Structures in the Workplace Level: 2 Credits: 31 D/650/0296 (VR41V3) Setting out to form Masonry Structures in the Workplace Level: 2 Credits: 23 T/650/0293 (VR42V3) Erecting Masonry Cladding in the Workplace Level: 2 Credits: 24 A/503/2772 (209v2) Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Level: 3 Credits: 10 Y/650/1392 (210V3) Developing and maintaining good occupational working relationships in the workplace Level: 3 Credits: 8 R/503/2924 (211v2) Confirming the Occupational Method of Work in the Workplace Level: 3 Credits: 11 A/503/1170 (641) Conforming to General Health, Safety and Welfare in the Workplace Level: 1 Credits: 2 T/650/1391 (49V3) Erecting masonry to form architectural and decorative structures in the workplace Level: 3 Credits: 35 Qualification optional units (Optional – Credits: 19 Minimum, 19 Maximum) H/650/0298 (VR44V3) Erect Thin Joint Masonry Structures in the Workplace Level: 2 Credits: 24 Y/650/0294 (VR50V3) Repairing and Maintaining Masonry Structures in the Workplace Level: 3 Credits: 25 R/650/0292 (VR639V3) Installing Drainage in the Workplace Level: 2 Credits: 19 F/650/0297 (VR810V1) Installing and forming specialist masonry elements in the workplace Level: 3 Credits: 21