557 Running courses

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.

Are you an ambitious, entrepreneurial business owner with a collaborative mindset? You are? Good! You're in the right place. Running your own business can be tough and the odds are against you - but don't worry! The support you need is on your doorstep - at next to no cost!

Learn to create cushions for your home, we will cover a basic cushion and also piping, ruffles and zip insertion.

Dive deep into well integrity management with EnergyEdge's classroom training. Take your skills to the next level today!

If you’re a beginner bag maker, this Retreat is perfect for you. A whole weekend to immerse yourself in fabrics, stabiliser, professional techniques and tips to boost your confidence and your skills. Hopefully, there’ll be a lot of chat and laughter too! **This retreat is a little different from many others in that making a bag isn’t the point of the weekend, although you will indeed make one. The focus is on learning new transferable techniques and skills that you will be able to use on so many bags you make in the future. We have our own ‘Retreat Suite’ of rooms, including a spacious, light and airy sewing room which is equipped with a display screen so everyone can easily see demonstrations from a working viewpoint. We also have our own bathroom and kitchen facilities. If you wish, you are free to continue work after dinner and until as late (or early!) as you like. You will need to bring your own sewing machine, fabric scissors and any other favourite sewing tools, but everything else is provided. Come and join us in the exclusive Facebook group Bag Makers Retreat at https://www.facebook.com/groups/bagmakersretreat/ for all the latest retreat info, chat, gossip and more, plus a chance to meet other like-minded folks.  If you have dietary requirements, please tell me before you book, so I can be sure we can meet your needs. All meal main courses are included in the retreat fee, as are Saturday and Sunday lunches and breakfasts. Starters, desserts and drinks with meals are not included but the meals are so huge you probably won’t want starters and desserts anyway!! Tea and coffee is available whenever you need, but you do have to make it yourself!  If you’d like to stay an extra night or two, maybe to arrive on Thursday or leave on Monday if you have a long drive, let me know and I’ll check availability with our host. If you’d prefer to travel by train, we are happy to ferry you to and from the station, just ask. Please aim to arrive no later than 2pm as we have a lot of pattern cutting and fabric choosing to get through on Friday! Friday The fun starts here as you arrive at your weekend home-from-home – a beautifully refurbished, 4-star 18th century coaching inn with all the comforts you would expect. You’ll have time to settle into your own delightfully comfortable en-suite room which has all the anticipated little luxuries, before an introductory get-together with me and your companions in the sewing room at 2pm. You’ll be given your own copy of the bag pattern, which is very beginner- and domestic machine-friendly but which will incorporate a lot of features and techniques that are also in much more complex designs, making this an excellent springboard to any bag you want to make. Then you can wallow in the plentiful stash of fabrics to choose from, including some of my exclusive feature panel prints which aren’t available anywhere else. All the materials, interfacing, stabiliser, threads and bag hardware you need are supplied. As soon as you’re ready, you can start preparing and cutting out your pattern and some of the bag pieces so we can hit the ground running in the morning. After a superbly-cooked and substantial evening meal at around 6pm or so, you are welcome to continue working in the sewing room or to simply relax and chat there before bed. Saturday After an excellent breakfast, we can really start work adding to and adapting your bag pattern. You’ll work at your own pace from around 9am with no pressure – I want your weekend to be fun and not stressful! We will walk through the techniques together and I will be there the whole time to answer questions and troubleshoot any tricky bits. You’ll also have the chance to try sewing with faux leather , if you haven’t already, and we’ll explore ways and techniques to use and apply rivets.  Refreshments are freely available all day and you can take a break whenever you wish. A light lunch (with homemade cake!!) is also provided and we’ll have a short break in the middle of the day. The rest of the day will be similar to Friday – sewing, dinner at 6ish and more sewing if you wish to before bed. Do feel free to have a walk or just sit outside for a breather if the weather is kind. Sunday How can it be Sunday already?? Breakfast over, we’ll get back to work. You will need to allow a few minutes to pack and check out of your room, as it has to be made ready for Monday’s guests. Apart from that, it’s uninterrupted sewing (with refreshments and lunch breaks!) until your bag is finished. We’ll be heading off for lunch at 12.30pm or so. We have the sewing room for the rest of the day. If you don’t quite get done, there’s absolutely no need to worry as you’ll easily be able to complete your bag at home. If you finish earlier feel free to head home whenever you’re ready. Amongst loads of other hints and tips, you’ll learn – Interfacings – what to use and not to use Using stabilisers – which is best and why How to create a zipped pocket the pro way Adding a recessed zipper main closure to almost any bag Installing hardware Incorporating a built-in key fob Installing a rectangular base Sewing the bag together and topstitching A sneaky way of getting your bag right-sides-out without ugly seams! An easy way to add a zipper pull without tools Working with different types of rivet machine Faux leather on a domestic machine You’ll have handouts on all the techniques to take home. And I hope you have a lot of fun and make new friends while you learn!!  I never abandon my students at the end of the course so if you get stuck on anything at home, you are welcome to give me a shout on Messenger and we’ll sort out your problem together. The not-so-small print Book your place using the simple booking system below – just click on your choice of dates and go from there. The full price is £395.00. The deposit of £60 is non-refundable if you cancel but can, however, be credited towards a future retreat booked within the next 6 months. It is completely refundable if I or the venue cancel. The booking page only shows the Friday, but the course is running until Sunday. The balance of £335.00 is payable by approx 6 weeks before the retreat date and payment instructions will be sent to you in good time. Cancellations 4 weeks or less before the retreat date can only be refunded if someone on the waiting list can come instead. *Don’t worry that your booking confirmation may be headed Unicorn Studios – it’s just the site that I’ve run my booking system from for years… it’s not a scam!! *

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Offer your customers a new, in-demand service with leather repair Leather repair is one of the most highly sought-after additional services detailing customers request. With over 53% of new cars delivered with leather or faux leather interiors, each one will likely require a repair at some point in its life, and with an average charge for a minor scuff of £120 and taking as little as 25 minutes to complete, through to full interior re-colouring costing upwards of £1000, it's become a must-have skill in a detailers arsenal for customer convenience, instant up-sell of services, and a standalone service instead of far more expensive re-trimming options. The course is a three-day, one-to-one training and skills session, which will take you through all steps of leather repair, from cleaning and assessment, through to fixing common scuffs, rips and tears. In-house colour matching and blending are taught, along with repair and recolour of steering wheels, and plastic recolouring. This course will give you the skills and confidence to complete leather repairs on all types of vehicles, with ongoing technical support for as long as you need it. Once complete your business can then become part of the Colourlock Accredited leather repair network. This includes; Colourlock branding and accredited-level discount on tools, consumables and materials. Optionally available is the Colourlock LRT master kit, to give you the tools and materials to complete repairs, the colour system to custom blend paints and various practice kits. When purchased with booking this has a saving of over £450 off RRP. Colourlock is one of the world's largest leather care and repair manufacturers, supplying OEM end leather solutions from the factory to the end user, along with repair solutions for professionals. Renowned the world over for their quality and the expertise of their training programme their knowledge and support are unrivalled and Colourlock currently has a presence on every continent. UK Detailing Academy is proud to be the exclusive training provider for Colourlock's Accredited Leather Technician course in the UK for both leather repair and the Top Life 2-year leather protection coating. The course is a three-day, one-to-one training and skills session, which will take you through all steps of leather repair, from cleaning and assessment, through to fixing common scuffs, rips and tears. In-house colour matching and blending are taught, along with repair and recolour of steering wheels, and plastic recolouring. This course will give you the skills and confidence to complete leather repairs on all types of vehicles, with ongoing technical support for as long as you need it. Once complete your business can then become part of the Colourlock Accredited leather repair network. This includes; Colourlock branding and accredited-level discount on tools, consumables and materials. Split over three days, with the first looking at leather in theory and cleaning and maintenance, the second on repairs and graining, and the third day spent with us practising colour matching, looking at more unusual repairs, and being able to spend the extra time on the practical repair side - until you can complete it with little to no input from the instructor. This level of instruction will lend you the confidence to immediately start minor repairs - though we recommend a period of practice to enhance your confidence with aspects such as colour matching and repair work. Optionally available is the Colourlock LRT master kit, to give you the tools and materials to complete repairs straight away and the colour system to custom blend paints for immediate resources. When purchased with booking, this benefits you a saving of over £450 off RRP.   LRT Master Kit The Colourlock Leather Technician Master kit is available to attendees on the Colourlock Accredited LRT 1-2-1 and group courses. Containing the tools equipment and consumables used and introduced on the course, it to allows you to hit the ground running and integrate leather repair into your business model. Included in the kit are a set of tools, cleaning and care products, a full 250ml set of pigment colours and top coats, graining and patching consumables, mixing tools, filters and various other niche items you won't know you need until you need them! RRP of over £2000 - on offer for pre-ordered kits for £1624 when ordered at the same time as the course only. Course Length 3 Days (0930 - 1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

Our 201 Enthusiast day was created for the hyper-enthusiast who wants to correct and enhance their own vehicle, rather than just care for it. If you've attended our 101 Enthusiast, you're all covered skills-wise for the prior knowledge element, but for all others to benefit from this event you will need a solid knowledge of preparation work and wash procedure, as this is mostly focussed on what comes after - namely paint correction. Refreshments are included on this intensive one-day group course, and there is time allotted at the end of the session to inspect your own vehicles if you need advice on particular issues.   Availability If no dates are showing as available in the calendar, you can sign up for updates to find out when new dates are released and new course developments. Our 201 Enthusiast day was created for the hyper-enthusiast who wants to correct and enhance their own vehicle, rather than just care for it. If you've attended our 101 Enthusiast, you're all covered skills wise for the prior knowledge element, but for all others to benefit from this event you will need a solid knowledge of preparation work and wash procedure, as this is mostly focussed on what comes after - namely paint correction. During the day we will be covering: Compound types and chemistry. Paint types and how to approach them. Pre-work decon wash, including clay and clay pads, decon pros/cons. Masking and surface protection tips. Lighting and inspection technique. Machine work, including Dual Action and Forced Rotation polishers, to correct and enhance the paint surface. Deeper defect removal, scratch hand sanding. Coatings, including ceramic and polymer, and their application. The day concludes with a Q&A session with a walk around your vehicles to advise on any issues. This is quite an intense day as we are trying to fit so much in, so we will be running from 9.30am until 16:00, with a break for lunch. You will have hands-on experience all day and will be working your way through all steps of a full correction, it will then be up to you to build on the knowledge you have gained by practising on your own vehicle, with ongoing support if needed. The course is run from our fully equipped studio in the heart of Gloucestershire, with easy access to the M4/M5, and under an hour and a half to the M25. Course Length 1 Day (0930-1600) Group Size Up to 6 people Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Refreshments or Lunch Lunch Included, Refreshments included

Kids Green Woodworking Workshops

Enhance your asset management skills with EnergyEdge's classroom training on the principles of asset management. Gain valuable insights and advance your career.