1300 BA courses in Bradford

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 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 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

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

Meetings are a traditional and essential component of local government. For both elected members and officers, meetings serve as a forum for discussion and agreement, planning and monitoring, communication and leadership, and decision-making. Used appropriately, meetings can challenge, inspire, illuminate and inform. And while they are not the only meetings that elected members will be asked to attend, committee meetings, in particular, are a mainstay of the political management process. Effective chairing is important because it can provide clear leadership and direction, ensure that debates are focused and balanced, enable decisions to be reached and ensure that resources are used to best effect. This two-hour 'masterclass'-style workshop will help elected members to understand their role, offer some approaches and ideas that will help to tackle typical challenges, and help to generally improve their effectiveness as a chair. To understand the skills and qualities of a good chair To learn ideas and approaches for chairing a successful meeting that is on time and achieves its outcomes To understand the protocols and boundaries for appropriate meeting etiquette and the chair's role in managing this effectively To appreciate how to manage yourself and others appropriately To take away personal actions to apply to your role 1 Welcome and introductions Objectives What's the challenge for you? 2 We can't go on meeting like this Common meeting challenges for chairs and why they succeed or fail Consequences and impact for the Council What's the context? 3 Roles and responsibilities of an effective chair Activities and input that explore the role, skills and qualities needed Role of the chair: what is it and how to do it well 4 Chairing for success - ideas and approaches to meet the challenges Managing time and boundaries Preparation and planning Creating the right environment Self-management Challenging personalities and good meeting behaviour 5 Final plenary session What's your plan? Take away actions

The importance of building services to the success of an organisation has never been greater and continues to grow. Developers and occupiers are becoming more aware of the contribution that building services make to the well being of occupants and hence their perception of the quality of the working environment. Those involved with the design, construction, maintenance and operation will increasingly be required to deliver building services that demonstrable contribution to the occupier's business. Energy efficiency, carbon management and occupant satisfaction depend substantially on the way building services are designed, managed and operated. To optimise these aspects, an informed strategic approach is essential. Tried and tested techniques and processes are available that, when applied holistically, will deliver substantial benefits. This course reviews best practice in the area and inspires participants to ensure that building services perform at their optimal level. To provide a better understanding of how building services can be designed, managed and operated to: Maximise occupant comfort, satisfaction and wellbeing Add value and contribute to the success of the business of the occupier Improve health safety Reduce operating cost, energy use, carbon emissions and environmental impact Optimise cost and value Provide strategies for continuous improvement and sustainable operation 1 Building services fundamentals The function of services in commercial buildings and their importance to the core business 2 Techniques and processes for optimising cost and value Programmed operation evaluation Continuous commissioning Lifetime product management Performance-based service Energy efficiency and the scope for environmental improvement 3 Making the business case and preparing the strategy Motivating decision-makers Empowering those who have to deliver the results Managing business risk 4 Strategy implementation and monitoring results Ensuring that rich and robust feedback is available to support continuous improvement and strategy enhancementWhen to get feedbackWhyHowWhat to do with it 5 Case histories and 'air time' Sharing experience and addressing specific issues of interest to participants Course review Close

This very practical and focused one-day workshop enables end-users, technical experts, proponents, internal customers and other key stakeholders to work with procurement and contracting to develop effective specifications and scopes of work, to ensure fit-for-purpose outcomes. The programme empowers participants to collaborate with all key stakeholders. This workshop will help participants: Understand the importance and value of clear and effective specifications Differentiate between the different methods of creating specifications and when to apply them Develop robust specification templates to ensure consistency Understand the use of appropriate language (critical to creating effective specifications) Appreciate the need to develop specifications in cooperation with stakeholders Make use of techniques such as value analysis and value engineering to define 'fit for purpose' in the context of creating effective specifications Embed key KPIs into the specification to ensure delivery Manage and mitigate legal and contractual risks in the specification 1 Introduction Learning outcomes Learning styles Plan for the day 2 The importance of effective specifications Scopes of work Impact of poor scopes of work Examples of costly errors 3 The critical role of language Terminology in creating effective specifications and scopes of work Problems of communication Lack of detail or too prescriptive 4 Encouraging cooperation Technical and commercial experts with responsibility for developing robust effective specifications and scopes of work Managing stakeholders' expectations Working with contractors 5 Types of specification Exploring and using the various approaches to the development of appropriate specifications and scopes of work Output Performance Technical Functional Solutions-based 6 The role of value analysis Value engineering in the process of developing scopes of work and specifications 7 Specifications and contracts The legal and contractual impact of poor specifications and scopes of work How to embed scopes of work and specification outputs into tender and quotation documents 8 Specifications as a management tool Developing KPIs and SLAs framed around robust effective specifications and scopes of work Negotiating with contractors Negotiating with stakeholders

Many managers question the value of appraisal programmes and many line managers believe appraisals are unduly time-consuming and bureaucratic. Yet the appraisal is a vital starting point when it comes to managing performance effectively and it is vital that managers appreciate this. Handled well, the benefits of formal appraisals are enormous. This thoroughly practical workshop has been designed to give line managers the knowledge, skills and confidence to deliver a well-structured appraisal - even in the most challenging circumstances. This course will help participants: Appreciate the benefits of the appraisal process Assess standards of performance objectively Plan and prepare for appraisals effectively Conduct a well-structured appraisal meeting Acquire the essential skills required for effective appraisals Improve their ability to discuss difficult issues more confidently Identify training and development requirements Agree clear and measurable development objectives Complete essential paperwork Understand the need to facilitate continual informal dialogue between appraisals 1 Introduction and course objectives 2 The appraisal process The aim of the appraisal process Understanding the bigger picture - the appraisal process as part of the employee development process The benefits of the appraisal process Common pitfalls Five steps to an effective performance appraisal 3 Step 1 - Assessment Using job standards as the basis for objective assessment Assessment of previous objectives 4 Step 2 - Preparation Documentation required Data on each appraisee Planning the meeting 5 Step 3 - The meeting The skills of appraisal interviewing The structure of the appraisal interview Dealing with poor performance and difficult situations Taking notes and completing documentation 6 Step 4 - Planning ahead and objective setting Identifying action to improve performance and enhance skills Establishing relevant training needs Agreeing SMART performance objectives Formulating a personal development plan 7 Step 5 - Action after the interview Essential paperwork Follow-up and action required between appraisal interviews Continuing informal dialogue 8 Video case study Bullets 9 Conclusion Course review / discussion Preparation of action plans for building on the skills learnt Close

Health and safety awareness training is mandatory for staff at all levels of an organisation. This is the ideal course to satisfy that requirement - a stimulating 'entry-level' programme explaining how health and safety should be managed in any working environment. The course outlines the basics of health and safety law and how organisations and individuals can become liable for health and safety offences. Roles and responsibilities for health and safety are discussed by reference to the key legislation and the expert trainer will explore with the delegates how these responsibilities are managed in practice in different types of organisation. The principles of risk assessment will be considered and their practical implementation discussed in relation to the management of the various hazards that are likely to be present in a typical workplace. This course will give staff: An understanding of health and safety law, liability and enforcement An explanation of the principles of health and safety management in the workplace and an understanding of who should be responsible for different aspects of health and safety A practical explanation of risk assessment and what constitutes a suitable and sufficient assessment A broad knowledge of the typical hazards in a workplace and how these should be managed 1 Overview of health and safety law Statute and civil law Liability and enforcement Statutory duties Contract law 2 Legislative framework The workplace - extent of responsibility / shared responsibility Relevant legislation 3 Management of Health and Safety Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Workplace (Health, Safety and Welfare) Regulations 1992 Accident Reporting (RIDDOR) Consultation with Employees and Safety Committees 4 Risk management within your organisation Business risk management Health and safety risk management The principles of risk assessment Transferring the risk to contractors and third parties 5 Risk assessment exercise - 'Challenge Anneka' 6 Managing the hazards in the workplace Work equipment Lifting equipment Display screens Manual handling Fire Chemicals (COSHH) Personal protective equipment (PPE) 7 Practical exercise - Workplace inspection 8 Questions, discussion and review

