7035 Courses

Laser Hair Removal and Skin Rejuvenation

Facilitated by Registered Clinicians with extensive experience

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

We will come to your school at a time that suits you and run a 2-hour workshop for all staff. We will present in clear and simple terms the school’s duties under the Equality Act, help you guard against discrimination, and leave you with useful resources. How will this workshop help your school? This is a practical, "hands on" workshop designed to be engaging and constructive. Over and above helping your school fulfil its legal duties, it will help ensure that nobody is left behind or discriminated against. The workshop will show how all protected characteristics covered by the Equality Act 2010 can be reflected positively in everyday school life. It will consider real-life examples and make this more meaningful and relevant by inviting participants to bring their own examples of equality challenges in school. We will show you how to get the best out of CSIE’s toolkit ‘Equality: Making It Happen’ – a succinct and user-friendly set of reference cards to help schools promote equality – and leave you with at least two complimentary copies. Above all, the workshop will help develop a shared understanding and build a consistent response to diversity and equality. We understand that all schools are at different stages of this journey, so this workshop will assist you in determining next steps and areas of specific focus for your setting. What will the workshop cover? The workshop will: provide an overview of the Equality Act 2010, including the Public Sector Equality Duty and what it means for all schools bring awareness to unconscious bias and how it can influence our interactions present strategies for removing barriers to learning and participation address intersectionality and how it affects people’s experiences help develop confidence and language for discussing sensitive equality issues add flesh to the bones of all the above, by considering real-life examples Who is it for? The workshop has been designed for all primary and secondary school staff and governors; delivery is adjusted to the context of each school. We encourage all teaching and non-teaching staff to attend, so that your school can develop a coherent and consistent response to diversity and equality. Feedback from previous CSIE equality workshops: Very knowledgeable presenter. I feel more empowered. Clear and concise. Very thought provoking. Clear, compassionate presentation.

Empower your parkinson's disease care with comprehensive training from experienced healthcare professionals

Private Pilot’s Licence (PPL (H)) Imagine walking into an airport, hiring a helicopter and flying yourself and your friends to an hotel. You land in their grounds and walk into the restaurant. After a lovely meal you take off and fly home. You can turn this fantasy into reality with a Private Pilot's licence (PPL (H)). Getting a PPL for helicopter flying is a tremendous experience from your first flying lesson to getting your license at the end. The course is a combination of flying in the helicopter and learning about the theory of why helicopters fly and how to fly safely. There are nine practical subjects you need to study, each with a multiple choice exam that you have to pass to qualify. These subjects are Air law, Operational procedures, Meteorology, Human performance and limitations, Communications, Aircraft (general) and principles of flight, Navigation, Flight performance and planning. In addition you will need to pass a practical test on the correct phraseology to use when talking to Air Traffic Control (ATC) as you fly across the country. This is known as 'radiotelephony' and we have our own in-house instructor and examiner. Overall, the course is challenging and stimulating. You can study at home and make use of Heliflight’s ground school where we will teach you all you need to know and help you if you have any difficulties with particular aspects. To take your exams you will first need to set up a CAA customer portal. You will also need this for your medical,  The flying part of the course is exhilarating. Divided into 30 different exercises you will spend at least 45 hours in the air to gain your license. These excercises provide you with the skills you need to fly safely, anywhere in the world (subject to meeting any local licencing requirements). You’ll get a feel for how the helicopter handles when flying straight and level, turning, climbing and descending. And, as your training progresses, you’ll learn how to hover. It takes time. Co-ordinating all the controls to fly above the ground in one position is tricky to begin with, but, when you mastered it, you’ll just want to do it again and again. Once you are proficient in the hover you’ll also be taught to land and take off. Pretty soon you’ll be ready for a solo flight. This is one of those great experiences in life and every pilot remembers theirs. The day you pilot a helicopter with no-one else in the cockpit, perhaps flying a circuit around the airfield, be prepared to feel fantastic for a very long time: it’s that tremendous. You’ll spend at least ten hours of your course flying solo, often away from the airfield and eventually landing at others as you practice navigation. Towards the end of the course there is also a practical test on navigating cross-country. Finally you take a flight test, a day where you demonstrate all you’ve learnt to a friendly flight examiner. Heliflight has its own resident examiners. On successful completion of your flight test you apply for your licence and soon you’ll be a bone fide Helicopter pilot. You need to be 16 years old to fly solo and have to be 17 to apply for a license. You must also be reasonably healthy as you will need to pass a medical examination with a doctor recognised by the Civil Aviation Authority. There is a specialist Aviation Medical Centre at the airfield. If you would like further information about the PPL (H) course and the other training available from Heliflight We’ll be happy to help. Alternatively please call us.

Egg tempera has been practiced by artists for over two thousand years. It is one of the most durable and beautiful paints in the history of art. Students will discover how master practitioners of this art form prepared their pigments from the earth, rocks and plants and mixed with egg yolk to make their tempera paint.

NEW Learn how to make a festive-themed wreath using mosaic on this one-day, beginner-friendly workshop with Edinburgh mosaic maker Jacky Cox of Mossy Mosaic. Make a wreath that won't wilt! Jacky will show you how to safely cut iridescent (shiny) glass and vitreous (swimming pool) tiles. The session will start with guided tuition to get you started. Once you have completed the first section you will be free to work on your own design, using colours and glass nuggets of your choosing. You will learn how to grout your creation, and be provided with a D-ring for hanging your finished wreath at home. This workshop is suitable for beginners, but also perfect for those who have already attended Jacky's introductory workshop and would now like to try to gain more experience by working with glass. All the materials to make your gorgeous wreath are provided. Earth conscious credentials We are mindful of the effect we have on the environment, and do our best to minimise our impact. You will take the lovely products you have created home with you on the day, and workshop correspondence and notes are sent to you electronically. Favourite feedback We love to hear what you think about our workshops. When we have a favourite review for this new workshop we will add it here. More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

Join us for a 2-day Mental Health First Aid (MHFAider®) course at The Ashcombe School in Dorking! Learn how to provide crucial support during a mental health crisis while gaining the skills to spot early signs of mental health issues. This in-person course creates a safe, supportive environment, with self-care prioritised throughout. Subsidised price: £10. Let's make mental health a normal part of everyday life!

This one-day or Two Session workshop will focus on a key but often ignored communication skill: Focused Listening.