1.1 📌 GS Sort
Use Google Sheets sort to reorder your data alphabetically or numerically.
- Select the range you want to sort.
- Click Data > Sort range.
- Choose Sort A–Z or Sort Z–A.
Tip: Check "Data has header row" to preserve titles.
Read More
1.2 🔍 GS Sort Sheet
Sort the entire sheet by a specific column.
- Select a column (e.g., A).
- Click Data > Sort sheet A–Z or Z–A.
Note: This affects all rows and keeps them aligned.
Read More
1.3 🧪 GS Sort by Range
Sort only a selected part of your sheet.
- Highlight the data (without headers).
- Click Data > Sort range.
- Pick the column and sort order.
Read More
1.4 🔍 GS Conditional Formatting
Automatically format cells based on values.
- Select your data range.
- Go to Format > Conditional formatting.
- Set a rule (e.g., "greater than 50").
- Choose a format (e.g., background color).
Read More
1.5 🧪 GS Single Color Formatting
This applies one condition to a range.
- Highlight cells and set one rule (e.g., "is empty").
- Applies one style (e.g., red text).
Read More
1.6 🔍 GS Color Scale Formatting
Apply a gradient of colors based on values.
- Choose three-point scale (min, mid, max).
- Useful for visualizing trends (e.g., heatmaps).
Read More
1.7 📌 AND
Returns TRUE if all conditions are met.
=AND(A1>10, B1<5)
1.8 🔍 AVERAGE
Calculates mean of values.
=AVERAGE(A1:A5)
1.9 🧪 AVERAGEIF
Average with condition.
=AVERAGEIF(A1:A10, ">50")
1.10 🔍 AVERAGEIFS
Average with multiple conditions.
=AVERAGEIFS(B1:B10, A1:A10, ">10", C1:C10, "<100")
1.11 🧪 COUNT
Counts numeric values.
=COUNT(A1:A10)
1.12 📌 COUNTA
Counts non-empty cells.
=COUNTA(A1:A10)
1.13 🧪 COUNTBLANK
Counts empty cells.
=COUNTBLANK(A1:A10)
1.14 🔍 COUNTIF
Counts cells meeting one condition.
=COUNTIF(A1:A10, ">50")
1.15 🧪 COUNTIFS
Counts cells matching multiple criteria.
=COUNTIFS(A1:A10, ">50", B1:B10, "<100")
1.16 🔍 IF
Returns a value if condition is true or false.
=IF(A1>10, "Pass", "Fail")
1.17 📌 IFS
Tests multiple conditions.
=IFS(A1>90, "A", A1>80, "B", A1>70, "C")
1.18 🔍 MAX
Returns the largest value.
=MAX(A1:A10)
1.19 🧪 MEDIAN
Returns the middle value.
=MEDIAN(A1:A10)
1.20 🔍 MIN
Returns the smallest value.
=MIN(A1:A10)
1.21 🧪 MODE
Returns most frequently occurring value.
=MODE(A1:A10)
1.22 🔍 OR
Returns TRUE if any condition is met.
=OR(A1>10, B1<5)
1.23 🧪 STDEV.P
Standard deviation for a population.
=STDEV.P(A1:A10)
1.24 🔍 STDEV.S
Standard deviation for a sample.
=STDEV.S(A1:A10)
1.25 🧪 SUM
Adds numbers.
=SUM(A1:A10)
1.26 🔍 SUMIF
Adds cells meeting one condition.
=SUMIF(A1:A10, ">50")
1.27 🧪 SUMIFS
Adds cells that match multiple conditions.
=SUMIFS(B1:B10, A1:A10, ">50", C1:C10, "<100")
1.28 🔍 VLOOKUP
Searches for a value in the first column and returns from another column.
=VLOOKUP("John", A2:C10, 2, FALSE)
1.29 🧪 XOR
Returns TRUE if only one condition is TRUE.
=XOR(A1>10, B1<5)