877 Courses

All my workshops are available as private bookings for family days. Whittling, Firecraft, Bark Crafts & Bushcraft Activities can all be arranged on a date and time that suit you. Activities can be modified for children of all ages. Travel - All my workshops can be run at any location within the UK. If you have your own space, inside or out, I am able to travel to you to teach. The price above is a 'starting from' price, and will vary depending on participant numbers, location and what activities are arranged. Get in touch here to arrange a day you wont forget! 


Learning Centre Support Specialist, Learning Support Assistant,

It's a great tie time to join the aviation industry as airlines look forward to a post pandemic recruitment.

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 intensive week of skills practice, feedback and ongoing assessment is the final stage before becoming a fully-qualified human givens practitioner Dates: Mon 6th – Fri 10th Feb 2023Mon 26th – Fri 30th June 2023 Length: 5 days (9.00am – 5.30pm) Tutors: Dr Gareth Hughes, Jo Baker, Rosalind Townsend, Carol Harper Open to: Graduates of Part 2 of the Human Givens Diploma Qualification: Human Givens Practitioner Level Diploma (HG.Dip.P.) This week far exceeded my expectations – I can’t wait to get back and apply what I’ve learntJOHN BUCHANBERGER Part 3 is the Human Givens Practitioner Qualification; the pre-requisite to becoming a fully qualified human givens therapist, eligible for inclusion on the HGI’s Professional Register (which is independently accredited in the UK by the Professional Standards Authority for Health and Social Care). Throughout the week, students practise and demonstrate a broad range of practical therapeutic skills under close supervision and rigorous on-going assessment by the two tutors and experienced facilitators. Students who have already successfully graduated from the course enthuse about how useful and enriching it is. Between Part 2 and Part 3 of the Diploma students are expected to carry out extensive therapeutic practice, with a minimum of 10 different people, under ongoing supervision. For more information, please read the following downloads. Course Dates All Part 3 weeks are held at Engineers’ House in Bristol Winter 2023 – Code WK14 Mon 6th–Fri 10th February 2023 – FULL Summer 2023 – Code WK15 Mon 26th–Fri 30th June 2023 – Full, with waiting list Autumn 2023 – Code WK16 Mon 20th–Fri 24th November 2023 – Waiting list, please contact the office HOW TO APPLY: To attend Part 3, your supervisor must be happy that you have gained enough therapeutic experience and are ready to progress with this part of the Diploma. As there are only 12 places on each Part 3, we recommend you contact us as soon as possible to let us know which course you and your supervisor think you will be most likely to attend. Your name will then be added to the list for that course (for more information on this stage of the Diploma, see: Working towards Part 3). Please contact Fiona Heffernan if you have any questions about the course, or are ready to put your name down for a place on one. Meet your tutors Carol Harper Carol has 30 years’ experience in private practice, her holistic outlook and curiosity has influenced her professional development… Read more Dr Gareth Hughes Gareth is an HG psychotherapist, researcher, nationally recognised expert on university mental health and wellbeing and a Principal Fellow of the Higher Education Academy. Read more Jo Baker For many years Jo worked as a therapist within the Psychological Wellbeing department at the University of Derby, where she dealt with an extensive and varied caseload… Read more Rosalind Townsend Ros Townsend is an experienced psychotherapist and supervisor with busy practices in SW England, where she combines private therapy work with referrals from Occupational Health and the NHS. Read more

