Project Selection with Google Sheets (Coursera)

Project Selection with Google Sheets (Coursera)

Project Selection is a critical aspect of Project Management. In an ideal world, organizations can initiate an unlimited number of projects. However, in the real world where organizations have limited resources (time, money, personnel, materials…) only a few projects, in most cases the projects deemed most beneficial are selected for initiation. There are numerous Project Selection Techniques organizations utilize to determine the most beneficial projects.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

In this Guided Project, we will use Google Sheets to analyze six (6) common Project Selection Techniques and complete a Project Selection Case Activity.

In this Guided Project, you will:
-Learn how to perform Six Quantitative Project Selection Techniques.

Learn step-by-step

  1. INTRODUCTION
  2. NET PRESENT VALUE (NPV)
  3. INTERNAL RATE OF RETURN (IRR)
  4. BENEFIT COST RATIO (BCR)
  5. PAYBACK PERIOD
  6. RETURN ON INVESTMENT (ROI)
  7. WEIGHTED SCORING MOD
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Herramientas de gestión de proyectos de desarrollo (Coursera) Coursera
Inter-American Development Bank - IDB

Herramientas de gestión de proyectos de desarrollo (Coursera)

¿Conoces el valor de utilizar distintas herramientas para la gestión de proyectos? Desarrollar y aplicar adecuadamente herramientas de gestión de proyectos puede generar un cambio sustancial para alcanzar los objetivos propuestos con los recursos disponibles. El contenido de este MOOC se basa en la metodología de Gestión de Proyectos para Resultados (PM4R) creada por el BID, que considera las siguientes 7 herramientas: la planeación de alcance; la gestión de tiempo; la gestión de costos; la gestión de compras; la gestión de comunicaciones; y la gestión de responsabilidades y de control de proyecto.

Sep 14th 2026
3 Weeks
Management of Urban Infrastructures – part 1 (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Management of Urban Infrastructures – part 1 (Coursera)

Sustainability, Resilience and Efficiency are fundamental considerations for city managers in managing urban infrastructures. Today, more than 3.9 billion people, making up more than 54% of the global population, live in cities. Urbanization is expected to continue in the coming years, raising the urban population to 6.0 billion by 2045. This dramatic increase in urban populations will inevitably increase the demand for energy, mobility (transportation), water, and other urban services in every city around the world. Without functional governance and management structures that ensure efficient, resilient and sustainable performance in cities, the current urbanization growth might become a catastrophic risk threatening the quality of life of the humanity.

Sep 14th 2026
5-12 Weeks
Managing Project Risks and Changes (Coursera) Coursera
University of California, Irvine

Managing Project Risks and Changes (Coursera)

This course will help you manage project risk effectively by identifying, analyzing, and communicating inevitable changes to project scope and objectives. You will understand and practice the elements needed to measure and report on project scope, schedule, and cost performance. You will be equipped with the tools to manage change in the least disruptive way possible for your team and other project stakeholders.

Sep 14th 2026
5-12 Weeks
GetVirtual: How to Launch Your Online Business (Coursera) Coursera
University of California, Santa Cruz

GetVirtual: How to Launch Your Online Business (Coursera)

The GetVirtual (GV) online training series teaches future entrepreneurs how to launch their first online business by providing step-by-step guidance for launching a website, building a logo and understanding the basics of online social media marketing. Course participants will gain access to GV's project management templates designed to support basic business transactions from initial client intake to invoicing.

Sep 28th 2026
4 Weeks
Foundations of Project Management (Coursera) Coursera
Google

Foundations of Project Management (Coursera)

This course is the first in a series of six to equip you with the skills you need to apply to introductory-level roles in project management. Project managers play a key role in leading, planning and implementing critical projects to help their organizations succeed. In this course, you’ll discover foundational project management terminology and gain a deeper understanding of the role and responsibilities of a project manager. We’ll also introduce you to the kinds of jobs you might pursue after completing this program. Throughout the program, you’ll learn from current Google project managers, who can provide you with a multi-dimensional educational experience that will help you build your skills for on-the-job application.

Sep 15th 2026
4 Weeks
Measure and Optimize Social Media Marketing Campaigns (Coursera) Coursera
Facebook

Measure and Optimize Social Media Marketing Campaigns (Coursera)

This course provides you with the skills to optimize your social media marketing efforts. Learn to evaluate and interpret the results of your advertising campaigns. Learn how to assess advertising effectiveness through lift studies and optimize your campaigns with split testing. Understand how advertising effectiveness is measured across platforms and devices, learn how to evaluate the ROI of your marketing, and master how to communicate your social media marketing results to others in the company. By the end of this course, you will be able to: analyze dashboards and evaluate ROI from your social media marketing efforts; understand different techniques used to optimize marketing campaigns, such as attribution and marketing mix models; implement an A/B test to optimize your campaign; present and communicate the results of your campaign to a team.

Sep 20th 2026
4 Weeks
Managing Machine Learning Projects (Coursera) Coursera
Duke University

Managing Machine Learning Projects (Coursera)

This second course of the AI Product Management Specialization by Duke University's Pratt School of Engineering focuses on the practical aspects of managing machine learning projects. The course walks through the keys steps of a ML project from how to identify good opportunities for ML through data collection, model building, deployment, and monitoring and maintenance of production systems. Participants will learn about the data science process and how to apply the process to organize ML efforts, as well as the key considerations and decisions in designing ML systems.

Sep 14th 2026
5-12 Weeks
Reviews & Metrics for Software Improvements (Coursera) Coursera
University of Alberta

Reviews & Metrics for Software Improvements (Coursera)

This course covers techniques for monitoring your projects in order to align client needs, project plans, and software production. It focuses on metrics and reviews to track and improve project progress and software quality. What you will learn: apply techniques to measure and visualize project progress, integrate Agile review practices to increase project visibility; reflect on lessons learned in software projects through retrospective exercises; improve project and process quality through ongoing measurement

Sep 28th 2026
4 Weeks
Analysis for Business Systems (Coursera) Coursera
University of Minnesota

Analysis for Business Systems (Coursera)

Most often, organizations acquire information systems as part of a larger focus on process improvement and efficiency. These organizations need to invest in the right system to meet their needs: right functionality, right size, and for the right price. The business systems analyst role in most organizations is responsible for translating the organization’s needs into requirements, which are then used to select or build the right system for the organization.

Sep 14th 2026
5-12 Weeks
Diseño de Proyectos de Desarrollo (Coursera) Coursera
Inter-American Development Bank - IDB

Diseño de Proyectos de Desarrollo (Coursera)

¿Sabes cómo hacer para que tus proyectos logren los resultados esperados? Un diseño adecuado es el primer paso hacia un proyecto exitoso. Este curso te brindará los conocimientos y herramientas fundamentales para diseñar proyectos de desarrollo sostenibles, evaluables y que cumplan con los objetivos propuestos.

Sep 14th 2026
3 Weeks