208 Code courses in Edinburgh

This one-day workshop will introduce you to the history and development of still life and product photography and its use in commerce and fine art. We will look at the work of historical and contemporary practitioners leading to a practical demonstration of still life photography, encompassing the relevant lighting, styling and composition. The day will include a simple product photography and lighting session exploring camera techniques and equipment you can use to create your own images. Please bring along a small object you would like to photograph as part of the day. Morning The day will start with an introduction to the still life genre, looking at its development through photography both as a commercial and artistic tool. We’ll then build and light a still life setup – providing guidance and examples of different lighting techniques, composition and styling skills. Afternoon The afternoon will focus on product photography and lighting for sales. This will include information on equipment and technical requirements, along with some handy tips, tricks and hacks! We’ll also demonstrate ‘Focus Stacking’ – an advanced technique for combining multiple images. The day will conclude with a practical session, where you will get a chance to work in small groups to photograph the objects you have brought in, we’ll also provide some sample objects if required. This is a great opportunity to put the day’s learning into practice with our tutor’s support on hand. Project Days are designed for those who are already familiar with some digital photography processes but who want to pursue a particular aspect and develop skills in a specific genre. This course is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge of camera skills and allow you to work confidently on your own projects. Some prior digital SLR photography experience is therefore recommended.   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.

The Portable Appliance Testing course or PAT testing course as it is more commonly known is one of our most popular courses as it does not require you to have any formal previous qualifications and once completed, will enable you to offer your services. In the commercial setting, the law places a responsibility on all employers to ensure that the electrical equipment to be used by their staff and the public, should be fit for purpose and safe for use. Hence, all portable appliances have to be regularly checked and maintained by a competent person.

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

About this Training Course The two elements which consistently remain in the forefront of every executive, tasked to manage a project, are 'Cost' and 'Time'. There is probably no disagreement or a need to prove that a strong correlation exists between Cost and Schedule. The mechanics of capturing cost during the execution is not that difficult a task, as it is when undertaking Design, Engineering, Estimating, Planning, Scheduling, and seeking financing for the project. The corporate management is expected to provide realistic, reliable and risks adjusted projections of a project's overall financial performance. This 3 full-day course and workshop is developed to make the delegates walk through the engineering formulas and equations to become a professional in managing estimates, projections, risks, uncertainties and secure financing for high value, high risk projects, from both On-shore and Offshore Oil & Gas industry segments. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Objectives of this Training Course: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Target Audience If you are responsible for undertaking one or more of the following functions in the Oil & Gas and Offshore & Marine Industry, you can't afford to miss this course: Management Accountants, Finance Managers, Cost Controllers, Project Directors, Contracts & Projects Managers, Estimators, Planners and Risk Managers. Course Level Intermediate Training Methods Unique Features of this Enhanced Course Curriculum: This course and the workshops are developed for the participants to gain comprehensive understanding of the field of Cost Engineering and its impact on the project execution, financing and risk management. The underlying objectives are: Enhance familiarization with mechanics of cost engineering in developing budgets and Project Cost Models. Gain understanding of diversity in financing of EPC Projects in context of Offshore and Onshore Oil & Gas projects in international arena. Identify risks associated with cost estimates and costing elements, with an objective of developing project strategies and minimizing the exposure to escalation of prices and market factors. Appreciate the correlation between cost and schedule, resulting in the delivery of contractual obligations. Develop competency to manage risks of costs and time overrun, by implementing appropriate cost control mechanism. Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader, during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

This course will introduce you to the beautiful world of colour analogue photography. Taking as a starting point the work of contemporary photographic artists working with colour, we will discuss and explore theory as well as developing core skills essential for the capture and printing of your own colour images. You will learn how to correctly expose colour negative film and learn more about the characteristics of different types of film and the effects that they can have on an image. Within Stills’ darkrooms you will learn how to process your colour film by hand and print high quality analogue C-Type prints. Day 1 Morning: Colour Theory, Inspiration and Refresher for SLR Camera Controls During the morning we will be looking at contemporary photographers and artists that have used colour to inform their practice in specific ways. We will look at the ways in which colour revolutionized the artworld and vernacular photography. We will also look at basic colour theory, exploring which colours compliment each other and why. We will also refresh basic camera controls, load cameras and head out to the streets to shoot a roll of film. Afternoon: Colour Film Processing During this session, you will learn how to hand process your colour film. We will discuss the loading of the tank and the preparation of the machine to ensure correct processing temperature. We will look at different film types, why you may want to use them and the range of effects that can be produced. Day 2 Morning: Introducing the Colour Darkroom and Contact Sheets You will be introduced to Stills colour darkooms and become familiarised with the range of equipment you will be using. You will be taught how to set up your darkroom for printing, how the colour print processor works and how to print a contact sheet for viewing your negatives. Afternoon: Printing In the afternoon you will be expected to make a series of final C-Type prints. You will be shown techniques to improve your printing skills and produce the images you desire. This last session will allow you time to print with some one-to-one attention. We will discuss some printing techniques to help you get the most from your negatives. We will also have time at the end of the day to look back on all the work produced over the course and discuss it in relation to theory we learnt at the beginning. By the end of the course you will have: Learned more about colour theory and have a knowledge of contemporary artists working with colour photography Learned to process your own colour film Experimented with a variety of specialised darkroom printing techniques Printed contact sheets and a collection of colour photographs Feel confident in a colour darkroom using specialist equipment   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.

