80 Courses in Edinburgh

Interior design masterclass in the city centre of Edinburgh

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

This is a practical ‘non medical’ day for front line practitioners working with children and young people with serious attachment issues arising from loss, trauma and abuse. We look at what Psychology may help us in our understanding of children who have faced issues with love and attachment. Splitting, handling projected feelings, constancy and permanence are explored. Online Course now available via Teachable Platform – Understanding Attachment Learn at your own pace… lots of text and video support Course Category Meeting emotional needs Behaviour and Relationships Inclusion Teaching and Learning Description This is a practical ‘non medical’ day for front line practitioners working with children and young people with serious attachment issues arising from loss, trauma and abuse. Drawing from the international research and literature and our own experience over many years as educational psychologists of the challenges of children with major social and emotional needs, we will explore together what the best practice can and could look like. We explore the language of attachment and outline very practical classroom strategies. We look at what Psychology may help us in our understanding of children who have faced issues with love and attachment. We explore the feelings of being on a desolate island of relational poverty or to imagine swimming with sharks. We explore the themes of violence, anxiety and experience of being a victim as young people grow older. We look at telling lies and explore how we can respectfully understand this. We reveal the new and innovative compass of vulnerability – the cognitive errors to which some are much more vulnerable. We look at triggers, self regulation and unpack a range of strategies.  Transference and counter transference are examined along with splitting, handling projected feelings, constancy and permanence. We explore what young people with these difficulties really need from us. We also spend time looking at the emotional impact on practitioners working with children with such needs and what helps at an personal and team level. We can all do something – we do not have to wait for expert therapists to arrive!  Testimonials Very moving presentation I will always try and think behind the behaviour now It had a huge impact on all levels We all seem to need it Belonging and feelings are so important Very user friendly Excellent! Learning Objectives Increased confidence regarding developing inclusive practice for children with serious attachment needs in mainstream schools Simple understandable explanation of attachment understood Access to a wider range of practical strategies to impact on social and behavioural needs Deeper understanding of core values surrounding inclusion of emotionally disabled children Opportunity to reflect on professional attitudes and behaviour towards parents and pupils with complex emotional needs New skills, scripts and processes to make inclusion successful Who Is It For ? Practitioners working in schools and other settings with children and young people of all ages Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : How can we start to develop an understanding of children with attachment needs? What is the true impact of loss, trauma and abuse? What else can we do to go about including high profile children or young people with challenging emotional needs? What useful psychological constructs can we use to guide us? This course also explores practical strategies and language for key adults rebuilding relationships with individual pupils. This is a participative day that aims to be explorative and practical. Opportunities to develop empathy with the children of concern will be created.

This 1-on-1 workshop is for beginner and professional photographers who like to try different genres of photography. Edinburgh Street Photography Course When? I f you have a certain date please contact me in advance for further arrangemnet. 6 hours course is also available on 1 on 1, please contact me for further information. Time: 11:30 AM - 14:30 PM Place to meet? Costa coffee above Waverley mall How long does this course take? 3 and half hours Can I use my SLR camera for this workshop? Definitely, but I don’t teach in SLR, you have to use your ability in using an SLR camera. What do I get from this course? You will gain confidence taking pictures of people in public. You will understand from my tips and tricks how this photography works for your self grow. You will find a hobby that challenging. M y tips and tricks. and more… Your hobby should be fun, in my workshops/courses there aren't any strict rules but please note: You must have the willingness to learn. No racism It doesn't matter what camera you have - your best tool is your intuition. My workshops are friendly environment - be flexible. If you are ready to start a different level of photography, this is FOR YOU! FACE YOUR FEARS AND START MOVING FORWARD IN PHOTOGRAPHY Follow the "I Candid You" WhatsApp Channel for an Update here. Join our group on facebook (private) here. Watch my video "Eye contact from random people on random street" here. Watch my video "Tips for Beginner Street Photography"here. My images were taken with Fuji X30, here.

