53594 Courses in Adlington delivered Online

As a paediatric hypnotherapist, you have the power to positively impact the lives of children and young people on the autism spectrum. Unlock your potential with our inspiring, blended-learning course that provides you with safe, effective, and ethical techniques. Our accreditation and ongoing support will help you enhance your expertise in positive psychology and solution-focused counselling, empowering you to guide your clients towards personal growth and positive outcomes. Explore our flexible course today and start making a difference in the lives of those you care about.

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

Official BRCGS Product Safety Management course: An Approach to Product Safety Culture Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

Official BRCGS Product Safety Management course: Environmental Monitoring Delivered online (Zoom) by a live BRCGS Approved Training Partner. Exam and Certificate fee included in the price.

Project Management Foundation (PM Foundation™): On-Demand PM Foundation™ provides a comprehensive introduction to the fundamentals of project management based upon PMI®'s A Guide to the Project Management Body of Knowledge (PMBOK® Guide). Dynamic and interactive, the course has an easy-to-use interface and includes a real-world video case study and exercises that run throughout the course to ensure increased retention of learning. Initiating Planning Executing Monitoring and Controlling Closing

This coaching programme is for aspiring women leaders in higher education, delivered in real time, fully online. Five workshops have been designed to support you in a group environment to work actively towards realising your professional goals, whatever they may look like, focused on leadership at all levels in higher education. HE needs leaders like you - workshops with Coach Academic will help to propel you to becoming one. For all academics who are female/identify as female. During this coaching experience you will explore and learn from: - your values and beliefs, and how they impact on your professional identity and actions - your beliefs about higher education, leadership, and yourself - your strengths and how to harness them for impact - your areas for development, and embracing the actions you choose to address these - your internal and external blockers, and how to manage these - your motivation - why do you want to lead in HE? From these you will be able to build your confidence and your leadership identity, and take concrete steps towards becoming the leader you aspire to be.

This coaching programme is for aspiring women leaders in higher education, delivered in real time, fully online. Five workshops have been designed to support you in a group environment to work actively towards realising your professional goals, whatever they may look like, focused on leadership at all levels in higher education. HE needs leaders like you - workshops with Coach Academic will help to propel you to becoming one. For all academics who are female/identify as female. During this coaching experience you will explore and learn from: - your values and beliefs, and how they impact on your professional identity and actions - your beliefs about higher education, leadership, and yourself - your strengths and how to harness them for impact - your areas for development, and embracing the actions you choose to address these - your internal and external blockers, and how to manage these - your motivation - why do you want to lead in HE? From these you will be able to build your confidence and your leadership identity, and take concrete steps towards becoming the leader you aspire to be.

