59278 Courses

Expand your Excel knowledge and learn how to structure and analyse large data sets.

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

The Level 1 Award in Construction Health & Safety is required by individuals who are looking to become eligible for the Green CSCS Card. A CSCS Card is required in order to access many construction sites, carry out basic duties and build relevant experience to enable them to progress their career onto the next stage allowing them to progress to a level 2 or 3 Qualification. This Level 1 Award will provide the basic knowledge and understanding of health and safety principles and procedures and delivers a comprehensive and technical overview in relation to many construction relevant topics that are operatives require in order to operate safely within the Construction sector. Topics covered include Risk Assessment, Manual Handling, Working at Heights, Moving Vehicles, Dust, Hazardous Substances, Asbestos, Welfare, Personal Hygiene, Fire, Work Equipment, Electricity, Underground Services, PPE, Mandatory signage and more!!!!! Candidates can undertake this qualification in a classroom based delivery followed by the CSCS test within a single day. The administration and photographs are included and the CSCS card is usually received within 5 to 10 days. The one day course can be delivered in any client venue or at various locations around the UK.

CAVA is a combined of assessment of occupational competence in the work environment, and the assessment of vocational skills, knowledge and understanding. Level 3: Certificate in Assessing Vocational Achievement (RQF) course is suitable for people who assess vocational skills, knowledge and understanding other than in the work environment (e.g. a workshop, classroom or other training environment).

Within this day you will learn how to mould a part of your/your partners/ your childs body in a safe, non toxic, water based material called alginate. You will then learn how to make a cast from that mould using a sculpture plaster. Once the cast is removed from the mould you will learn how to 'fettle' the cast in other words make it perfect, then you'll have the option of adding a colour to the cast or mounting it on a stand. What you learn during the course can be used to cast your children's hands and feet when you're back at home, I can supply all the materials you need to do this. I've been running this type of workshop for 25 years so I'm very experienced in the process. I cast my own mothers hands about a year before she died and they are my most prized possessions as they have picked up so much detail

During this class we will explore the creation of abstract sculpture starting with the development of ideas, shapes and forms, then we will use some composite sculpture material to transfer your ideas from a sketch to a 3 dimensional work. The material we use is rigid but very easily worked with rasps and reduction paper so you'll quite quickly gain confidence in working with it. We will supply a dust mast if requred You don't need any prior experience in sculpture or a background in art to enjoy this course, I'll take you through all aspects of the creative process. At the end of the day you'll have a piece of work to take away but we will also have discussed how to take your original to the next stage which will be moulding and casting to re-produce it in a hard wearing material.

Still Technique course, suitable for osteopaths and final year osteopathic students

Every employee needs to have their performance managed and it is equally important to 'catch people doing something right