Instead of manually sorting, you can use the QUERY function to do all the work for you, while automatically updating your data as new information comes in. Check out the video below on the details:
Tuesday, May 23, 2017
Tutorial - Create reports using the Query Function
Having Google Forms enter your information directly into a spreadsheet is a great time saver. And once it's there, you can easily filter and sort your data. However, too many times people will mess up their data when they only sort some of their columns - making the data invalid and useless.
Instead of manually sorting, you can use the QUERY function to do all the work for you, while automatically updating your data as new information comes in. Check out the video below on the details:
Instead of manually sorting, you can use the QUERY function to do all the work for you, while automatically updating your data as new information comes in. Check out the video below on the details:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment