6966 Courses

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

With Actress, Acting and Audition Coach Sarah Hannah Introduction With the resurgence of period dramas both on stage and especially on the screen, the demand for ‘Classically Trained’ actors has never been greater. Changes in the way you audition has seen an increase in being called upon to audition and self-tape with Shakespearean monologues which could leave you uncertain about how to best prepare. Rarely taught outside a handful of top drama schools, First Folio Technique is widely seen as the gold standard for classical acting. It also makes performing Shakespeare a lot easier! This intensive online workshop will lead you through simple guidelines to demystify and detangle the text, uncover Shakespeare’s clues and learn how to easily decipher what lines mean and how to deliver them. This course can be complimented by our Shakespeare’s Words: The Rules of Verse Speaking – and how Shakespeare Breaks Them! course. Meet Your Tutor Sarah Hannah Actress, Acting and Audition Coach Sarah Hannah is a highly experienced professional actress, acting and audition coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your passion and understanding of the works of William Shakespeare. Course Outline *You will be sent a pdf worksheet for this workshop that you will need to write on. It is therefore recommended that you print it out if you can. Additional Information Features The First Folio is considered a reliable and authoritative source for Shakespeare’s plays. While there may be some variations and textual issues, it provides a foundational text for many of his works Scholars often refer to it to establish the most accurate versions of Shakespeare’s plays Suitable if you are (17 yrs+) and looking to discover Shakespeare Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Learning Outcomes Discover your passion and understanding of Shakespeare Course Location Held Online Via Zoom

With Sarah Hannah Introduction With the recent resurgence of period dramas both on stage and especially on the screen, the demand for ‘Classically Trained’ actors has never been greater. Changes in the way we audition has also seen an increase in actors being called upon to audition and self-tape with Shakespearean monologues leaving many actors intimidated and uncertain about how to best prepare. Ideal for actors of all ability, this online workshop will teach you all of the basic rules for acting in verse, perfect for any period drama work on screen… and then learn how Shakespeare and others break the rules! What these ‘rule breaks’ are for and the amazing help that this gives you when speaking these lines and bringing your character to life. This course can be complimented by our Secrets of Acting Shakespeare: First Folio Technique course. Meet Your Tutor Sarah Hannah Actress, Acting and Audition Coach Sarah Hannah is a highly experienced professional actress, acting and audition coach. Bringing her extensive experience of working on stage and screen, Sarah will focus on enhancing your passion and understanding of the works of William Shakespeare. Course Outline *You will be sent a pdf worksheet for this workshop that you will need to write on. It is therefore recommended that you print it out if you can. A strong internet connection is required to join our live online courses and workshops. Please test your connection before booking as we cannot refund due to technical issues. Please familarise yourself with Zoom before attending your workshop. Your camera will be required to be switch on during the workshop. Additional Information Features Suitable if you are (17 yrs+) and looking to discover Shakespeare Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Learning Outcomes Appreciate a deeper understanding of Shakespeare Course Location Held Online Via Zoom

This mega life skills training course will equip you with all the essential skills you need to successfully navigate everyday life. Through life skills training, you'll learn everything from problem-solving techniques and communication techniques to time management tips and financial literacy skills. Drawing on the personal experiences of successful people, this course will teach you how to communicate effectively and meaningfully with others, so you can be confident when faced with difficult conversations or challenging situations. You'll discover easy-to-follow strategies for overcoming mental obstacles and conquering procrastination, and develop the resilience you need to weather any storm life throws your way. Life skills course is designed to give you knowledge that you can apply immediately to enrich your life, reduce stress levels, and whatever comes your way! Course includes: Course 01: Life Coaching and Career Counselling Course 02: Spiritual Life Coaching Course Course 03: Behaviour Management & Emotional Intelligence Course 04: Anger Management & Conflict Resolution Course 05: Dealing With Difficult People In Life & Work Course 06: Psychology, Meditation & Parapsychology Course 07: Motivation Skills Course 08: Personal Development Skills Course 09: Team Management Course 10: Setting & Achieving Goals Course 11: Time Management Skills Course 12: Office Skills The comprehensive learning resources for Life skills course are available anytime, anywhere, so you can study at your own pace in the convenience of your own home. Industry experts break down the curriculum into tiny, manageable units. And our professionals will respond to any of your questions. Reality Check: Many students claim that even though it is shorter than other courses they have taken, it has taught them considerably more. This course is just as good as many other offline courses that were 5 to 10 times more expensive. As a result, taking this outstanding course is highly recommended by everyone. Course Significant Points: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Method of Assessment MCQ Based Passing Marks 60% Unlimited Retake Exam Instant Assessment and Feedback CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in Life skills course. However, This course particularly effective for- Students Recent graduates Job Seekers in related field Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill We take pleasure in offering the most adaptable, relatively inexpensive, and enjoyable online courses possible to eager aspirants all around the world. Requirements Learners seeking to enrol for Life skills course should meet the following requirements; Basic knowledge of the English language, which you have already Basic Knowledge of Information & Communication Technologies for studying online or digital platform Stable Internet or Data connection in your learning devices Career path This is a whole course package. You'll be capable of covering every job/employment sector after finishing this Life skills bundle. The major goal of this package is to make you intelligent and proficient in all areas, so you can communicate and perform effectively at work. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £9.99

