2622 Courses in South Normanton

The aim of this course is to give delegates who have to use full working breathing apparatus during their working activities a greater understanding of correct operational procedures. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to use power tools. By the end of the course delegates will have an understanding of the correct operational procedures of power tools. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to use gas monitors By the end of the course delegates will have an understanding of the correct operational procedures of gas monitors. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This course is aimed at anyone who has to undertake manual handling duties as part of their work routine, and will give the delegates a basic understanding of the correct manual handling techniques when moving, handling and lifting of loads. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This course is aimed at anybody who may accidentally encounter asbestos containing materials as part of their job role within maintenance, building and demolition industries. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This course is designed to provide delegates that need to use abrasive wheels with an in-depth understanding of the requirements of the law, associated regulations and safe working practices when using abrasive wheels. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to use Ladders. It will give the delegate an understanding of the safe use and inspection as well as awareness of the regulations. Book via our website @ ESS | Working at Heights training | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

This ESS course is suitable for operatives who during the daily activities have to wear a safety harness. It will give the delegate an understanding of the safe use of a harness, methods of inspection and awareness of the regulations. Book via our website @ ESS | Working at Heights training | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

Round the clock support Phone and text support Talk through emotions Address emotions and thoughts Grieving strategy plan Expression of feelings Life coaching Personal and confidential grieving programme Coping strategy advice and guidance 7 session 1 hour per wee https://relationshipsmdd.com/product/bereavement-and-grieving-package/

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