• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2 Rya courses in Nottingham

Individual Sailing Training

4.9(48)

By Go West Sailing

All our skippers and instructors are either fully qualified RYA Yachtmaster or Cruising Instructors with many years of experience sailing in Scotland and with years of offshore experience, sailing across the seas and oceans. They all have various other RYA qualifications and are keen to share their knowledge with you. If you would like to talk about your sailing plans and aspirations, or are interested in customised training at sea or ashore, please contact us at admin@gowestsailing.com

Individual Sailing Training
Delivered In-Person in Largs or UK WideFlexible Dates
Price on Enquiry

Microsoft Excel Advanced - In-company

By Microsoft Office Training

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

Microsoft Excel Advanced - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£650

Online Options

Show all 16

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

4.4(67)

By London Waterloo Academy

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to: Travel the world and be paid for it Work in a friendly, collaborative atmosphere, 5000 metres above the sea level Build a global network This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board.  98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lesson per week for 18 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment. Individual support on the journey from the course to a job placement Receive constant updates on recruitment and news from Aviation the world We will enhance your CV Full support on your job application process Gain an insight into the airline selection process and final one-to-one interview What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 14 March 2024 – 11 July 2024, Thursday classes 10 June 2024 – 7 October 2024, Monday classes 17 September 2024 – 14 January 2025, Tuesday classes 18 November 2024 – 17 March 2025, Monday classes Course duration – 18 weeks Classes – once a week Lesson Time – 6:30pm to 9pm – GMT (London time) Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS
Delivered Online + more
£300 to £529

VIRTUAL AIRLINE CABIN CREW COURSE

4.4(67)

By London Waterloo Academy

This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate.   98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lessons per week for 9 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.  What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course Individual support on the journey from the course to a job placement With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. We will enhance your CV Guidance through the job application process (free of charge) Gain an insight into the airline selection process and final one-to-one interview The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 15 May 2024 – 10 July 2024, Wednesday classes 18 September 2024 – 6 November 2024, Wednesday classes 14 November 2024 – 9 January 2025, Thursday classes Course duration – 9 weeks Classes – once a week Lesson Time – 10am to 5pm – London time Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

VIRTUAL AIRLINE CABIN CREW COURSE
Delivered Online + more
£300 to £529

RYA Yachtmaster Fast Track Online Theory Course

5.0(5)

By Ardent Training

The RYA Yachtmaster Fast Track Online Theory Course is an online theory course designed to suit those who have a lot of experience at sea but have no formal qualifications. Alternatively, perhaps you have completed the Day Skipper course but your skills are a little rusty and underused. The RYA Yachtmaster Course Fast Track course will provide a little more background on each topic before moving onto the advanced skills of the Yachtmaster syllabus.

RYA Yachtmaster Fast Track Online Theory Course
Delivered Online On Demand
£475

RYA Day Skipper Theory Online Course

5.0(5)

By Ardent Training

Enjoy this RYA Day Skipper theory course. A comprehensive introduction to chart work, navigation, meteorology, and the basics of seamanship. This RYA online course is delivered in video and text format, to give you flexibility and control over your learning. Made up of 15 modules with interactive activities and knowledge checks to get the most out of your distance learning experience.

RYA Day Skipper Theory Online Course
Delivered Online On Demand
£315

RYA Coastal Skipper Theory And Yachtmaster Offshore Theory Online Course

5.0(5)

By Ardent Training

The RYA Yachtmaster Fast Track Online Theory Course is an online theory course designed to suit those who have a lot of experience at sea but have no formal qualifications. Alternatively, perhaps you have completed the Day Skipper course but your skills are a little rusty and underused. The RYA Yachtmaster Course Fast Track course will provide a little more background on each topic before moving onto the advanced skills of the Yachtmaster syllabus.

RYA Coastal Skipper Theory And Yachtmaster Offshore Theory Online Course
Delivered Online On Demand
£345