***24 Hour Limited Time Flash Sale*** English for Literacy and Language Teaching 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 English for Literacy and Language Teaching 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 English for Literacy and Language Teaching 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 English for Literacy and Language Teaching Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this English for Literacy and Language Teaching Career Bundle: Course 01: English Literature Course 02: An Introduction to British and American Literature Search Course 03: Comparative Literature Course 04: Medieval History Course 05: Social Science Diploma Course 06: Level-3 English Grammar Course Course 07: English: Spelling, Punctuation, and Grammar Course 08: Essay Writing in English Course 09: Creative Writing Course: Writing Storybooks For Children Course 10: Creative Writing Course - Fiction Course 11: Creative Writing Course - Novel Course 12: Novel Writing and Publishing Course 13: 200 Common English Idioms and Phrases Course 14: Content Management Course 15: Copyediting & Proofreading Course 16: Information Management Course 17: Data Management Training Course 18: Document Control Course 19: ICT: Information and Communication Technology Course 20: GDPR Course 21: Administrative Management Course 22: Data Entry Administrator Course 23: New Functions in Microsoft Excel Course 24: Functional Skills IT Course 25: Complete Communication Skills Master Class Course 26: Goal Setting Course 27: Touch Typing Course 28: Computer Operating System and Troubleshooting Course 29: Microsoft Access Databases Forms and Reports Course 30: ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! With English for Literacy and Language Teaching, 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 English for Literacy and Language Teaching today and take the first step towards achieving your goals and dreams. Why buy this English for Literacy and Language Teaching? Free CPD Accredited Certificate upon completion of English for Literacy and Language Teaching Get a free student ID card with English for Literacy and Language Teaching Lifetime access to the English for Literacy and Language Teaching course materials Get instant access to this English for Literacy and Language Teaching course Learn English for Literacy and Language Teaching from anywhere in the world 24/7 tutor support with the English for Literacy and Language Teaching course. Start your learning journey straightaway with our English for Literacy and Language Teaching Training! English for Literacy and Language Teaching premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the English for Literacy and Language Teaching 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 English for Literacy and Language Teaching course. After passing the English for Literacy and Language Teaching exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This English for Literacy and Language Teaching course is ideal for: Students seeking mastery in English for Literacy and Language Teaching Professionals seeking to enhance English for Literacy and Language Teaching skills Individuals looking for a English for Literacy and Language Teaching-related career. Anyone passionate about English for Literacy and Language Teaching Requirements This English for Literacy and Language Teaching doesn't require prior experience and is suitable for diverse learners. Career path This English for Literacy and Language Teaching 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, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

