1197 Courses

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

5-day practical leather bag pattern cutting and design course with leather crafting skillsLearn leather bag design and creation processes with an introduction to leather crafting. Design bags in 3DSee 1-day Pattern Cutting (The Basics) course, here. Join us in our Oxfordshire Workshop (UK) for a week of learning and making. Learn directly from Leathersmith and London College of Fashion Lecturer, Georgie Tym as she guides you through designing your own patterns from scratch to create a whole catalogue of 3D shapes for bags and accessories along with a basic introduction to leather crafting skills. Who is this course for? This 5-day practical bag pattern cutting and introduction to leather craft course is ideal for all experience levels, from beginners to confident makers. A perfect introduction into the pattern cutting skills and leather skills you’ll need to create and design your own bag patterns and leather designs. Are you looking to: Start your own bag brand? Design your own bags? Understand the bag making process? Create bags at home to complete your own handmade wardrobe? Satisfy a general interest into the skills and techniques required to make your own bags? Develop a foundation in leather crafting skillsIf you've answered yes to any of the above, then this is the course for you. What to expect Join Georgie to learn the basics of pattern cutting for bags with an introduction to leather craft. The course includes a foundation knowledge through to more complex cutting techniques. Looking at 3D shapes and examples from which you can create multiple shapes and details. Learn all the essential skills you will need to begin your leather crafting journey. This is the course for you if you’re ready to turn those bags you’ve been dreaming up and designing into 3-Dimensional tangible reality. Within the course, you’ll also be introduced to techniques and materials suitable for accessories, including sewing on an industrial sewing machine and stitching leather by hand. Upon completing the pattern cutting and introduction to leather course you will take away the knowledge to bring your designs to life. Complete with a set of paper/ fabric mock-ups which can be kept as your reference sample set and leather craft samples you will have your very own library of resources to inspire and generate future ideas. The course covers: Pattern types and shapes suitable for each construction type Patterns for details and functionality features Professional methods and best practice Basic pattern cutting techniques Pattern design/ development and sequences Hands on involvement and demonstrations. Hand stitching leather and other materials Machine stitching leather and other materials Leather tools and machinery Seam types used in bag and leather constructions Leather and other materials discussions You will receive a certificate upon completion of the course.  What's included in the price? There are no additional costs. Basic materials will be included.The course runs from 10am – 3.30pm Monday - Friday. There will be a tea/ coffee breaks throughout and an hour break at lunch. Please note lunch is not provided.The course will be run from the HOME STUDIO of Hands Of Tym in Banbury, Oxfordshire, OX16 9DHParking available on the drive or on the street with easy access via the M40. Banbury train station is a steep 30 min walk. Trains run from both London Marylebone and Birmingham to Banbury in 50mins. Also well connected to Reading, Oxford, Leamington Spa to name a few.Maximum class size is 5 Cancellation policy Easy - Cancellation and a full refund can be obtained up to 2 weeks before the course starts About Georgie at Hands of Tym During training at Cordwainers, London College of Fashion in 2010 I learnt how to design, make and manufacture bags professionally. Following a varied career in Accessories design and development across many roles and international brands I set up Hands of Tym in 2016. The courses I offer are suitable for all, from experienced to total novice. Come along to learn something new, and design and make your own leather bag in a day.

QA Level 2 Award In Basic Life Support And Management Of Anaphylaxis (RQF) Half day course Gives learners the knowledge and skills to save someone who is in anaphylactic shock Also covers how to prevent this happening in the first place Also available as a bolt-on to certain other courses Course Contents: Incident and Casualty Management Managing an Unresponsive Casualty Recovery Position The Chain of Survival CPR Signs and Symptoms of Anaphylaxis Treatment of Anaphylaxis Medication Use of Adrenaline Auto-Injectors Benefits of this course: Anaphylaxis is a severe and life-threatening allergic reaction, which requires immediate medical attention Did you know that in 2014 there were over 4,000 hospital admissions for anaphylactic shock in England? Every year, the number of those suffering from anaphylaxis is increasing. This makes it very important for people to know what to do when encountering someone who is having an anaphylactic shock This QA Level 2 Award in Basic Life Support and Management of Anaphylaxis (RQF) course has been designed for those who have a specific responsibility at work, at home or as a volunteer, to provide basic life support and manage anaphylaxis when dealing with an emergency Successful applicants will be able to recognise the signs and symptoms of anaphylaxis and will be equipped with the vital skills needed to administer safe, prompt and effective treatment. This includes practising with adrenaline auto-injectors. Accredited, Ofqual regulated qualification: Our Basic Life Support and Management of Anaphylaxis training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Basic Life Support and Management of Anaphylaxis Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in Management of Anaphylaxis..The Ofqual Register number for this course is 603/2548/3