COMING SOON: RYA Yachtmaster Ocean Online Course

5.0(5)

By Ardent Training

This course teaches you astro navigation, ocean passages, worlwide meteorology, and the practical skills required to use a Sextant for Ocean Navigation.

COMING SOON: RYA Yachtmaster Ocean Online Course
Delivered Online On Demand
FREE

RYA Day Skipper shore-based online, distance learning, theory course

5.0(23)

By Westview Sailing

RYA Day Skipper shore-based online distance learning course

RYA Day Skipper shore-based online, distance learning, theory course
Delivered Online On Demand
£350

RYA Yachtmaster shore-based, online, distance learning, theory course

5.0(23)

By Westview Sailing

RYA Yachtmaster shore-based, online, distance learning, theory course
Delivered Online On Demand
£375

27th January Lydia Silver #Agent121. Looking for: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION

5.0(1)

By I Am In Print

LOOKING FOR: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION After a childhood buried in library books and Beanos, Lydia started her career in the editorial team at Egmont, where she commissioned books such as the Carnegie Medal-winning The Poet X. She joined the Darley Anderson team in 2018, and as well as building an engaging and diverse list of authors and illustrators, she was promoted to Director in March 2024. With experience on both sides of the commissioning desk, Lydia loves working editorially with her clients and developing ideas from an initial spark into a full manuscript. She represents clients across all age groups, including picture book, chapter book, middle grade and YA, and has a particular focus on non-fiction. Lydia reads and considers widely, and among other things she is looking for snort-inducing stories for younger readers, clever and contemporary teenage and YA fiction, and non-fiction projects that take big ideas and make them easily navigable, accessible and fun. No matter the story, Lydia is drawn to voice above anything else and will always be sucked in by a strong hook. Lydia represents clients including Soofiya, Gina Blaxill, Mark Bradley, Ryan Hammond, Alice Harman, Joyce Efia Harmer, Catherine Jacob, Hannah Moffatt, Rachel Morrisroe, Nick Sheridan, Rashmi Sirdeshpande and Eva Wong Nava. If you could sum up her tastes in three words, they would be curious, characterful and heartfelt, and in three books, they would be One of Us is Lying, Nevermoor and You Are Awesome. Lydia would like you to submit a covering letter, a 1 page synopsis and the first 3 chapters or 20 pages of your completed manuscript in a single word document. For Picture Books please submit a covering letter and texts for two completed stories. (In addition to the paid sessions, Lydia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Thursday 16th January 2025

27th January Lydia Silver #Agent121. Looking for: PICTURE BOOKS, CHAPTER BOOKS, MG, YA, CHILDREN'S NON-FICTION
Delivered Online + more
£72

18th February Francesca Riccardi #Agent121. Looking for: ADULT FICTION

5.0(1)

By I Am In Print

LOOKING FOR: ADULT FICTION Francesca Riccardi is a literary agent at Kate Nash Literary Agency. She has previously worked in sales roles at HarperCollins, Constable & Robinson, Atlantic Books (where she was recognised as a 2017 Bookseller Rising Star), and most recently was sales and marketing director for Canelo. She has worked with authors including Holly Seddon, Rachel Lynch, Cesca Major, Robert Fabbri, Marion Todd, M C Beaton, Catherine Ryan Howard, and Phil Rickman. Francesca is looking for character-driven popular commercial adult fiction across all genres. She loves books with a strong voice and sense of place, and is particularly interested in stories that are high concept, appealing to a millennial audience, and showcase lesser known experiences and/or female and diverse narratives. Francesca would like you to submit the first 5000 words of your manuscript, a synopsis and your cover letter in that order in one single Word document. (In addition to the paid sessions, Francesca is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Thursday 6th February 2025

18th February Francesca Riccardi #Agent121. Looking for: ADULT FICTION
Delivered Online + more
£72

Educators matching "Rya"

Show all 2