top of page



Train your new powers
Use inputs tried and tested by Sheets gods.
Total Percentage
Get the total average percentage difference of a range.

Sum Values
Sum all of the values in a range.

Group Values
Create new ranges by grouping values and adding aggregated data columns.

Extract Data
Extract exactly what you need across a range of strings of values.

VLOOKUPS
Match values across ranges and return a corresponding value from another column.

Percentage Increase/Decrease
Calculate the percentage difference from one range of values to another.

Remove Columns
Remove columns from a range.

Filter Ranges
Filter the range using any column of data.

Conditional Statements
Use IF statements across a full range of data.

Average Values
Average all of the values in a range.

Glossary
bottom of page