212 Code courses in Edinburgh

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

This short course will help you take your images from the screen to final professional-quality prints. We will walk through the processes and techniques needed to take the mystery out of this often daunting and overlooked part of the creative process. By the end of the day you will have gained the skills and confidence to take digital files through preparation in Photoshop, optimisation, and onto physical test printing, adjustments and final output on Stills’ large format Epson inkjet printer. We’ll cover areas critical to the desired outcome including screen and print calibration, paper choice and ICC profile use. By the end of the day you will have two A3 prints on premium Hahnemule matt or gloss papers. Participants should have a basic understanding of Photoshop and attend with a selection of their own RAW files or high resolution TIFFs to work with through the practical exercises. Morning We will begin with evaluating our images and processing the file to maximise print quality output. We will then use Adobe Bridge, Adobe Camera Raw & Adobe Photoshop for the optimisation process. Participants will be guided in preparing their images ready for test printing, before evaluating and adjusting. Discussion will cover using ICC profiles, screen and print calibration, colour rendering, canvas sizing, and sharpening for final print output on various media. Afternoon We will then put the skills we have learned into practice, producing and evaluating test prints before undertaking our final A3 digital inkjet prints. Each participant will finish the session with two finished prints. There will be plenty of opportunity for participants to ask questions at every stage, so that you feel confident and can make informed decisions throughout the whole process. This course is 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. It is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge and allow you to work confidently on your own 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.

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.

From propaganda to advertising, posters are a ubiquitous, powerful vehicle to take a message to the masses. Over four weeks, learn how to approach poster design in a creative and practical way. Although some computer work will be introduced, it will only be used as another production tool, participants will be encouraged to experiment with analogue techniques such as collage and hand-generated type. You will learn about the history of poster design; learn to use aspects of Adobe InDesign, Illustrator and Photoshop; develop approaches to letterform and layout. The emphasis of this course is on the development of a set of posters from research and design through to output. Week 1: History History of Poster Design: Looking at significant and famous posters from around the globe and their impact on society. Practical activity: After a quick introduction to InDesign we will recreate one of these posters, studying the component parts and their relationships to one another. Homework: Think of a concept for your design. What is it for? Who is your target audience? Where and how will it be displayed? Select a favourite poster to bring in or discuss with the group in week 2. Week 2: Image We will begin by discussing participant posters they have brought in to share and look at positives and potential negatives within the designs. Image selection can be a key factor to the success of your poster campaign. We will think about the choices between photography and illustration looking at examples of how this is done successfully. Think about the different ways we can generate and use images. Practical activity: Consider what medium the image might be and how it can be created. Learn about flatbed/film scanner for potential use in image creation. Week 3: Fonts We will look at how typography impacts designs and the messages that it can convey by itself. Consider various approaches to how we can generate type. How typographic selections work alongside selected images. Practical activity: Work through a few typographic workshops thinking about how typographic choices will alter the message you are trying to convey. We will consider various ways and techniques of creating type for our poster. Homework: Developing your typographic solution further, if required. Work through variations of layout. Week 4: Output Continue working on our posters making final tweaks and selecting the poster that is our most successful design for output. We will look at the various formats for output and how we prepare our posters for print. Look at usage of different poster sizes – why use one over the other?? Practical activity: Size your final poster and get it ready for output (if working analogue, scan final poster and upscale).   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.

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.

Adobe After Effects CC is the industry leader in video compositing software, offering an exciting and versatile array of applications for the creation of professional moving image work. On this course you will learn a range of visual effects and animation techniques, working between Photoshop and After Effects to create videos which explore text based motion graphics, character animation, green-screen compositing, 3D landscapes, motion tracking and lots more in-between. Alongside technical exercises the tutor will screen and discuss relevant artists, designers and filmmakers, providing both the technical skills and inspiration to create your own professional motion graphics work, filmic special effects or experimental artists video. Computer experience is required. Week 1 This week we will create a short video that combines text, still image and video layers. Through this exercise you will learn how to: Navigate the workspace on After Effects Set up a project and select a video format Introduce video to the timeline and split layers Change the position and scale of layers Introduce basic text Use selections in Photoshop to create a still image composition Import this composition into After Effects to create a composite video. Week 2 This week we will look at basic animation techniques. Through a series of exercises, you will learn how to: Use Photoshop to great multi-layered elements for animation Import these Photoshop elements into After Effects Work with key-frames and interpolation Add motion blur Duplicate and pre-compose animated elements Create a parallax effect to give the illusion of depth Apply blending modes Work with the puppet tool to create moving joints for an animated character Week 3 This week we will look at converting 2D photographs into a 3D virtual space to provide depth and movement. Through a series of exercises, you will learn how to: Convert a 2D image into a 3D space Set up a multi-layered diorama in Photoshop Import this into After Effects and position the layers within 3D space Create an animated camera move through 3D space Apply depth of field Week 4 This week we will look at working with green-screen compositing to place a live action figure within an animated backdrop. Through a series of exercises, you will learn how to: Work with the Keylight filter Adjust colour balance and tone Composite the figure against an animated background Introduce shadows and highlights Use the green-screen figure to create a silhouette Week 5 This week we will look at applying masks to footage to create cutouts, as well as exploring different applications for effects. Through a series of exercises, you will learn how to: Work with masks Use the Roto-mask tool Apply time re-mapping Work with ‘Particle Playground’ and similar effects Week 6 This week we will look at working with the paint panel to create animated drawings, as well as using motion tracking to attach a text element to a moving point within a video clip. Finally, we will cover how to output your final project, adding sound effects and applying a basic edit. Through a series of exercises, you will learn how to: Create text based motion graphics (kinetic typography) Apply motion tracking to live action footage Render your project Add sound to your video   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.