Cloud & Productivity Software
How to Make a Pivot Table in Google Sheets: Group, Filter, Calculate
Build a pivot table in Google Sheets, then sort, filter, group by month, show percentages and add a calculated field.
Covers cloud productivity suites, collaboration platforms, storage services, and SaaS tools including Microsoft 365, Google Workspace, and similar enterprise and SMB solutions.
30 articles
Cloud & Productivity Software
Build a pivot table in Google Sheets, then sort, filter, group by month, show percentages and add a calculated field.
Cloud & Productivity Software
Highlight duplicates in Excel, preview the unique rows with Advanced filter, then delete with Remove Duplicates without losing data you need.
Cloud & Productivity Software
How the 30-day Google Drive Trash window works, why trashed files still use storage and stay shared, and why emptying Trash is permanent.
Cloud & Productivity Software
Learn the QUERY syntax in Google Sheets, when to set the headers argument, how to keep the query in a cell, and why mixed-type columns return blanks.
Cloud & Productivity Software
Protect a range or whole sheet in Google Sheets, keep input cells editable, remove protection, and learn what locking can't stop.
Cloud & Productivity Software
What Google's own announcements say about expiring access on Drive files, shared drives and folders, and where the official steps live.
Cloud & Productivity Software
What counts toward your Google storage across Gmail, Drive and Photos, what doesn't, and why some new accounts start with 5 GB instead of 15 GB.
Cloud & Productivity Software
Use a conditional formatting custom formula like =$B1="Yes" to color an entire Google Sheets row, and fix the rule when it colors the wrong cells.
Cloud & Productivity Software
Write XLOOKUP formulas in Google Sheets that replace VLOOKUP, look left, return whole rows, find the last match and show your own not-found text.
Cloud & Productivity Software
How to cancel a Gmail message right after you hit Send, and how to raise the Undo Send window to 30 seconds on desktop.
Cloud & Productivity Software
Use Google Docs version history to restore or copy an older version, name versions to keep them, and avoid losing a Sheet's cell edit history.
Cloud & Productivity Software
Freeze, unfreeze, hide and group rows or columns in Google Sheets on a computer, Android phone, or iPhone and iPad, with the exact menu taps.