3740 Courses in Edinburgh delivered Live Online

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

This advanced Level 3 EFT training is geared to those tapping practitioners who are looking to advance their skills to a significantly elevated level of expertise. The art of EFT delivery is emphasized, working with difficult/challenging clients and issues are explored, further refinement of techniques is honed, and additional advanced techniques are demonstrated and taught.

Official BRCGS Gluten-Free Issue 4 for Auditors course. Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Revit face to face training customised and bespoke.

This award introduces the critical concepts associated with AI and explores its relationship with the systems and processes that make up the digital ecosystem. It explores how AI can empower organisations to utilise Big Data through the use of Business Analysis and Machine Learning, and encourages candidates to consider a future vision of the world that is powered by AI.

This package is ideal for those who select the wrong partners repeatedly choosing emotionally unavailable people, bad characters and people that treat them badly. Dating Coach support for 6 weeks sessions twice a week 30 mins Dating Coach correctional dating training programme Gift Package sent to home with Dating literature and guidance pamphlet Support and Advice Dating advice for singles https://relationshipsmdd.com/product/i-always-choose-the-wrong-people-to-date-package/

This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Course Category Meeting emotional needs Behaviour and Relationships Inclusion Early Years Description This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Girls will often withdraw, attack or even hurt themselves when under emotional stress and this is not always obvious in the way it is with boys. 1 in 4 women experience domestic violence and every week 2 women are killed by a current or ex partner. Whilst the world assumes girls have no problems processing their emotions, we lift the lid on this and question what is really happening for girls this century? Testimonials Learning Objectives Increased understanding of girls’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion Opportunity to reflect on professional attitudes and behaviour towards girls and their emotional challenges New skills and processes to make girls’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners 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 : Is there an invisible problem with girls? What can we do to meet the emotional needs of girls? What helps? What should our priority be with girls? This workshop will explore: Cultural and historical expectations of girls in our society Shared experiences of teaching and parenting girls Circle of Courage as a way of understanding emotional needs Fathers, mothers and daughters Solution Circle Problem Solving around girls’ needs What girls really need If you you want something similar, but not gender specific try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or you may like: RESTORATIVE INTERVENTIONS

Level 3 Supporting Teaching and Learning in Schools Certificate is a RQF qualification & this course play a major role by working with pupils & supporting teachers. This course has been designed to teach the knowledge required to be a teaching assistant and support children’s learning from birth to nineteen years. The course covers various requirements needed to work as an assistant within schools and how to approach a career in the education sector.  ABOUT THIS COURSE: Level 3 Award in Supporting Teaching and Learning is a knowledge only qualification. Experience in the real work environment is not required and the entire course is completed online. Please note that this is a knowledge only Level 3 qualification and does not require any practical assessments. COURSE ASSESSMENT: To pass this course learners must pass 4 assignments. These are completed after navigating through the corresponding lessons and writing your answers to assignment questions. Once these have been read and marked by your personal tutor, feedback and marks are provided to students which contain helpful tips to improve work in future assignments. UNITS COVERED: • Unit 1: Schools and Colleges as Organisations • Unit 2: Support Health and Safety in a Learning Environment • Unit 3: Understand how to Safeguard Children and Young People • Unit 4: Understand How Children and Young People Develop HOW MUCH THIS COURSE COST? Level 3: Award in Supporting Teaching and Learning Course will cost for Distance Learning / Online £249.99 and for class based £349.99. There is no any hidden fess/cost.