Spreadsheets

Excel and Google Sheets formulas, templates, and automation — written from real use.

Showing 1–5 of 5 articles

Abstract flat illustration of a white spreadsheet grid with three cells highlighted in different shades of teal forming a gradient, a small paint bucket icon in the corner, and a dashed arrow pointing from a rule panel card to the highlighted cells
Spreadsheets

How to Use Conditional Formatting in Google Sheets (Rules, Formulas, and Fixes)

How to use conditional formatting in Google Sheets: built-in rules, color scales, custom formulas that highlight entire rows or flag duplicates, and how to manage multiple rules without conflicts.

Abstract flat illustration of a white spreadsheet grid with a teal search-key cell in the first column, a dashed arrow scanning down the column, and a highlighted result cell connected by a teal arrow to a small output card
Spreadsheets

How to Use VLOOKUP in Google Sheets (Examples and Every Error Fix)

How to use VLOOKUP in Google Sheets: the four arguments explained with a real example, exact vs approximate match, and the fix for every error it can throw.

Abstract flat illustration of a spreadsheet grid on a white card with one amber cell showing a warning triangle, an arrow pointing to a second white card holding a teal checkmark circle
Spreadsheets

How to Fix the #REF! Error in Google Sheets (Every Cause, Every Fix)

The #REF! error in Google Sheets means a formula points to a cell that no longer exists. Every cause — deleted columns, broken VLOOKUPs — and each fix.

Abstract flat illustration of two overlapping spreadsheet grids in teal and navy on a white background, one slightly elevated above the other, with small chart bars between them
Spreadsheets

How to Convert Excel Files to Google Sheets (What Breaks and How to Fix It)

How to convert Excel files to Google Sheets: three conversion methods, what breaks in translation, and fixes for the errors you'll actually hit.

Abstract flat illustration of a spreadsheet grid with several rows fading out, leaving only distinct highlighted rows in teal and navy on a light background
Spreadsheets

How to Remove Duplicates in Google Sheets (3 Methods, Edge Cases Included)

How to remove duplicates in Google Sheets using Data cleanup, the UNIQUE formula, and conditional formatting — plus edge cases and common mistakes.