35682 Courses delivered Online

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

Designed for professional B2B salespeople to develop a modern approach to winning business

Logistics Management: Logistics Management Course Online The most fruitful way to recognise prospective suppliers and integrate their distributions into your work schedules is to use logistics effectively. You will learn how to handle your supply chain and establish working relationships that will prove profitable to your needs and the vendor. Take the first important step toward a rewarding career in Supply Chain and Logistics Management: Logistics Management by enrolling in our exclusive Logistics Management: Logistics Management Course! The Logistics Management: Logistics Management Course begins with an overview of logistics management: logistics management. The role of the professional logistics manager is also thoroughly discussed. The Logistics Management: Logistics Management course highlights include Logistics Management: Logistics Management Course, the importance of Logistics Management: Logistics Management Course, procurement, processing, delivery procedures, Supply Chain metrics, analysis of logistics performance and much more. Why choose this Logistics Management: Logistics Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Logistics Management: Logistics Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Logistics Management: Logistics Management Course. Main Course: Level 4 Logistics Management Course Free Courses included with Logistics Management: Logistics Management course. Course 01: Level 5 Supply Chain Management Course 02: Level 5 Negotiation Skills Course 03: Level 7 Diploma in Facilities Management Course 04: Level 1 Business Management [ Note: Free PDF certificate as soon as completing the Logistics Management: Logistics Management course] Logistics Management: Logistics Management Course Online This Logistics Management: Logistics Management Course consists of 09 modules. Course Curriculum of Logistics Management: Logistics Management Course Module 01: Introduction to Logistics Management Module 02: Logistics, the Supply Chain and Competitive Strategy Module 03: Product Design, Cleaner Production and Packaging Module 04: Sustainable Purchasing and Procurement Module 05: Sustainable Warehousing Module 06: Customer Service and Logistics Module 07: Basic Inventory Planning and Management Module 08: Freight Transport Management Module 09: Reverse Logistics and Recycling Assessment Method of Logistics Management: Logistics Management Course After completing Logistics Management: Logistics Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Logistics Management: Logistics Management Course After completing the Logistics Management: Logistics Management course, you can instantly download your certificate for FREE. Who is this course for? Logistics Management: Logistics Management Course Online This Logistics Management: Logistics Management Course is ideal for: Candidates wishing to upgrade their knowledge in Supply Chain and Logistics Management Candidates interested in a career change. Existing Supply Chain workers seeking promotion. Logistics managers looking to expand skills, knowledge and abilities. Requirements Logistics Management: Logistics Management Course Online To enrol in this Logistics Management: Logistics Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Logistics Management: Logistics Management Course. Be energetic and self-motivated to complete our Logistics Management: Logistics Management Course. Basic computer Skill is required to complete our Logistics Management: Logistics Management Course. If you want to enrol in our Logistics Management: Logistics Management Course, you must be at least 15 years old. Career path Logistics Management: Logistics Management Course Online Upon successful completion of our Logistics Management: Logistics Management Course, candidates may choose to pursue an extensive range of long-term careers, including: VP Supply Chain Materials Planner Production Planner

Try Grow with this taster session! We've extracted a snippet of module 1 to give you a flavour for how our CPD programme works. Give it a try! Comprehensive, inclusive and accessible CPD for EAL teaching – designed for all educators.   At FlashAcademy®, we believe in a whole-school approach to EAL teaching, empowering every educator to contribute to the success of multilingual learners.  Our CPD programme provides:  Practical knowledge and evidence-based strategies. Resources to reflect, refine, and grow your school’s EAL provision. Actionable tools designed by experienced teachers and EAL specialists who understand the challenges of teaching multilingual learners. With real-life context learning, you’ll gain the skills to deliver impactful teaching and help your EAL students thrive.  About Grow with FlashAcademy®  Developed in collaboration with EAL Inclusive, we have created a comprehensive CPD journey for educators. Whether you’re new to EAL or looking to refine your strategies, Grow with FlashAcademy® offers flexible, on-demand learning.  What’s included?  A blend of video lessons, interactive content and a downloadable reflection journal. On-demand access via Cademy so you can learn at your own pace. Expert virtual drop-in sessions to connect with EAL specialists and ask your questions. Modules designed for practical implementation in schools. Why Grow with FlashAcademy®?  The challenge  EAL coordinators and practitioners often highlight the growing gap in whole-school teaching support for EAL provision. With budget constraints shifting responsibility to classroom teachers, the need for accessible, high-quality CPD has never been greater.  The solution  Grow with FlashAcademy® bridges this gap by offering a blend of online training and expert-led support. Developed with insights from leading EAL experts, our programme addresses the challenges schools face today. We’re creating meaningful change to equip educators with the tools they need to succeed.  Programme tiers We have created three tiers, you can purchase just one tier or a mix depending on your existing knowledge and requirements. Tier 1: Foundations of EAL pedagogy  Tier 2: Advanced pedagogy and assessment (Coming in 2025)  Tier 3: Whole-school systems and strategy (Coming in 2025)  Each tier includes 6 modules (60–90 minutes each), providing over 18 hours of evidence-based CPD.  How it works  1) Learn  Complete each module at your own pace. We recommend completing two modules per term to allow time for the following steps. 2) Reflect  Use the downloadable reflection journal to evaluate your learning and its impact. 3) Implement  Trial strategies in your classroom. 4) Connect  Join one live virtual drop-in session per tier to ask an EAL expert for advice and support.  Meet the experts  Our network of passionate EAL practitioners are ready to support your journey with actionable insights and proven strategies. These experts are an integral part of our mission to drive wider change in EAL provision.  Speakers in this tier include:  Anna Leaman, EAL Specialist and Director, EAL Inclusive. Anna is our programme leader, she'll be your guide throughout the programme. Chris Woodhams, Assistant Campus Principal, OneSchool Global. Soofia Amin, Assistant Head Teacher and Specialist Lead in Education for Multilingualism at Kensington Primary. Ready to get started?  Enrol in Grow with FlashAcademy®. Start building your expertise and refining your school’s EAL action plan today. 

