14594 Courses

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Success in Cambridge Maths is often a prerequisite for many competitive university courses, particularly in the fields of engineering, physics, computer science, and of course, mathematics. This self-paced course from Spark Generation provides a strong foundation for students planning to pursue mathematically-intensive careers or those who want to prepare for their high school journey in a smart way. :)

Success in Cambridge Maths is often a prerequisite for many competitive university courses, particularly in the fields of engineering, physics, computer science, and of course, mathematics. This self-paced course from Spark Generation provides a strong foundation for students planning to pursue mathematically-intensive careers or those who want to prepare for their high school journey in a smart way. :)

Description: Are looking forward to learning each and every single details of Microsoft Office 2016? Then you are at the right place! Microsoft Office 2016 Essentials is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more. Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialog box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records, and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Essentials is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

If you're aiming to support learners in mastering English while also standing out in educational recruitment, this 20-in-1 ESOL Tutor bundle positions you ahead of the hiring curve. Perfect for future ESOL tutors, support workers, or language educators looking to enter schools, community centres, or adult education roles. Want to be job-ready in a world where communication is everything? Start here—before someone else gets the interview slot. 🔍 Description This course bundle doesn’t just offer knowledge—it gives you the professional polish to meet the growing demand for ESOL-focused educators. Today’s language support roles require more than classroom ability—they demand clarity, adaptability, and communication excellence. Whether you're pursuing teaching assistant roles, training centre jobs, or international education work, this bundle equips you with a standout skillset employers actually ask for. With soft skills, administrative tools, and linguistic awareness woven in, your job-readiness isn’t just implied—it’s certified. And yes—20 in-demand topics, one convenient bundle, at a fraction of the cost. Because smart jobseekers know it’s not just what you know—it’s what you show on your CV. ❓ FAQ Q: Who is this bundle aimed at? A: Aspiring ESOL tutors, English language assistants, adult learning facilitators, or community educators. Q: Will this help me get a job in education? A: It boosts your hireability for roles in schools, language centres, charities, and ESOL programmes. Q: Is this bundle suitable for non-native English speakers? A: Yes—many non-native speakers use this to strengthen teaching skills and support roles. Q: Can I use this to freelance or teach online? A: Absolutely. These skills are valued by online tutoring platforms and private learners. Q: Does the bundle cover more than teaching? A: Yes. It also builds communication, self-management, and equality competencies valued in any workplace.

Picture a world where you could speak the silent language of animals, understand their needs, and tend to them with both knowledge and empathy. The 'Animal Care, Psychology and First Aid' course is your gateway to such a world, meticulously designed to blend compassion with practical care techniques. It's a sanctuary of learning that equips animal aficionados with insights into animal welfare, health, and psychology, guiding you through the nuances of various species. As you navigate through the curriculum, you'll become adept in the art of caring, feeding, and ensuring the safety and happiness of our non-human friends. Learning Outcomes Acquire a comprehensive understanding of animal welfare principles and health care. Develop proficiency in the handling and restraint of different animal species to ensure safety and minimise stress. Master the techniques of proper animal nutrition, feeding, and transportation. Learn to assess risks associated with animal care to prevent potential health hazards. Gain knowledge in the optimal design and maintenance of animal housing. Why choose this Animal Care, Psychology and First Aid course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Animal Care, Psychology and First Aid Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Animal Care, Psychology and First Aid course for? Individuals passionate about animal welfare and seeking to build a foundation in animal care. Veterinary assistants aiming to refine their knowledge and care techniques. Animal shelter volunteers desiring formal education on animal psychology and health. Pet owners looking for expert guidance on effective first aid and risk assessment. Future zoologists and animal researchers wanting a practical start in animal handling. Career path Veterinary Nurse - £18,000 to £25,000 Animal Welfare Officer - £20,000 to £30,000 Zoological Curator - £25,000 to £40,000 Animal Behaviourist - £20,000 to £35,000 Wildlife Rehabilitator - £15,000 to £25,000 Pet Nutrition Consultant - £20,000 to £30,000 Prerequisites This Animal Care, Psychology and First Aid does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Animal Care, Psychology and First Aid was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.   Course Curriculum Animal Care, Psychology and First Aid Animal Welfare 00:30:00 Animal Health 00:30:00 Different Kinds of Animals 00:30:00 Animal Handling and Restraint 00:30:00 Animal Transporting 01:00:00 Animal Feeding 00:30:00 Assessment of the Risk 00:30:00 Animal Caging 00:30:00 Recommended Reading Recommended Reading : Animal Care, Psychology and First Aid 00:00:00 Mock Exam Mock Exam- Animal Care, Psychology and First Aid 00:20:00 Final Exam Final Exam- Animal Care, Psychology and First Aid 00:20:00

