823 Systems courses

What do engineers and project managers need to know of finance? 'Nothing - leave it to the accountants!' No, no, no! Engineers must be conversant with the terminology and statements that accountants use. Technical expertise in projects, service delivery, production or other areas can only really be harnessed if the managers understand the accounting and reporting that drives businesses. This course gives the necessary understanding to project, production and technical managers. It develops their skills in understanding financial and management accounting. Accountants may not always like it but a major part of their work is to be the 'servants of business' and to gather, compile and present your figures. So you must understand the figures - they belong to you, your processes or projects. There are many reasons for maintaining accurate accounts. This course focuses on the strategic issues (those over-used words) - what figures reveal about the drivers of business and what they reveal about the day-to-day issues that accountants bother you with. The course will enhance your understanding of finance and of the accounting issues which affect your projects, production and technical areas of business. This course will help you: Understand the business world in figures - make sense of what the accountants are telling you Appreciate what drives business - and how this affects your role in your part of the business Relate your activities to the success of the business - through figures Gain the skills to advance in management - financial awareness is a 'must have' if you are to progress in your career 1 What do accountants do? The finance function, types of accountant, financial v management accounting and the treasury function Understanding the role of the finance function and how the information you provide may be used 2 The basic financial statements Balance sheets and income statements (P&L accounts) What they are, what they contain and above all what they can reveal - how to read them The accounting process - from transactions to financial statements What underpins the statements - accounting systems and internal controls 3 Why be in business - from a financial perspective The driving forces behind financial information Performance measures - profitability, asset utilisation, sales and throughput, managing capital expenditure 4 Accounting rules - accounting standards Accounting concepts and the accounting rules: accruals, 'going concern' - substance over form and other 'desirable qualities' Accruals - why the timing of a transaction is so important to the finance function Depreciation and amortisation - the concepts and practice Accounting standards - the role of International Financial Reporting Standards 5 Cash The importance of cash flow - working capital management Cash flow statements - monitoring overall cash flows Raising cash - levels of borrowing, gearing Spending cash - an outline of capital expenditure appraisal 6 Budgeting Why budget? - good and bad practice Determining why budgets play a key role and should not be simply an annual ritual Justifying your budgets - the link between the strategic plan and day-to-day budgeting - alignment of company culture Budgets as motivators - the importance of the right culture Techniques to improve budgeting - whether day-to-day or capital budgeting 7 Costing The type and detail of costing very much depends on your business - eg, manufacturing piston rings is quite different from the construction of a power plant Issues with overhead allocation Accounting for R&D 8 Reading financial statements Annual financial statements - why they are produced, what's in them and what you should look for Learning what a set of accounts reveals about a company's current situation, profitability and future prospects 9 Performance measurement - analytical reviews and ratio analysis ROI/ROCE Profitability, margins and cost control Sales - asset turnover Efficiency (asset / stock turnover, debtor / creditor days) 'City' measures Investment (interest / dividend cover, earnings per share, dividend yield)

Why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships.Learn the skills, knowledge and have the confidence to tackle difficult conversations in a productive way. Course overview Duration: 1 day (6.5 hours) This workshop is designed for those who deal on a regular basis with fellow employees, suppliers or customers from different cultural backgrounds. The workshop will focus on understanding why cultural differences exist, what you can do to understand and respect these differences and then implement strategies to build effective intercultural relationships. The one day session will use professional actors in the afternoon so that you can practice real-life situations involving intercultural challenges. Objectives  By the end of the course you will be able to: Understand what makes us different from people from other cultures Appreciate why we form impressions of other cultures Use strategies to communicate effectively with those from different cultural backgrounds Build trust with those we work with from a different cultural background Content Intercultural Challenges What challenges do you face with dealing with people from different cultures? Why do these challenges exist? Understanding Culture What is culture? Trompenaars’ Model of Culture – what determines our understanding of different cultures Cultural theories Hall and Hall:Three Systems of TimeThe Importance of Context – Data vs Dialogue Hofstede – 6 Cultural Dimensions Trompenaars – 7 Cultural Dimensions Chart your intercultural business relationships against these dimensions Strategies and Intercultural Management Trompenaar’s 3 step approach – Recognise, Respect, Reconcile How to foster and maintain trust Effective intercultural communication strategies Practical Activities Professional actors will work with you in small groups in the afternoon to practice real-life challenging conversations.

