32706 Courses

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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 PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

***24 Hour Limited Time Flash Sale*** GDPR , Compliance & Information Management Level 3, 5 & 6 at QLS Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unleash your potential in the crucial sectors of GDPR, Compliance, and Information Management with our comprehensive course bundle. Included in this unique bundle are three Quality License Scheme (QLS) endorsed courses that provide you with an in-depth understanding of GDPR basics, compliance certification, and information management. To authenticate your learning journey, you'll receive a hardcopy certificate upon completion of these QLS-endorsed courses, marking a noteworthy milestone in your professional development. But that's not all; this course bundle also incorporates five relevant Continued Professional Development (CPD) Quality Standard (QS) accredited courses. These cover important topics like Anti-Money Laundering (AML), Know Your Customer (KYC) guidelines, Cyber Security Awareness, Cyber Law, and Security Management. Equip yourself with this comprehensive GDPR, Compliance & Information Management course bundle and stay ahead in a world that increasingly values data protection and regulatory compliance. Key Features of the GDPR, Compliance & Information Management Level 3, 5 & 6 at QLS Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our GDPR, Compliance & Information Management Level 3, 5 & 6 at QLS bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Data Protection : GDPR Basics QLS Course 02: Certificate in Compliance QLS Course 03: Information Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Anti-Money Laundering (AML) Training Course 02: KYC Course 03: Cyber Security Awareness Training Course 04: Cyber Law Online Course Course 05: Security Management Diploma In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our GDPR, Compliance & Information Management Level 3, 5 & 6 at QLS courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the GDPR, Compliance & Information Management Level 3, 5 & 6 at QLS Bundle: By the end of this GDPR, Compliance & Information Management bundle course, learners will be able to: Understand the essentials of the General Data Protection Regulation (GDPR). Gain theoretical knowledge of compliance and its significance in businesses. Learn about the intricacies of Information Management. Gain insights into Anti-Money Laundering (AML) measures. Understand the importance of Know Your Customer (KYC) guidelines. Develop awareness about Cyber Security and its importance in the digital age. Gain insights into the essentials of Cyber Law. Understand the principles of Security Management. The GDPR, Compliance & Information Management Level 3, 5 & 6 at QLS bundle offers a wide spectrum of knowledge across several key domains. It empowers you with a fundamental understanding of the GDPR, taking you through its importance in the digital era, and ensuring data protection. The bundle also includes a course on Compliance, which deepens your knowledge of maintaining organisational standards and regulations. The Information Management course provides insights into managing and utilising information effectively in a business setting. Moreover, the bundle also includes relevant CPD QS accredited courses like AML Training and KYC, offering a thorough understanding of financial regulations and customer verification processes. Further, it encompasses courses like Cyber Security Awareness Training, Cyber Law, and Security Management Diploma, amplifying your understanding of the digital security landscape. This comprehensive course bundle promises a thorough theoretical understanding, preparing you for the next steps in your career journey. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This GDPR, Compliance & Information Management bundle course is ideal for: Individuals aspiring for a career in data protection, compliance, or information management. Professionals in the IT or finance sector seeking to enhance their theoretical knowledge. Students studying law, finance, or related fields. Anyone with a keen interest in understanding the legal and regulatory aspects of data management. Career path GDPR Compliance Officer - Salary range in the UK: £25,000 - £55,000 per year Compliance Officer - Salary range in the UK: £26,000 - £60,000 per year Information Management Specialist - Salary range in the UK: £30,000 - £70,000 per year AML Analyst - Salary range in the UK: £30,000 - £55,000 per year Cyber Security Analyst - Salary range in the UK: £30,000 - £70,000 per year Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Duration 2 Days 12 CPD hours This course is intended for Delegates should be PC literate, i.e., familiar with PC'S/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; manage files and folders and be comfortable using Microsoft Office applications such as MS Excel, MS Word etc. Overview The purpose of this course is to provide delegates with the practical skills to build and manage project schedules. It is designed to provide techniques and tips that will help users of the software apply it as a powerful tool to develop competent and unambiguous schedules - while avoiding some of the traps associated with the incorrect application of scheduling features. Techniques learned will also facilitate communicating deliverables and milestones to project stakeholders. This course covers management practices and methodologies and an in-depth knowledge of MS Project functionality. Delegates will be able to create and manage project schedules during the course and reinforce attained skills through practical applications. Project Management Overview Concepts of project management and scheduling The project lifecycle and phases Fundamental importance of defining ? and agreeing ? project scope Developing a Work Breakdown Structure (WBS) to define project scope 4 steps to create a schedule based on the WBS Understanding task dependencies Understanding the concept of the project baseline Developing a Project Schedule Setting the ?Scheduling Mode? Creating Tasks, Recurring Tasks (e.g. progress or review meetings) and Milestones Defining task Dependencies Applying Lag and Lead Time Working with the Critical Path Managing Tasks in the schedule Add Notes and attach project documents to tasks Setting and removing task Constraints and Deadlines Applying the ?Task Path? feature to view dependencies Working with Resources Creating a Resource Pool Working with Resource Calendars Creating Team/Group Calendars Understanding Effort Driven and Non-Effort Driven scheduling Assigning Resources to tasks Working with Project Costs Managing Project Information Applying Field, Tables and Views Applying Filters and Groups Creating custom Fields, Tables and Views (Drop-down menus, Traffic Light reports, Flag Fields) Using the ?Organiser? feature for customised elements Communicating Project Information Applying formats to Views and Tables Using the ?Copy Picture? command Create and Print Project Reports Exporting to Excel Managing Resources Finding Resource Overallocations Resolving Overallocations (reassigning, splitting tasks, utilising float, changing work contours) Applying Resource Levelling features Tracking Progress Setting the Project Baseline Applying the Tracking Gantt and Tracking Table Using the ?Mark on Track? and ?Update Tasks? features Working with Dashboards and Burndown Reports Programme Management Methods to consolidate multiple Project Files Resource sharing - setting up a Master Resource Pool Creating and managing Master Project Files

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Project Administration bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Construction Project Administration related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Project Administration bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Project Administration Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Construction Industry Scheme (CIS) Course 2: Property Development Diploma Course 3: Property Management Training Course 4: Real Estate Investor Level 3 Course 5: Public Housing Management Course 6: Construction Management - Level 5 Diploma Course 7: Customer Service Course 8: Document Control and Management Course 9: Fundraising Course 10: Environmental Law & Impact Assessment Course 11: Working at Height Course 12: Effective Communication Skills for Technical People Course 13: Leadership & Management Course 14: Leadership Styles Course 15: Building Surveyor Course 16: Property Law Course 17: Contracts Law UK Course 18: Decision Making in High Stress Course 19: Contract Management Training UK Course 20: Property Business Training - Level 5 Course 21: Residential Property Sales Course 22: Land Surveyor Course 23: Cost Estimation for Multiplex Building with Xactimate Course 24: UK Land Management Complete Training Course 25: Public Speaking Skills - CPD Accredited 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Construction Project Administration bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Project Administration Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Project Administration bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Project Administration Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

