Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist
Report Writing Course Overview This comprehensive course in report writing is designed to equip learners with the skills needed to write clear, structured, and effective reports in any professional setting. Covering essential topics such as planning, research, writing, and presentation, the course provides a solid foundation for producing high-quality reports. Learners will develop an understanding of grammar, punctuation, and the use of visual aids, such as tables and graphs, to enhance their reports. By the end of the course, participants will have the ability to create well-structured, concise, and informative reports suited to various industries. Course Description The course delves into the core principles of report writing, beginning with an introduction to the basics and progressing through the stages of planning, preparation, and writing. Learners will explore research techniques and how to collect relevant information effectively. Emphasis is placed on developing an organised structure for reports and revising for clarity and accuracy. The course also covers the technical aspects of grammar and punctuation, the inclusion of visual data, and proposal writing, enabling learners to present their findings professionally. With guidance on creative thinking, learners will refine their ability to approach report writing with a strategic mindset, ensuring their work is impactful and relevant in any workplace. Report Writing Curriculum Module 01: The Basics of Report Writing Module 02: Planning for Report Writing Module 03: Preparation for Report Writing Module 04: Research and Information Collection Module 05: Writing and Revising the Report Module 06: English Grammar and Punctuation Guide for Report Writing Module 07: Using Tables, Charts and Graphs in a Report Module 08: Proposal Writing Module 09: Presentation of the Report Module 10: Developing Creative Thinking and Creativity Module 11: Quick Check While Writing a Report (See full curriculum) Who is this course for? Individuals seeking to improve their report writing skills. Professionals aiming to enhance their report presentation abilities. Beginners with an interest in learning effective report writing. Those wishing to develop the skills necessary for clear communication in the workplace. Career Path Report Writer Business Analyst Technical Writer Project Manager Administrative Support Research Assistant
This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.
Are you looking for a way to manage your projects more efficiently and effectively? Do you want to learn how to use Microsoft Project, one of the most popular and powerful project management tools in the world? If so, this online course is for you! In this course, you will learn how to create, update, and share project plans using Microsoft Project. You will also learn how to use the social media features of Microsoft Project to collaborate with your team members, stakeholders, and clients. You will discover how to: - Set up a project and enter tasks, durations, dependencies, and resources - Track the progress and performance of your project using various views and reports - Adjust your project plan to deal with changes, risks, and issues - Export your project data to Excel, PowerPoint, or Word This course is suitable for anyone who wants to learn how to use Microsoft Project for project management, whether you are a beginner or an intermediate user. You will need access to a computer with Microsoft Project installed (any version from 2013 to 2021) and an internet connection. You will also need a Microsoft account to use the social media features of Microsoft Project. By the end of this course, you will be able to create and manage project plans using Microsoft Project and leverage the power of social media to enhance your project communication and collaboration. Enrol today and take your project management skills to the next level!
Discover how to effectively reduce gas flaring and monetize resources with EnergyEdge's specialized course. Enroll now!
Through this course, you will learn how to arrange Kafka a producer and consumer and Kafka Streams and Connectors accurately. You will also gain the skills needed to coordinate Kafka with existing application stages and to pass the Apache Kafka certification exam.
Unlock the full potential of product management with our comprehensive course. Dive deep into product management fundamentals, Agile methodologies, and gain hands-on experience with essential project management tools, including Trello, Jira, Microsoft Teams, Planner, and ChatGPT. Elevate your career and drive success in the digital age.
Course Information Join our comprehensive course, meticulously designed to equip individuals implementing Good Clinical Laboratory Practice (GCLP) within laboratories handling samples from clinical trials. Delve into the current regulatory landscape governing laboratory work supporting clinical trials, referencing key guidelines such as the ICH Guideline for Good Clinical Practice, the Clinical EU Trials Directive, relevant regulations, and leveraging insights from the RQA guidance document on GCLP. Is this course for you? This course is tailored for laboratory managers, analysts, investigators, trial coordinators, monitors, and auditors operating in diverse settings such as pharmaceutical company laboratories, central laboratories, contract research organisations, hospital laboratories, clinics, and investigator sites. This course will give you: Guidance on effectively interpreting and applying GCLP within the broader framework of Good Clinical Practice (GCP) Insight into the seamless integration of GCLP within clinical programmes (GCP) Practical strategies for implementing GCLP in the nuanced environment of clinical research laboratories The chance to update your knowledge with the latest interpretations and guidance on clinical laboratories by the UK Medicines and Healthcare Products Regulatory Agency (MHRA) Access to a seasoned panel of speakers with extensive expertise A unique opportunity to deepen your understanding of GCLP's application across diverse scenarios. Engage in: Lively discussions to foster ideas Problem-solving sessions targeting specific challenges Detailed exploration of specific aspects within the realms of GCP and GCLP. Tutors Tutors will be comprised of (click the photos for biographies): Vanessa Grant -, - Louise Handy Director, Handy Consulting Ltd Tim Stiles Consultant, Qualogy Ltd Programme Please note timings may be subject to alteration. Day 1 08:50 Registration 09:00 Welcome and Introduction 09:20 Good Clinical Practice and the Requirements of Good Clinical Laboratory Practice A review of Good Clinical Practice and its requirements for the laboratory analysis of samples from a trial. The thought processes behind the development of Good Clinical Laboratory Practice, its objective, scope, interpretation and application are explained. 10:00 Safety and Ethical Consideration Informed consent, confidentiality, expedited reporting, blinding and unblinding and serious breaches of the GCP are discussed. 10:40 Break 10:55 Organisation and Personnel Responsibilities within GCP and the Laboratory The responsibilities of key functions that should exist within a clinical laboratory including personnel records of training and competence are discussed. 11:30 Staff Training and Training Records Personnel records of training and competency assessments are discussed. 11:45 Laboratory Facilities, Equipment and Materials Suitable facility design, organisation and operation will be discussed. The calibration, validation and maintenance of equipment used in the conduct of sample analysis are examined, as are the suitability of materials and the identification and labelling of reagents and solutions. 12:30 Lunch 13:15 Workshop 1 - Facilities, Equipment and Responsibilities Some practical problems with regard to the facilities, equipment and responsibilities are explored. 13:45 Workshop 1 - Feedback 14:15 Computer Systems Validation Systems, including computerised systems, used in the analysis, collection and reporting of results should be appropriately tested, operated and controlled. What this means in practice is discussed. 14:45 Trial Protocols, Analytical Plans During this session we examine the purpose, content, control and change of these important documents. 15:30 Break 15:45 Workshop 2 - SOPs, Clinical Protocols, Analytical Plans and Validation The practicalities of managing and documenting the planning phase of analytical work on a trial are explored along with computerised system validation. 16:30 Workshop 2 - Feedback 17:00 Close of Day Day 2 09:00 Conduct of the Work and Quality Control Many of the issues that surround the conduct of sample collection, shipment, storage, analysis and management of Analytical Methods are discussed. This includes the quality control of the assay that may be employed and Quality Control checks. 10:00 Deviation Management The expectations around deviations and CAPA are discussed. 10:15 Workshop 3 - Conduct of the Work and Quality Control Practical work conduct and quality control issues are explored. 10:45 Break 11:00 Workshop 3 - Feedback 11:30 Source Data, Data Integrity, Records and Reports The creation and subsequent management of source data and records, data integrity, are discussed, together with the process of reporting analytical results. 12:10 Workshop 4 - Data, Records and Reports Practical problems with data, records and reports are investigated. 12:45 Lunch 13:30 Workshop 4 - Feedback 14:00 Quality Audit The requirements for and purpose of quality audits are discussed. The difference between quality audit and quality control are explained along with the role of the quality audit staff and their interaction with the analytical project managers, laboratory management and study staff. 14:40 Risk Management How should we assess risk and how can we use the process to assist in evaluation of audit findings. 15:15 Break 15:30 Regulatory Inspection The conduct of regulatory inspections and current expectations of the inspectors. Preparation for inspections and conduct during them will be discussed. 16:00 Panel Session This panel session will address any outstanding issues raised by the delegates. 16:15 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 14 Points Development Level Develop
Course Overview This advanced-level Project Management Level 7 course offers comprehensive training designed to develop strategic thinking, leadership acumen, and organisational proficiency. Covering the essential principles of professional project delivery, the course aligns with international frameworks such as PMBOK and PMI standards, giving learners a solid foundation in high-level project management methodologies. From global project execution to risk and quality management, participants will gain the skills to oversee complex initiatives, manage cross-functional teams, and navigate dynamic business environments. Emphasis is placed on critical areas such as change management, performance evaluation, and crisis response. By the end of the course, learners will be prepared to assume leadership roles in project-driven environments across diverse industries, demonstrating competency in managing time, resources, stakeholders, and strategic outcomes with confidence and clarity. Course Description This Level 7 course delves into advanced project management theories and practices, equipping learners with essential knowledge across the entire project lifecycle. Starting with foundational concepts and extending to global project frameworks, the curriculum includes modules on time, resource, and quality management, along with strategic planning, communication, and procurement. Learners will explore techniques for managing stress, conflict, and team performance, while also developing crisis response strategies and resilience planning. A strong focus is placed on leadership and stakeholder engagement, enabling participants to drive results through effective coordination and planning. Each module is structured to build critical thinking and decision-making capabilities suited for high-level responsibilities. By engaging with industry-relevant case studies and strategic planning exercises, learners will graduate with the insight required to lead organisational change, oversee multifaceted projects, and ensure long-term success within both public and private sectors. Course Modules: Module 01: Introduction to Project Management Module 02: PMBOK and PMI Module 03: Global Project Management Module 04: Project Life Cycle Module 05: Time Management Module 06: Quality Management Module 07: Effective Planning & Scheduling Module 08: Human Resource Management Module 09: Performance Management Module 10: Talent Management Module 11: Organising Meeting and Conferences Module 12: Managing Resources Module 13: Change Management Module 14: Business Resilience and Crisis Management Module 15: Conflict Management Module 16: Stress Management Module 17: Communication Skills Module 18: Procurement & Purchasing Management Module 19: Risk Management (See full curriculum) Who is this course for? Individuals seeking to progress into senior-level project roles. Professionals aiming to formalise their project management expertise. Beginners with an interest in leadership and organisational management. Team leaders or coordinators aspiring to manage large-scale projects. Career Path Project Manager Programme Director Business Change Manager Risk and Compliance Officer Operations Manager Strategic Planning Consultant Procurement and Contracts Manager Portfolio Manager Crisis and Resilience Coordinator
Agile Scrum Master Course Overview This Agile Scrum Master course offers a comprehensive introduction to Agile methodologies with a particular focus on the Scrum framework. Learners will gain a clear understanding of Scrum principles, roles, events, and artefacts, enabling them to effectively support and lead Agile teams. The course emphasises the evolution from traditional development models to Agile, ensuring participants grasp how Scrum drives flexibility and continuous improvement. Designed to enhance both knowledge and leadership capabilities, it prepares learners for professional certification while equipping them with skills to improve team collaboration and project delivery efficiency. Upon completion, learners will be confident in facilitating Scrum processes, managing sprint cycles, and applying Agile metrics to monitor progress. Course Description This course delves into the essential concepts of Agile Scrum, starting with its foundational objectives and the transition from traditional project management to Agile approaches. Detailed exploration of the 2020 Scrum Guide updates helps learners stay current with industry standards. The curriculum covers the structure and responsibilities of Scrum teams, the cadence of Scrum events, and the purpose of Scrum artefacts. Additionally, it addresses the challenges of scaling Scrum for larger projects and incorporates advanced topics such as Agile requirements gathering, estimation techniques, and performance metrics. The learning experience is structured to build a thorough understanding of Agile frameworks, preparing learners for the Professional Scrum Master (PSM1) certification with guidelines and strategic tips. This course is ideal for those aiming to enhance their Agile knowledge and leadership within diverse professional environments. Agile Scrum Master Curriculum Module 01: Objectives and Targets Module 02: From the Traditional Development Model to the Agile Module 03: 2020 Scrum Guide: What’s New! Module 04: Bonus: Full eBook of the Course! Module 05: Scrum Module 06: The Scrum Team Module 07: Scrum Events Module 08: Scrum Artifacts Module 09: Scaling Scrum Module 10: Scrum in Practice! Module 11: Agile Requirements Module 12: Estimation Techniques Module 13: Agile Metrics Module 14: PSM1 Certification Preparation Guidelines, Tips & Tricks (See full curriculum) Who is this course for? Individuals seeking to master Agile Scrum principles and practices. Professionals aiming to advance their career in Agile project management. Beginners with an interest in Agile frameworks and team leadership. Project managers, team leads, and business analysts wanting to implement Scrum. Career Path Scrum Master in IT and software development teams. Agile Project Manager in various industries. Product Owner or Agile Team Facilitator roles. Consultant specialising in Agile transformation and coaching.