Managing for Growth is designed for anyone who has management and leadership responsibilities within an organisation. Suitable for newly promoted managers, team leaders and supervisors through to senior managers; the objective of the programme is to develop a culture that will translate strategy into measurable outcomes by engaging these leaders to facilitate change and innovation. The programme is extremely effective at giving managers the tools and skills to deliver sustainable change and business growth. It's also been proven to reduce costs and increase profit – even before the programme has ended.   Managing for Growth is built upon three aspects common to every job:   Managing Resources. Ensuring that the resources available are appropriate for the tasks for which they are required and are being used effectively. Learning how to control and coordinate a mix of available resources for maximum efficiency. Managing Relationships. Positively influencing people’s behaviour in order to motivate them and promote effective working. Focusing on listening skills, we share ways to improve communication and teamwork to get the best from both internal and external relationships. Controlling Routines. Investigating the processes/systems/routines/series of actions that are linked together to achieve a desired outcome. Recognising the importance of controlling, developing, simplifying and following routines.   Managing for Growth shows your team leaders, supervisors and managers how to cultivate a culture of teamwork and continuous improvement within your organisation.   Focus for Action Throughout the programme the participants take part in work-based activities that will cause them to evaluate every aspect of their job and identify areas for improvement. By the end of the programme, the participants act on these action lists and implement improvement projects that will deliver measurable results.   Continuous Improvement Managing for Growth sets the framework for continuous improvement by transferring skills and knowledge enabling your team leaders to translate organisational strategies into real, measurable outcomes.   Format Designed for groups of up to 6 people, the programme is spread over 4 months with the first 7 sessions being held every 2 weeks and the final session a month later. Each session lasts approximately 2 hours.

Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure  09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch  12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.

Firefighting or solving the same problems week after week? Create a problem-solving culture in your business with this proven methodology.

This five-day programme empowers participants with the skills and knowledge to understand and effectively apply best practice commercial and contracting principles and techniques, ensuring better contractor performance and greater value add. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Practitioner (CCMP) qualification. By the end of this comprehensive programme the participants will be able to: Develop robust contracting plans, including scopes of work and award strategies Undertake early market engagements to maximise competition Conduct effective contracting and commercial management activities, including ITT, RFP, negotiated outcomes Understand the legalities of contract and commercial management Negotiate effectively with key stakeholders and clients, making use of the key skills of persuading and influencing to optimise outcomes Undertake effective Supplier Relationship Management Appreciate the implications of national and organisational culture on contracting and commercial activities Appreciate professional contract management standards Set up and maintain contract and commercial management governance systems Take a proactive, collaborative, and agile approach to managing commercial contracts Develop and monitor appropriate and robust KPIs and SLAs to manage the contractor and facilitate improved contractor performance Appreciate the cross-functional nature of contract management Collaborate with clients to deliver sustainable performance and to manage and exceed client expectations Understand the roles and responsibilities of contract and commercial managers Use effective contractor selection and award methods and models (including the 10Cs model) and use these models to prepare robust propositions to clients Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Effectively manage the process of change, claims, variations, and dispute resolution Develop and present robust propositions Make appropriate use of best practice contract and commercial management tools, techniques, and templates DAY ONE 1 Introduction Aims Objectives KPIs Learning strategies Plan for the programme 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Critical success factors Essential features of professional commercial and contract management and administration The 6-step model 4 Putting the 'management' into commercial and contract management Traditional v 'new age' models The need for a commercial approach The added value generated 5 Definitions 'Commercial management' 'Contract management' 'Contracting' ... and why have formal contracts? 6 Stakeholders Stakeholder mapping and analysis The 'shared vision' concept Engaging with key functions, eg, HSE, finance, operations 7 Roles and responsibilities Contract administrators Stakeholders 8 Strategy and planning Developing effective contracting plans and strategies DAY TWO 1 Contract control Tools and techniques, including CPA and Gantt charts A project management approach Developing effective contract programmes 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Tendering Overview of the contracting cycle Requirement to tender Methods Rationale Exceptions Steps Gateways Controls One and two package bids 4 Tender assessment and contract award I - framework Tender board procedures Role of the tender board (including minor and major tender boards) Membership Administration Developing robust contract award strategies and presentations DAY THREE 1 Tender assessment and contract award II - processes Pre-qualification processes CRS Vendor registration rules and processes Creating bidder lists Disqualification criteria Short-listing Using the 10Cs model Contract award and contract execution processes 2 Minor works orders Process Need for competition Role and purpose Controls Risks 3 Contract strategy Types of contract Call-offs Framework agreements Price agreements Supply agreements 4 Contract terms I: Pricing structures Lump sum Unit price Cost plus Time and materials Alternative methods Target cost Gain share contracts Advance payments Price escalation clauses 5 Contract terms II: Other financial clauses Insurance Currencies Parent body guarantees Tender bonds Performance bonds Retentions Sub-contracting Termination Invoicing 6 Contract terms III: Risk and reward Incentive contracts Management and mitigation of contractual risk DAY FOUR 1 Contract terms IV: Jurisdiction and related matters Applicable laws and regulations Registration Commercial registry Commercial agencies 2 Managing the client-contractor relationship Types of relationship Driving forces Link between type of contract and style of relationships Motivation - use of incentives and remedies 3 Disputes Types of dispute Conflict resolution strategies Negotiation Mediation Arbitration DAY FIVE 1 Performance measurement KPIs Benchmarking Cost controls Validity of savings Balanced scorecards Using the KPI template 2 Personal qualities of the contract manager Negotiation Communication Persuasion and influencing Working in a matrix environment 3 Contract terms V: Drafting skills Drafting special terms 4 Variations Contract and works variation orders Causes of variations Risk management Controls Prevention Negotiation with contractors 5 Claims Claims management processes Controls Risk mitigation Schedules of rates 6 Close-out Contract close-out and acceptance / completion HSE Final payments Performance evaluation Capturing the learning 7 Close Review Final assessment Next steps

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

