Rya courses

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.

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.

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.

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

RYA Day Skipper shore-based online distance learning course

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: Tuesday 26th August 2025

LOOKING FOR: ADULT FICTION, NON-FICTION Hannah joined Watson, Little in 2024 after four years as an agent at Northbank Talent Management and a year at Penguin Random House UK. She’s building a varied list of commercial and upmarket fiction and non-fiction, and authors she’s represented have been listed for prizes including the Women’s Prize, the British Book Awards, the Jhalak Prize, the Comedy Women in Print Prize and the Bollinger Everyman Wodehouse Prize for Comic Fiction. She’s always looking for excellent writing which marries a strong voice with a catchy concept and a compelling plot, but more specifically, in fiction, she loves to represent: Crime and thriller novels with a confident voice, a clear hook and a fresh approach – especially if it says something about the world we live in today. She recently enjoyed the structure of Wrong Place, Wrong Time by Gillian McAllister, the fun voice and family dynamics of My Sister, The Serial Killer by Oyinkan Braithwaite and the holiday setting of Murder on Lake Garda by Tom Hindle. Love stories, whether that’s a smart romcom like Book Lovers by Emily Henry or Romantic Comedy by Curtis Sittenfeld, an intimate coming-of-age love story like Open Water by Caleb Azumah Nelson or a big, weepy epic. General contemporary fiction about complicated people, families and lives, often when there’s a mystery at its heart. Some of her recent favourites include Really Good, Actually by Monica Heisey, I’m Sorry You Feel That Way by Rebecca Wait, and All My Mothers by Joanna Cannon. She also takes on a small amount of historical fiction, generally set in the 19th and 20th centuries – so she’s not the best fit for books set much further back in time or myth retellings. She’s also looking for non-fiction with a strong voice and new insight into an experience or place, and am particularly interested in self-help, lifestyle and wellbeing, science, psychology, nature writing, memoir, and new ways into genres such as true crime, history or the environment. Over the years, she has loved The Glass Castle by Jeannette Walls, The Five by Hallie Rubenhold and Manifest by Roxie Nafousi. She’s not the right agent for sci-fi, fantasy or action thrillers, and is currently not accepting children’s and YA novels, scripts or poetry. Hannah would like you to submit your fiction as a covering letter, 1-2 page synopsis and the first 5,000 words of your manuscript in a single word document.  For non-fiction, she would like to see: 1-page synopsis – to give an overview of what the book will offer the reader and how it's different from other books out there on this topic A detailed proposed contents list, including proposed sub-section headings as well as chapter headings – to give a sense of the overall reader journey (this is not included in the word count) (In addition to the paid sessions, Hannah is kindly offering one free session for low income/underrepresented 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 25th September 2025

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: Wednesday 22nd October 2025 by 12 noon UK BST

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