Google Sheets for community organizing

In this first module, you will discover what Google Sheets is and how it can help you in real-life situations.

Think of Sheets as a large digital notebook where you can organize names, dates, amounts, tasks, attendance lists, inventories, survey responses, budgets, and many other types of information.

The difference is that this notebook can help you organize large amounts of data, perform calculations automatically, and allow several people to work in the same file.

You will explore different ways to use it in your organization, project, community, or even in managing your household.

You will also take your first steps with the tool: you will open Google Sheets, create a spreadsheet, learn about cells, rows, and columns, enter your first piece of information, and give your file a name.

By the end of this module, you will be able to:

• understand what Google Sheets is and how it can be useful;

• recognize different ways to use it in community work;

• identify information that you could organize in a spreadsheet;

• access Google Sheets;

• create a new spreadsheet;

• enter your first data;

• name and save your file.

As a first reflection, you will begin identifying a list, budget, record, or task from your own reality that you would like to organize during this learning journey.

Now that you have entered Google Sheets, it is time to get to know the space where you will be working.

You can imagine this module as entering a new kitchen for the first time. At first, you may not know where the utensils, ingredients, or different drawers are. But once you understand the space, you can focus on what you want to create.

Google Sheets works in a similar way.

In this module, you will become familiar with the grid, rows, columns, and cells. You will learn that each cell has its own address, such as A1, B3, or D10, allowing you to locate it precisely.

You will also explore the menu bar, toolbar, name box, and formula bar.

You will learn how to move through a spreadsheet using your mouse and keyboard, and discover that a single file can contain several sheets to organize different parts of a project.

By the end of this module, you will be able to:

• recognize the main parts of Google Sheets;

• distinguish between rows, columns, and cells;

• understand cell addresses;

• use the name box and formula bar;

• recognize the main tools and menus;

• navigate through a spreadsheet with greater confidence;

• create and rename different sheets within the same file;

• recognize when your work has been saved automatically.

Little by little, the workspace will feel less unfamiliar, and you will begin to feel more comfortable moving around within it.

Having information is important. But organizing it so that you and other people can understand it easily is even more useful.

In this module, you will begin working directly with different types of data: text, names, numbers, dates, quantities, and amounts.

You will learn how to select cells, rows, and columns; add or remove space; copy and move information; and adjust the size of rows and columns according to what you need to display.

You will also learn how to use the appearance of a spreadsheet to communicate information more clearly.

You will be able to apply formats for dates, numbers, and currencies, use titles and headers, and work with borders, alignment, colors, and text wrapping.

The goal is not to decorate a spreadsheet. It is to make the information easy to read, understand, and use.

By the end of this module, you will be able to:

• enter and edit different types of information;

• select cells, ranges, rows, and columns;

• add and delete rows or columns;

• copy, cut, paste, and move information;

• adjust the size of rows and columns;

• organize long text within cells;

• apply date, number, and currency formats;

• use colors, borders, and alignment with intention;

• build a clear and understandable table.

During the practical activity, you will create a monthly expense record, transforming simple information into an organized table that another person can understand without needing a long explanation.

In this module, you will discover one of the most useful features of Google Sheets: performing calculations automatically.

A formula does not have to be complicated. It is simply an instruction you give to the spreadsheet so that it can perform a calculation for you.

You will learn how to use cell addresses in your calculations so that results can update automatically when the information changes.

You will begin with simple addition, subtraction, multiplication, and division.

Then you will learn some essential functions:

SUM to add values.

AVERAGE to calculate averages.

COUNT to count cells containing numbers.

COUNTA to count cells containing information.

MAX to find the highest value.

MIN to find the lowest value.

You will also learn how to work with cell ranges and copy formulas so that you can perform the same calculation across several rows.

By the end of this module, you will be able to:

• understand what a formula is;

• use cell references in calculations;

• perform basic mathematical operations;

• use essential Google Sheets functions;

• work with ranges of information;

• copy formulas across different records;

• recognize some common errors;

• review and correct formulas;

• create calculations that update when the data changes.

During the practical activity, you will build a monthly budget that can automatically calculate income, expenses, totals, and balances.

This is where you will begin moving from simply recording information to making that information work for you.

Working with ten records may be simple. But what happens when you have one hundred, two hundred, or many more?

As the amount of information grows, you also need new tools to quickly find what you are looking for.

In this module, you will learn how to sort data alphabetically, by amounts, or by dates.

You will also learn how to use filters to display only the information you need at a particular moment without deleting the other records.

