33622 OV courses

hypnotherapy to manage peri and post menopausal symptoms and promote emotional balance. We'll explore how hypnotherapy harnesses the mind-body connection to address challenges such as hot flashes and insomnia. Through practical techniques and empowering insights, participants will learn to navigate menopause with greater ease and vitality, fostering overall women's health and empowerment. Discover the transformative potential of hypnotherapy in embracing this stage of life with confidence and well-being.

Unveil Africa’s political future: Dive into colonial legacies, state-building challenges, democratization efforts, the African Union’s influence, and emerging great power rivalries. Discover sharp, insightful takes on contemporary African politics.

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

This 6 week course will support you to make the most of the range of applications Adobe Premiere Pro offers in the production of video. Sample footage will be provided for you throughout the course, but you can also bring along your own video files to work on. The course is quite technical so some computer experience is required. We use Macs on the course – the Premiere interface is the same across operating systems but some shortcuts and menu items are different. Week 1- The basics This week we’ll start with some of the basics, introducing you to editing and Premiere Pro through: A short history of editing; from analogue to digital Getting to know the layout of Premiere Pro Working with ‘bins’ (folders) and creating edit Sequences Making selects from the rushes and sound files by creating in and out points Introducing clips to the timeline and making a simple edit with music Understanding rendering for smooth, full quality playback Week 2- Editing narrative sequences This week we’ll get further stuck into editing by building narrative, focus on offline editing‚ better organisation of your projects and breaking down footage through: Re-linking lost or moved footage Video ingest – importing and organising clips Organising and breaking down rushes using annotated markers and sub-clips Basics of the effects and motion settings Using our skills to create a simple narrative sequence Editing a dialogue sequence Considering the best ways of exporting your film for online Learn Adobe Media Encoder for more efficient exporting Week 3- Video settings, effects & titles This week we will focus in on what makes up video from a technical standpoint. We will then look at how we can work with and alter these parameters for different uses in our films through: Transcoding – converting the footage into an editable file and understanding codecs and meta data Adjusting scale and positioning and using motion keyframes to create movement over time Adding titles and animating them Applying transitions and various stock video effects Layering tracks and using opacity and different layer blending effects Creating masks and using motion tracking Working with green-screen footage, creating mattes, mask filters and working with multiple layers Week 4- Audio & sound This week we’ll consider the importance of sound design and music for narrative and atmosphere in film and experimental video through: Learning how to enhance your film with sound and music Introducing audio and music to the timeline, cutting and leveling Laying down music and cutting the footage to fit Building sound design around an existing edit with sync-sound and SFX Common practice and different approaches for syncing external microphone audio and video Mastering the audio and making sure that it is all levelled Learning how to create subtitles for our films and different methods to export/embed them Week 5- Colour This week we’ll start looking at colour in our videos and what role that plays. We will look at the process of colour grading and changing the mood in our films through: Using Lumetri Colour, the colour-correcting function within Premiere Pro CC Matching the colour of different cameras to create a similar look Creating different “colour grades” to create different atmospheres Stylising our footage Understand the colour limitations of video files and the importance of exposure when filming Working with tracked masks to isolate certain areas within your image to colour correct Week 6- Putting it all together In our final week we will get the opportunity to experiment with all the skills we’ve learned to create an opening sequence for a tv series. This is also a great opportunity to revisit any topics from previous weeks.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

HSE, First aid at work, EFAW, FAW,

Ofqual Regulated Qualification|100% Online Course| FREE Assessment, Certificate & 1 Year Web Subscription|Expert Support

Please note: This training is delivered by a third party Tutor NOT The Makaton Charity. For any workshop information, to book, or to make payment please contact the Tutor directly. Safeguarding (F2F) The Makaton Safeguarding workshop is designed to support professionals and carers of children and adults with severe communication and learning disabilities. The workshop builds on existing knowledge of signs and symbols from Level 1 and 2 training, and provides instruction for extra signs and symbols specific to safeguarding situations. Participants are invited to consider differing protocols and practice. The workshop will enable participants to consider how the vocabulary may be safely applied to promote communication for people who use Makaton within a range of levels and contexts. Content This unique workshop provides signs and symbols for a range of vocabulary covering a number of topics: People: family, relationships and people around us Body parts and clothes Places Feelings: feelings, thoughts and behaviours (including bullying and abuse) Sexual behaviour By the end of the workshop you will be able to: Develop a ‘Safeguarding through Makaton’ plan for implementation in your own setting. Demonstrate an understanding of the range of people Makaton users could come into contact with at different ages and stages in their lives; Demonstrate how Makaton can be personalised and used at different levels of complexity to meet individual needs; Identify vocabulary required by a Makaton user and be able to apply the principles of this analysis to the user’s own setting; Demonstrate an understanding of the difference between comments and questions, and an appreciation of how to maintain an interaction with a Makaton user; Describe strategies or methods appropriate to use with a Makaton user to help them understand and use vocabulary or concepts; Duration The Makaton Safeguarding Workshop is made up of 13 learning hours, and is commonly delivered over 2 full days. Alternatively, the Workshop comprises of 4 modules and can be delivered flexibly over a number of weeks to suit participant’s needs. Maximum number of participants: 12 Accessibility Please indicate if you have any challenges or additional needs, so reasonable adjustments can be made to support your learning and participation. Entry criteria Prior to attending the Safeguarding Workshop you must have attended a Level 1 and a Level 2 workshop. In... [Read more] Instructions This is a Makaton Safeguarding course. This venue is within walking distance to Guildford mainline and bus stations. The park and ride stops outside this venue and there are several car parks within a 5 minute walk. Refreshments provided throughout the day and plenty of shops and cafes nearby for lunch. Invoice option available for Organisations on booking page. Tutor is also available for in-house workshops - email laura@signandshine.co.uk Privacy Statement 📎 Privacy_Statement.pdf Terms And Conditions Updated 2022 📎 Terms_and_Conditions_updated_2022.pdf