WHY TAKE THE DOMESTIC ELECTRICAL & EV CHARGING PACKAGE? Current demand for electric car charging points is increasing every year. This is being driven by changes to government policy which intend to eliminate all petrol and diesel cars by 2040. This means that in the run up to this change, domestic meter installs are predicted to rise drastically. This 25 Day Domestic EV Charging point installation course package is designed specifically for those who are new to the industry and teaches you both domestic electrics and EV car charging point installation. Demand for EV car charging point installers is rising and we are regularly approached by employers looking for trained installers.  Course Snapshot: This course covers advanced domestic installation (Step 1) plus a C&G Qualification in EV Charging Point installation. The Course breaks down as follows: 14 Days Practical In Centre 4 Days E-Learning 4 Days Virtual Classroom

COURSES EVERY WEEK THROUGHOUT EVERY YEAR COURSE OVERVIEW. DURATION: 4 DAY (09:00 - 18:00) COST: £1500 PER PERSON LOCATION: HAMPSHIRE THIS 4 DAY HEFAT COURSE IS WITHOUT DOUBT THE HIGHEST LEVEL OF HOSTILE ENVIRONMENT TRAINING AVAILABLE Hostile Environment First Aid Training (HEFAT) has been designed for those operating or working in hostile or elevated risk environments who require an advanced level of medical training. The skills taught on the HEAT course are taken to the next level by training delegates how to deal with more complex levels of medical conditions and trauma first aid training coupled with practical training in the use of advanced medical equipment and techniques. In line with all of our benchmark courses HEFAT ensures that travellers from all backgrounds are prepared for the widest possible threat levels across the widest field of environments and situations. Delegates leave aware of potential risks and confident that they have the skills and knowledge to deal with immediate and developing situations. No previous training or qualifications are required to attend this course. Unsure if this is the right course for you? Get in touch with our team to help you choose the best course for your needs. COURSE ELEMENTS. THREAT RISK ASSESSMENT AND MITIGATION ADVANCED TRAUMA AND FIRST AID TRAINING KIDNAP AND HOSTAGE VEHICLE SAFETY AND SECURITY POST TRAUMATIC AND ENVIRONMENTAL STRESS LANDMINE AND IED’S NAVIGATION TECHNIQUES WEAPON FAMILIARISATION CONFLICT MANAGEMENT RADIO AND VOICE COMMUNICATION

QA Level 2 Award In Principles Of Risk Assessment (RQF) Face to Face: One-day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong... Risk Assessments are vital for Health and Safety, and vital for the whole process Course Contents: Main causes of Work-related Fatalities, Injuries and ill health Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence The Role of Risk Assessments in Accident and ill Health Prevention Legal Requirements for Risk Assessments Importance of Personal hygiene Basic Process for Undertaking a Risk Assessment The Five Steps of a Risk Assessment Benefits of this course: In 2020/21, a whopping 1.7 million people suffered from a work-related illness 441,000 of those sustained an injury 142 People, plus 60 members of the public, lost their lives... The estimated cost of injuries and ill health was £15 billion 28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments Accredited, Ofqual regulated qualification: QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9

MASTERCLASS ONE-2-ONE 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! PDO Threads course Our one-day Harley Elite Academy PDO cog thread lift ( Elite Mini Face Lift )training course is providing for Doctors ,Nurses , Dentist looking to further to present non-surgical facelift. It s the newest trend made popular by some of celebrities recently and it is an amazing and effective latest technique to mehanical lift and tighten skin. We provide second option using mono and screw it has the potential to redefine facial contours and induces collagen production. This type threads support structure for the tissue of the face by encouraging natural collagen synthesis with 30 % immediately results that peak at 6 months and more. During the training learn how to safely achieve mid and lower face lift and tight , we aim to help you master class techniquesre-volumisation and lifting using one of the highest quality products on the market PCL Threads.   Thread Lift Masterclass Course You will perform this procedure on live models under the supervision You will practice using This master training will teach you how to introduce threads in Body areas including: Inner Thigh | Inner Arm | Knee | Tummy | Buttock Using threads: screw, mono and cogs. During Dermal Filler Masterclass, you will learn the full Anatomy of the face and gain practice.Anatomy, Vascular Supply of the face, Nerves Contraindications Complications Management Post treatment advice Additional information ATTENDANCE ONLINE (theory), IN-CLINIC (Practice) PDO THREADS LIFT AREA BEGINNER Face and Neck Threads Lift, ADVANCED Body Threads Lift, MASTERCLASS Face, Neck, Body Threads Lift, MASTERCLASS Foxy Eyes | Cat Eyes