Highlights of the Course Course Type: Self-paced online course Guided Learning Hours: 140 Accreditation: NCFE Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Certificate: Certificate upon passing the official exam Access: Lifetime Access Tutor Support- Personalised feedback on your all assignments Customer Support: 24/7 live chat available What you will learn from this course? Upon successful completion of this Level 4 Certificate in Education and Training, you will be able to: Understand the responsibilities and function of teaching in education and training Possess the capacity to maintain a safe and encouraging learning environment Learn about the relationships between teachers and other training and career professionals. Utilise initial and diagnostic evaluations to work with children to set individualized learning objectives Develop and incorporate inclusive education to meet the needs of the organisation as well as those outside of it. Engage in conversation with students and other learning professionals to promote learning Embrace the basic standards while facilitating inclusive teaching and learning, and learn how to use technology to accomplish inclusive teaching and learning Consider your own performance as you get ready for inclusive teaching and learning Implement a variety of assessment strategies to meet the requirements of different learners, and while grading pupils stick to the fundamentals Utilise your resources while delivering inclusive instruction and evaluation Level 4 Certificate in Education & Training Online This Level 4 Certificate in Education and Training is accredited by NCFE and regulated by Ofqual, making it a nationally recognised credential that will improve your CV and set you apart from the competition. You will gain knowledge about the duties and responsibilities as well as gain skills to evaluate potential learners, develop and implement a variety of teaching and learning strategies, and deliver instruction and training. Towards the end of this course, you'll acquire an extensive range of teaching abilities and expertise you need to establish a successful career in the education sector. Who is this Course for? The following individuals may benefit from this Level 4 Certificate in Education and Training: all types of trainers aspirant teachers teachers of all levels teacher trainers teachers wishing to improve their instructional abilities teachers wishing to enhance their employment prospects Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Eligibility Requirements This Level 4 Certificate in Education and Training has no academic prerequisites and is open to students from all academic disciplines.  Assessment Procedure Upon successful completion of this Level 4 Certificate in Education and Training, you will be evaluated by a series of assignments that the instructors of the course will internally construct and grade. This strategy will give students more confidence to ace the exam because it precisely represents the content taught in class and fits the teaching methodology being used. Pass" represents the qualification's overall grade Each item included in the qualification framework must be completed by the student For a student to pass a unit, they must demonstrate their understanding of each unit by achieving all of the listed learning outcomes and meeting all of the evaluation criteria Assignment Submission For each portion of the award, you are required to submit a number of short assignments. Assignments should incorporate theory and establish connections to actual workplace or classroom circumstances in order to convey pertinent arguments. These assignments will aid in your exploration and application of the entire teaching and learning cycle. If more work is needed, your instructor will offer feedback and the chance to resubmit assignments. Practical Teaching Assessment The practical assessments require you to provide written documentation of at least three actual classroom teaching sessions of an hour each. This does not include anything done as part of the Level 3 Award in Education and Training that was witnessed. A minimum of thirty minutes must pass between each observation. This witness evidence must be given by a teacher who possesses the necessary qualifications. In extraordinary circumstances, we may also set up a video link with your tutor to finish these observations. The three observations must be related to the following compulsory units: Delivering education and training (M/505/0122) Using resources for education and training (L/505/0127) Assessing learners in education and training (F/505/0125) No previous experience is required to enrol into this course. However, you must complete 30 hours of in-class teaching experience throughout the course of the program to receive your completion certificate. Your practical teaching demonstration will need to be observed by an expert witness who has a level 5 diploma in education and training. For an extra charge of £175 + VAT for 4 hours, if you'd prefer, we can assist you by providing an expert witness.  Advance Your Career This Level 4 Certificate in Education and Training will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. Following the completion of this certification, you may pursue the following credentials:  Assessing Vocationally Related Achievement at Level 3 Assessing Vocational Achievement at the Level 3 Assessing Competence in the Workplace: Level 3 Award Certificate in Education and Training at Level 4 Advanced Practitioner Level 4 Certificate in Schools and Colleges Technology-Enabled Educators Level 4 Award Diploma in Education and Training at Level 5. If you are looking for a Level 3 Award in Education and Training, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  This Level 4 Certificate in Education and Training is accredited by NCFE and regulated by Ofqual. The National Council for Educational Awarding (NCFE) is a national educational awarding body that is well-known and respected throughout the world, which will improve your prospects of finding employment and showcase your professional growth. Course Curriculum Course Overview Course Overview - Level 4 Certificate in Education and Training 00:00:00 Sample Useful Documents Observation Recording Requirements 00:15:00 Sample Session Plan Pro-Forma 00:15:00 Sample Portfolio Building Record Sheets 00:15:00 Sample Graded Observation Pro-Forma 00:15:00 Preface Preface 00:18:00 Introduction Introduction 00:25:00 1. Reflecting, evaluating and improving your practice 1. Reflecting, evaluating and improving your practice 00:15:00 2. Professional roles and responsibilities 2. Professional roles and responsibilities 00:15:00 3. You and your learners mental health and emotional well-being 3. You and your learners mental health and emotional well-being 00:18:00 4. Learners and their needs 4. Learners and their needs 00:25:00 5. Assessment practices and processes 5. Assessment practices and processes 00:25:00 6. Communication 6. Communication 00:18:00 7. Inclusive learning environments 7. Inclusive learning environments 00:19:00 8. Planning and Delivery 8. Planning and Delivery 00:15:00 9. Teaching practice and observations 9. Teaching practice and observations 00:17:00 10. Progression routes 10. Progression routes 00:16:00 11. Study skills Glossary of acronyms Glossary of acronyms 00:18:00 Appendix Appendix 00:24:00 Answers to Activities Answers to Activities 00:15:00 Index Index 00:23:00 Assignment - Mandatory Units Assignment 1: Understanding Roles, Responsibilities and Relationships in Education and Training Assignment 1 - Understanding Roles, Responsibilities and Relationships in Education and Training 00:14:00 Assignment 2: Planning to Meet the Needs of Learners in Education and Training Assignment 2 - Planning to Meet the Needs of Learners in Education and Training 00:10:00 Assignment 3: Delivering Education and Training Assignment 3 - Delivering Education and Training 00:15:00 Assignment 4: Assessing Learners in Education and Training Assignment 4 - Assessing Learners in Education and Training 00:14:00 Assignment 5: Using Resources for Education and Training Assignment 5 - Using Resources for Education and Training 00:09:00 Assignment - Optional Units Assignment 6: Working with Individual Learners Assignment 6 - Working with Individual Learners 00:00:00 Feedback Feedback 00:00:00

If you want to achieve a Level-5 Ofqual UK-Government Regulated TESOL certification in the most effective, time-saving and enjoyable way, embark on a thrilling learning adventure in TEFL Wonderland. Unlike the click-and-read TEFL courses, this play-and-practice expedition will engage all your senses and keep you motivated to achieve your learning mission.