33819 OV courses

During pregnancy, hypnotherapy fosters a calm mindset, eases discomfort, and aids in preparing for childbirth (hypnobirthing). By harnessing the power of the mind-body connection, hypnotherapy proves advantageous in alleviating challenges when birthing fostering overall women's health and empowerment.

In our exploration of hypnotherapy's effectiveness in addressing trauma and PTSD symptoms, we delve into the intricate relationship between traumatic experiences and physiological responses, such as the function of the vagus nerve. Traumatic events can contribute to an overactive vagus nerve, which manifests in symptoms as anxiety, mood changes, nausea, and pain.

Aspiring author? We know how frustrating it can be to have a brilliant story idea but feel stuck on where to start. The blank page can be intimidating, and finding the time and confidence to write can seem impossible. This Two-Day Creative Writing Workshop is designed specifically for beginners like you, ready to turn your novel dreams into reality! 🚀✍️

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.

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

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.

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