Station House Cookery School has teamed up with the multi award winning Crafty Distillery who produce Hills and Harbour Gin.

Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. Course Overview Develop true expertise and learn every aspect of Social Media Marketing across 10 modules of interactive content such as Facebook, LinkedIn, Snapchat, YouTube and Instagram. Gain relevant and deep knowledge of social strategy, research and content from industry skills experts. Become a certified social media marketing specialist: Join over 200,000 members around the world, working for some of the world’s top companies using DMI to keep their careers and skills relevant. 81% of our members have been promoted upon completion of one of our courses and 53% have got a salary increase. Get certified with the DMI SPECIALIST digital marketing certification and become a professional digital marketer. Get world class, specialist knowledge and insight: Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. With 10 modules focused on every aspect of social media marketing, DMI Specialist is the most comprehensive Social Media Course available anywhere. Program learning outcomes and content: What Will I Learn? Get the know-how, experience and the insights to be able to work and speak with authority in this face-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. We’ve added 8 new soft skill lessons to give you the most industry ready certification available, anywhere. Who is this for? The DMI Specialist Social is for individuals who are responsible for social media marketing campaigns. This includes: • Digital marketing generalists • Marketing Specialists • Marketing Managers • Content creators • Social media consultants • Individuals pursuing profession in social media marketing. • Anyone who wants a career change Course Content: Social Research: Just who are your audience? What do they do, think, feel, eat, love, hate and ‘like’? And what do they think about you? Knowledge is power. And both knowledge and power are fascinating. This module gives you the research techniques to know your audience, and cultural and industry trends. Every day the very people you want to reach throw up gigantic amounts of data. Without the right tools and thinking, it’s a critical mass of meaningless banality. With the right tools and thinking, you have insight deep into hearts and souls. Delve into these tools and put them to use, including the new Google Analytics 4 platform. Social Content: Facebook kittens. Twitter debates. Instagram filters. People can’t get enough content on social media – so better content means better opportunities. So, what does your audience want to see, like and share? With streamlined planning, clever strategy and targeted scheduling, putting the right content in front of the right people is no longer a shot in the dark! Now, you can create amazing content formats that capture the attention of audiences across all social platforms. You can strategize and plan using cutting-edge tools that make your channels stand out from all the others. This module covers the various content formats across platforms, the power and practice of scheduling content and how you can bring it all together with super strategies. Facebook, Instagram and Pinterest: Facebook, Instagram and Pinterest are powerhouses of the social media world. They provide you and your brand with the chance to interact with your customers across the globe at scale. But, each of them has unique features, analytics, and quirks. The module gives you a deep understanding of how these platforms work, how to make your brand stand out in these different spaces, and why you need a spread of messaging across each to succeed. • Build an active, engaged and captive community across each channel. • Create compelling and clever ads that target your audience at the right time. • Use analytics to understand what your audience is doing. Then tweak your content to resonate in all the right ways. • Master the key features of each channel to advertise, strategize and optimize. • Manage each platform so you get the best reach and results. • Reach billions of social loving people every day! Twitter: Twitter marches to its own drum in the social media world – less post and wait, more what’s happening right now. It’s a platform that allows your audience to see, report and comment on world events in almost real-time. It’s also a place where the audience is young, wealthy and educated. Twitter literally challenges you to be ‘more clever’, and this module shows you how. • What a successful Twitter account looks and acts like. • How to use Twitter Ads Manager to advertise effectively. • The right Twitter Ad format for your campaign. • Using Twitter Analytics to react and connect better. • How to create more Tweet-friendly content – snappy, shareable and short. • When to post for maximum impact and engagement. LinkedIn: This module will introduce you to the platform and show you how to use features such as Company pages and Showcase pages, to create a stellar presence for your company – and gain a deep understanding of what that means on LinkedIn. You will understand the unique advertising features and content formats on offer such as Text ads, Sponsored ads, Sponsored InMails, Display ads, and the aptly named Dynamic ads. See what best practice means on this platform, strategize like a CEO and measure the effectiveness of your campaigns. Linkedin can be a tricky platform to master as the tone is hard to crack. But do Linkedin well and your competitors will be scrambling to copy you! You’ve got this – because we do. YouTube & Social Video: YouTube because you have eyes to see. And a picture speaks a thousand words – and this being social, should inspire a few thousand too. Social video is one of the most awesome tools in your new bag of digital tricks. And video is no longer the preserve of guys with film study degrees. This superpower is now yours, and here we give you all the tech and thought basics to make it happen, including how to set up and manage a YouTube channel and create strategies that don’t treat creativity like a buzzword. Learn how video sits within the rest of your mix across platforms, build your online audience and use advertising and analytics for visual campaigns that mesmerise. • Set up and manage a dynamic YouTube channel. • Get creative with social video strategies that engage and convert. • Learn how video sits within the rest of your social media mix. • Build and develop your online audience in a way that benefits your brand. • Use advertising and analytics to deliver mesmerizing visual. Social Apps: If you’re looking to create a buzz online, then social apps are the place to be. Think fun, engaging, and ‘out of the box’ as that’s what these platforms are made for and audiences flock to them (particularly a young demographic). Discover how to use TikTok, Snapchat, WeChat, WhatsApp, and Twitch to tune into your audience effectively. Take a dive into features and understand how to manage content to make the most of everything you post. You’ll also understand how to advertise on the apps that suit your brand. Plus, take inspiration from the best by seeing what campaigns worked and why, so you can TikTok your way to social success. Social Commerce and Affiliate Marketing: With so many eyes on social media, it pays (literally) to know how to market and sell your products online. Social commerce happens when an astute marketer combines the best of social media with the best of e-commerce. You’ll explore the ins and outs of social commerce along with how to create a successful online shop. The latest tactics and tools will be covered so you can make social buying seamless from the first click to the last. You’ll also explore how to optimize paid commerce activity – including cart abandonment – to get the best results. Looking for a way to earn extra money while you grow? Use your social media to tap into affiliate marketing – a great way to earn commission by promoting another company’s products or brand you admire. When it comes to influencing, social media allows you to think BIG. Tap into the world of social influencers by connecting and collaborating with people that think like you. Or reach out to your influencer crush and shine a light on your brand by getting into their social feed. Social Customer Service: One of the best dynamics of social media is how it manages to be collective – the thoughts of billions – yet also personal (it’s about what I ‘like’). This leaves scope for important personal interaction – meaning social customer service is an opportunity for your brand to stand out. This module examines the customer experience. It looks at how to break your audience down into buyer personas so you know them better – and so serve them better. It shows you which platforms do service best and how. Need a social customer service strategy? – no problem. Want to understand how to manage social customer service effectively? – that’s easy. Not sure how to measure and analyze customer service performance? – well, you will now! This module focuses on your customer’s happiness so you can build a contented online community. An audience that feels connected to your brand, so they’ll tell everyone else how great it really is. Social Strategy: So, you have the skills, tools, followers, know-how, tech, smarts and big ideas. Now learn to tie it all together with cutting-edge social strategies practiced by the world’s leading brands. And work out how your social offering sits with – or carries – the rest of your marketing mix. Here we look at planning a dynamic social media strategy that works for you. We dive into setting objectives and social KPIs so you know what you want and can track how you’re getting there. Social media and content production budgets are also explored so you put your money in the places that work, rather than those that don’t. Turn your social media dream into a reality by crafting a social strategy that lets you and your brand sparkle. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

This course is designed to provide you with the required skills to either become employed in a dog grooming environment or set up your own grooming business.  At an appropriate time during your training, you will be given the option to pursue a nationally accredited qualification in addition to those detailed above. You may, of course, choose to complete the training only and not gain a qualification other than the ones included. The course will cover: The preparation, styling and finishing of dogs Preparation for practical assessments Theory study support Students will receive all course materials and it is recommended that students bring along a camera for before and after photographs as well as pens, high-lighters and notepads. COURSE LENGTH: 20 Days consisting of our Salon Assistant Course (below) plus an additional 12 days of clipping and styling training