Hello everyone:
Welcome to my 10 tip series where each month I’ll be sharing 10 tips on various pieces of technology.
This would include tips on popular screen readers, office software, and browsers.
If you have any suggestions on what you would like me to share then by all means! Write to me at donnajodhan@sterlingcreations.ca.
For this month:
10 tips for learning about google sheets
Here are 10 practical tips for learning Google Sheets, especially if you want to go from beginner to confident user:
1.
Master the basics first
Learn how to enter data, format cells, freeze rows/columns, and use basic formulas like SUM, AVERAGE, MIN, and MAX.
2.
Understand relative vs. absolute references
Practice using $A$1 vs A1. This is critical when copying formulas across rows and columns.
3.
Learn the most useful formulas early
Focus on high-impact ones like IF, COUNTIF, SUMIF, VLOOKUP / XLOOKUP, INDEX, and MATCH.
4.
Use keyboard shortcuts
Shortcuts (like Ctrl + / to see them all) can dramatically speed up your workflow.
5.
Practice with real data
Use budgets, schedules, grades, or sales data—real use cases help concepts stick much better than fake examples.
6.
Explore filters and sorting
Learn how to filter data, create filter views, and sort by multiple columns to analyze information quickly.
7.
Get comfortable with charts
Practice turning data into charts and learn which chart types best represent different kinds of data.
8.
Learn conditional formatting
This helps highlight trends, errors, or important values automatically (e.g., color-coding high/low numbers).
9.
Use Google Sheets’ built-in help
The “Explore” button and formula suggestions can teach you new functions as you work.
10.
Watch short tutorials and replicate them
Don’t just watch—pause and recreate what you see. Hands-on repetition is the fastest way to learn.
To contact me please send an email to donnajodhan@sterlingcreations.ca
I’m Donna J. Jodhan (sight loss coach and accessibility advisor)