***24 Hour Limited Time Flash Sale*** Foundation in Accounting Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Foundation in Accounting Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Foundation in Accounting bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Foundation in Accounting Online Training, you'll receive 40 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Foundation in Accounting Career Bundle: Course 01: Foundation in Accounting Course 02: Financial Management For Financial Advisors Course 03: Accounting & Bookkeeping Masterclass Course 04: Basic Business Finance Course 05: Finance and Budgeting Diploma Course 06: Corporate Finance: Working Capital Management Course 07: Capital Budgeting & Investment Decision Rules Course 08: Financial Forecasting Model for New Business Course 09: Financial Analysis Course Course 10: Xero Accounting - Complete Training Course 11: Financial Ratio Analysis for Business Decisions Course 12: Secure Your Finance by Creating a Robust Financial Plan Course 13:Banking and Finance Accounting Statements Financial Analysis Course 14: Finance and Budgeting Diploma Course 15: Finance: Financial Risk Management Course 16: Central Banking Monetary Policy Course 17: Business Law: Applied Fundamentals Course 18: Raise Money and Valuation for Business Course 19: Business Manager Training Course Course 20: Strategic Business Management Course 21: Investment Course 22: Real Estate Investor Training Course 23: Internal Audit Analyst Training Course 24: Inflation: Modern Economies Course 25: Contract Law & Consumer Protection Course 26: Anti Money Laundering (AML) And KYC Concepts Course 27: Contract Management Course Level 5 Course 28: Internal Compliance Auditor Course 29: Compliance Risk and Management Course 30: Financial Modeling Using Excel Course 31: Microsoft Excel Complete Course Course 32: Ultimate Microsoft Excel For Business Bootcamp Course 33: Excel Data Analysis Course 34: Craft Excel Pivot Tables for Data Reporting Course 35: Microsoft Excel Training: Depriciation Accounting Course 36: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 37: Smart Goal Setting Course 38: Time Management Course 39: Critical Thinking in The Workplace Course 40: Workplace Confidentiality With Foundation in Accounting, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Foundation in Accounting today and take the first step towards achieving your goals and dreams. Why buy this Foundation in Accounting? Free CPD Accredited Certificate upon completion of Foundation in Accounting Get a free student ID card with Foundation in Accounting Lifetime access to the Foundation in Accounting course materials Get instant access to this Foundation in Accounting course Learn Foundation in Accounting from anywhere in the world 24/7 tutor support with the Foundation in Accounting course. Start your learning journey straightaway with our Foundation in Accounting Training! Foundation in Accounting premium bundle consists of 40 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Foundation in Accounting is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Foundation in Accounting course. After passing the Foundation in Accounting exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Foundation in Accounting course is ideal for: Students seeking mastery in Foundation in Accounting Professionals seeking to enhance Foundation in Accounting skills Individuals looking for a Foundation in Accounting-related career. Anyone passionate about Foundation in Accounting Requirements This Foundation in Accounting doesn't require prior experience and is suitable for diverse learners. Career path This Foundation in Accounting bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. WHEN: FRIDAY 6th September 10-4 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Peter Keep –About WHAT DOES THE DAY INVOLVE? The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. In this class Peter will teach you how to make a catch with a hinged locking mechanism.This project is easier than it first looks, but you do need to have experience piercing out shapes and drilling. During the one-day workshop Peter will show you some other options and explain how they work. You will also be provided with information handouts and materials. These specialist skills can be applied across other aspects of jewellery making. You NEVER stop learning as far as the jewellery industry is concerned and it is Peter’s passion to maintain traditional skill. EXPERIENCE REQUIRED: Students should have some workshop experience and be confident using normal jewellery tools and equipment. If you are unsure, please email us at hello@workshop925.com to discuss any queries, we are always here to help. CLASS SIZE: 7 WHAT IS INCLUDED? All tools and consumables are supplied. WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any lunch, snacks and drinks which you may want to your session. We have tea and coffee for you to help yourselves to. We supply all materials and tools. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.