185 Running courses in Edinburgh

Create a hardcover hinged book with an intricate Japanese stab stitch – a nifty way of stitching single sheets together and a great book structure to master!

Get to grips with this eye-catching leather (or pleather) long-stitch binding and have fun picking different coloured threads and decorative papers to give your book it’s own unique character.

This half day course is designed to help relatively inexperienced managers and supervisors to manage their staff effectively. The course can be run as a one-off session or can be incorporated into a series of sessions on managing staff. Alternatively it can be run as a day session and incorporate elements of the Managing the Difficult Staff member course. The course can concentrate on managing paid staff or (for voluntary and community sector organisations) can include aspects of supervising and supporting volunteers as well.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

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

This half day course is designed for voluntary and community organisations and those involved in community development who need to write funding applications and want to ensure that their bids are clear, focussed and meet the funders’ criteria.

BECOME A SPIRITUAL WARRIOR MENTOR  A journey through Japanese shamanism and philosophy in 13 modules during 3 full week-ends, available online and in person, to become a Spiritual Warrior Mentor and learn practical shamanic practices to use in your sessions and group work.  This will require the completion of some case studies and homeworks.  It gives you the opportunity to add a job qualification to your holistic experience that can be used in individual sessions or group events. We are a globally certified IPHM training provider (International Practitioners of Holistic Medicine). MODULES 1) Loving your imperfection through Wabi Sabi: accept the impermanence of things and recognise the beauty of imperfection, learning to flow like a river. In this module you will learn not to attach yourself to a theory, to a knowledge, but learn how to become flexible in order to be powerful and solve any life problem. 2) Embrace your wish to change through Kaizen: Kaizen is an approach to creating continuous improvement based on the idea that small, ongoing positive changes can reap significant improvements compared to radical changes to achieve transformation. In this module you will learn how to master the art of creating habits. 3) Face life challenges and storm through Hanafubuki: through 'the cherry blossom storm' we have the magical moment when the sakuras begin to fall, creating a delicate blizzard of petals. This concept of ephemeral beauty is a metaphor for human life, rich and beautiful but also fragile and fleeting. In this module you will learn how to remain calm to make the best decisions. 4) Express your own emotions and welcome those of others through Omoiyari: Omoiyari is commonly translated to empathy, but it actually has a deeper meaning; it literally means to give your thoughts to others. In this module you will learn how to release your own emotions and develop empathy and compassion for others. 5) Repair your own soul wounds through Kintsugi: Kintsugi is the art of mending broken objects with gold, it is the art of treasuring your wounds by repairing them with the gold of pure aesthetic experience. The wounds of our lives are seen through the eyes of the soul,which receives and heals them with the gold of death,of rebirth and freedom. In this module you will learn to perform a rite of passage after which nothing will be the same as before. 6) Master the art of patience through Nintai: Nintai is the power of enduring without complaint, without looking for quick results. It means sticking to your path, trusting the process, to your beliefs. In this module you will learn to never give up, to wait for the right time for things to happen. 7) How gratitude changes you and your brain through Itadakimasu: this word means “I humbly receive” and relates to the traditional way of showing gratitude by elevating above one’s head the gift received. Through time, itadakimasu became the expression showing appreciation for the food received. In this module you will learn the benefits of gratitude on your mental health. 8) Learn to become grounded through Shinrin-Yoku: Immersion in nature has scientifically proven therapeutic effects: it can reduce stress hormone concentrations in the body, strengthen the immune system, regulate blood pressure and heart rate, and lower cholesterol. Shinrin-Yoku is an adventure of deep communion with nature. In this module you will learn how to ground yourself. 9) Develop the best version of you through Hanasaki: this is the blossom of a flower. You will use this word for blossoming the best version of yourself. No matter who you are, where you come from, what your path has been so far, in this module you will learn to aspire to a better version of yourself. 10) Less is more: learn to declutter and simplify your life through Danshari: There’s a new movement rising around the world. Perhaps you’ve heard of it: Danshari. It means “refusal, disposal and separation” You can simply translate it as cleaning or tidying up, but this word means more than this. In this module you will learn to abandon attachment to objects and make a better use of them. 11)Connect with your soul mission through Ikigai: ikigai is that thing that gives our existence a marvellous intensity, it is what gives meaning to life or, as the French would say, its raison d’etre. There is a fire inside us: it can burn with more force, it can weaken, but then it can come back stronger than ever. Ikigai cannot be a simple mental vision, as it is wider, deeper and absolute than the thinking mind. You can only live it, and only by living it can you know it. In this module you will learn the first steps to move nearer to your soul mission. 12)Accept your own shadows, feeling a part of the universe through Yugen: Beauty is Darkness. Shadows are what allow the visible to emerge. The whole world and ourselves are a constant duality: we wake up and go to bed, the sun rises and goes down, we feel on top of the world and we feel stressed, we move in and out, we feel active and we feel lazy and so on. It’s the natural flow of the universe, nothing lasts in the same status forever. In this module you will learn to keep this duality between inner light and darkness stable and to reach the perfect moment. 13)Accept the impermanence of life through mono no aware: ‘this is the deep feeling or pathos of things, the powerful emotions that objects can evoke or instil in us. It is often associated with a poignant feeling of transience, a beautiful sadness in the passing of lives and objects, like the glorious colour of autumn leaves as they are about to fall. In this module you will learn how to let go of our attachments to transient things. Through this certified course you will learn these for yourself and to help others in their transformation if you are an holistic therapist: ● to become grounded and calm ● to create fundamental daily habits ● to have the right approach to solve any life challenge and storm ● how to flow with life ● to express your emotions and develop compassion ● to repair your own wounds ● to practise patience and gratitude ● to become a better version of yourself ● to be nearer to meet your soul mission You can choose: Online (either live or receiving the recordings)  or at the Art and Spirituality Centre 6-8 Alexander Drive EH11 2RH Edinburgh First week-end 22nd-23rd February 2025 10am-5pm Saturday Modules 1,2 (Wabi sabi, Kaizen) Sunday Modules 3,4 (Hanafubuki, Omoyari) Second week-end 15th-16th March 2025 10am-5pm Saturday Modules 5,6 (Kintsugi, Nintai) Sunday Modules 7,8, 9 (Itadakimasu, Shinrin-Yoku, Hanasaki) Third week-end 14th-15th June 2025 10am-5pm Saturday Modules 10,11 (Danshari, Ikigai) Sunday Modules 12,13 (Yugen, Mono No Aware) If you are not available to attend, you can catch up with the recordings and do your homeworks in order to qualify. You an also attend one day or one week-end only. Cost The full course with qualification: £450 Option A) Pay the whole course in full with £50 discount, so just £400 and get a free 1-1 session with me (online or in person) of the value of £100 Option B) Pay a Deposit £150 to secure your place, £150 1st March and £150 1st June 2025 Option C) Join individal week-ends with no qualification £150 each Option D) Join one day only £75 each Disclaimer  By booking any event or 1-1 session -online or any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism, Art and Spirituality and any business partners working with for the event 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. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise. When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by the law according to my current insurance.   Added element of the disclaimer If the class happens in any venue and you are causing any damage to the property, you are taking responsibility of your actions. It is down to the individual to take personal responsibility when participating in physical activity and when entering a space that is used and shared by other parties. Giada Gaslini does not take any responsibility about possible risks that may arise but can only advise and enforce guidelines and legal requirements as defined by the Scottish Government and local authorities.  Giada's Journey Creative explorer of the human well-being with twenty years’ experience running events, workshops and retreats. Co-author of a non-profit book with other 33 Italian women about their stories in different countries. She has been learning to heal herself supportinga Holistic connection between mind, body and spirit. She has been studying and practicing Buddhist teachings, meditation and the Five Tibetan Rites Yoga in Nepal, India and Italy. Approached the imaginal world and dreams with the psychologist Elio Occhipinti and a regressive hypnosis journey with the vision of the psychiatrist Brian Weiss.  Her studies and practice have helped her become: Shamanic Practitioner and Teacher with the two years formal training at Anam Cara and one year in Wales Shamanic and Integral Yoga Teacher, Ikigai Coach,Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy and part of the Italian-Swiss Association for Counselling and Coaching, Aiscon.  Professional Esoteric Numerologist graduated at The Connaissance School of Numerology Corporate Mental Health Coach achieved with WeFocus Founder of Drink In Art exhibitions of local artists in private flats Founder of Invisible Caims creative and spiritual workshops, classes and therapies Founder of the Art and Spirituality Centre centre for creativity and well-being in Edinburgh

