1 Educators providing Icon courses in Sheffield

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

The Gold Card Training Programme is the most comprehensive electrician course available. We offer weekday, weekend and evening delivery options. JIB ECS (Gold) Card is quickly becoming a necessity when seeking work on commercial sites, or sub-contracting to larger contractors.

The shortage of electricians has lead to an increased demand nationwide and in turn a sharp rise in salary. Our training solutions can help you gain nationally recognised qualifications such as City & Guilds and NVQ. Not only you will train in state-of-the-art training centres, but you can also have the opportunity to attain the Work Based Performance Units and complete a portfolio of diverse evidence of onsite work.

£ Enquire Focus Awards Level 4 Certificate in Education and Training (RQF) Brand new course coming soon Currently run via virtual classrooms Ask us for more information!

Qualsafe Food Allergen Awareness (RQF) Half day course This course gives learners the knowledge and understanding of food allergens and foods that commonly cause intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Benefits of this course: This qualification is aimed at food handlers and other staff involved in food preparation and services It provides knowledge and understanding of food allergens and foods that commonly cause intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. Course Contents: The characteristics and consequences of food allergies and intolerances How to identify and control contamination from allergenic ingredients Ways to accurate communicate of allergen information to consumers Accredited, Ofqual regulated qualification: This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8 Classroom £95.00 pp Enquire about this course Half day course This course gives learners the knowledge and understanding of food allergens and food intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Enquire about this courseCourse ContentsUpcoming Dates Face to Face / Classroom Courses Would you like this course? Contact us and we'll set a date. We also run short, CPD Accredited training sessions in Food Allergens and Intolerances. Enquire about this courseCourse Contents Benefits of this course: This qualification is aimed at those who are working in, or preparing to work in a food handling, food retail or food manufacturing role It provides knowledge and understanding of food allergens and intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. This is an Ofqual regulated qualification, showing your due diligence and care for your customers Enquire about this course Course Contents The characteristics of food allergens, food intolerance and coeliac disease The importance of, and procedures for identifying and controlling food allergen risks How to provide accurate food allergen information Enquire about this course Our Reviews Facebook 5.0 Rating READ FACEBOOK REVIEWS "Informative and very enjoyable!" Google Reviews 5.0 Rating READ GOOGLE REVIEWS Accredited, Ofqual regulated qualification This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8

This QA Level 2 Award in citizenAID (RQF) course is a half-day course to teach the skills and knowledge needed in case one finds themselves in the middle of a terrorist attack. The skills are also usable in any event where there might be either multiple or severely injured people. Past attendees said:  Attended the citizen aid course this week, absolutely brilliant. Whilst we all hope that we are never involved in a major incident, the big question though would be are we prepared, what would we do? This course discusses various incidents and some are uncomfortable to think about, but if something happened most people panic, after this course you are likely to stay calm, take control and above all save lives. This course is for everyone due to the current threats in the world, However large companies especially should consider training their staff, it may save your life or someone close to you. Highly recommended, well presented and really interesting. Benefits of this course: Following several terrorist attacks that have claimed the lives of countless victims and left many in hospital with critical injuries, both in the UK and abroad, it has been clear that normal, everyday people can save each other's lives with the right levels of training This course, together with the citizenAID Phone App and a pocket guide, has been designed by both highly experienced military and civilian clinicians This course will teach you what to do during a terrorist-related, or 'simply' a serious accident, where casualties can suffer from severe trauma. It is specifically designed to help people react safely, prioritise the injured and give life-saving first aid to the casualties RUN - HIDE - TELL - TREAT Watch this short, 4 ½ minute video by the Counter Terrorism Police UK on how to stay as safe as possible during firearms and weapons attacks Whether work is causing or aggravating mental health problems, employers have a legal responsibility toward their employees Fortunately, these events are rare, but when they do happen, being prepared can save your life, and that of others Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable This half-day course gives people a good awareness of mental health in the workplace Better still, of course, is to do this citizenAID course with us, which will help a lot more! Course Contents Active shooter or knife attacker scenario Shooting incident Suspect bombs Exploded bomb Casualty first look Severe bleeding Tourniquets Haemostatic Dressings Unresponsive casualty Broken Bones Burns Casualty handover Accredited, Ofqual regulated qualification Our citizenAID course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards and taught by an experienced trainer. This means that you can rest assured that your citizenAID training is of high quality. The Ofqual Register number for this course is 603/1934/3.

£ 12.50 per session A series of hourly small group sessions where we look at different aspects of Word Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

£ 12.50 per session (when doing this with others, in a small group). £60 for all 6 sessions A series of hourly small group sessions where we look at different aspects of Publisher In each session, we'll be covering a different aspect of Publisher Would you like us to cover anything specific? Contact us! Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

£ Enquire Highfield Level 3 Award in Delivering Training (RQF) Three day course

£ Enquire Highfields Level 1 Certificate in Digital Skills 140 - 217 hours