Data Miner’s Motherlode

Here is a collection of functions to assist with data collection and analysis.

Q: Have you ever wanted to pull data from one Google Sheet to another?
A: Try the IMPORTRANGE function.

Q: How can I pull data from one sheet to another with specific columns?
A: Try the QUERY function.

Q: How can I cross reference data from one sheet and another?
A: Try the VLOOKUP function.

Q: How can I convert a value to another value to make it more user friendly?
A: Try the IF function.

Check back soon for more helpful functions!

Leave a Reply

Your email address will not be published. Required fields are marked *