Imagine embarking on a scientific journey that fuses the complexities of biology with cutting-edge technology. This is the essence of our Biotechnology course, a carefully curated programme that begins with an 'Introduction to Biotechnology,' setting the stage for what will be an enlightening expedition into the fusion of nature and tech. As learners peel back the layers of this innovative field, they'll uncover the milestones that have defined biotechnology throughout history, providing a rich context for their studies. The course then guides participants through the intricate landscapes of molecular and cellular biology, where the building blocks of life are manipulated and redefined. Delve into the intriguing similarities and differences between biotechnology and molecular biology, before mastering the revolutionary techniques of genetic engineering. This educational voyage is not just about the theories; it explores biotechnology's pivotal role in health, industry, and its emerging influence within the business sector. It's an invitation to become conversant in a language that will shape the future of healthcare, agriculture, and environmental stewardship. Learning Outcomes Understand the fundamental principles and scope of biotechnology. Analyse the historical development and its impact on current practices. Differentiate between the roles of biotechnology and molecular biology. Apply genetic engineering concepts in various biotechnological fields. Assess biotechnology's applications in healthcare and industrial sectors. Why choose this Biotechnology course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Biotechnology course for? Aspiring biotechnologists seeking foundational knowledge. Biological science students exploring specialised fields. Medical professionals interested in biotechnological applications. Entrepreneurs eyeing the biotech industry for business opportunities. Environmental advocates understanding biotechnology's role in sustainability. Career path Biotechnologist: £25,000 - £60,000 Research Scientist (Biotechnology): £23,000 - £45,000 Genetic Engineer: £30,000 - £55,000 Biotech Product Manager: £40,000 - £70,000 Clinical Research Associate: £24,000 - £45,000 Biotechnology Consultant: £35,000 - £80,000 Prerequisites This Biotechnology does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Biotechnology was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01 - Introduction to Biotechnology Introduction to Biotechnology 00:19:00 Module 02- Biotechnology in the Realm of History Biotechnology in the Realm of History 00:27:00 Module 03- Molecular and Cellular Biology Molecular Biology 00:27:00 Module 04 - Biotechnology Versus Molecular Biology Biotechnology Versus Molecular Biology 00:11:00 Module 05- Genetic Engineering Genetic Engineering 00:16:00 Module 06- Biotechnology in Health Sector Biotechnology in Health Sector 00:11:00 Module 07- Industrial Biotechnology Industrial Biotechnology 00:14:00 Module 08- Biotechnology in a Business Perspective Biotechnology in a Business Perspective 00:13:00 Assignment Assignment - Biotechnology 00:00:00

