Google Sheets Functions, Formulas, and Charts: Free Written Tutorials

A spreadsheet becomes more useful when you can explain its numbers, control its inputs, and present the result clearly. Google’s Use Functions, Formulas, and Charts in Google Sheets brings those skills together through written tutorials on charts, data preparation, lookup functions, surveys, and pivot tables. It is aimed at learners ready to move beyond basic cell editing.

The course uses practical lab scenarios, ending with a challenge activity. All six official written units linked below are freely readable, including the final task brief. That gives you a complete reading route without payment or sign-in. Starting hosted lab sessions and earning the formal badge are separate activities with their own access requirements.

Course at a glance

What you’ll learn

• Create and customize charts, including comparisons, relationships, and inline visualizations.
• Sort, filter, format, clean, and validate spreadsheet data.
• Explore lookup and search techniques using functions such as VLOOKUP, QUERY, and SUBSTITUTE.
• Follow examples of error handling and manipulating the layout of data.
• Connect Google Forms responses with spreadsheet analysis, validation, and branching logic.
• Use pivot tables, named ranges, and descriptive statistics to summarize information.

Skills you’ll gain

• Formula reasoning
• Data validation
• Lookup functions
• Pivot tables
• Chart selection
• Survey data analysis

Follow the complete free reading route

These links open the full official written material directly. Read the walkthroughs before deciding whether you want to use the separately provided hosted practice environments.

1. Use Charts in Google Sheets — Explore chart types, customization, and small visualizations within a sheet.
2. Validate Data in Google Sheets — Study sorting, filtering, formatting, validation rules, and data cleaning.
3. Finding Data in Google Sheets — Follow search, substitution, lookup, and query examples, including function-error handling.
4. Use Google Forms with Google Sheets — Connect survey design, response rules, and analysis in a spreadsheet.
5. Pivot Tables in Google Sheets — Explore summaries, named ranges, descriptive statistics, and collaboration.
6. Use Functions, Formulas, and Charts in Google Sheets: Challenge Lab — Read the final brief covering preparation, analysis, a chart, and a pivot table.

Make reliable results part of your study

The tutorials use a fictional bakery business to connect spreadsheet tasks with everyday operational questions. Treat that setting as a teaching scenario. The transferable lesson is how to move from entries that need attention to a summary another person can understand, rather than how to reproduce one business’s figures.

While reading a formula example, note its input range, the question it answers, and the result you expect from a small sample. Hand-check that sample before trusting a larger summary. A formula returning a number is not enough to establish that the number answers the right question.

For lookup and error-handling examples, record what should happen when an item is missing or an input is unexpected. For charts, write a plain-language conclusion before choosing a visual. These habits help you examine assumptions without claiming that any spreadsheet is automatically accurate or ready for business use.

Who will get the most from it?

The intermediate level suits learners who already understand basic spreadsheet navigation and want a more deliberate analytical workflow. The tutorials recommend introductory Google Sheets learning for newcomers. If cells, ranges, and simple editing are unfamiliar, begin with a foundation course from the course library before working through these examples.

The freely readable route covers the entire published written sequence, but it does not include a promise of free hosted practice or recognition. Hosted sessions can require credits, a subscription, or an eligible allowance. Reading the challenge brief also does not complete the scored challenge or award a badge.

Enroll Now

Frequently asked questions