630 Courses in Edinburgh

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path 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

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

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

I've added this two day workshop because a one day workshop gives you the basics, but two days will allow you to develop your carving technique and use additional knife grasps.  By embedding good technique into the way you carve, you will avoid injuries and additional regular stretching will help you to look after your body. You will leave with the knowledge and confidence to carve safely at home.  You will have access to a range of different tools, starting with the axe to rough out spoon blanks - I have a good range of axes you can try from budget to the Gransfors large carving axe. Next using the Mora wood carving knives (105/106/120) to shape your blanks into spoons following traditional designs for optimising strength and utility. I also have a range of hook knives to try out. Using these traditional tools you will make a spoon from local and sustainable fresh cut green wood (usually willow/birch/alder or cherry) - starting with a log and leaving with a spoon. From the initial splitting of the log, trimming it down with an axe, to carving finer details and decorations with chip carving knives. This course is located close to central Edinburgh and is accessible by public transport.  Depending on the weather it can be inside or outdoors in the wildlife garden. Courses can also be arranged to suit your availability! Please email to discuss your requirements, discounts are available for small groups or multiple days. Course numbers are usually limited to five or less; individual training courses can also be arranged. What's included in the price? Tea, coffee, light lunch of bread and soup and snacks. Professional training in the use of a range of traditional tools. Advice on tool care and sharpening. Fresh cut (green) wood for carving. Some tools available for sale at competitive rates.  

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.

Alien spoons? Well, only because it is a memorable name and some of the knife grasps feel a bit alien to start with. You will soon get to grips with them and the focus of this workshop is learning to use safe and efficient carving techniques with hand tools - the axe, straight knives and hook knives... maybe also a drawknife on a shave horse. By following good technique you will avoid injuries and with regular stretching this will help you to look after your body as well as the tools. You should leave with the knowledge and confidence to carve safely at home. The tools are relatively cheap and easy to use in a small space. You will have access to a range of tools, but primarily use the Mora wood carving knives (106/120/164s) and be shown traditional designs for optimising strength and utility. Using these traditional tools you will make a spoon from local and sustainable fresh cut green wood - starting with a log and leaving with a spoon. From the initial splitting of the log with a froe or axe, trimming this down with an axe, and on to carving finer details and decorations with knives. Additional skills in building a shave horse and other green wood working can also be taught. This course is run from close to central Edinburgh and is accessible by public transport.  Depending on the weather it can be inside or outdoors in the wildlife garden. Courses can also be arranged to suit your availability! Please get in touch to discuss your requirements, discounts are available for small groups or multiple days. Course numbers are usually limited to five or less; individual training courses can also be arranged. What's included in the price? Tea, coffee, light lunch of bread and soup and snacks - All vegan Professional training in the use of a range of traditional tools. Advice on tool care and sharpening. Fresh cut (green) wood for carving. Some tools available for sale at competitive rates. Summary of course information emailed to you after the workshop.

The course will introduce you to some of the most enduring photographic portraits and provide discussion on why they remain so seminal. The course includes an introduction to lighting and composition techniques for portraiture, as well as providing guidance on shutter speed, aperture, lenses, and other visual controls. You will use studio flash lighting to explore basic techniques in formal and informal portrait photography – though all of the techniques taught are transferrable to natural and other lighting media. There will be time for participants to photograph under three standard lighting set-ups. Some digital SLR photography experience is recommended. Morning The morning session centres on discussion of the work of some classic portrait photographers and standard techniques employed. The discussions will include elements of composition, pose, gesture, format and technique. Afternoon The afternoon session will cover practical studio lighting, standard lighting set-ups, direction of sitters, and time permitting also a brief introduction to some of the editing capabilities of Adobe Photoshop. Project Days are designed for those who are already familiar with digital photography processes but who want to pursue a particular aspect or develop more specific skills in one or more areas. This course is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge of DSLR camera skills and becoming a better photographer in general. It will help you to work confidently on your own creative projects and develop the artist in you.   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.

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.

Adobe Lightroom Classic helps solve two of the main problems that afflict digital photographers: how to organise all your files, and how to edit them without spending all of your spare time at a computer screen. Lightroom Classic is a convenient and flexible desktop programme that helps you to organise and sift your photographs into collections, and also gives access to a powerful set of tools that edit, enhance and export your pictures. You can use intuitive pre-set tools, you can create your own favourite adjustments, you can edit large numbers of images with one click of a mouse, and you can fine-tune your image-editing by selectively working on parts of a picture. And you can experiment, secure in the knowledge that you are working in a non-destructive environment and that your pictures are safe. This practical short course will introduce you to the principles of file organisation and image-editing, giving you the knowledge and confidence to choose when to work with this convenient and flexible programme, and whether or not you need the full power of Photoshop Creative Suite. Sample picture files will be provided for you to work with, or you can bring a selection of your own. If you work in RAW, please also bring JPEGs on a memory stick, external hard drive or cloud storage such as Dropbox. Please note this course does not cover the new version of LightRoom CC (which is specifically designed for mobile devices) and only uses the most recent version of LightRoom Classic. Morning You will get to know the Lightroom layout and workspace, importing a set of files into the catalogue and starting to organise the files into collections and adding useful file information. You will explore the opportunities for viewing and aids for analysing the pictures. You will start to use the convenient ‘quick develop’ editing tools. We will then explore the digital image-editing workflow. The usual flow is to correct and optimise before we enhance, interpret or exaggerate. The basic areas to consider are cropping, cloning, colour and tone. Taking each in turn, we will correct and clean up the pictures in a measurable and controllable way. We will investigate techniques to control digital noise, colour distortions and lens corrections. We will work on individual files and also start applying corrections to batches. We will create and apply pre-set corrections. Afternoon Having corrected and optimised the picture files, we can start interpreting, enhancing and exaggerating – the fun part of image-editing! We can try colour to black-and-white conversions, using the many pre-sets to guide; we can selectively boost or restrain colours; we can add grain and textures, vignettes and split tones; we can mix and match these effects and create and save our own favourite effects. We can apply adjustment effects to selected picture areas. Image editing is all good fun, but how do we know where to start? Or when to stop? We‚’ll have a look at some photographic styles and techniques from photography’s rich history to give us some ideas and then try to replicate them. We will discuss ways of using the programme and the technology to develop photographic projects. And we will look at how Lightroom can help us to export those projects as books, prints and slideshows. 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.

RSPH level 2 Identifying and Controlling Food Allergy Risks Training Course Do you need an allergy trainer to come to your food business and teach your staff face to face about food and drink allergens, their dangers and how to control them? Our allergy trainer can come to your business and deliver this course at your business premises. Although we are based in London, we are happy to travel and deliver this course at your business location. (Trainer travel fees may be applicable depending on your location). Staff will receive interactive training and coaching on allergens and intolerances with an experienced trainer. We can also tweak the training to include issues you would like to cover. See our website for more details. Special offer for on-site allergy training. £250 plus £20pp includes RSPH exam fees (usually £350 plus £30pp) This course is suitable for any catering business such as restaurants, pubs, hotels, cafes, catering companies, cooks, self employed, artisans, event caterers and more. This course is also important for staff who are Front of House, who take customer orders and relay the orders to cooks and chefs and other people who are preparing food for customers who have allergies and or intolerances. This is a short one day training course, typically 9am-3pm. Topics covered include- Allergens, Allergen Identification, Cross contact, Cross Contamination, Allergic Reactions, Food Intolerances, Coeliac, Anaphylaxis, Natasha's Law, UK Food Safety Regulations, Allergy Controls, Substituting ingredients, Customer Communication and what to do in an Emergency. Contact us to book training.