Overview This comprehensive course on Master English Speaking 2 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master English Speaking 2 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Master English Speaking 2. It is available to all students, of all academic backgrounds. Requirements Our Master English Speaking 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 27 sections • 51 lectures • 03:36:00 total length •Introduction: 00:04:00 •1 - 10 Ways to Encourage Someone: 00:08:00 •Practice Pronunciation and Test Yourself: 00:04:00 •10 Ways to Talk about Price: 00:06:00 •Practice pronunciation and Test Yourself: 00:03:00 •10 Phrases for Saying Something is Easy and Difficult: 00:05:00 •Practice pronunciation and Test Yourself: 00:04:00 •10 Phrases for Remembering, Reminding & Forgetting: 00:07:00 •Practice pronunciation and Test Yourself: 00:04:00 •5 Ways to Interrupt Someone Politely: 00:04:00 •Practice pronunciation and Test Yourself: 00:03:00 •6 Ways to Ask for Clarification: 00:04:00 •Practice pronunciation and Test Yourself: 00:02:00 •7 Phrases for Complaining: 00:04:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Ways to Ask Someone Else to Do Something: 00:04:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Ways to Ask for Help: 00:05:00 •Practice pronunciation and Test Yourself: 00:03:00 •10 Expression about Age: 00:07:00 •Practice pronunciation and Test Yourself: 00:04:00 •10 Phrases for Shopping: 00:06:00 •Practice pronunciation and Test Yourself: 00:04:00 •10 Phrases for Talking about Food: 00:05:00 •Practice pronunciation and Test Yourself: 00:03:00 •10 Phrases for Talking about TV: 00:05:00 •Practice pronunciation and Test Yourself: 00:04:00 •10 Phrases you will hear in the Airport: 00:05:00 •Practice pronunciation and Test Yourself: 00:04:00 •5 Ways to Check if the Other Person Understands You: 00:03:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Phrases for Hot Weather: 00:05:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Phrases for Cold Weather: 00:04:00 •Practice pronunciation and Test Yourself: 00:02:00 •10 Ways to Talk about the Rain in English: 00:04:00 •Practice pronunciation and Test Yourself: 00:02:00 •10 Ways to Say that you are Tired: 00:05:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Phrases for Promises & Resolutions: 00:04:00 •Practice pronunciation and Test Yourself: 00:02:00 •10 Excuses for being Late: 00:05:00 •Practice pronunciation and Test Yourself: 00:03:00 •5 Ways to Say Someone is Correct: 00:03:00 •Practice pronunciation and Test Yourself: 00:02:00 •5 Ways to Say Someone is wrong: 00:04:00 •Practice pronunciation and Test Yourself: 00:03:00 •7 Ways to Say Someone is Smart: 00:03:00 •Practice pronunciation and Test Yourself: 00:02:00 •PDF: 00:24:00 •Assignment - Master English Speaking 2: 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Overview This course provides all the principles, knowledge, and skills that you will need to absorb, to carry out exemplary Social Care. The Care Certificate in Child Development, Psychology and Protection course has been written with the help of industry professionals and lays out all of the EU/UK standards for delivering care to the community. You will be taught how to safeguard the vulnerable, provide appropriate nutrition, respect privacy and dignity, support those with challenges and disabilities, and ensure hygiene and cleanliness. Understand your responsibilities in the Social Sector today. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. ** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. ** Method of Assessment To enhance your knowledge regarding the course and to assess your learning, you need to complete the assignment questions provided at the end of the course, which you can complete either during or after the course.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Care Certificate in Child Development, Psychology and Protection. It is available to all students, of all academic backgrounds. Requirements There are no specific prerequisites to enrol in this Care Certificate in Child Development, Psychology and Protection course . Anyone and everyone can take this course. The Care Certificate in Child Development, Psychology and Protection is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Course Curriculum 3 sections • 32 lectures • 15:21:00 total length •Module 1: Introduction to Childcare and Nutrition: 00:25:00 •Module 2: Understanding Child Development: 00:26:00 •Module 3: Keeping Children Healthy & Safe: 00:33:00 •Module 4: Day-to-day Child Caring: 00:20:00 •Module 5: Macronutrients: 00:20:00 •Module 6: Micronutrients: 00:20:00 •Module 7: Child Nutrition Requirements: 01:03:00 •Module 8: Child Nutritional Problems & Physical Activity: 00:25:00 •Module 9: Children with Special Needs: 00:41:00 •Module 10: Child Abuse & Protection: 00:25:00 •Module 11: Early Years Provision: 00:21:00 •Module 01: Introduction to Child Psychology: 00:28:00 •Module 02: Attachment and Relationship Building in Childhood: 00:31:00 •Module 03: Impacts of Separation and Loss on Attachment: 00:27:00 •Module 04: Factors That Influence Development: 00:36:00 •Module 05: Cognitive Development: 00:25:00 •Module 06: Social and Emotional Development: 00:43:00 •Module 07: Personality and Intellectual Development of Children: 00:36:00 •Module 08: Stages of Language Development: 00:27:00 •Module 09: Understanding Moral Development: 00:18:00 •Module 10: Play, Imagination, and Creativity: 00:26:00 •Module 11: Problems of Infancy: 00:20:00 •Module 12: Problems of Childhood: 00:23:00 •Module 13: Problems of Adolescence: 00:28:00 •Module 01: Introduction to Safeguarding: 00:21:00 •Module 02: Laws and Guidance: 00:43:00 •Module 03: Child Abuse: 00:49:00 •Module 04: Child Sexual Exploitation: 00:38:00 •Module 05: Responding to Disclosure and Reporting: 00:25:00 •Module 06: Risks and Risk Assessment: 00:16:00 •Module 07: Things to Do after Referral: 00:24:00 •Module 08: Record Keeping: 00:18:00