Are you passionate about ensuring a safe and healthy workplace for all? Discover a rewarding career in health and safety auditing, a profession in high demand across the UK. In a world where safety is paramount, your expertise can make a real difference. With our comprehensive "Health and Safety Auditor" bundle, you'll have the knowledge and credentials to excel in this vital field. This bundle covers a wide spectrum of essential topics, including the Award in Workplace Safety at QLS Level 2, Workplace First Aid Level 3, and even specialised courses like Anaphylaxis and Basic Life Support. Dive deep into the intricacies of Occupational Health and Safety, Food Hygiene & Safety, Infection Prevention, and Fire Risk Assessment, all while mastering the nuances of Electrical Safety, Ladder Safety, and Working at Height. Your expertise will extend to Lone Worker Safety, COSHH, Asbestos Awareness, HAVS, RIDDOR Awareness, LOLER, and Manual Handling, making you a well-rounded health and safety professional. In the UK, the demand for health and safety auditors is continuously growing, and this profession offers competitive income opportunities. By enrolling in this bundle, you'll position yourself as a knowledgeable and skilled expert in health and safety auditing, ready to meet the evolving needs of the workplace. Don't miss this chance to embark on a career where you can truly make a difference. Elevate your knowledge and career prospects with our "Health and Safety Auditor" bundle today, and take the first step towards a safer and healthier tomorrow. Learning Outcomes: Master workplace safety standards and regulations. Acquire life-saving first aid and anaphylaxis skills. Expertise in occupational health and safety principles. Ensure food hygiene and infection prevention. Conduct fire risk assessments confidently. Safely handle electrical, ladder, and height-related tasks. Excel in COSHH, asbestos awareness, and more. Unlock a world of safety expertise with our "Health and Safety Auditor" bundle. Delve into the intricacies of workplace safety, first aid, and life-saving techniques. Equip yourself with a comprehensive understanding of occupational health and safety principles. Learn to prevent infections and ensure food hygiene. Become a fire risk assessment pro and handle electrical tasks with confidence. This bundle empowers you to excel in crucial areas like COSHH and asbestos awareness. Elevate your career prospects by mastering manual handling and more. Each course within this bundle offers unique benefits. Workplace Safety at QLS Level 2 equips you with the fundamentals, while Workplace First Aid Level 3 imparts life-saving skills. Our Diploma in Occupational Health and Safety ensures you're well-versed in industry standards. Food Hygiene & Safety Level 2 and Infection Prevention instil vital knowledge for hygiene-conscious workplaces. Fire Risk Assessment and Electrical Safety courses provide expertise in safety protocols. Topics like COSHH, asbestos awareness, and Manual Handling Training are essential for compliance and injury prevention. This bundle is perfect for aspiring health and safety auditors, professionals seeking to enhance their safety skills, or anyone dedicated to promoting a safer work environment. Whether you're entering the field or advancing your career, these courses are your ticket to success. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Health and Safety Auditors Workplace Safety Enthusiasts Safety Compliance Professionals Career Advancers in Safety Career path Health and Safety Auditor: £30,000 - £45,000 per year Safety Officer: £25,000 - £35,000 per year Occupational Health Specialist: £30,000 - £45,000 per year Food Safety Inspector: £25,000 - £35,000 per year Fire Safety Consultant: £35,000 - £50,000 per year Compliance Manager: £35,000 - £60,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Weaving with a frame loom and a wide range of textured yarns and fabrics you can create a wall hanging in just three hours. Pick your favourite colours and textures from our extensive range of fibres and create something beautiful for your home

Employing a mix of practical exercises and critical reflection, this introductory day course provides an overview of fundamental techniques for recording and editing voice, ambiences and sound effects for podcasts, video/film and art installations or just for fun. The course uses industry standard software and introduces a range of popular, high quality microphones and portable recording devices. The course has enough flexibility to be steered by the individual interests of the participants, but you will generally cover; the properties of sound, microphone selection and placement, gain structure, effective planning, noise limiting and reduction, sound editing, dynamics, sound processing and spatial effects. If desired, we can look at a variety of techniques for improving sound quality and recording audio from video conferencing, as we all find ourselves working and interacting in this manner every day. Computer experience is required. Morning Microphone Selection – why and when to use Applications, characteristics, limitations Microphone type – Dynamic, Condenser, Lavalier, Shotgun, Boundary, Stereo, Binaural Polar Patterns – Omni, Cardoid, Attenuated and others Practical microphone placement and technique Critical distance, proximity effect, shielding, simple acoustic treatments, filtering Lavalier microphone – positioning, preventing distortion & rustles Booming – positioning, preventing microphone bumps Stereo Mics – phase issues Afternoon Editing techniques (fades, looping) Building a mix Basic sound processing, noise reduction and dynamics (channel strips, EQ and compression) Insert effects (modulation, filtering, distortion) Send effects (delay, reverb) Automation (of volume, panning etc) Bussing (sending signals to multiple fx) Mastering effects (limiting) Exporting and file types   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.