611 Courses in Sheffield

QA Level 2 Award In Principles Of Manual Handling (RQF) Half day course (face to face), 2 sessions (virtual) Gives learners a good understanding of why manual handling is so important Gives learners the knowledge of safe manual handling principles Our full day course, Safe Moving and Handling, will also give learners sound practice in manual handling Course Contents: Common manual handling injuries Manual handling laws Responsibilities of employers and employees Manual handling risk assessments Safe movement principles associated with manual handling, including the body’s: Recognising a range of mental health conditions:Musculoskeletal systemCentre of gravityLever system Manual handling equipment:Types of manual handling aids and equipmentMaintenance and requirements for testing Theory of safe manual handling principles, including: Preparing for a lift Solo lifting, carrying and lowering an object Team manual handling Benefits of this course: 498,000 people people suffered from musculoskeletal disorders due to work related activities in 2018/2019 Of those, 138,000 were from people who had not suffered this before 6.9 million working days, or 26,436 working years, were lost due to work-related musculoskeletal disorders that year On average, each of those people had to take 16 days off work, with many never fully recovering from those injuries This course is there to help people avoid getting injured in the first place, saving both human suffering and cost to the employer and employee both Accredited, Ofqual regulated qualification Our Principles of Manual Handling Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Principles of Manual Handling Course fulfills the legal requirements and is a very good way to make sure you and your employees are trained in the principles of Manual Handling. The Ofqual Register number for this course is 603/2720/0

Recruitment Skills 1 Day Workshop in Sheffield

Public Speaking 1 Day Training in Sheffield

10 Soft Skills You Need 1 Day Training in Sheffield

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Highfield Level 1 Award In Health And Safety Within A Construction Environment (RQF) Highfield Level 1 Award in Health and Safety within a Construction Environment (RQF) One day course For those applying for the Green Labourer CSCS Card Includes the Health, Safety, Environment Test For Operatives and Specialists book or DVD by CITB! Face to Face: One day course + time for self-study required This course is supported by the Construction Industry Training Board (CITB) This course is designed to give learners a route to applying for the Green Labourer CSCS Card Course Contents: The purpose of a risk assessment The purpose of a method statement The legal requirements of risk assessments and method statements The common causes of work-related fatalities and injuries The implications of not preventing accidents and ill-health at work Health and safety definitions Hazards and potential risks of a a range of situations The importance of reporting accidents and near misses Accident reporting procedures Risk assessments and dynamic risk assessments The reasons for using safe manual handling in the workplace The employees' responsibilities under current legislation and official guidance in relation to manual handling in the workplace The procedures for safe manual handling Working at height Employees' legal responsibilities in relation to working at height Potential hazards when working at height Controlling risks and hazards while working at height Regulations regarding working at height COSHH: substances hazardous to health Common risks to health within a construction environment Drugs and alcohol Personal Hygiene Asbestos PPE (Personal Protective Equipment) Working around plant and equipment safely Benefits of this course: In 2018/19, 1.4 million people suffered from a work-related illness They have a much higher rate of work-related ill-health than those working in many other industries Construction workers have the highest rate of musculoskeletal disorders compared to other occupations This course develops learners’ knowledge and understanding of health and safety in a construction environment so they can work safely on a construction site Those who successfully complete this Level 1 Award in Health and Safety in a Construction Environment and have completed the CITB Health, Safety & Environment Test within the last 2 years can then apply for a Green Labourer CSCS card. Our Health And Safety In A Construction Environment Training Course is a nationally recognised, Ofqual regulated qualification accredited by Highfields Qualifications. This course leads to the obtainment of the CSCS labour card, allowing workers to work on construction sites. The Ofqual Register number for this course is 603/2442/9

QA Level 3 Award In First Aid At Work (RQF) Three-day course Gives learners the knowledge and skills to be a first aider Recommended by HSE for high risk workplaces Course Contents: The Roles and Responsibilities of an Emergency First Aider Assessing an Incident Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Casualty CPR Safe Use of an AED (Automated External Defibrillator) Choking Seizures Wounds and Bleeding Shock Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning Benefits of this course: 1.1 million workers in Britain had an accident at work in 2014/2015 Of those, 2,700 were from the East Midlands On average, one out of every 370 people received an injury at work The estimated cost of injuries and ill health last year was £15 billion The Health and Safety (First Aid) Regulations 1981 require all employers to make arrangements to ensure their employees receive immediate attention if they are injured or taken ill at work. This includes carrying out a risk assessment, appointing a suitable amount of first aiders and providing adequate first aid training Typically, first aiders will hold a valid certificate in either First Aid at Work (FAW) or Emergency First Aid at Work (EFAW) Our QA Level 3 Award in First Aid at Work (RQF) - FAW - training course is the one recommended for first aiders in a high risk workplace Having the correct first aid provision in the workplace is not just a legal requirement, it is incredibly important for the safety of all members of staff! As this is a Regulated Qualification, employers can book this course for their employees in the safe knowledge that they have fulfilled their legal responsibilities for providing quality first aid training, without having to undertake any lengthy due diligence checks Accredited, Ofqual regulated qualification: Our First Aid at Work (FAW) course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your First Aid at Work Certificate fulfills the legal requirements and is a very good way to make sure you and your employees are trained in First Aid, having the ability to save lives should the situation occur. The Ofqual Register number for this course is 603/2384/X

QA Level 2 Award In Basic Life Support And Management Of Anaphylaxis (RQF) Half day course Gives learners the knowledge and skills to save someone who is in anaphylactic shock Also covers how to prevent this happening in the first place Also available as a bolt-on to certain other courses Course Contents: Incident and Casualty Management Managing an Unresponsive Casualty Recovery Position The Chain of Survival CPR Signs and Symptoms of Anaphylaxis Treatment of Anaphylaxis Medication Use of Adrenaline Auto-Injectors Benefits of this course: Anaphylaxis is a severe and life-threatening allergic reaction, which requires immediate medical attention Did you know that in 2014 there were over 4,000 hospital admissions for anaphylactic shock in England? Every year, the number of those suffering from anaphylaxis is increasing. This makes it very important for people to know what to do when encountering someone who is having an anaphylactic shock This QA Level 2 Award in Basic Life Support and Management of Anaphylaxis (RQF) course has been designed for those who have a specific responsibility at work, at home or as a volunteer, to provide basic life support and manage anaphylaxis when dealing with an emergency Successful applicants will be able to recognise the signs and symptoms of anaphylaxis and will be equipped with the vital skills needed to administer safe, prompt and effective treatment. This includes practising with adrenaline auto-injectors. Accredited, Ofqual regulated qualification: Our Basic Life Support and Management of Anaphylaxis training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Basic Life Support and Management of Anaphylaxis Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in Management of Anaphylaxis..The Ofqual Register number for this course is 603/2548/3

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups