1285 Courses in Edinburgh

Correcting the areas you feel are affecting your confidence and wellbeing. Analysation of exes and pressure points in your life talk about your relationship, finding Mr or Mrs Right, single life, loneliness, cheating, better dating skills and relationship issues with your girlfriend or boyfriend, dating or getting to know someone new. Whatever the relationship problem talk to an M.D.D dating coach.1 hour session choice of phone or face to face session Self improvement coaching and guidance to support you today https://relationshipsmdd.com/product/self-improvment/

The 2-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

The QA Level 3 Award in Administering Emergency Medical Gases (RQF) is a regulated and nationally recognised qualification that has been specifically designed for those who have a responsibility for providing treatment to patients who need medical gases administering in prehospital environments. During this 1 day course, candidates will learn how to safely administer emergency oxygen, pre-operational inspections for oxygen therapy equipment and the clinical need for oxygen therapy when dealing with a range of conditions. Successful candidates will leave with the skills, knowledge and competencies needed to safely administer prompt and effective medical gases in an emergency situation.

30 mins session.Talk about your relationship, finding Mr or Mrs Right, single life, loneliness, cheating, better dating skills and relationship issues with your girlfriend or boyfriend, dating or getting to know someone new. Whatever the relationship problem talk to an M.D.D date coach. Use our call a counsellor service now for instant support. Choose a dating coach or counsellor we have a large team of qualified experienced professionals available. Dating advice for singles 30 mins advice on your situation (Couples can call also. The price will remain the same.) https://relationshipsmdd.com/product/m-d-d-quick-chat-telephone-service/

The QA Level 2 Award in Principles and Practice of Moving People Safely (RQF) is a regulated and nationally recognised qualification that has been specifically designed for those who work, or intend to work, in a role that involves assisting and moving people.  This 1 day course provides candidates with a clear understanding of the principles of moving people safely and includes the opportunity to practise and apply these principles in a variety of situations; individually, in a team, and with the assistance of equipment.  Candidates will leave the course with the knowledge and skills required to move people safely whilst ensuring that the risk of personal harm is reduced and that health and dignity are retained.

UNV CCTV Training, covering off the fantastic protfolio of UNV CCTV products, looking at how to configure them, what manufcaturer tools are available and how to connect remotely and via mobile apps to installed systems.

Did you know that 30.7 million working days were lost due to work-related illnesses and workplace injury in 2017/18?  It is an employer’s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training to employees to allow them to work in a way that does not put themselves or others at risk.  The QA Level 2 Award in Health and Safety in the Workplace (RQF) is ideal for all employees, as it helps candidates develop a greater understanding of health and safety issues and the role that everyone plays in maintaining a safe working environment. What’s more, with subjects covered in just 1 day, this regulated and nationally recognised qualification is the ideal way for organisations to improve health and safety awareness, whilst minimising disruption to everyday business operations!

Welcome to our Couples Coaching Session an extra long session to tackle pressing issues with a professional therapist, where you and your partner will receive expert guidance and education on how to improve your relationship. Our 1-hour and 30-minute session with a qualified relationship coach will provide you with instant advice and cover a wide range of topics to help you better understand and strengthen your relationship .This session is also suitable if you have one issue you would like to discuss with your partner. During the session, our coach will cover different areas such as effective communication, trust-building, intimacy, conflict resolution, and creating a healthy relationship dynamic. You and your partner will learn how to identify and overcome relationship obstacles, develop strategies for a more fulfilling relationship, and understand each other’s needs better. Our Couples Coaching Session is perfect for anyone looking to improve their relationship and strengthen their connection with their partner. As a new customer, you’ll receive a free 30-minute follow-up call to check on your progress and get further support. Don’t wait to take the first step towards a happier, healthier relationship with your partner. Book your Couples Coaching Session today and start building a stronger, more fulfilling relationship! https://relationshipsmdd.com/product/couples-coaching-session/

Our *NEW* Mini First Aid Baby Proofing class is our second class, designed for parents and carers of babies and children over 3 months. It can be taken after our 2 hour Baby and Child First Aid class, or in isolation for those parents who are starting their weaning journey, or have a baby on the move!