All organisations today operate in an environment of constant and rapid change. Managing this change effectively is often achieved through a portfolio of formal projects. Many organisations today have qualified and experienced project management staff to run their projects. Some organisations today have dedicated functions, staff or processes to support their project management teams. The very largest organisations have in-house Enterprise Programme Offices, or project management specialists in corporate audit or risk functions; or organise 'Red Team Reviews' of a project by other staff with project management experience who are not participating in the reviewed project. But for many mid-size businesses and SMEs - and even some larger organisations - these resources are simply not available. For them, having access to external expertise to assure project management disciplines and to coach project managers can be a major contributor to project success. Such reviews can take place at project initiation; at major stage-gates (especially if significant capital is to be committed at the stage-gate); or at any other time if concerns arise concerning project quality, cost or timescales. And it is for those organisations that we offer the necessary expertise, on an ad hoc basis, in reviewing projects and coaching senior project management staff. A document review and workshop led by one of our consultants can help you assess whether: The strategic goals and priorities for the project are clear and being addressed Governance of the project within the business is defined and being effectively executed Project roles and responsibilities are clear and effective The credibility and robustness of the project plan can be enhanced Performance measures and reporting procedures are effective Critical risks are identified and being managed and contingencies are agreed The roles, responsibilities and capabilities of the key players in the project team are fit for purpose Budgets are realistic and costs being managed effectively Communication and change management activities are effectively planned and being executed At your discretion, you can capture the outcomes from the workshop for yourselves, in terms of identifying opportunities for improvement, or you can have our consultant write a report and make recommendations to you.

This programme provides an intensive, one-day overview of the key concepts and techniques of project management. The project management methods presented can be applied to a wide range of projects and the course emphasises both the task and the team-related aspects of project management. The aims of the programme are to: Present the key concepts of project management Provide a structured approach for managing projects Demonstrate tools and techniques for planning and controlling project work Enable participants to apply the techniques to their own projects At the end of the programme, participants will: Recognise the benefits of a structured approach to project work Be able to apply a range of practical tools and techniques to improve their personal effectiveness in project work Have a means of determining the status of current projects and know what actions are needed to ensure success 1 Introduction Why this programme has been developed Review of participants' needs and objectives 2 Key concepts The characteristics of projects and project work The four key phases of a project Essential lessons from past projects Key success factors Achieving success through the 'Team-Action Model' Challenges of the multi-project situation 3 Setting project goals Understanding 'customer' requirements Managing project stakeholders and gaining commitment Using questioning skills to define goals and success criteria Defining and documenting the scope of the project 4 Project planning Defining what has to be done Creating a work breakdown Agreeing roles and responsibilities for the work Developing a programme using networks and bar charts Estimating timescales, costs and resource requirements Planning exercise: participants develop a project plan Identifying and managing project risks Using project planning software Managing and updating the plan 5 Project implementation and control Creating a pro-active monitoring and control process Techniques for monitoring progress Using latest estimates Managing project meetings Resolving problems effectively Managing multiple projects Personal time management 6 Course review and action planning Identify actions Sponsor-led review and discussion of proposals Conclusion

This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the total process of managing contracts Exploit opportunities to extract even more added value Develop appropriate relationships with contractors Understand and use a range of contracting strategies and options Measure and improve contract performance Understand the impact of legislation on contract performance 1 Welcome Introductions Aims and objectives Plan for the day 2 Contract management An overview of the contracting process, mapping the 'territory' 3 Contract managers Skills Knowledge Attributes Responsibilities 4 Critical success factors Defining successful outcomes Effective stakeholder engagement Creating a shared vision of the outcomes 5 Placing contracts How to develop an effective specification and scope of work documents How to develop a robust contracting strategy Appropriate types of contract 6 Customers and stakeholders Customer and stakeholder analysis Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight 7 Working with suppliers Creating and developing commercial relationships Types of relationship How to manage difficult relationships Contractor motivational issues How to use incentives 8 Negotiation and related skills Introduction to key negotiation skills Persuading and influencing skills to work with stakeholders to improve outcomes for all 9 Dealing with change Claims and variations How to challenge contractor claims and requests for variations by making use of contractual terms Specifications to prevent false claims 10 Performance improvement How to measure and improve contractor performance Developing KPI systems Using contractual terms and conditions and basic legal principles 11 Contract close The importance of effective contract close processes 12 Close Review of key learning points Personal action planning