Nursery Nurse: Nursery Nurse Course Online Childcare is one of the most rewarding professions. If you enjoy working with children and assisting them in their development and learning, this Nursery Nurse: Nursery Nurse Course for you. Working with children requires common sense and an understanding of the importance of professionalism and good practice in all that you do. This course will help you to improve your knowledge and understanding of current childcare practice. The Nursery Nurse: Nursery Nurse Course will teach you how to observe and assess young children in the early years setting of a nursery, as well as how to safeguard young children. Complete the Nursery Nurse: Nursery Nurse Course and learn how to keep young children safe and work with special needs children. Why choose this Nursery Nurse: Nursery Nurse Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Nursery Nurse: Nursery Nurse Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Nursery Nurse: Nursery Nurse Course. Courses including with this Nursery Nurse: Nursery Nurse Course bundle Course 01: Nursery Nurse Course 02: Teaching Assistant Course 03: Primary Teaching Diploma Course 04: Early Years Level 4 Course 05: EYFS Teaching Diploma [ Note: Free PDF certificate as soon as completing the Nursery Nurse: Nursery Nurse Course] Nursery Nurse: Nursery Nurse Course Online This Nursery Nurse: Nursery Nurse Course consists of 10 modules. Course Curriculum of Nursery Nurse: Nursery Nurse Course Module 01: Introduction to Nursery Nurse Module 02: Recognizing Children's Growth and Development Module 03: Observation and Assessment of Children in Early Childhood Settings Module 04: Promoting Equality, Diversity and Inclusive Practice in Early Years of Learning Module 05: Safeguarding and Protecting Young Children Module 06: Health and Safety of Children in the Early Years Module 07: Nutrition and Healthy Food for Children Module 08: Play and Learning in Children’s Education Module 09: Working with Children Having Special Needs Module 10: Working in Partnership with Parents and Careers Assessment Method of Nursery Nurse: Nursery Nurse Course After completing Nursery Nurse: Nursery Nurse Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Nursery Nurse: Nursery Nurse Course After completing the Nursery Nurse: Nursery Nurse Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Nursery Nurse: Nursery Nurse Course Online This Nursery Nurse: Nursery Nurse Course is suitable for anyone who wants to: Learn more about a career as a Nursery Nurse. Develop the skills and knowledge needed to work in teaching. Make a career change and explore new career opportunities. Requirements Nursery Nurse: Nursery Nurse Course Online To enrol in this Nursery Nurse: Nursery Nurse Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Nursery Nurse: Nursery Nurse Course. Be energetic and self-motivated to complete our Nursery Nurse: Nursery Nurse Course. Basic computer Skill is required to complete our Nursery Nurse: Nursery Nurse Course. If you want to enrol in our Nursery Nurse: Nursery Nurse Course, you must be at least 15 years old. Career path Nursery Nurse: Nursery Nurse Course Online Opportunities in this Nursery Nurse: Nursery Nurse Course field include: Nursery Nurse Nursery Teacher SEN Teacher Primary Teacher

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Excel - VBA Bootcamp course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FREE Welcome class, introduction to the Foundation and Diploma in Clinical Hypnotherapy and to your journey into the study and practice of Clinical Hypnotherapy. This induction session will give you a Course Overview and show you where to find all you need to support your learning experience. 

Learn how to effectively manage data breaches under GDPR regulations. Discover essential steps, from establishing a response plan to leveraging GDPR Data Protection Consultancy and gap analysis services. Ensure compliance and protect your organization.

