Posts

Showing posts from June, 2020

Combining Multiple Google Forms Results into a Single Spreadsheet with Separate Tabs

Image
It is possible to create multiple Google Forms and have them all feed into the same spreadsheet. What makes this technique useful is that you can have different groups of users filling out different forms in different locations, and all of these results can go into the same spreadsheet, but the results will be automatically filtered into the correct tab at the bottom. I say "automatically," but first you will need to set up the form(s) to know where to go.  I created the video tutorial below because I know I will be referring to it for various scenarios, which include: Teachers who want to give out a copy of the same Quiz in Google Forms to multiple classes but have the results feed into the same Google Sheet. Technology trainers (or any trainers) who provide classes during the year and want to keep a record of all class lists in the same spreadsheet. Using a Google Form for each class session, all of the class lists can feed into the same master spreadsheet. Band direc

How to Place Text on Top of a Picture or a Picture Behind Text in Google Docs: The Workarounds

Image
Here is a common question from a Google Docs user: So here's the deal...I would like to insert a picture into a Google Doc. I would like the picture to be behind the text. I looked up online for an answer, and found that I must: Insert the picture as a drawing. Add a text box to the drawing and insert the text. This seems very cumbersome...Any thoughts? Great question. Unfortunately, you have hit on one of Google Docs' biggest flaws/limitations. It has no "Behind Text" text wrapping feature.  Microsoft Word  does have this feature though (see my screenshot below). I'm not sure what you are creating, so I'm not sure if it is something you could do in Microsoft Word instead. Also, many peple out there simply don't have a full-blown licensed version of Microsoft Word. What I did below was to insert a photo and then type some text, click on the Text Wrapping button, and then chose  Behind text . Then, I used the Windows Snipping Tool (found in nearly