401 Courses in Edinburgh

During this two-day workshop, you will learn how to tell a compelling story via photographs. Participants will gain the tools for conceiving of and crafting their own projects, with pointers on how to find ideas, develop your vision, and self-edit. We will cover a broad range of themes, including subject interaction, ethical dimensions, natural light usage and composition. There will also be practical guidance on financing projects, and where to place finished work.Between the two sessions there will be an assignment, intended to provide a practical application of newly acquired skills – this will be reviewed in our second meeting.This workshop is perfect for those with a good understanding of digital photography, seeking to hone their storytelling abilities and push the boundaries of documentary photography.Day 1:– Introduction to photographic storytelling.– Case study of Michael’s work in relation to the practicalities involved with funding, organising and producing a documentary project.– Discussion on the work of inspirational photographers, film makers, and artists.– Consideration of the ethical challenges encountered when producing documentary photography.– Introduction of practical task, and review of images.There will be a practical assignment to be carried out before the 2nd session.Day 2:– Photo story workshop and discussion on style.– Editing: how to select the right pictures to suit narrative objectives.– How to work within time constraints.– Practical task– Portfolio review of work produced during the workshop.– Presentation on opportunities, competitions, and publishing documentary photography projects.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

Gain a deep understanding of Production Sharing Contracts (PSC) and related agreements through our expert-led course. Enroll now and excel in your field with EnergyEdge.

Can be run as a one day or two day course. Whereas the one day course concentrates on Speaking Skills in delivering a talk and allows time for participants to prepare and deliver a very short talk, the two day course offers the opportunity for participants to deliver a longer (15 minute) talk and includes consideration of other situations where speaking skills are important such as talking in meetings, talking at interviews etc.

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

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

A half day course for those who find themselves taking and presenting minutes for different kinds of meetings. The session will provide practical tips on how to write minutes that are clear and more concise and how to save time during the minute-taking process. It will be a useful session for both novice and experienced minute takers.

The ability to identify and respond to changing trends is a hallmark of a successful business. Whether those trends are related to customers and sales, or to regulatory and industry standards, businesses are wise to keep track of the variables that can affect the bottom line. In today's business landscape, data comes from numerous sources and in diverse forms.

Art and Spirituality is a Community space for Creativity and Well-being. It is your sacred nest in Edinburgh to become an Inner Explorer and Soul Painter within your Heart. A beautiful renovated Studio Room and Therapy Room and aCafe. A space for everyone where to find healing, inspiration, self-expression and nourishment for your body and spirit through healthy food, classes, workshops and therapies run by different facilitators.  It is situated near Haymarket Station and many buses connect the city centre to Gorgie Road and Westfield: numbers 1,2,3,22,25,33,38,44 Join our creative spiritual community and come to work with us among beautiful canvasses in our studio. Find inspiration and calmness to concentrate on your work or project. We offer you the opportunity to rent a desk during the week and we offer fast connection and free tea and coffee in the studio. If you wish to have lunch or anything else in our Fusion Asian Cafe onsite, this is connected through an internal door. Orders at the cafe are not included in the rent. Other food options are available in the area of Gorgie-Dalry.  Disclaimer By booking a desk you release Giada Gaslini and Art and Spirituality CIC and Pigsy's Den (cafe) 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 whilein the venue.

Overview The Risk Analysis course is a highly demanded certification for roles in project risk management. It recognizes skills, competency, and competency in assessing and identifying project risks, mitigating threats and capitalising on opportunities, while still possessing core knowledge and practical application in all areas of project management. The risk management specialist role on project teams is becoming more important to an organization's success. This course has been designed to benefit professionals who have the responsibility of regularly making important business decisions and wish to enhance their Risk Management abilities and apply them to their businesses. Upcoming Events Online (USD 2250) Online Streaming Live (Flexible Dates) For more dates and Venue, Please email sales@gbacorporate.co.uk

This half day course is designed to help participants in the voluntary and community sector to monitor and evaluate the work of their organisation effectively and ensure that their working practices are robust and fit for purpose. It can also be relevant to those staff in statutory agencies who work on community projects.