This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, follow a methodical workflow to develop sound solutions, use open-source, off-the-shelf tools to develop, test, and deploy those solutions, and ensure that they protect the privacy of users. This course includes hands-on activities for each topic area.

A Warm Welcome to Ludo Tutors Founded in 2017 by Martha, a Dyslexic and Dyspraxia graduate from Cambridge University (Education with English and Drama, BA MA Cantab), Ludo Tutors was created to provide students with a holistic, well-rounded education and excellent quality Tutors. We have over 150 Tutors on our books and tutor everything from Academic subjects (such as 11+ Exams, Key Stage Three Science, GCSEs and A Levels) through to LAMDA Drama, Shakespeare and Public Speaking Exams). What are 11+ / Entrance Exams? 11+ Exams, sometimes called 'Entrance Exams', are examinations that many UK private schools. The rare usually competitive and a bit daunting! Don't panic, though - we're here to help!  How do I take Entrance Exams? Different schools have different application procedures, timelines and expectations. Some will belong to a body of schools using the same examination papers, whereas others will set their own, independent exams. Many also charge an administration fee. We do not advise parents on the applications themselves, but we have garnered a depth of knowledge about 11+ Exams that enable our Tutors to workeffikiently and effectively, whilst still keeping their students engaged and in good spirits. Who are your Tutors? Over half of our Tutors studied at either Oxford or Cambridge University and many hold PGCEs or TEFL/CELTA qualifications. All Tutors are Enhanced DBS checked. We interview each Tutor personally, to get to know them and to find our students the best match. What 11+ experience do you have? Our Founder, Martha, has extensive experience preparing students for the UK's top independent school exams, with many of her students achieving their first choice school, if not also a scholarship - lovely! This work is now carried out by our experienced and friendly tutors, with input from Martha if, as and when they may need extra support.

The course is designed to help improve your understanding of the legal requirements, the theoretical and practical principles for both the initial verification and certification of an electrical installation, further your knowledge and practical skills in the testing and inspection of a range of existing electrical installations, and help improve your understanding of the legal requirements, the theoretical and practical principles for the periodic inspect and testing and certification of an electrical installation.

This class focuses on the areas of the body that are overworked and hold tension/ trauma. By using breathwork and meditation, we are able to become more mindful of the signals our body sends us and target that area with deep stretch holds and activating the cardiovascular system to release the tension of tight muscles. An inclusive class for everyone that wants to rid the body of tightness or perhaps just to relax, focus on meditation and the breath. Benefits: detoxify the body improve flexibility strengthen digestive system oxygenates the body increase internal organ function strengthen the nervous system increase immune system function cleanse and focus the mind This class is sponsored by Community Fund, Awards for All We prioritize the area of Gorgie-Dalry-Saughton where our studio is based.  By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending.

The QNUK Level 3 Award in Emergency First Aid at Work (RQF) is ideal for those employers that need to meet the minimum requirement of first aid regulations; typically those working in shops, offices and other low risk environments.

Puppy training classes and dog training classes are suitable for general dog training and relationship building. Classes are run in line with the IMDT (Institute of Modern Dog Traioners) code of ethics, and training techniques are based upon positive reinforcement, using dog treats or dog toys and play as rewards for completing the actions we ask the puppy or dog to complete.    Classes will be limited to 6 people, to ensure I can circulate and provide individual feedback relevant to your puppy or dog training. We will teach foundation behaviours, with the benefit of being in a dog training class environment, which relies on your dog working around the distraction of other dogs. Classes will also teach you to effectively communicate with your dog and give you the skills to practice outside of classes and implement the training in your every day life, in a rage of environments. Puppy training classes and Dog training classes last 1 hour. They are run on Friday mornings in Bishop's Stortford. Puppy training class= 9:30am Dog training class= 11:00am DOG TRAINING CLASSES BISHOP'S STORTFORD Puppy training group class= £100 (6 classes) Dog training group class= £100 (6 classes)   Classes are run in blocks of 6 weeks. Please contact me to find out the next start date.