1180 Courses in Sheffield

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk 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 Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office 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

FAA Level 2 Award In First Aid For Youth Mental Health (RQF) Classroom (1 day course), Virtual (3 x 2½ hour sessions) Gives learners knowledge of Youth Mental Health First Aid Gives learners the skills to help young people with mental health problems and improve their mental health Course Contents: What is Youth Mental Health? The role of the mental health first aider Identifying mental health conditions Recognising and managing Stress Mental health conditions Recognising a range of mental health conditions:DepressionAnxietyPsychosisEating disordersSuicideSelf-harmPost-traumatic stress disorderConduct disorders - BullyingDrugs and alcohol Mental health first aid action plan Benefits of this course: These figures, taken from the Young Minds website show clearly how many young people suffer with their mental health... One in six children aged five to 16 are identified as having a probable mental health problem That means that, on average, five children in every classroom have a mental health problem 80% of young people with mental health needs agreed that the coronavirus pandemic had made their mental health worse Suicide was the leading cause of death for males and females aged between five to 34 in 2019 Around half of 17-19 year-olds with a diagnosable mental health disorder has self-harmed or attempted suicide at some point In 2018-19, 24% of 17-year-olds reported having self-harmed in the previous year, and seven per cent reported having self-harmed with suicidal intent at some point in their lives So please, learn more about how to help these youngsters, and give them the chance to live happy, healthy lives Accredited, Ofqual regulated qualification Our Mental Health First Aid Courses are nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd in association with NUCO Training. This means that you can be rest assured that your Mental Health First Aid Certificates fulfill the upcoming legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff's mental health conditions. The Ofqual Register number for this course is 603/7176/6

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 Level 3 International Foundation Diploma for Higher Education Studies (L3IFDHES) is usually a one-year pre-university qualification that provides students with an entry route to an overseas university. The L3IFDHES prepares students with the essential English language skills, key transferable study skills, cultural knowledge, and chosen specialisms that universities feel bridges the gap between high school and undergraduate study. In January 2023 we offer pathways in business and higher finance. With agreements in place with over 70 universities across the globe, students’ can progress with confidence to a higher education course for further study. Entry Requirements For entry onto the NCC Education Level 3 International Foundation Diploma for Higher Education Studies (L3IFDHES) qualification students must have successfully completed secondary school education. Students must also meet the English language entry requirements of: • IELTS minimum score of 4.5 or above OR • GCE ‘O’ Level English D7 or above Alternatively, a student can take the free NCC Education Higher English Placement Test which is administered by our Accredited Partner Centre’s.

Highfield Level 2 Award In HACCP For Catering (RQF) Full day course This course gives learners the knowledge and understanding of HACCP regulations Shows learners how to implement these in their catering environment Benefits of this course: This course is for those working in a food catering environment and other food handlers This qualification is intended for both those who are already working in catering and those who are preparing to work in the industry This course will give an introduction to HACCP It will support those who are, or will be part of a HACCP (hazard analysis and critical control points) team within a catering environment Course Contents: The procedures required to develop Food Safety Management systems based on HACCP principlesThe role of the food handler in implementing a Food Safety Management System based on HACCP principlesThe need for prerequisite programmesCommon prerequisite programmesSteps required to develop HACCP based food safety systems How to develop food Safety Management systems based on HACCP principles The purpose of identifying hazards at each step in a food process The importance of, and methods which can be used to determine, specific controls at steps in the process The importance of identifying critical (safe) limits The importance of monitoring controls Ways of monitoring controls The purpose of taking appropriate corrective action The importance of verification and review of HACCP based Food Safety Management Systems Documentation and records needed to support HACCP based Food Safety Management Systems Accredited, Ofqual regulated qualification: Our HACCP for Catering training course is a nationally recognised, Ofqual regulated qualifications accredited by Highfields Qualifications. This means that you can be rest assured that your HACCP for Catering Certificate provides information for best practice and goes a long way toward ensuring that food produced is as safe as possible. The Ofqual Register number for this course is 603/2527/6