Do you have a growing mountain of negatives and/or prints and wish to have them as digital files? This course will equip you with the skills to digitally archive your collection ready for reprinting and sharing online! It can be intimidating to approach alone, but this class will break the process down into an easy step-by-step tutorial – from scanning, to editing, and exporting. Having completed the course, participants will have a solid understanding of the required processes and can go on to take full control of their negatives and potential outputs. This workshop will take you through the scanning process – turning analogue negatives/prints into digital files – using two different scanners: an Epson flatbed and a Hasselblad virtual drum scanner. Providing an opportunity to look at how best to scan and restore prints as well as negatives, you will learn the benefits of both scanning systems and understand when and why to use them. Once images are scanned, you will then be shown how to take full advantage of all the information you have captured to really get the most out of the files. The course will guide you through the editing process using Adobe Photoshop to bring your photos up to the highest standard, utilizing colour correction, levels, adjustments as well as a walkthrough of the processes used to clean dust and scratches from your images. You will be shown how to export files for digital printing as well as for sharing online. All equipment and software will be provided for you, but in order to get the most out of the course you are encouraged to bring along a varied selection of negatives and/or prints to use during the course. It is estimated that you will have time to scan up to a dozen images during the day, so please do not bring along whole archives at this stage! Having completed the course you will be able to return to Stills to confidently use the scanning facilities here on a session or daily basis. However, much of the information and learning from these systems can be directly applied to your own home scanning setup if required.   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.

Japanese Yoga and Vegan Gyoza Cooking Class Join us for a unique experience combining movement and nourishment! This class begins with one hour session of Japanese Yoga, run by Giada, founder of Art and Spirituality and School of Shamanism. This is a dynamic and meditative practice that harmonizes body, mind, and spirit. Rooted in traditional Japanese principles, the yoga focuses on breath, posture, and gentle stretches to promote flexibility, balance, and relaxation. Japanese Yoga is part of Shamanic Yoga, which is ancestral, ancient, pre-vedic. It has the element of ecstasy, of a non ordinary state of consciousness, where you work with nature, animals, yantras, mantras, mudras, rituals, initiations in the imaginal forest, in the natural code, non the social code. Merceliade says that this yoga is the oldest form of yoga and we find it in various traditions: Hindu tradition (Shaktism), Himalayan (Naropa, Milarepa etc), South America (Andean yoga), Siberia, Mongolia, Japan (Yamabushi), Taoism, Alchemy. No experience required and mats are provided. After the yoga session, we’ll dive into the culinary world with a hands-on vegan gyoza cooking class, run by Gloria, founder of Madebyflour. Learn how to prepare delicious and healthy gyoza, a popular Japanese dumpling, using fresh, plant-based ingredients. Our step-by-step guidance will show you how to fold and cook these savory delights to perfection. Recipes in the class include gluten and other allergens. Please add a note in your booking if you have any dietary requirement or allergy. The lessons are suitable for all levels of experience and materials and mats are provided. By attending this class you release Giada Gaslini, Gloria Civillini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending.

The City & Guilds 2365 Level 3 Course is the natural progression for anyone who has completed the Level 2 Diploma 2365 course or related level 2 courses. On completion of this course you will then be able to undertake the Level 3 NVQ thus becoming recognised as a fully qualified electrical engineer within the industry with the ability to apply for JIB (Gold Card) membership upon successful completion of the AM2 Assessment. Further information on the Level 3 can be found here: C&G 2365 Level 3 Diploma in Electrical Installations — Optima Electrical Training (optima-ect.com)

If you have at least 5 years working experience and you would like to attain Gold Card status via the Experienced Worker route by joining the City & Guilds 2346 NVQ Level 3, you will also need to hold the below two pre-requisite qualifications: City & Guilds 2391-52 Inspection and Testing Course C&G 2382-22 BS7671 18th Edition

As phone and tablet cameras continue to improve and App developments become more advanced, mobile photography – previously considered only suitable for quick snaps and throwaway selfies – is more and more becoming recognised as a legitimate photographic medium. And anyone with a phone or tablet can do it! This course will explore the concepts of digital camera photography (and all that it entails) but through the medium of your own mobile device. Through a mixture of discussion and practical work this course will help you to push the limits of what your phone camera can do. As well as exploring the creative side of photography, we’ll break down some of the technical elements to get a better understanding of photography in general and learn how to achieve similar results using your phone or tablet. We’ll explore useful Apps to help get the desired output from your device and spend time looking at postproduction techniques that can improve and enhance your camera photos beyond a casual snapshot. Some of the Apps we will be looking at include Slow Shutter (iOS), VSCO (iOS/Android), Snapseed (iOS/Android), Adobe Lightroom for Mobile (iOS/Android) and Manual Camera (Android). You do not need to have all these downloaded in advance and, please be aware that depending on the capabilities of your phone, some of the features of these apps may not be available to you. This course is suitable for beginners and requires very little technical knowledge – just an enthusiasm and interest in photography and how to get a little more from your device. Please bring comfy weather-appropriate clothing as there will be some time spent outside shooting. Please specify the Make and Model of your mobile device when booking, so that the tutor can provide specific information tailored to your device wherever possible   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.