This course provides exceptional training on the principles and processes required to successfully operate a warehouse. PARTICIPANTS WILL LEARN HOW TO: • Learn about the characteristics of a warehouse and its function • Understand the basic principles of effective layout design and product storage prioritization • Gain an understanding of modern practices in warehouse operations, such as Kanban and 5S • Understand the importance of packaging and data inputs to improve the performance of pick and pack operations • Understand the role of KPIs in warehouse and supply chain management COURSE TOPICS INCLUDE: Material storage as part of supply chain management Evaluation of outsourcing issues Challenges of codification and traceability Performance management Automated and mechanized systems Different storage methodologies Use of Warehouse management systems Optimum cube utilization and labour productivity Picking and packing management systems Goods receipt and dispatch

The aim of the course is to ensure that safety requirements are appreciated by managers. To enable them to review their own safety systems. It give’s the ability to introduce new controls and possibly implement changes as appropriate to ensure safety in the workplace. Who Should Attend? The course is designed for managers and supervisors in any sector, who are required to manage health and safety risk and resources within their organisation. It is also beneficial for anybody wishing to get into the Health and Safety profession or Management. The IOSH qualification is an impressive qualification to add to a CV. Course Duration: 3 days. Learning Objectives: On successful completion of the course, delegates should be able to: Explain ‘managing safely’. Explain the component parts of a recognised safety management system such as HSG65. Identify the data and techniques required to produce an adequate record of an incident. To demonstrate the procedure for an accident investigation, recognising the human factors involved. Describe statutory requirements for reporting and procedures for checking non-reporting. Describe methods of basic trend analysis for reactive monitoring data. Define ‘hazard’ and ‘risk’, and describe the legal requirements for risk assessment. Demonstrate a practical understanding of risk assessment technique and the data required for records. Describe workplace precaution hierarchies. Prepare and use active monitoring checklists. To implement schedules for active monitoring, recording results and analysing records. Outline the main provisions of the Health and Safety at Work etc Act and the Management of Health and Safety at Work Regulations. Outline relevant health and safety legislation, codes of practice, guidance notes and information sources such as the HSE. Syllabus: 1. Module 1 – Introduction and Overview. 2. Module 2 – Risk Assessment. 3. Module 3 – Risk Control. 4. Module 4 – Health and Safety Legislation. 5. Module 5 – Common Hazards. 6. Module 6 – Investigating Accidents and Incidents. 7. Module 7 – Measuring Performance. What do IOSH Managing Safely Courses involve? The course has seven comprehensive modules. These modules cover risk assessment and control, Health and Safety Legislation, common hazards, accident and incident investigation. Also covered is performance measurement. Effectively covering all aspects of safety management in the workplace. To obtain the IOSH Managing Safely certificate, attendees will need to complete a four day course. The course is delivered using high quality animated graphics. This includes sophisticated, fun presentations to make the content of the course more memorable. With training tools including board games, DVDs and quizzes displaying clear scenarios and essential practical content. We have worked hard to ensure that taking an IOSH Managing Safely course is as enjoyable as possible. Attendees will officially attain their IOSH Managing Safely certificate upon successful completion of both the written and practical assessments of the course. Certification: An IOSH Managing Safely certificate is awarded to all those who attend the course successfully completing both written and practical assessments. Candidates will also receive an excellent workbook from IOSH, with all the tools to help them once they are back in the workplace. Understanding of the course material is evaluated by means of a 45-minute written assessment paper consisting of 20 multi-format questions. There is also a practical assessment. MHA Training was established in 2008 based at our training centre in Warrington, Cheshire. We provide an array of services On-Site also for clients around the North West in areas such as Manchester, Liverpool, Widnes, St Helens, Runcorn, Wigan, Preston and Leeds. Over the years we have expanded and have instructors available for all of our courses Nationwide. IOSH Managing Safely Refresher Course: Recently IOSH have introduced a one day refresher course. This enables candidates having previously sat a course within 3 years to keep their qualification current and upto date in just a one day course. For more information please see the factsheet below.