Cover Image: Google Sheets Intermediate Reference and Cheat Sheet

Google Sheets Intermediate Reference and Cheat Sheet

Pub Date:   |   Archive Date:

Member Reviews

Really informative and a must have for reference if you use Google sheets I love these and use often.

Was this review helpful?

This is a very useful little reference sheet. I love keyboard shortcuts and these ones are great. Its a handy thing to have on your pinboard and I will use it quite a lot.

Was this review helpful?

This little reference sheet gives lots of great tips for getting the most out of Google Sheets. I look forward to using some of these functions, especially joining text and numbers which was a feature I learned about from this document.
Many thanks to NetGalley and i30 Media Corp for the advanced copy.

Was this review helpful?

Excellent reference and cheat sheet for anyone who uses Google Sheets. I learned a lot more than I already knew and will use this often.

Was this review helpful?

.not what I was expecting. This is not a book but a sheet of commands useful for excel and it is quite impossible to follow without any context. Maybe it should not be part of this platform.

Was this review helpful?

Overall I like the graphics and the detail provided for the shortcuts. The choices are good for what many user will use.

I think page 4 should be reworked. The difference for Mac and Windows is not significant and usually is Control versus Command. If those were tightened up, then significantly more shortcuts could be shown.

The ones I think are very useful are those for number formatting e.g.:
Ctrl+Shift+ 1 :Decimal
Ctrl+Shift+ 2 : Time
Ctrl+Shift+ 3 : Date
Ctrl+Shift+ 4 : Percentage

Borders e.g.:
Alt + Shift + 6 : Remove Borders
Alt + Shift + 7 : Apply Outer Borders

Ctrl +Alt +9 : Hide Rows
Ctrl +Shift+9 : Unhide Rows
Ctrl + ~ : Show All Formulas

Was this review helpful?

Super-handy,quick reference sheet that I can keep beside my computer, rather than doing an Internet search or watching videos, for the formulas to help me create and utilize the functions I need. Covers not only the bare basics, but somewhat more-often used shortcuts for all the outcomes I need!

Was this review helpful?

Super helpful for anyone who is a Google user. We utilize Google at school, and this help me learn a few new things as a struggling hybrid teacher during the pandemic!

Was this review helpful?

A very useful set of tips about Google Sheets to be followed. You can easily apply it to everyday use of it and it helps a large variety of jobs and professional assignments. Intermediate to advanced knowledge is necessary in order to proceed to specific tasks assigned in the exercises mentioned in the Google Sheets. An useful material for anyone looking for complex projects, including collaborative ones, via this Google instrument.

Was this review helpful?

The instructions are clear and well organized. It has basic formulas for financial planning, and is aimed at novices who need the instruction. It could be more useful if it had some of the intermediate functions like VLOOKUP, counting up fields based on a search with COUNTA, and finding text in strings. Other than that, I think it can be handy for those looking for a simple reference.

Was this review helpful?