5411 Courses in Cardiff delivered Live Online

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our 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. Tailored training courses: In, in company training, 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. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction 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

The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC Medication. Routes. Formulation. Types. Absorption. MDT. Roles and Responsibilities. Levels of support. Boundaries and agreed ways of working. Order. Receive. Store. Record. Transfer. Dispose. 7 R’s. Sources of info. Practical session including MAR charts. Risk assessments. Person Centred Care. Review. Covert. Consent. Refuse. Errors and action. Infection Control and Technique.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

This online PLC training course is done as a live classroom, using an online virtual classroom platform with live classes and a tutor present throughout the course. Not just an e-Learning package, this is a REAL LIFE classroom, giving you the opportunity to interact with the tutor. This course is fully interactive and a free copy of the software to each attendee which the tutor can view and give feedback on. The course is the best possible online experience you can have with a fully accredited certificate on completion of the exam. All instructions for installing the software and licencing it will be given prior to the course beginning. No prior knowledge is required for this course as it starts from scratch and assumes no previous experience, you will reach the skilled level where you can look at becoming a programmer, get into engineering maintenance in an industrial environment, fault find or make amendments to programs, this is the course for you. The course covers 2 of the major manufacturers, Siemens S7 and Allen Bradley (but will be slightly bias towards Allen Bradley due to the simulation software being used, which will also be given to you to keep). The course aims to be 90% practical, as we believe the easiest way to learn is to do it! A full set of course notes and manuals will be emailed to you.

Properly employed and supported, TRiM Practitioners can make a significant contribution to staff welfare by offering structured peer support and TRiM assessments to colleagues. TRiM practitioners are trained to identify the risk factors for the development of post traumatic stress and to know when to signpost colleagues to professional support.

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

Who should learn? This course has been designed for those who are new to EV Charging Installations or for those requiring a better understanding of electric vehicle charging equipment installations. Learners using this course could be from any background or industry sector, from apprentices through to senior managers. Course Introduction This online course will cover the key aspects of the design, specification and installation of Electric Vehicle Charging Equipment Installation. This course will look at the requirements detailed in Section 722 of BS 7671:2018+A1:2020 as well as the IET Code of Practice for Electric Vehicle Charging Equipment Installation, 4th Edition. The course will also help to enhance your expertise on the best practice for Electric Vehicle Charging Equipment Installation, providing you with a deeper understanding of how to select and use the correct earthing systems to protect against electric shock as well looking into vehicle-to-grid, on street installations and smart infrastructure integration. We would recommend that you purchase a copy of The Code of Practice For Electric Vehicle Charging Equipment Installation, Fourth Edition to get the best out of this course. Learning Objectives Through this online course, you will learn: How to specify Electric Vehicle Charging Equipment Installations How to design electrical installations containing electric vehicle charging and supply equipment The steps involved in planning, installing and commissioning of electric vehicle charging points Key risks and hazards for various types of installation, and how to address them, including: Dwellings, Commercial and Industrial premises, On-Street installations, and filling stations.

What does this course cover? This five-day course covers a range of topics, all of which are covered via a mixture of theoretical and practical training – we aim for our courses to be as hands-on as possible. The course specifically covers: An introduction to SCADA systems, covering elements, servers, hardware and software, graphics, and more. A range of systems including automatic control, FIELDBUS, and wireless communication systems. An introduction to serial interfaces, ethernet networks, fibre optic, and wireless. Communications, including case studies to establish communication with PLCs. Process variables. Programmable Logic Controllers (PLCs), Remote Terminal Units (RTUs), sensors, and alarms. Introduction to OPC (open plan communications) How to configure OPC UA servers and how to program an OPC UA client Client and server development Connection management Security configuration Trends and historical data System components This course covers a wide range of industry-recognised manufacturers, including Siemens, Allen Bradley, Wago and Mitsubishi.) What will I gain from this course? Upon successful completion of this course, candidates will gain a City & Guilds certification in SCADA and PLC Communications.

This course is aimed at beginners with no previous electrical experience or knowledge, it’s ideal for those wanting to enter the electrical industry. Completion of this combined course provides the majority of skills required for candidates to work as an industrial, commercial and domestic electrician. Please note this course incorporates weeks 1 to 4 of the Total Electrical 20 course.

EFQM Performance Improvement Practitioner Course A 2-day deep-dive workshop on RADAR and how to use it as an agile project performance framework. The essential course for anyone wanting to learn more about the RADAR logic and how to build a continuous improvement culture and mindset across your whole organisation.   Who is it for? This course is suitable for anyone who wants to understand the RADAR logic and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course; it is also a Level 1 option for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career.   Benefits By the end of the course, participants will be able to: Explain the overall RADAR logic Explain the main principles of positive culture and mindset for driving performance Describe how RADAR can be implemented into an organisation to improve performance at every level Identify how to use RADAR to drive the management agenda Apply RADAR across day-to-day initiatives and key projects as an agile project performance framework. Programme The main topics covered during the EFQM Performance Improvement Practitioner training are: RADAR logic and examples of how it can be used Using RADAR to drive the management agenda Using RADAR to drive strategic initiatives Using RADAR to set up strategic KPI’s RADAR as a Performance Improvement Framework Case studies and group exercises RADAR Improvement Matrix self-assessment The training is spread over two days and is delivered in a virtual classroom setting (Zoom or Microsoft Teams), using videos, group discussions, case studies and activities in breakout rooms and presentations from the trainer.   Further Development The EFQM Performance Improvement Practitioner training provides core knowledge about the RADAR Logic. In some cases, the training will have fulfilled an individual's learning needs. In many cases, the individual will want to consolidate their learning by applying the theory to a practical task. We encourage you to apply RADAR to a practical, work-based project, and we provide guidance on how to approach and complete your project.    Completion of the RADAR Performance Improvement Project also allows you to progress to one of the advanced EFQM qualification programmes: EFQM Performance Improvement Leader, EFQM Assessor or EFQM Organisational Change Leader.   EFQM Performance Improvement Leader If you successfully complete the EFQM Performance Improvement Practitioner training and the subsequent project, you are invited to apply for the EFQM Performance Improvement Leader assessment. You will be guided and coached by an EFQM trainer and asked to present your project to the EFQM expert panel. Here you will answer questions about how you applied the RADAR logic and principles (we provide participants with templates for running the project, as well as a high-level mid-term review). You will also receive feedback on how to improve and maximise the use of RADAR for future endeavours. Dates and time: This is a two day on-line workshop delivered on the 31st of January & 7th of February from 9:00 AM to 3:30 PM GMT Cost: £650 + VAT