Enhance your SkillsBuilding on Level One and the skillset developed, you will be advancing onto more advanced machine polishing and cleaning techniques, to progress your detailing career and skillset further. Existing valeters and detailers confident in their skillset's reflection of Level One's content may also qualify to bypass to this level, should they be able to demonstrate their qualification by purchasing, taking, and passing with sufficient breadth, our online Level One assessment. Machines introduced at this level include forced rotation dual action polishers, every inception of Dual action polishers, both in throw and size. We'll also look at pad types, heavy cutting options and defect identification to assess what can be rectified and how. Interiors are explored in greater depth with higher yield services with 'dry' steam cleaning, odour removal, leather protection and treatment, and stain removal with the associated chemistry. Small area sanding and isolated correction are a key finish to this level and allow you to achieve fantastic results from otherwise irreparable damage Following your introduction skills learnt in Level One, you will be progressing onto more skilful machine polishing and cleaning techniques. Machines introduced at this level include forced rotation dual action polishers, every inception of Dual action polishers, both in throw and size. We'll also look at pad types, heavy cutting options and defect identification to assess what can be rectified and how. Interiors are explored in greater depth with higher yield services with dry steam cleaning, odour removal, leather protection and treatment, and stain removal with the associated chemistry. • Pad types • Compound grades • Rubber and plastic protection • Coatings after-care • Polymer and PTFE exterior LSPs • Glass sealants • Troubleshooting • Accreditations • Financial management • Insurance • Marketing • Pricing • Spot Sanding • Targeting your customer base • Safe working practice • Workshop planning • Intermediate chemical knowledge • Efficiency and time management • Matte finishes • Environmental considerations • Advanced cleaner chemistry • Bonded overspray and concrete • LSPs • Engine bay detailing • Plastic trim restoration • Odour removal • Steam cleaning • Stain removal & chemical principles • Fabric and leather protection • Paint types and their principles • Long and short throw DA machines • Forced action machines • Lighting • Defect identification Following the course, further case studies and exercises will allow the knowledge to develop further as you use it over a 3-6 month period, after which the Level 2 exam is sat to award certification. Course Length 2 Days (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Completion of Level 1 Refreshments or Lunch Refreshments included

The NVQ Level 3 is designed to provide both new entrants and those seeking progression in their career, with the opportunity to develop the necessary skills to carry out job roles and responsibilities associated with the installation and maintenance of Electrotechnical systems.

Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Course Category Person Centred Planning Team Building and Leadership Description How to facilitate Person Centred Planning? How is it different from any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? How does it differ from ‘chairing a meeting” What skills and processes enable the group to work together effectively and avoid going off at tangents or dissolving into an unfocussed ‘discussion’ Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Making inclusive action plans using full participation and graphic facilitation Drawing on the planning tools MAPS and PATH (Pearpoint, Forest and OBrien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. In this training we make this facilitation explicit and attempt to model, teach and enable practice of key skills and processes. Jack Pearpoint, Marsha Forest and John O’Brien developed these innovative PCP approaches in North America and they are being used successfully in many parts of the UK. The planning can focus on an individual, group or organisation and provides a powerful problem solving opportunity, which is flexible and robust enough for many occasions. Tell the story, find the dream, touch the nightmare, and explore who you are, what are the gifts and strengths of the person or group, what are the needs of those present and what is the action plan for the future? Testimonials Learning Objectives Participants understand group and graphic facilitation processes for Person Centred Planning Participants have skills and confidence to facilitate PATH/MAP processes Participants learn graphic as well as process facilitation skills. Strengthens practitioners inclusive practice Provides additional tools for those involved in inclusive work in schools and the wider community Further develop problem solving and planning skills Who Is It For ? Person Centred Planning Facilitators Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Voluntary Organisations Course Content The course answers the questions: Need to find new ways to facilitate Planning? How to facilitate Person Centred Planning? How is it different to any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? What are the skills and processes that will make the group work really well and a wonderful graphic to be created? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LA? Inclusive Solutions offer an introductory day to facilitating person centred planning or a 3 – 10 session course which is practical as well as values based. Participants will receive direct individualised coaching and training. We will cover: Group and Graphic Facilitation processes Use of music and dramatic participation methodology The person being at the centre Family members and friends being full partners Planning reflecting the person’s capacities, what is important to the person and specifying the support they require to make a full contribution to their community Planning building a shared commitment to action that will uphold the person’s rights Planning leading to continual listening, learning and action and helping the person get what they want out of life. Essential Lifestyle Planning, PATH MAPS Personal Futures Planning

Upskillings qualification that has been developed to meet the mandatory SIA top up training requirement for Door Supervisors who undertook their training prior to June 2010.

This IMI qualification is designed for technicians who maintain, diagnose and repair high and low voltage operating systems on electric/hybrid vehicles. It contains the skills and knowledge required to work safely around a vehicles high and low voltage train system, whilst carrying out repairs or maintenance. This course will also cover working safely around a vehicle that may have has damage to its high energy/electrical system.