515 Courses in Edinburgh

Gain comprehensive knowledge and practical skills for fine-bore nasogastric tube care and feeding with our healthcare professional course. Learn techniques, considerations, and patient care for enteral nutrition, medication administration, and gastric decompression.

Overview A comprehensive and practical 3 days workshop on pricing, using and managing structured interest rate derivatives. What used to be called exotic interest rate derivatives are now commonplace and an essential part of the financial marketplace either as legacy transactions or embedded in new structures. This intensive course is for anyone who wishes to be able to use, price, manage, market or evaluate standard interest rate derivatives such as Constant Maturity Swaps, Range Accruals and Quantos. We also look in detail at such important products as CMS spread-linked structures and volatility/variance swaps, always from a pragmatic practitioner’s perspective. Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers IPV professionals Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

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.

This course is designed to help give you a sound understanding of the role and benefits of well...

This practical half day course is designed to teach your staff to effectively deploy and use an...

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

Level 3 NVQ Diploma in Occupational Work Supervision

Project Stakeholder Relationship Skills: In-House Training This course is designed to provide project managers with the ability to: Analyze the complexities of major stakeholder relationship categories Apply the most appropriate interpersonal relationship skills to the different categories of relationships Align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle What you Will Learn Examine traditional and non-traditional ways to identify and assess stakeholders Explain how competence, character, and trust lead to project success and strong relationships with stakeholders Utilize 'Embodied Leadership' skills to build stakeholder relationships Apply stakeholder engagement best practices to case study and real-life scenarios Getting Started Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations

Overview This course has been created to help safely navigate attendees through the minefield of absence management, paying attention to issues of systems, procedures and organisational culture along the way. Using a selection of exercises, activities and sample documents, the course examines some traditional methods of management as well as some more contemporary and innovative ways of keeping a lid on casual absence. Attendees will take away a number of practical tools and ideas to enable them to target performance improvement when back at their desks. Description It’s estimated that absence from work costs the UK economy over £13 billion per year, with the ‘average’ employee taking around seven days off sick annually. The need for managers, HR people and leaders to control absenteeism is critical if a company is to survive and prosper. But just what is ‘absence’? And how do we go about managing it and reducing it wherever we can, without falling foul of employment law? As well as the usual training material, attendees on this course also receive several useful handouts and exercises relating to absence management. Topics covered: An Absence Management Model – this section identifies a simple model for managers to apply when dealing with absenteeism Defining Absence – the text book definition will help learners clearly understand what is meant by absence Types of Absence – unravelling the different types of absence and distinguishing between absence and leave Classifying Absence – by classifying types of absence, the learner can begin to get a steer on how to manage it Statistics – identifying the real cost of absence and looking at regional and sector differences Reasons for Absence – considering the high-level issues that have an impact on absence, like culture and job design Causes of Sickness – here the national league tables of sickness causes are discussed, giving the learner the chance to reflect on their own team or company Absence Management – Stage 1 – contracts, policies, procedures and legal entitlements are all examined here, to allow learners to get a grasp of what they have to know to Absence Management – Stage 2 – record keeping, costing absence and benchmarking provide the chance for analysis and understanding in the context of the learner’s own organisation Absence Management – Stage 3 – setting out the skills and interventions that managers need to apply in the effective management of absence, including: communication, professional advice, workplace issues and return to work interviews Traditional Approaches – an examination of performance management, sick pay, discipline, recruitment and selection and how these can lend themselves to effective absence management Reducing Absenteeism – through less traditional approaches, looking at ‘carrots and sticks’, targets, employee assistance, unusual initiatives and organisational culture. Recent Developments – considering the impact of ‘fit notes’ and potential pandemics. Who should attend This course has been designed for anyone that deals with absence or needs to have an awareness of the absence management process. This could include; Team leaders, supervisors, managers, HR professionals and anyone else involved in the management of people or organisations. Requirements for Attendance None.

Private soap making class run by The Scottish Soapworks at The Arienas Collective in Edinburgh City Centre