Introduction When it comes to academic writing, referencing is crucial. It’s not just about giving credit where it’s due, but also about enhancing the credibility of your work. Among the various referencing styles, Harvard referencing for word essays is one of the most widely used, especially in the UK. But why is it so popular, and how can you master it? Let’s dive in! Understanding Harvard Referencing Harvard referencing is a system of citation that allows you to acknowledge the sources you’ve used in your academic writing. It’s an author-date system, which means you include the author’s surname and the year of publication within the text, and provide full details in a reference list at the end. Despite its name, Harvard references didn’t originate from Harvard University. The style was first used by a zoologist named Edward Laurens Mark in a paper published in 1881. Over time, it has evolved and become one of the most recognized citation styles worldwide. Harvard referencing consists of two main components: in-text citations and a reference list. In-text citations are brief and are placed within the body of your text, while the reference list provides full details of all the sources you’ve cited. The Basics of Harvard Referencing In-text citations in Harvard referencing include the author’s surname and the year of publication. If you’re quoting directly, you should also include the page number. For example: (Smith, 2020, p. 23). The reference list is where you provide full details of each source cited in your work. Each entry should include the author’s name, year of publication, title of the work, and other relevant information, depending on the type of source. A reference list includes only the sources you’ve directly cited in your text, while a bibliography may include all sources you’ve consulted, whether or not you’ve cited them. How to Cite Different Types of Sources When citing a book, you should include the author’s name, year of publication, title (in italics), edition (if applicable), place of publication, and publisher. For example: Smith, J. (2020). The Art of Referencing (2nd ed.). London: Academic Press. Journal articles should include the author’s name, year of publication, title of the article, title of the journal (in italics), volume number, issue number, and page numbers. For example: Brown, A. (2019). ‘Understanding Harvard Referencing’, Journal of Academic Writing, 12(3), pp. 45-67. For websites, include the author (or organization), year of publication (or last update), title of the webpage (in italics), and the URL. For example: University of Oxford. (2021). Harvard Referencing Guide. Available at: https://www.ox.ac.uk/harvard (Accessed: 10 September 2024). When citing a newspaper article, include the author’s name, year of publication, title of the article, title of the newspaper (in italics), date, and page number. For example: Doe, J. (2022). ‘The Future of Academic Writing’, The Times, 5 May, p. 12. For government documents, include the name of the government department, year of publication, title of the document (in italics), place of publication, and publisher. For example: UK Department for Education. (2020). Education Policy Report. London: HMSO. Cite conference papers by including the author’s name, year of publication, title of the paper, title of the conference (in italics), location, and date of the conference. For example: Jones, M. (2023). ‘Innovations in Academic Writing’, International Writing Conference, Manchester, 10-12 April. Harvard Referencing for Electronic Sources When citing e-books, the format is similar to print books, but you should include the format (e.g., Kindle) or the platform where it’s available. For example: Adams, R. (2018). Digital Referencing (Kindle ed.). Available at: Amazon.co.uk. For online journals, follow the same format as print journals, but include the DOI or the URL where the article can be accessed. For example: Taylor, S. (2021). ‘Harvard Referencing in the Digital Age’, Journal of Modern Research, 15(4), pp. 33-50. DOI: 10.1234/jmr.2021.0987. The format for websites remains the same as mentioned earlier, with the inclusion of the URL and the access date. For social media, include the author (or username), year, content of the post (in italics), platform, and the date of the post. For example: @AcademicWriterUK. (2023). The key to successful referencing is consistency. Twitter, 15 March. Advanced Harvard Referencing Techniques When you can’t access the original source and need to cite a secondary source, mention both the original and secondary source. For example: (Smith, 1989, cited in Brown, 2019). For works with multiple authors, list up to three authors in the in-text citation. For more than three, use “et al.” after the first author’s name. For example: (Jones, Smith, and Brown, 2020) or (Jones et al., 2020). If you’re citing different editions of a book, mention the edition in your reference. For example: Brown, A. (2018). Theories of Learning (3rd ed.). Oxford: Oxford University Press. If some information is missing, like the author or date, use “Anon.” for anonymous authors and “n.d.” for no date. Common Harvard Referencing Mistakes and How to Avoid Them Incorrect formatting can easily occur if you’re not careful. Make sure to follow the correct structure for each type of source, as this can significantly impact your grade. Leaving out essential details like the author’s name or the year of publication is a common mistake. Always double-check your references before submitting your work. Punctuation is crucial in Harvard referencing. Misplacing a comma or period can change the meaning of your citation. Pay attention to the details! Tools and Resources for Harvard Referencing Online citation generators can save you time, but be cautious—always double-check the generated citations for accuracy. Tools like EndNote or Zotero can help you manage your references and ensure consistency throughout your work. Many universities provide specific guidelines for Harvard referencing. Always refer to your institution’s guidelines to ensure you’re following the correct format. The Importance of Consistency in Harvard Referencing Consistency is key in Harvard referencing. Uniformity in your citations not only makes your work look professional but also enhances readability. Inconsistent referencing can confuse readers and may lead to a lower grade. Make sure your citations follow a consistent style throughout your work. Tips for Mastering Harvard Referencing Always double-check your references before submission. Small errors can add up and impact your overall grade. Keep a record of all the sources you consult. This will make it easier to create your reference list and avoid missing any citations. Using a Harvard style guide can help ensure that you’re following the correct format. It’s a handy tool for quick reference. Conclusion Mastering Harvard referencing may seem daunting at first, but with practice and attention to detail, it becomes second nature. Remember, proper referencing not only supports your arguments but also adds credibility to your work. So, take your time, be consistent, and use the resources available to you.

11-in-1 Premium Bundle | CPD QS Certified | 110 CPD Points | Free Hardcopy + PDF Certificate + Exam | Lifetime Access