1687 Courses in Nottingham

On this course we go into far greater detail on understanding the dog’s needs, behaviour, state of mind, language, and improving your leadership skills.

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

Summary This half day course is designed to help managers and supervisors understand the causes of poor behaviour and look at different strategies for dealing with this. The course can be run as a one-off session or can be incorporated into a series of sessions on managing staff. Alternatively it could be increased to a day-long course with participant’s role playing different scenarios in the afternoon. For voluntary and community organisation participants the course could include dealing with difficult volunteers as well as paid staff.

NPORS Report of Thorough Examination (N019)

Our Level 3 Sports Massage courses will give you everything you need to become a Sports Massage Therapist in your own right and be able to practice straight away. To provide learners with the confidence, knowledge and skills required, to be able to provide a safe and professional treatment to a range of clients, helping in injury prevention, improving physical wellbeing and aiding the healing process of injuries.

Our Level 3 Sports Massage courses will give you everything you need to become a Sports Massage Therapist in your own right and be able to practice straight away. To provide learners with the confidence, knowledge and skills required, to be able to provide a safe and professional treatment to a range of clients, helping in injury prevention, improving physical wellbeing and aiding the healing process of injuries.

FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.

Miss Date Doctor’s Communication Skills coaching is designed to help you improve your ability to communicate effectively with your partner or potential partner. Whether you struggle to express yourself clearly, have difficulty understanding your partner’s needs, or frequently find yourselves in arguments or misunderstandings, our coaching can provide you with the tools and skills needed to build stronger, more fulfilling relationships and communication skills are essential in creating solid relationships. Our Communication Skills coaching includes a range of techniques and strategies, such as active listening, non-verbal communication, conflict resolution, and empathy building. We can help you develop the ability to communicate clearly and assertively, express your emotions in a healthy way, and build deeper levels of trust and understanding in your relationships.Have 3 1 hour sessions with your coach. The Miss Date Doctor Communication Skills Package includes the following: Relationship Communication, Effective Communication, Communication Techniques, Active Listening, Conflict Resolution, Empathy Building, Communication Skills Coaching, Communication Strategies, Non-Verbal Communication, Relationship Communication Skills, Communication Training. https://relationshipsmdd.com/product/communication-skills-package/

In some organisations appraisals are seen as an annual chore that has to be undertaken and neither the manager nor the staff gain any real benefit from it. This half day course is designed to help managers appraise their staff effectively so that both parties develop more insight, motivation and a better understanding of each other. It will help participants work with their staff to create work plans that are effective and realistic. This course can be run as a one-off session or as part of a series of sessions on staff management.

Level 2 NVQ Diploma in Piling Rig Operations - Piling Rig Operative