For example, you might have a large participant list and want to see only the people from a particular community, those who attended a specific activity, or those who still have a pending task.

You will also explore tools that help you keep important headers visible while moving through a long table, find specific information, and replace repeated data when corrections are needed.

By the end of this module, you will be able to:

• sort information alphabetically;

• organize numbers from smallest to largest or largest to smallest;

• sort records by date;

• keep the different parts of the same record together;

• create and remove filters;

• display only data that meets specific conditions;

• combine different filtering criteria;

• keep important rows or columns visible;

• quickly find information within a spreadsheet;

• use Find and Replace to correct repeated information.

During the practical activity, you will work with a workshop participant list, using different tools to locate and organize information more quickly.

Community work is rarely done alone.

Many projects involve coordinators, team members, volunteers, people responsible for different activities, administrative staff, and participants who may be working from different locations.

In this module, you will discover how Google Sheets can become a true space for collective work.

You will learn how to share a spreadsheet and decide what each person can do within the file.

You can assign different levels of access:

Viewer, when someone only needs to see the information.

Commenter, when someone needs to leave feedback without directly changing the data.

Editor, when someone needs to work in the spreadsheet and make changes.

You will also learn how to use comments to discuss specific information directly within the spreadsheet, reply to others, assign tasks, and resolve conversations once an issue has been addressed.

You will also explore version history so you can understand how a document has changed and recover previous information when necessary.

By the end of this module, you will be able to:

• share a spreadsheet with specific people;

• share through links when appropriate;

• choose the right level of access;

• work simultaneously with other people;

• create, reply to, assign, and resolve comments;

• review the history of changes;

• restore previous versions;

• protect certain cells or ranges;

• establish practices that help keep collaborative work organized.

Sharing a spreadsheet does not mean losing control. It means creating a space where each person can participate according to their responsibilities.

So far, you have learned how to record, organize, calculate, find, and share information.

In this module, you will begin using tools that can help you interpret and communicate that information more clearly.

You will learn how to create charts and choose the type of visualization that best represents what you want to communicate.

Data can then become visual stories that show trends, comparisons, progress, or differences in ways that are easier to understand.

You will also learn how to create dropdown lists and validation rules that help people enter information more consistently.

For example, instead of writing the same status, category, or community name in different ways, you can provide predefined options.

You will also explore conditional formatting, which can automatically highlight information when it meets certain conditions.

You will learn how to import information from other files or spreadsheets and explore ways to use Gemini, when available, as support for specific tasks within Google Sheets.

By the end of this module, you will be able to:

• choose a chart according to the message you want to communicate;

• create and customize charts;

• turn data into visual representations;

• create dropdown lists;

• use validation rules to improve data quality;

• automatically highlight important information;

• import information from other files;

• use artificial intelligence tools as support when available;

• review AI-generated suggestions before using them.

During the practical activity, you will create a monthly financial report, combining information, calculations, and visual tools to communicate results more clearly.

You have reached the final module.

You began by entering your first piece of information into a cell. Now you can organize data, create formulas, work with large lists, collaborate with others, build charts, and establish rules that help keep information organized.

The next step is making sure that all of this work can be maintained over time.

In this module, you will learn how to create reusable templates so that you do not have to start from scratch every time you carry out a similar activity.

You can create a structure for budgets, records, participant lists, reports, or projects that you can later copy and reuse.

You will also learn how to organize different functions within the same file. For example, you might have one sheet for instructions, another for entering information, another for reference lists, and another for results and charts.

You will also work on organizing your files in Google Drive and learn how to use clear names for files, folders, and individual sheets.

The goal is to build systems that other people can also understand and use.

A good spreadsheet should not depend only on the memory of the person who created it.

By the end of this module, you will be able to:

• use existing templates;

• create your own reusable templates;

• make working copies without changing the original file;

• establish clear ways of naming files and folders;

• organize your spreadsheets in Google Drive;

• separate data entry from calculations and analysis;

• keep information clean and consistent;

• document important formulas and structures;

• create a data dictionary that explains the information you use;

• protect formulas and elements that should not be changed;

• create copies and backups of important information;

• review permissions, ownership, and responsibilities;

• prepare files that other people can understand and continue using.

You will also reflect on something essential for community work: who takes care of the information and what happens when people change roles.

You will be able to define who manages a file, who enters information, who reviews its quality, and who uses the results to support decisions.

As a final activity, you will build your own sustainable spreadsheet system, bringing together many of the tools you have learned throughout the course.