221 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

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

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.

Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities...  Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 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. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office 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

A series of hourly small group sessions where we look at different aspects of Excel Duration: 1 hr sessions Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

The course is designed to help improve your understanding of the legal requirements, the theoretical and practical principles for both the initial verification and certification of an electrical installation, further your knowledge and practical skills in the testing and inspection of a range of existing electrical installations, and help improve your understanding of the legal requirements, the theoretical and practical principles for the periodic inspect and testing and certification of an electrical installation.

“Any good photography is a successful synthesis of technique and art.” – Andreas Feininger Discover the magic of Black & White Photography and learn some of the secrets the masters use to make stunning photographs. Explore the fundamentals of light and time and no longer be a slave to the Auto setting. Master the manual functions of your 35mm SLR film camera and unlock its true potential. Get to grips with the complete darkroom workflow from processing film to printing your own black & white photographs. Perfect for those with no experience or those looking for a full refresher. If you don’t have a 35mm SLR camera we have a limited number available for use during the course – please make your selection from the dropdown at time of booking. Week 1 Capture, technical notes, discussions, art context Understand the fundamentals of light and time in balancing an accurate exposure; No longer be a slave to the Auto setting! Learn how to utilise the Manual functions of your 35mm SLR camera including aperture, shutter speed, film speed and metering. Understand depth of field, composition and creative photo-making techniques; Appreciate photography within an art context – Begin to look at the work of other photographers Assignment: You will be given one roll of B&W film to be shot for the second week Week 2 Film processing Learn how to process B&W film by hand in Stills’ darkrooms. We will discuss different film types and chemistry, as well as best practice procedures for film handling. Appreciating photography within an art context-Sally Mann. Week 3 Contact Printing Gain an appreciation of general darkroom procedures;understand how to set up your enlarger and make a contact print using the traditional analogue method; learn how to make 8×10″ work prints using the single filter printing method. All paper and chemistry will be provided. Week 4 Darkroom printing This last session will allow participants to keep on printing with some one to one attention. We will also explore some basic dodging and burning and other printing techniques to get the most from your negatives and make a series of final prints.     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. Stills uses ILFORD PHOTO chemicals on this course that can potentially pose a risk to pregnant and breast feeding women and asthmatics. We take every care to ensure good working practices and adequate ventilation in our darkrooms. If you feel you may be adversely affected, please visit the Health and Safety section of Ilford’s website for further information.   General Guidance Notes for Pregnant and Breast Feeding Women and Asthmatics: From a risk assessment standpoint, provided all necessary control measures (such as good working practices, adequate ventilation, and the use of appropriate PPE) are in place then pregnant and breastfeeding women should be able to continue to work safely with photochemical products.Inhalation is the main route by which fumes and gases enter the body, making good ventilation a high priority. Exposure to irritant chemicals that would not affect most people may provoke an asthma attack in a person who already has asthma. For example, low levels of the gas sulphur dioxide can be produced by some ILFORD PHOTO processes. Most individuals would be unaffected but asthmatics may suffer adverse affects. ILFORD PHOTO products include no known human carcinogens, and no substances to which phrase R46 (May cause heritable genetic damage) or R64 (May cause harm to breastfed babies) applies. Most ILFORD PHOTO developers use hydroquinone, and their classification therefore includes R40 (Limited evidence of a carcinogenic effect) and R68 (Possible risk of irreversible effects). Some ILFORD PHOTO chemicals use boric acid or borates. These substances are classified as toxic for reproduction. As a result, the classification of some of the powder developers includes R60 (May impair fertility) and R61 (May cause harm to the unborn child).

Get to grips with the complete darkroom workflow from processing film to printing your own black & white photographs.

On this course we go into far greater detail on understanding the dog’s needs, behaviour, state of mind, language, and improving your leadership skills.

Behavioural Foundation Course. The foundation course is a great opportunity to learn about your dog’s needs.