Discover the powerful schedule and cost risk analysis features of PRA. Course overview Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives By the end of the course you will be able to: Import schedules into PRA Add three point estimates onto plans Perform schedule and cost analysis Use templated quick risk Run risk analysis Interpret results from the Risk Histogram and Tornado graph Add task percentiles to a Gantt chart Set up a risk register Add qualitative and quantitative risks Link risk to activities in the plan Create reports Use the Distribution Analyser Content Importing schedules Importing MSP and Primavera Schedules Running import checks Checking schedule integrity Schedule risk analysis 3 point estimating Entering uncertainly Different distributions Using quick risk Updating plan Importing plans with 3 point estimates Cost/Resource uncertainty Resource loadings Creating 3 point cost estimates Resource distributions and escalations Simple cost estimates Templated quick risk Setting up and applying templated quick risk Assessing risk at WBS level Running risk analysis Running risk analysis Interpreting results on the Risk Histogram Setting analysis options Task percentiles Setting task percentile options Including task percentiles on the Gantt chart Tornado graph Creating a Tornado graph Viewing sensitivity Analysing sensitivity against activities Setting up the risk register Setting Schema levels Defining criteria and tolerances Setting up a Risk Breakdown Structure (RBS) Working with manageability and proximity Saving scoring matrices Adding custom fields Exporting data Exporting to Excel, Word and PowerPoint Qualitive risks Setting risk IDs Adding risk cause, description and effect Setting up risk details Entering mitigation actions Quantitative risks Linking risks to activities Adding schedule and cost impacts Defining how multiple risks impact Correlation Migrating your plan Adding mitigation actions to your plan as tasks Linking tasks to mitigation actions Actioning your risk register Progressing risks Importing progressed plans Linking register to progressed plans Risk history The Waterfall chart Saving and reporting Exporting the risk register Running reports Creating new reports Building and comparing risk plans Using the distribution analyser Comparing dates and cost
Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code
Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables
Course Overview: Human Rights Consultant Certification As societies strive for equality and justice, understanding human rights principles and their practical applications becomes increasingly vital. The 'Human Rights Consultant' course offers a comprehensive journey into the realm of human rights, equipping participants with the knowledge and skills necessary to advocate for and implement human rights principles effectively. This course is designed for individuals passionate about human rights, including activists, lawyers, policymakers, and professionals in various fields seeking to integrate human rights into their work. Module 1: Introduction to Human Rights In this foundational module, participants will explore the origins, evolution, and philosophical underpinnings of human rights. They will examine key documents such as the Universal Declaration of Human Rights and learn about the core principles and concepts that form the basis of human rights law and practice. Module 2: Practical Applications of Human Rights Building upon the theoretical foundation laid in Module 1, this module delves into real-world applications of human rights principles. Participants will learn how to identify human rights violations, analyze case studies, and develop strategies to address human rights issues in diverse contexts, including conflict zones, marginalized communities, and corporate settings. Module 3: Human Rights Advocacy and Activism Effective advocacy and activism are essential for promoting and protecting human rights. In this module, participants will gain practical skills in advocacy techniques, community organizing, coalition building, and leveraging social media and other platforms to raise awareness and mobilize support for human rights causes. Module 4: Human Rights and Business Businesses have a significant impact on human rights, both positively and negatively. This module examines the intersection of human rights and business, focusing on corporate social responsibility, supply chain management, labor rights, and the role of businesses in advancing human rights principles within their operations and beyond. Module 5: Human Rights and International Law International law serves as a critical framework for the protection and enforcement of human rights. Participants will explore the international legal mechanisms and institutions responsible for upholding human rights, including the United Nations, regional human rights bodies, and international courts. They will also analyze landmark human rights cases and treaties. Module 6: Human Rights and Climate Change Climate change poses profound threats to human rights, including the right to life, health, food, and shelter. In this module, participants will examine the nexus between human rights and environmental sustainability, exploring topics such as climate justice, environmental rights, indigenous rights, and the role of states and international actors in addressing climate-related human rights challenges. Certification and Beyond Upon successful completion of all modules and assessments, participants will receive a certification as a Human Rights Consultant, validating their expertise in understanding, promoting, and defending human rights. Graduates of the course will join a global network of human rights advocates and professionals, equipped to make a meaningful impact in their communities and beyond. Additionally, the course provides a solid foundation for further study or specialization in human rights law, policy, or advocacy. Course Curriculum Module 1_ Introduction to Human Rights Introduction to Human Rights 00:00 Module 2_ Practical Applications of Human Rights Practical Applications of Human Rights 00:00 Module 3_ Human Rights Advocacy and Activism Human Rights Advocacy and Activism 00:00 Module 4_ Human Rights and Business Human Rights and Business 00:00 Module 5_ Human Rights and International Law Human Rights and International Law 00:00 Module 6_ Human Rights and Climate Change Human Rights and Climate Change 00:00
Understand the Terminology of Modern Project Management with this Handy Guide and Glossary
This course explores Autism and the current body of thinking and knowledge around Autistic Spectrum Disorders. This enables learners to consider how to adapt their practice with useful strategies to better support an individual with autism.
Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App
Introducing the 'Diploma in Aviation Human Factors and Crew Resource Management' Unlock the keys to safer and more efficient aviation operations with our comprehensive Diploma program in Aviation Human Factors and Crew Resource Management (CRM). This specialized curriculum is meticulously crafted to equip aviation professionals with the critical knowledge and skills necessary to enhance safety, minimize human error, and optimize crew performance. Module 1: Introduction to Aviation Human Factors and CRM Embark on your journey with a solid foundation in the principles of Aviation Human Factors and Crew Resource Management. Understand the fundamental concepts that shape the interaction between humans and aviation systems. This module lays the groundwork for the subsequent specialized topics, setting the stage for a holistic approach to safety and efficiency in the aviation industry. Module 2: Organizational Factors in Aviation Human Factors and CRM Delve into the organizational aspects that influence human performance in aviation. Learn how organizational structures, culture, and management practices impact crew dynamics and overall safety. Develop strategies to create a culture that fosters open communication, accountability, and continuous improvement. Module 3: Human Factors in Aviation Accidents and Incidents Examine real-world case studies to gain insights into the role of human factors in aviation accidents and incidents. Analyze the contributing factors and develop a deep understanding of how human errors can lead to adverse outcomes. Equip yourself with the knowledge to identify potential risks and implement proactive measures to prevent incidents. Module 4: Crew Resource Management Master the art of effective team collaboration with a focus on Crew Resource Management. Explore communication techniques, leadership skills, and teamwork strategies essential for optimizing crew performance in diverse and challenging aviation environments. Acquire the tools to mitigate conflicts and enhance decision-making within the crew. Module 5: Situational Awareness Sharpen your ability to perceive, comprehend, and project situational awareness in dynamic aviation scenarios. Understand the factors that influence situational awareness and learn to maintain a high level of awareness to make timely and informed decisions. Cultivate the skills necessary to stay ahead of the complexities inherent in aviation operations. Module 6: Decision Making Navigate the complexities of decision-making in aviation with a focus on critical thinking and problem-solving. Develop the ability to make sound decisions under pressure and uncertainty. Explore decision-making models and scenarios that are relevant to the aviation industry, ensuring that you are well-prepared to handle challenges with confidence. Why Choose Our Diploma Program? Expert Faculty: Learn from industry experts and experienced professionals who bring real-world insights to the classroom. Interactive Learning: Engage in practical simulations, case studies, and interactive exercises to reinforce theoretical knowledge. Global Recognition: Enhance your credentials with a diploma that is recognized globally, opening doors to career opportunities worldwide. Career Advancement: Equip yourself with the skills and knowledge demanded by the aviation industry, positioning yourself for career growth and advancement. Enroll in our Diploma in Aviation Human Factors and Crew Resource Management today and elevate your career to new heights. Safety, efficiency, and excellence await! Course Curriculum Module 1_ Introduction to Aviation Human Factors and CRM Introduction to Aviation Human Factors and CRM 00:00 Module 2_ Organizational Factors in Aviation Human Factors and CRM Organizational Factors in Aviation Human Factors and CRM 00:00 Module 3_ Human Factors in Aviation Accidents and Incidents Human Factors in Aviation Accidents and Incidents 00:00 Module 4_ Crew Resource Management Crew Resource Management 00:00 Module 5_ Situational Awareness Situational Awareness 00:00 Module 6_ Decision Making Decision Making 00:00
Project Management Template Kit and Checklists
Attracting candidates and matching them to temporary or permanent job positions with client companies.