>> Deal Price is Active Now! Save: £403 GBP! Offer Ends Soon, Hurry Up!! << Special Course : Made Exclusively for Lucrative Career Optimists This provides an excellent opportunity to gain the skills and knowledge you'll need to advance in your career. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. This will provide you with the right CPD Accredited qualifications that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get notice by a prospective employer and stand out from the crowd. This has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take the course is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.. Why choose UK Employment Law? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover on the Course: Module 01: Basics of Employment Law What is Employment Law Purpose Individuals the Law Covers The entity the Law Covers Module 02: Legal Recruitment Process Recruitment & the Equality Act 2010 Ways to Avoid Unlawful Discrimination in Recruitment Employers' Legal Duties Employees' Duties The Main Legal Issues Advertising for a Job Application Form Shortlisting Interviews Adjustments for Candidates with Disabilities Selection Automated Decision-making Making an Offer of Employment Carrying out Checks on Potential Employees Restrictions on the Employment of Children and Young Persons Employers' Guide to Criminal Record Checks Module 03: Employment Contracts Written Statement 2020's Law Regarding Employment Contracts Type of Contracts Contents of Lawful Employment Contracts The Risk of Not Giving a Written Employment Contract on Day-one Module 04: Employee Handbook Staff Handbooks A Written Statement by the Law Mandatory Information in a Statement Content of a Lawful Employee Handbook Related Written Policies Supporting Statutory Rights Module 05: Disciplinary Procedure A Fair Disciplinary Procedure A Fair Investigation A Fair Disciplinary hearing A Fair Penalty Right of Appeal ACAS guidelines Module 06: National Minimum Wage & National Living Wage The National Minimum Wage 2020 Calculating the National Minimum Wage Pay Reference Period (PRP) Training On-call or standby time Keeping Record of the Working Hour Module 07: Parental Right, Sick Pay & Pension Scheme Pregnant Employees' Rights Statutory Maternity Leave Statutory Maternity Pay (SMP) Statutory paternity Leave Statutory Paternity Pay (SMP) Statutory Adoption Pay and Leave Statutory Parental Bereavement Pay and Leave Statutory Sick Pay (SSP) Workplace Pension Scheme Module 08: Discrimination in the Workplace Discrimination & Equality Act 2010 Medical Condition Regarding Disability Disability Discrimination Failure to Make Reasonable Adjustments Areas of Reasonable Adjustments Sex Discrimination Sexual Orientation Discrimination Race Discrimination Module 09: Health & Safety at Work The Health and Safety at Work Act 1974 Role of Health & Safety Representative Smoking Law at Work Suspensions from Work for Medical Reasons Workplace Temperatures Module 10: Dismissal, Grievances and Employment Tribunals Necessary Paperwork to Face Employment Tribunal Claim Types of Dismissal Grievance Procedure Employment Tribunal hearings Module 11: Workplace Monitoring & Data Protection Data Protection principles Rights Under the Data Protection Act 2018 Personal Data an Employer Can Keep about an Employee What an Employer Should Inform an Employee Assessment Process Once you have finished the learning stages in the course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? The course has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the UK Employment Law. Enrol on the course and learn a new professional skill from anywhere, at any time! Requirements Enrol on the course with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the course without any delay. We only ask that all students have a passion for learning and literacy, and be over the age of 16. Complete the course from your computer, tablet, or smartphone, and learn in a way that suits you. Career path After completing this course, you are to start your career or begin the next phase of your career in this field. Our entire course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Course Information Our comprehensive course is used as a gateway to those stepping into the world of auditing clinical studies. Tailored for those already acquainted with Good Clinical Practice (GCP) and those transitioning from other audit disciplines, this programme stands as a pivotal guide. Pre-existing knowledge of GCP will significantly enhance your learning experience in auditing against these guidelines. How is this course run? Engage in immersive workshops providing hands-on practice with auditing techniques in a GCP context. Our seasoned tutors, boasting extensive audit experience, intertwine theory with practical insights drawn from their own professional journeys. What will I learn? A comprehensive understanding of the historical backdrop and objectives driving Good Clinical Practice, incorporating the latest industry developments Solid grounding in quality assurance activities aligned with regulatory standards Insight into potential pitfalls within clinical trials and the pivotal role of auditors in addressing these issues Clarity on the roles and responsibilities inherent to clinical trials auditing Exposure to a diverse range of audit techniques complemented by illustrative examples and supportive documents A nuanced understanding of regulatory inspectors' activities Expanded professional networks to propel your auditing career forward. Benefits include: A clear understanding of the role of the auditor under Good Clinical Practice improved audits Improved Good Clinical Practice compliance for your clinical trials. This course is structured to encourage delegates to: Discuss and develop ideas Solve specific problems Examine particular aspects of Good Clinical Practice. Tutors Tutors will be comprised of (click the photos for biographies): Rosemarie Corrigan EVP Global Quality, Worldwide Clinical Trials Cathy Dove Director and Owner, Dove Quality Solutions Julie Kelly Associate Director, Clinical Quality Assurance, Corcept Therapeutics Susana Tavares Director of Research Quality Assurance, - Programme Please note timings may be subject to alteration. Day 1 12:30 Registration 13:00 Welcome and Objectives for the first day of the course 13:30 Laying the Foundations Introduction to the clinical development process, the concepts of quality assurance, quality control and audit. 14:30 Break 15:00 Patient Protection Requirements for informed consent and ethics committee. Access to source documentation. Including a patient protection exercise. 16:05 Workshop 1 - Case Study on Informed Consent 16:45 End of Day Questions and Answers 17:00 Close of Day Day 2 08:50 Questions and Answers from Day 1 09:00 Effective Site Audits The procedures involved in selecting and setting up audits at investigator sites. 09:40 Workshop 1 - Planning the Effective Audit 10:30 Break 10:45 Source Data Verification The need for and purpose of verifying data. 11:25 Workshop 2 - Source Data Verification 12:30 Lunch 13:30 IMP Management The requirements surrounding the distribution of investigational medicinal products. Accountability from release to destruction. 14:15 Critical Document Audits The conduct of other study specific audits including protocols, databases and reports. 15:00 Break 15:15 Non-compliance Determining the acceptability of data. 16:00 Fraud - Fact or Fiction? How to identify fraud and its consequences 16:45 End of Day Questions and Answers 17:00 Close of Day Day 3 08:50 Questions and Answers from Days 1 and 2 09:00 Auditing Third Parties A review of audits of contract research organisations. 10:00 System Audits The concept of auditing processes across many clinical trials, including a practical exercise in process mapping. 10:45 Break 11:00 Workshop 3 - Process Mapping 11:45 Effective Audits Where theory meets reality. 12:30 Lunch 13:20 Audit Reports - Closing the Loop An examination of the processes which follow the evidence gathering phase of the audit. 14:20 Workshop 4 - Audit Reports Audit reports, corrective and preventive action. 15:00 Break 15:10 Regulatory Inspection Auditors and regulatory inspections -how the QA team can help the organisation to perform during a regulatory inspection. 15:55 Final Questions and Answers 16:10 Close of Course Extra Information Face-to-face course Course Material Course material will be available in PDF format for delegates attending this course. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course. The material will be emailed in advance of the course and RQA will not be providing any printed copies of the course notes during the training itself. Delegates wishing to have a hard copy of the notes should print these in advance to bring with them. Alternatively delegates are welcome to bring along their own portable devices to view the material during the training sessions. Remote course Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 17 Points Development Level Develop

Level 2 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access