One and a half-hour session Have you already got a valid First Aid Certificate? Do you feel confident you can do what needs to be done when the situation arises? Are there first aid situations you do not feel ready for, that were maybe not covered or are now more important to you? These special First Aid Skills Practice Sessions give you the chance to refresh your theory and/or practical skills Whichever subjects you would like to work on - you choose what you want to practice or know more about Course Contents: Can’t quite remember how or why to put someone in the recovery position? Practice it! Still confident in giving CPR? Ever done it with different barriers? Here’s your chance. Scared of what to do if someone chokes? We have baby and child infant choking models and an adult choking vest. Save their lives! Bandage a wound, apply a sling, treat someone for shock? That can be done. Want to know more about Heart Attacks or Strokes? Just let us know. Know the theory about an Automated External Defibrillator (AED), but haven’t had the chance to actually use one? Now you can. And so on and so forth – the choice is yours! Benefits of this course: Have you already got a valid First Aid Certificate? Can you still remember everything that you have learned? Or maybe you did some training a while ago that wasn't necessarily certificated, and you just want to refresh your skills and knowledge a bit Do you feel confident you can do what needs doing when the situation arises? It is highly recommended to do 'something’ to keep your skills up to date – as a matter of fact, this is a prerequisite of your First Aid Certificate. We run Annual Refresher courses, which is a properly accredited certification awarded by Qualsafe Awards. These are recommended on a yearly basis. In between that, it is still good to keep one's skills and knowledge up to date. Our special First Aid Skills Practice Sessions give you the chance to refresh your theory and/or practical skills. Whichever subjects you would like to work on. An experienced trainer will be at hand to show and explain. NOWHERE ELSE DO YOU HAVE THE CHANCE TO DO THIS! CPD Accredited: These sessions are non-Ofqual regulated. However, they are taught by our trainer, who is an accredited first aid trainer via Qualsafe Awards, First Aid Awards Ltd and Highfields Qualifications. You'll get accredited quality either way! These sessions are CPD Accredited, so you'll get 1.5 CPD hours with this training. If you'd like to do a nationally accredited course instead, we'd like to recommend you do our First Aid at Work Annual Refresher, Emergency First Aid at Work, First Aid at Work or Basic Life Support for Adults and Children course.

Highfield Level 2 Award In HACCP For Manufacturing (RQF) Full day course This course gives learners the knowledge and understanding of HACCP regulations Shows learners how to implement these in their manufacturing environment Benefits of this course: This course is for those working in a food Manufacturing environment This qualification is intended for both those who are already working in catering and those who are preparing to work in the industry This course will give an introduction to HACCP It will support those who are, or will be part of a HACCP (hazard analysis and critical control points) team within a Manufacturing environment Course Contents: The procedures required to develop Food Safety Management systems based on HACCP principlesThe role of the food handler in implementing a Food Safety Management System based on HACCP principlesThe need for prerequisite programmesCommon prerequisite programmesSteps required to develop HACCP based food safety systems How to develop Food Safety Management systems based on HACCP principles The purpose of identifying hazards at each step in a food process The importance of, and methods which can be used to determine, specific controls at steps in the process The importance of identifying critical (safe) limits The importance of monitoring controls Ways of monitoring controls The purpose of taking appropriate corrective action The importance of verification and review of HACCP based Food Safety Management Systems Documentation and records needed to support HACCP based Food Safety Management Systems Accredited, Ofqual regulated qualification: Our HACCP for Manufacturing training course is a nationally recognised, Ofqual regulated qualifications accredited by Highfields Qualifications. This means that you can be rest assured that your HACCP for Manufacturing  Certificate provides information for best practice and goes a long way toward ensuring that food produced is as safe as possible. The Ofqual Register number for this course is 603/2527/6

Leadership and Management development, Leadership training, management training, Leadership development

In-house training courses on electric and hydrogen vehicle technologies, charging infrastructure and how they work.

This accredited course provides knowledge and understanding in relation to health, wellbeing and personal safety - extremely useful in life!