Neat Google Stuff

Return - https://go.mgpd.org/ngs

Here is some neat Google stuff that you may not be aware of. Let's go through them in no particular order (well, alphabetical order). How many of these do you know about?

Google Docs

@ Insert

Type @ symbol and you'll be prompted to select what you want to insert from the Search menu that appears.

You can insert people's emails, building blocks, Files, Lists, Media, Page components, and much more (like Table of Contents, Equations, Bookmarks, etc.)

Emoji Comments

Start to leave a comment, choose the emoji option

Insert Dropdown

Allows you to insert a dropdown menu, like the one shown right.

Add options in a dialog box above, then you will see what appears in your document below.

Pageless Option

How to Get It: File -> Page Setup -> Pageless

Hot Tip

When inserting images in Pageless mode, your image options (i.e. wrap text) change. A workaround is to use tables to place images where and how you want them.

Show Outline

How to Get It: View -> Show Outline

Hot Tip

You can edit your outline to only show headings you want to see, then use the outline to jump around the document. Works great with Pageless.

Summary Area

Add a summary to your doc in the document outline

View -> Show Outline

Watermark

How to Get It: Insert -> Watermark

You can add an image or text (diagonal or horizontal)

Google Drive

Copy-n-Paste Files/Folders in Drive

You can now copy-n-paste files/folders using your keyboard in Chrome browser only.

  • Windows/Chromebook user?

    • Use Ctrl-C (copy) and

    • Ctrl-V (paste)

  • Mac user?

    • Use Command-C (copy)

    • Command-V (paste)

Folder Edits: Add Emojis and Change Color

  • Emoji: Right-click and Rename to paste in emoji

  • Change Color: Right-click on a folder to get more Change Color options.

Google Forms

Google Forms has new formatting options. Have you noticed or seen them? Google has made this available to all Google Workspace customers as well as legacy G Suite Basic and Business customers. They also are making it available to users with personal Google Accounts. Roll out started June 28, 2022.

Google Sheets

These are a few of my favorite functions. If you don't know about them, you're missing out on what you can do.

  • =Concatenate(A2,” “,B2,”<”,C3,”>”)

  • =join(",",A1:A5)

  • =IFERROR(value, [value_if_error]) (See more)

  • =IMPORTRANGE (sheet_url, range_string)

  • =QUERY(NAMEDRANGE, "SELECT A WHERE B='Google Sites' ")

  • =COUNTIF (range, criterion)

  • =COUNTA (range, criterion)

  • =DetectLanguage(B2) with =GoogleTanslate(B2,C2,”en”)