Join me for a full immersive day, online and in Edinburgh at the Art and Spirituality Centre, with theory and practice to discover: 🔍What Shamanism is and its origins 🔍How to journey for yourself and another person 🔍How to retrieve a gift 🔍Introduction to healing: extractions and soul retrieval 🔍Power dance Please have with you: 🌟 a blindfold 🌟 your favourite scarf to be used as a magic cloak 🌟 a notebook if you like Shamanism is a spiritual practice that goes beyond every beliefs and culture and is about trying to reach your full potential as you walk on planet earth, so connecting yourselves to the whole. Shamans were described as the first physicians, magicians, artists, storytellers, spiritual beings. But shamans are healers that make changes in invisible realms to help healing in the ordinary reality of the community. Shamans see in the darkness while connecting with the divine outside the time in an altered state of consciousness. The Powerful Benefits of Shamanic Drumming Shamanic drumming can: 🌿 Reduce stress 🌿 Improve concentration 🌿 Open the door to self-acceptance 🌿 Encourage healthier lifestyle choices 🌿 Support cardiovascular health 🌿 Boost your immune system 🌿 Promote deeper self-awareness by synchronizing brain activity and inducing alpha waves 🌿 Help release negative emotions and emotional trauma Lunch is not included Giada's Journey Creative explorer of the human well-being with twenty years’ experience running events, workshops and retreats. Co-author of a non-profit book with other 33 Italian women about their stories in different countries. She has been learning to heal herself supporting a Holistic connection between mind, body and spirit. She has been studying and practicing Buddhist teachings, meditation and the Five Tibetan Rites Yoga in Nepal, India and Italy. Approached the imaginal world and dreams with the psychologist Elio Occhipinti and a regressive hypnosis journey with the vision of the psychiatrist Brian Weiss.  Her studies and practice have helped her become: Shamanic Practitioner and Teacher with the two years formal training at Anam Cara and Teacher Training in Wales  Shamanic and Integral Yoga Teacher, Ikigai Coach, Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy and part of the Italian-Swiss Association for Counselling and Coaching, Aiscon.  Professional Esoteric Numerologist graduated at The Connaissance School of Numerology Corporate Mental Health Coach achieved with WeFocus Founder of Drink In Art exhibitions of local artists in private flats Founder of School of Shamanism creative and spiritual workshops, classes and therapies Founder of the Art and Spirituality Centre centre for creativity and well-being in Edinburgh By attending to our classes, workshops and retreats you agree to our TERMS AND CONDITIONS Payment  Bookings are non-refundable.  Disclaimer  By booking a class or workshop or retreat or 1-1 session -online or any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism and any business partners working with Invisible Caims 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. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise. When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by English Law and the exclusive jurisdiction of the Courts of England and Wales according to my current insurance.   Added element of the disclaimer If the class happens in any venue and you are causing any damage to the property, you are taking responsibility of your actions. It is down to the individual to take personal responsibility when participating in physical activity and when entering a space that is used and shared by other parties. Invisible Caims does not take any responsibility about possible risks that may arise but can only advise and enforce guidelines and legal requirements as defined by the Scottish Government and local authorities.   

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

How to turn your creative passion into a career: take your first steps on this relaxed and welcoming workshop at The Arienas Collective in Edinburgh led by Laura Ogilvie Jones coaching